思路: 直接查询info表
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="sec.*"
import="dao.*"
import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String uname = (String)session.getAttribute("uname");
System.out.println(uname);
S_info_sum sis = new S_info_sum();
List<Info> list = new ArrayList<Info>();
list = sis.s_sum(uname);
int n = 0;
%>
<table border="2" bgcolor="ccceee" width="650">
<tr bgcolor="#E0FFFF" align="center">
<td>记录条数</td><td>图书号</td><td>图书名</td><td>用户名</td><td>类型</td><td>借期</td><td>还期</td><td>超期</td><td>info</td>
</tr>
<%
for(Info b : list){%>
<tr align="center">
<td><%=++n %></td>
<td><%=b.getId() %></td>
<td><%=b.getName() %></td>
<td><%=b.getUname() %></td>
<td><%=b.getType() %></td>
<td><%=b.getLenddate() %></td>
<td><%=b.getHuanqi() %></td>
<td><%=b.getCq() %></td>
<td><%=b.getInfo() %></td>
<!-- <td><%=b.getAppoint() %></td> -->
</tr>
<% }System.out.println("3333");//request.setAttribute("list", list);
%></table>
</body>
</html>
package sec;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import dao.Info;
import javabean.DB;
public class S_info_sum {
private DB db = new DB();
private Connection conn = null;
private PreparedStatement pstmt = null;
private List<Info> list = new ArrayList<Info>();
public List<Info> s_sum(String uname) throws Exception{
String sql="select id,name,uname,type,lendate,huanqi,cq,info from info where uname=?";
conn=db.getConn();
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, uname);
ResultSet rs = pstmt.executeQuery();
rs.last();
System.out.println(rs.getRow());
if(rs.getRow()!=0) {
rs.beforeFirst();
while(rs.next()) {
String id=rs.getString("id");
String name1=rs.getString("name");
String uname1=rs.getString("uname");
String type=rs.getString("type");
String lendate=rs.getString("lendate");
String huanqi=rs.getString("huanqi");
String cq=rs.getString("cq");
String info=rs.getString("info");
Info inf= new Info(id,name1,uname1,type,lendate,huanqi,cq,info,null);
list.add(inf);
}
db.free(rs, pstmt, conn);
}
return list;
}
}