图书管理系统java代码

项目下的包及类：数据库bookcollection表book（bookID设置为自增）表user表userbook登录注册页面：package bookDB;import .*;import .*;public class RLogin extends JFrame implements ActionListener{ sSelected()){sex = rb1[m].getText();}}sSelected()){type = n+1;}}userbean rs = new userbean();(), sex, (), (), (),(), type);();}} quals(password) ){(null,"登录成功!");bookMain main = newbookMain();;import .*;public class RLogin extends JFrame implements ActionListener{sSelected()){sex = rb1[m].getText();}}sSelected()){type = n+1;}}userbean rs = new userbean();(), sex, (), (), (),(), type);();}};import .*;public class bookAdd extends JFrame implements ActionListener{;importimport .*;public class bookEdit extends JFrame implements ActionListener{Container c;JLabel jLabel1 = new JLabel("图书ID：");JLabel jLabel2 = new JLabel("图书名：");JLabel jLabel3 = new JLabel("作者：");JLabel jLabel4 = new JLabel("出版社：");JLabel jLabel5 = new JLabel("馆藏量：");JLabel jLabel6 = new JLabel("剩余馆藏量：：");JLabel jLabel7 = new JLabel("当前预约人数：");JTextField bookID = new JTextField(10);JTextField bookname= new JTextField(10);JTextField author = new JTextField(10);JTextField press = new JTextField(10);JTextField number = new JTextField(10);JTextField lastNumber = new JTextField(10);JTextField apointment = new JTextField(10);JButton editconfirm = new JButton();public bookEdit(){("修改图书信息");(true);try{Init();}catch (Exception e){();}etScreenSize();((int) - 400)/2,(int) - 300)/2 +45); }public void Init() throws Exception{ (600,500);c = ();(new FlowLayout());(jLabel1);(null);(bookID);(jLabel2);(null);(bookname);(jLabel3);(null);(author);(jLabel4);(null);(press);(jLabel5);(null);(number);(jLabel6);(null);(lastNumber);(jLabel7);(null);(apointment);; import .*;public class bookLend extends JFrame implements ActionListener{ Container c;JLabel jLabel1 = new JLabel();JLabel jLabel2 = new JLabel();JLabel jLabel3 = new JLabel();JLabel jLabel4 = new JLabel();JTextField bookname = new JTextField(10); JTextField bookID = new JTextField(10); JTextField username= new JTextField(10); JTextField userID = new JTextField(10); JButton bookconfirm = new JButton(); public bookLend(){("借阅图书");(true);try{Init();}catch (Exception e){();}etScreenSize();((int) - 400)/2,(int) - 300)/2 +45); }public void Init() throws Exception{ (600,500);c = ();(new FlowLayout());("借阅图书名: ");(jLabel1);(null);(bookname);("借阅图书ID: ");(jLabel2);(null);(bookID);("确定"); ; importimport .*;public class bookReturn extends JFrame implements ActionListener{ Container c;etScreenSize();((int) - 400)/2,(int) - 300)/2 +45);}public void Init() throws Exception{(300,500);c = ();(new FlowLayout());("归还图书id: ");(jLabel2);(null);(bookid);("确定");(reconfirm);(this);}public void actionPerformed(ActionEvent e){Object obj = ();if(obj == reconfirm){bookBean rs = new bookBean();; importimport javax.*;import .*;public class bookSearch extends JFrame implements ActionListener{ etScreenSize();((int) - 400)/2,(int) - 300)/2 +45);}public void Init() throws Exception{(300,500);;importimport javax.*;import .*;import class Mybook extends JFrame{etScreenSize();((int) - 400)/2,(int) - 300)/2 +45);}public void Init() throws Exception{(1000,1000);科生2.研究生3.老师)：");etScreenSize();etScreenSize();((int) - 400)/2,(int) - 300)/2 +45);}public void init() throws Exception{etScreenSize();((int) - 400) / 2, (int) - 300) / 2 + 45);}public void init() throws Exception{// TODO Auto-generated method stub (1300, 1500); // 设置窗口大小c = ();(new FlowLayout());// 添加标签("要修改的姓名: ");(jLabel1);(null);(studentName);("性别: ");(jLabel2);(null);(studentSex);("密码: ");(jLabel4);(null); (studentPassword);("学生类别: ");(jLabel5);(null);(studentType);("学生院系: ");(jLabel6);(null);(studentDepartment);("专业: ");(jLabel7);(null);(studentMajor);// 添加“确认修改”按钮("确认修改");(editconfirm);(this);} // end init method// 事件监听@Overridepublic void actionPerformed(ActionEvent e) { // TODO Auto-generated method stubObject obj = ();if(obj == editconfirm){ //点击修改个人信息//获取登录用户的iduserbean login = new userbean();String loginID = ;//调用修改个人信息的方法personBean rs = new personBean();(), (),(),(), (), (),loginID);();}} // end actionPerformed method} // end class personInfo修改个人信息方法;package bookDB;importpublic class personBean {String sql;ResultSet rs = null;String studentName;String studentSex;String studentID;String studentPassword;String studentType;String studentDepartment;String studentMajor;// 修改个人信息public void personModify(String name, String sex, String password, String Type, String department, String major,String loginID){DatabaseConn2 DB = new DatabaseConn2();= name;= sex;= loginID;= password;= Type;= department;= major;int type = (studentType);//用户类型int canborrow = type*5+5; //用户可借图书数量//String loginID = ("请输入登录账号：");sql = "update user set userName = '"+ studentName +"',"+ " sex = '"+ studentSex + "',password = '" + studentPassword + "',"+ " userType = "+type+",department = '" + studentDepartment + "',canBorrow = "+canborrow+","+ " major = '" + studentMajor +"' where userID = '"+ studentID +"' ";try{// ();(sql);(null,"成功修改一条记录!");}catch (Exception e){(null,"修改失败!","错误",;}finally {//();();}} // end personModify method } // end class personBean。