JSP 取数据库多行数据 MVC结构 用EL取值
方法代码
public PenaltyCreditcard getPenaltyCreditcard(PenaltyCreditcard penaltycreditcard) throws Exception {
PenaltyCreditcard pc = null;
String sql = "Select Account_ID,creditcardType,penalty,limitTime,[name],phoneNumber,monthConsume,[creditworthiness] from CreditcardInfo where limitTime <=getdate() and monthConsume>0 ";
PreparedStatement pstmt = null;
try {
pstmt= DBConnection.getConnection().prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
// List list = new ArrayList();
while (rs.next()){
pc = new PenaltyCreditcard();
pc.setAccount_ID(rs.getInt(1));
pc.setCreditcardType(rs.getString(2));
pc.setPenalty(rs.getInt(3));
pc.setLimitTime(rs.getString(4));
pc.setName(rs.getString(5));
pc.setPhoneNumber(rs.getString(6));
pc.setMonthConsume(rs.getInt(7));
pc.setCreditworthiness(rs.getString(8));
pc.setCreateTime(penaltycreditcard.getCreateTime());
pc.setWregister_ID(penaltycreditcard.getWregister_ID());
System.out.println("数据库取出的罚款信用卡"+rs.getInt(1));
}
pstmt.close();
rs.close();
} catch (Exception e) {
System.out.println("getPenaltyCreditcard()异常"+e);
}finally {
// 关闭数据库连�
相关问答：
我的开发的平台是Myeclipes6.0 + tomcat5.x + mysql
我所有的编码方式都是用的UTF-8
我只用了Strtus框架
在一个form中如下用的是post的提交方式：
<form class="form" action=&quo ......
我的程序如下：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv=&q ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......
我JSP的页面是：
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
