图书馆管理系统（jsp jsf ajax j2ee）

package com.library.model; import java.sql.Connection; import java.sql.Date; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Calendar; import com.library.common.Dbconn; import com.library.view.BookVo; import com.library.view.BrBookVo; import com.library.view.Error; public class BrBookModel { Dbconn dbc; String fakuan; long s; public void YueJieBook(String kahao,int id){ dbc=new Dbconn(); Connection con=dbc.getCon(); try { Statement stmt=con.createStatement(); String sql1="select bianma from books_info where id="+id; ResultSet rs=stmt.executeQuery(sql1); String bianma=null; while(rs.next()){ bianma=rs.getString("bianma"); } String sql="insert into books_br(con,bon,flag) values("+kahao+",'"+bianma+"',0"+")"; stmt.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public ArrayList SelectYuJieBooks(String kahao){ ArrayList a=new ArrayList(); dbc = new Dbconn(); Connection con = dbc.getCon(); Statement stmt; try { stmt = con.createStatement(); String sql = "select books_br.id,bianma,bookname,author,bookkind,fakuan from books_info,books_br,card_info where card_no=con and card_no="+kahao+"and bianma=bon and flag=0"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int id=rs.getInt("id"); String bianma=rs.getString("bianma"); String name=rs.getString("bookname"); String author=rs.getString("author"); String kind=rs.getString("bookkind"); String fakuan=rs.getString("fakuan"); BrBookVo bbv=new BrBookVo(); bbv.setId(id); bbv.setBianma(bianma); bbv.setBookname(name); bbv.setAuthor(author); bbv.setBookkind(kind); bbv.setFakuan(fakuan); a.add(bbv); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return a; } public void DeleteYuJieBook(int id){ dbc=new Dbconn(); Connection con=dbc.getCon(); try { Statement stmt=con.createStatement(); String sql="delete from books_br where id="+id; stmt.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void BorrowBook(int id){ dbc=new Dbconn(); Date d=new Date(new java.util.Date().getTime()); int a=d.getYear(); int c=d.getDate(); int b=d.getMonth(); String time=null; if(b+2==13){ time=(a+1+1900)+"-01"+"-"+c; }else{ time=(a+1900)+"-"+(b+2)+"-"+c; } Connection con=dbc.getCon(); try { Statement stmt=con.createStatement(); String sql="update books_br set flag=1,bdate='"+d+"',rdate='"+time+"' where id="+id; stmt.executeUpdate(sql); String sql1="select con,bon from books_br where id="+id; ResultSet rs=stmt.executeQuery(sql1); String bianma=null; int card_no=0; while(rs.next()){ bianma=rs.getString("bon"); card_no=rs.getInt("con"); } String sql2="update books_info set shuliang=shuliang-1 where bianma='"+bianma+"'"; stmt.executeUpdate(sql2); String sql3="update card_info set maxborrow=maxborrow-1 where card_no="+card_no; stmt.executeUpdate(sql3); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //判断还有没有书 public boolean BookSubtract(int id){ boolean bool=false; dbc=new Dbconn(); Connection con=dbc.getCon(); try { Statement stmt=con.createStatement(); String sql="select bon from books_br where id="+id; ResultSet rs=stmt.executeQuery(sql); String bianma=null; while(rs.next()){ bianma=rs.getString("bon"); } String sql1="select shuliang from books_info where bianma='"+bianma+"'"; ResultSet rs1=stmt.executeQuery(sql1); int shuliang = 0; while(rs1.next()){ shuliang=rs1.getInt("shuliang"); } if(shuliang>0){ bool=true; } else{ bool=false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return bool; } //判断借阅卡的最多借阅次数 public boolean SelectMaxBorrow(int id){ boolean bool=false; dbc=new Dbconn(); Connection con=dbc.getCon(); Statement stmt; try { stmt = con.createStatement(); String sql="select con from books_br where id="+id; ResultSet rs=stmt.executeQuery(sql); int card_no=0; while(rs.next()){ card_no=rs.getInt("con"); } String sql2="select maxborrow from card_info where card_no="+card_no; ResultSet rs2=stmt.executeQuery(sql2); int maxborrow=0; while(rs2.next()){ maxborrow=rs2.getInt("maxborrow"); } if(maxborrow>0){ bool=true; } else{ bool=false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return bool; } //查看已经借的书 public ArrayList SelectYiJieBooks(String kahao){ ArrayList a=new ArrayList(); dbc = new Dbconn(); Connection con = dbc.getCon(); Statement stmt; try { stmt = con.createStatement(); String sql = "select books_br.id,bianma,bookname,author,bookkind,fakuan from books_info,books_br,card_info where card_no=con and card_no="+kahao+"and bianma=bon and flag=1"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int id=rs.getInt("id"); String bianma=rs.getString("bianma"); String name=rs.getString("bookname"); String author=rs.getString("author"); String kind=rs.getString("bookkind"); String fakuan=rs.getString("fakuan"); BrBookVo bbv=new BrBookVo(); bbv.setId(id); bbv.setBianma(bianma); bbv.setBookname(name); bbv.setAuthor(author); bbv.setBookkind(kind); bbv.setFakuan(fakuan); a.add(bbv); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return a; } //归还书籍 public boolean ReturnBook(int id){ dbc=new Dbconn(); boolean bool=false; Connection con=dbc.getCon(); try { Statement stmt=con.createStatement(); String sql1="select con,bon,rdate from books_br where id="+id; ResultSet rs=stmt.executeQuery(sql1); int card_no=0; String bianma=null; Date rdate=null; while(rs.next()){ card_no=rs.getInt("con"); bianma=rs.getString("bon"); rdate=rs.getDate("rdate"); } String sql2="update card_info set maxborrow=maxborrow+1 where card_no="+card_no; stmt.executeUpdate(sql2); String sql3="update books_info set shuliang=shuliang+1 where bianma='"+bianma+"'"; stmt.executeUpdate(sql3); String sql="delete from books_br where id="+id; stmt.executeUpdate(sql); if(new Date(new java.util.Date().getTime()).before(rdate)){ bool=true; } else{ Date d=new Date(new java.util.Date().getTime()); Calendar cl=Calendar.getInstance(); cl.setTime(d); Calendar c2=Calendar.getInstance(); c2.setTime(rdate); s=(cl.getTimeInMillis()-c2.getTimeInMillis())/(1000*60*60*24); String sql4="select fakuan from books_info where bianma='"+bianma+"'"; ResultSet rs1=stmt.executeQuery(sql4); while(rs1.next()){ fakuan=rs1.getString("fakuan"); } bool=false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return bool; } public Error A(){ Error e=new Error(); e.setFakuan(faku