WebRoot/jsp/back/backbook.jsp

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%
	String idStr = request.getParameter("id");
	String book_id = request.getParameter("book_id");
	String count = request.getParameter("count");
	String index = request.getParameter("index");
	
		Connection conn =null;
		PreparedStatement ps = null;
		int id = Integer.parseInt(idStr);
		try{
		 	conn = DBHelper.getConnection();
			conn.setAutoCommit(false);
		 	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();
		 	
		 	ps = conn.prepareStatement("update book_borrow set status = 1,fine=0,autcal_date=? where borrow_id="+id);
		 	ps.setDate(1,new java.sql.Date(new java.util.Date().getTime()));
		 	ps.executeUpdate();
		 	
		 	conn.commit();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,null);
		}
		request.setAttribute("msg","ok");
		request.getRequestDispatcher(index+".jsp").forward(request,response);
 %>