图书借阅历史查询| 图书号 | 图书名称 | 读者账号 | 读者姓名 | 借阅日期 | 归还日期 |
| ${loan.card } | ${loan.bookname } | ${loan.adminname } | ${loan.username } | ${loan.begintime } | ${loan.endtime } |
<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\" pageEncoding=\"UTF-8\"%>
管理员登陆package books.liao.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import books.liao.dbdao.DBbooks;import books.liao.pojo.Loan_history;public class Loan_historyDao {public List
selectName(String bookname){List jh=new ArrayList();Connection lj=DBbooks.getConnection();StringBuffer sql=new StringBuffer();sql.append(\"select * from history where status = 2 and bookname like '%\") .append(bookname) .append(\"%\");try {Statement sta=lj.createStatement();ResultSet re=sta.executeQuery(sql.toString());while(re.next()) {Loan_history loan=new Loan_history();loan.setHid(re.getInt(1));loan.setAid(re.getInt(2));loan.setBid(re.getInt(3));loan.setCard(re.getInt(4));loan.setBookname(re.getString(5));loan.setAdminname(re.getString(6));loan.setUsername(re.getString(7));loan.setBegintime(re.getString(8));loan.setEndtime(re.getString(9));loan.setStatus(re.getInt(10));jh.add(loan);}re.close();sta.close();} catch (SQLException e) {e.printStackTrace();}DBbooks.CloseConnection(lj);return jh;}public Loan_history selectAll(int aid) {Loan_history loanHistory = null;Connection lj = DBbooks.getConnection();String sql = \"SELECT * FROM history WHERE status = 2 AND aid = ?\";try {PreparedStatement pst = lj.prepareStatement(sql);pst.setInt(1, aid);ResultSet re = pst.executeQuery();while (re.next()) {loanHistory = new Loan_history();loanHistory.setHid(re.getInt(1));loanHistory.setAid(re.getInt(2));loanHistory.setBid(re.getInt(3));loanHistory.setCard(re.getInt(4));loanHistory.setBookname(re.getString(5));loanHistory.setAdminname(re.getString(6));loanHistory.setUsername(re.getString(7));loanHistory.setBegintime(re.getString(8));loanHistory.setEndtime(re.getString(9));loanHistory.setStatus(re.getInt(10));}re.close();pst.close();} catch (SQLException e) {e.printStackTrace();}DBbooks.CloseConnection(lj);return loanHistory;}}package books.liao.houtaiServlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import books.liao.dao.Loan_historyDao;import books.liao.pojo.Loan_history;public class SelectBooksName extends HttpServlet{public void doGet(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException {doPost(req,resp);}public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException {request.setCharacterEncoding(\"UTF-8\");String bookname=request.getParameter(\"bookname\");Loan_historyDao dao=new Loan_historyDao();List loan=dao.selectName(bookname);request.setAttribute(\"loan\",loan );request.getRequestDispatcher(\"Loan history.jsp\").forward(request, response);
