WebRoot/jsp/back/fkList.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="com.book.util.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="com.book.pojo.*"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>罚款信息</title>
<link href="css/style.css" rel="stylesheet" type="text/css">
<script src="js/js.js"></script>
<%
	List list = (List)request.getAttribute("backList");
	String msg = (String)request.getAttribute("msg");
	if(list == null){
		Connection conn =null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		list = new ArrayList();
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("select borrow_id,reader_name,book_name,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 join book_reader r on b.reader_id = r.reader_id and b.status=0 and getDate() > back_date ");
		 	rs = ps.executeQuery();
		 	while(rs.next()){
		 		BookBorrow b = new BookBorrow();
		 		b.setBorrow_id(rs.getInt(1));
		 		b.setReader_name(rs.getString(2));
		 		b.setBook_name(rs.getString(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{
			DBHelper.close(conn,ps,rs);
		}
	}
 %>
<style type="text/css">
<!--
body {
	margin-left: 3px;
	margin-top: 0px;
	margin-right: 3px;
	margin-bottom: 0px;
}
.STYLE1 {
	color: #e1e2e3;
	font-size: 12px;
}