图书管理系统--当前借阅信息

最新推荐文章于 2020-06-16 00:13:46 发布

-kric-

最新推荐文章于 2020-06-16 00:13:46 发布

阅读量731

点赞数

分类专栏： # 图书管理系统

本文链接：https://blog.csdn.net/ly_jewel/article/details/94625317

版权

图书管理系统专栏收录该内容

4 篇文章 1 订阅

订阅专栏

思路：直接查询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;
	    }

}