设计实现一个图书管理系统。图书信息存放到一个数据库中。图书

package tushuManagement; import tushuManagement.reader; public class readerManage { private reader reader1=null; java.sql.Connection cn1=null; java.sql.Statement st=null; java.sql.ResultSet rs=null; String sql=""; public readerManage() { cn1=DBconnection.getConnection(); } public boolean Insertreader(int readernum,String readername, String readersex, java.sql.Date birthday, String readertype) { boolean f=false; sql="insert into reader values('"+readernum+"','"+readername+"','"+readersex+"','"+birthday+"','"+readertype+"')"; int n=0; try { st=cn1.createStatement(); n=st.executeUpdate(sql); if(n>0) { f=true; } else { f=false; } } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } finally { try { st.close(); } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } } return f; } public boolean Searchreader(int readernum) { boolean f=false; sql="select * from reader where readernum = "+readernum; try { st=cn1.createStatement(); rs=st.executeQuery(sql); if(rs.next()) { reader1=new reader(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getDate(4),rs.getString(5)); f=true; } else { f=false; } } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } finally { try { rs.close(); st.close(); } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } } return f; } public boolean deletereader(int readernum) { boolean f=false; sql="delete from reader where readernum = "+readernum; int n=0; try { st=cn1.createStatement(); n=st.executeUpdate(sql); if(n>0) { f=true; } else { f=false; } } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } finally { try { st.close(); } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } } return f; } public boolean Updatereader(int readernum,String readername, String readersex, java.sql.Date birthday, String readertype) { boolean f=false; sql="update reader set [readername]='"+readername+"',[readersex]='"+readersex+"',[birthday]='"+birthday+"',[readertype]='"+readertype+"' where readernum="+readernum; int n=0; try { st=cn1.createStatement(); n=st.executeUpdate(sql); if(n>0) { f=true; } else { f=false; } } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } finally { try { st.close(); } catch(java.sql.SQLException cnfe) { System.out.println(cnfe.getMessage()); } } return f; } public void setreader1(reader reader1) { this.reader1 = reader1; } public reader getreader1() { return reader1; } }