WebRoot/jsp/statis/conditionSelect.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="com.book.util.Util"%>
<%@page import="java.util.*"%>
<%@page import="com.book.pojo.*"%>
<%@page import="java.sql.*"%>
<%
		String type = request.getParameter("type");
		String sql = "";
		if("borrow".equals(type)){
			String borrow = request.getParameter("borrow");
			sql = "select borrow_id,reader_id,book_id,borrow_date,back_date,b.status,b.borrow_count,b.book_id from book_borrow b where b.borrow_id like '%"+Integer.parseInt(borrow)+"%'";
		}else if("book".equals(type)){
			String book = request.getParameter("book");
			sql = "select borrow_id,b.reader_id,b.book_id,borrow_date,back_date,b.status,b.borrow_count,b.book_id from book_borrow b join book_info i on b.book_id=i.book_id  and (i.book_name like '%"+Util.encodeGB2312(book)+"%' or i.book_id like '%"+Util.encodeGB2312(book)+"%')";
		}else if("name".equals(type)){
			String name = request.getParameter("name");
			sql = "select borrow_id,b.reader_id,b.book_id,borrow_date,back_date,b.status,b.borrow_count,b.book_id from book_borrow b join book_reader r on b.reader_id = r.reader_id and (r.reader_name like '%"+Util.encodeGB2312(name)+"%' or r.reader_id like '%"+Util.encodeGB2312(name)+"%')";
		}
		
		Connection conn =null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List list = new ArrayList();
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement(sql);
		 	rs = ps.executeQuery();
		 	while(rs.next()){
		 		BookBorrow b = new BookBorrow();
		 		b.setBorrow_id(rs.getInt(1));
		 		b.setReader_id(rs.getInt(2));
		 		b.setBook_id(rs.getInt(3));
		 		b.setBorrow_date(rs.getString(4));
		 		b.setBack_date(rs.getString(5));
		 		b.setStatus(rs.getInt(6));
		 		b.setBorrow_count(rs.getInt(7));
		 		b.setBook_id(rs.getInt(8));
		 		b.setFine(Util.fineAmount(rs.getString(5)));
		 		
		 		list.add(b);
		 	}
		 	request.setAttribute("backList",list);
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			request.getRequestDispatcher("condition.jsp").forward(request,response);
			DBHelper.close(conn,ps,rs);
		}
 %>