WebRoot/jsp/borrow/addborrow.jsp

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

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="com.book.util.*"%>
<%@ 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>
<script type="text/javascript" src="../../js/jquery.js"></script>
<%
	
	String reader_id = request.getParameter("reader_id");
	String book_id = request.getParameter("book_id");
	String back_date = request.getParameter("back_date");
	String count = request.getParameter("count");
	String remark = request.getParameter("remark");
	
	Connection conn =null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	String str = "";
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
	if(back_date != null && !"".equals(back_date)){
		java.util.Date d = new java.util.Date();
		java.util.Date d2 = sdf.parse(back_date);
		if(d.getTime() > d2.getTime()){   //还书时间必须大于当前日期
			str = "ok";
		}
	}
	int status = 0;
	double amount = 0.5;    
	if(reader_id != null && book_id != null && !"ok".equals(str)){
		try{
			conn = DBHelper.getConnection();
			ps = conn.prepareStatement("select * from book_borrow b where reader_id=? and status = 0 and getDate() > back_date ");
			ps.setInt(1,Integer.parseInt(reader_id));
			rs = ps.executeQuery();
			if(rs.next()){
				java.sql.Date date=rs.getDate("back_date"); 
				amount = Util.fineAmount(date.toString());
				status = -1;
			}else{
				//sconn.setAutoCommit(false);
				
				ps = conn.prepareStatement("insert into book_borrow (reader_id,book_id,borrow_date,back_date,remark,borrow_count,status) values (?,?,?,?,?,?,0)");
				ps.setInt(1,Integer.parseInt(reader_id));
				ps.setInt(2,Integer.parseInt(book_id));
				ps.setDate(3,new java.sql.Date(new java.util.Date().getTime()));
				ps.setDate(4,new java.sql.Date(sdf.parse(back_date).getTime()));
				ps.setString(5,Util.encodeGB2312(remark));
				ps.setInt(6,Integer.parseInt(count));
				ps.execute();
				
				ps = conn.prepareStatement("update book_info set book_count = book_count-? where book_id=?");
				ps.setInt(1,Integer.parseInt(count));
				ps.setInt(2,Integer.parseInt(book_id));
				ps.executeUpdate();