java+swing+mysql圖書管理系統(tǒng)(附完整源代碼)

課程設(shè)計(jì)精品圖書If理系統(tǒng)書生系統(tǒng)說明：本系統(tǒng)釆用eclipse開發(fā)，IDEA,eclipse,myedipse均可運(yùn)行界面采用swing實(shí)現(xiàn)數(shù)據(jù)庫：mysql.附sql代碼，其余數(shù)據(jù)庫可復(fù)制sql代碼運(yùn)行數(shù)據(jù)庫連接文件mysql-connector-java-8.0.16.jar本系統(tǒng)的背景圖片可根據(jù)自己的需求替換項(xiàng)目分為管理員和普通用戶兩種角色管理員有圖書査詢、圖書借還、賬戶管理（修改密碼、賬戶信息、借書記錄）、圖書管理（増加、修改、刪除）的權(quán)限普通用戶有圖書査詢、圖書借還、賬戶管理（修改密碼、借書記錄）的權(quán)限項(xiàng)目結(jié)樸#setLayout(null);setSize(800,600);setLocationRelativeTo(null);jLabel.setFont(font);jLabel.setBounds(315,80,400,100);jPanel.add(jLabel);model.addColumn("書號newVector<Integer>());model.addColumn("書名newVector<Integer>());model.addColumn("借書日期"，newVector<Integer>());model.addColumn("還書日期",newVector<Integer>());model.addColumn("狀態(tài)”,newVector<Integer>());JTablejTable=new3Table(model);JScrollPanepane=new3ScrollPane(jTable);pane.setBounds(80,160,640,350);jLayeredPane.add(pane);JTableHeaderhead=jTable.getTableHeader();head.setPreferredSize(newDimension(head.getWidth(),30))；head.setFont(newFont("宋體”，F(xiàn)ont.SOLD,20));head.setBackground(Color.cyan);jTable.setRowHeight(30);jTable.setFont(newFont(”宋體”，F(xiàn)ont.ROMAN_BASELINEt17));DefaultTableCellRendererrenderer=newDefaultTableCellRenderer();renderer.setHorizontalAlignment(DefaultTableCellRenderer.C￡NTER);jTable.setDefaultRenderer(Object.class,renderer);borrow(model,user);jPanel.setBounds(0,0,800,200);jPanel.setOpaque(false);jPanel.setLayout(null);setTitle("借書記錄”)；setResizable(false);setContentPane(jLayeredPane);add(jPanel);add(Label);setVisible(true);}privatevoidborrow(DefaultTableModelmodel.Stringuser){Connectioncon=DB.connectDB();PreparedStatementpreSql;ResultSetrs;StringsqlStr="select*fromborrowrecordswhereuser=?”；try{preSql=con.prepareStatement(sqlStr);preSql.setString(l,user);rs=preSql.executeQuery();booleanflag=false;while(rs.next())(flag=true;intbookid=rs.getlnt(3);Stringbookname=rs.getString(4);Datedate=rs.getDate(5);Datedate2=rs.getDate(6);Stringstate=rs.getString(7);model.addRow(newVector<>(Arrays.asList(bookid,bookname,date,date2,state)));}if(!flag){3OptionPane.showMessageDiaLog(null,”您還沒有借書哦！")；}con.close();)catch(SQLExceptione){}}}UpdateBookFace.java:packageView;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.table.DefaultTableModel;importDao.BookDao;publicclassUpdateBookFaceextends3Frame(

privateDPaneljPanel=new3Panel();privateJLabeljLabel=newJLabel("修改圖書信息”)；privateJLabeljLabel2=newJLabelC類另lj:");privateJLabeljLabel3=newJLabel(M書名:”)；privateJLabeljLabel4=newDLabelC作者：”）；privateJLabeljLabel5=newJLabel（-出版社：“）；privateJLabeljLabels=newJLabel（"價(jià)格：”）；privateJLabeljLabel6=newJLabel（"狀態(tài)：”）；privateJLabeljLabel?=newJLabel(M書號:”)；privateDTextFieldfield=new3TextField(20);privateDTextFieldfield2=new3TextField(20);privateDTextFieldfield3=newJTextField(20);privateDTextFieldfield4=new3TextField(20);privateDTextFieldfields=newJTextField(20);private3ComboBox<String>box=new3ComboBox<String>();private3ComboBox<String>boxl=newJComboBox<String>();privateDButtonbutton=new3Button("確定“)；privateFontfont=newFont("宋體"，F(xiàn)ont.BOLD,40);privateFontfont2=newFont("宋體"，F(xiàn)ont.BOLD,25);privateFontfont3=newFont("宋體"，F(xiàn)ont.BOLD,20);publicDefaultTableModelmodel=newDefaultTableModel();privateStrings;privateStringsi;

publicUpdateBookFace(){Iconi=newImagelcon("img\\bgl.jpg");3LabelLabel=newJLabel(i);Label.setBounds(0,0,580,100);setLayout(null);setSize(580,650);setLocationRelativeTo(null);setTitle("修改圖書信息”);jLabel.setFont(font);jLabel.setBounds(155,80,400,100);jLabel?.setFont(font2);jLabel7.setBounds(125,200,250,30)；jLabel2.setFont(font2);jLabel2.setBounds(125,250,250,jLabel2.setBounds(125,250,250,30)；jLabel3.setFont(font2);jLabel?.setBounds(125,300,250,jLabel?.setBounds(125,300,250,30)；jLabel4.setFont(font2);jLabel4.setBounds(125,350,250,jLabel4.setBounds(125,350,250,30)；jLabels.setFont(font2);jLabels.setBounds(125,400,250,jLabels.setBounds(125,400,250,30)；jLabel6.setFont(font2);jLabel6.setBounds(125,450,250,jLabel6.setBounds(125,450,250,30)；jLabels.setFont(font2);jLabel8.setBounds(125,500,250,30);box?addltem("請選擇類別")；BookDao.findcategory(box');box.setFont(font3);box.setBounds(245,250,200,30);box.setOpaque(false);boxl.addltem("在館”)；boxl.addltem("外借");BookDao.findcategory(box);boxl.setFont(font3);boxl.setBounds(245,450,200,30);boxl.setOpaque(false);field4.setFont(font3);field4.setBackground(Color.cyan);field4.setBounds(245,200,200,30);field4.setOpaque(false);field.setFont(font3);field.setBackground(Color.cyan);field.setBounds(245,300,200,30);field.setOpaque(false);field2.setFont(font3);field2.setBackground(Color.cyan);field2.setBounds(245,350,200,30);field2.setOpaque(false);fields.setFont(font3);field3.setBackground(Color.cyan);field3.setBounds(245,400,200,30);field3.setOpaque(false);fields.setFont(font3);fields.setBackground(Color.cyan);fields.setBounds(245,500,200,30);fields.setOpaque(false);button.setFont(font2);button.setBounds(120,560,325,35);button.setBackground(Color.cyan);button.setOpaque(false);jPanel.add(jLabel);jPanel.add(jLabel2);jPanel.add(jLabel3);jPanel.add(jLabel4);jPanel.add(jLabels);jPanel.add(jLabel6);jPanel.add(jLabel?);jPanel.add(jLabels);jPanel.add(box);jPanel.add(boxl);jPanel.add(field);jPanel.add(field2);jPanel.add(field3);jPanel.add(field4);jPanel.add(fieldS);jPanel.add(button);add();jPanel.setBounds(0,0,850,650);jPanel.setOpaque(false);jPanel.setLayout(null);setResizable(false);add(jPanel);add(Label);setVisible(true);}publicvoidsetModel(DefaultTableModelmodel){this.model=model;}privatevoidadd(){s=”請選擇類別"；box.addItemListener(newItemListener(){publicvoiditemStateChanged(ItemEvente){if(e.getStateChange()==ItemEvent.SE￡ECr￡D){s=(String)e.getItem();}}})；si=“在館”；boxl.addItemListener(newItemListener()(publicvoiditemStateChanged(ItemEvente)(if(e.getStateChange()==ItemEvent.S￡L￡C7￡D)(sl=(String)e.getItem();}}})；button.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){try{Stringbookname=field.getText().trim();Stringauthor=field2.getText().trim();Stringpress=field3.getText().trim();Stringprice=field4.getText().trim();intbookid=Integer.parselnt(fields.getText().trim。)；BookDao.modifybook(bookid,s,bookname,author,press,price,si);model.setRowCount(0);BookDao.atLdoo/?(model);J0ptionPane.sA7owMessageDiaLog(null,"操作成功”)；}catch(Exceptionel)(JOptionPane.showMessageDiaLog(null,"輸入不正確","警告”，JOptionPane.UARNING_MESSAGE);}}})；}}

UpdatePswFace.java:packageView;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.*;importDao.DB;importTest.LandTest;publicclassUpdatcPswFaceextendsJFrame{privateDPaneljPanel=newJPanel();privateDLabeljLabel=newJLabel("用戶名：”)；private3LabeljLabel2newJLabel();privateJLabeljLabel3new3Label（M原始密碼：”）；privateJLabeljLabel4newJLabel（"新密碼：“）；privateJLabeljLabelSnewJLabel（”確認(rèn)密碼：”）；privateDPasswordFieldfield=new3PasswordField(22);privateprivate3LabeljLabel2newJLabel();privateJLabeljLabel3new3Label（M原始密碼：”）；privateJLabeljLabel4newJLabel（"新密碼：“）；privateJLabeljLabelSnewJLabel（”確認(rèn)密碼：”）；privateDPasswordFieldfield=new3PasswordField(22);privateDPasswordFieldfield2=new3PasswordField(22);privateDPasswordFieldfield3=new3PasswordField(22);privateFontfont=privateFontfont=newFont("宋體Font.BOLD,24);privateFontfontl=newFont("宋體”,Font.BOLD,22);privateJButtonbutton=new3Button("修改")；privateDFrameframe=new3Frame();publicUpdatePswFace(Stringuser){setSize(600,45。)；Iconi=newImagelcon("img\\bgl.jpg");3LabelLabel=newJLabel(i);Label.setBounds(0,0,600,150);setTitle("修改密碼”)；jLabel2.setText(user);jLabel.setFont(font);jLabel2.setFont(font);jLabel3.setFont(font);jLabel4.setFont(font);jLabelS.setFont(font);field.setFont(fontl);field2.setFont(fontl);field3.setFont(fontl);button.setFont(fontl);add();jLabel.setBounds(120,170,150,30);jLabel2.setBounds(260,170,300,30);jLabel3.setBounds(120,210,150,30);field.setBounds(260,215,140,25);jLabel4.setBounds(120,250,150,30);field2.setBounds(260,255,140,25);jLabel5.setBounds(120,290,150,30);field3.setBounds(260,295,140,25);button.setBounds(115,340,285,30);jPanel.add(jLabel);jPanel.add(jLabel2);jPanel.add(jLabel3);jPanel.add(field);jPanel.add(jLabel4);jPanel.add(field2);jPanel.add(jLabels);jPanel.add(field3);jPanel.add(button);jPanel.setLayout(null);jPanel.setBounds(0,0,600,400);jPanel.setOpaque(false);add(jPanel);add(Label);setResizable(false);setLocationRelativeTo(null);setLayout(null);setVisible(true);}publicvoidsetFrame(3Frameframe)(this.frame=frame;}privatebooleancomparison(Stringuser.Stringpassword)(Connectioncon=DB.connectDB();PreparedStatementpreSql;ResultSetrs;StringsqlStr="select*fromusertablewhereuser=try{preSql=con.prepareStatement(sqlStr);preSql.setString(l,user);rs=preSql.executeQuery();while(rs.next())(Strings=rs.getString(4);if(s.equals(password)){returntrue;}else(returnfalse;}}con.close();returnfalse;}catch(SQLExceptione)(returnfalse;}}privatevoidadd()(button.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){Stringuser=jLabel2.getText().trim();Stringoldpass=field.eetTextC).trim();Stringnewpass=field2.getTex^t().trim();Stringsurepass=field3.fietText().trimQ;if(comparison(user,oldpass)){if(newpass.length()<6||newpass.length()>16){JOptionPane.showMessageDiaLog(null,"密碼規(guī)定6-16位，不能含有空格"，"警告"，JOptionPane.MARNING_MESSAGE');empty。；}else(if(newpass.equals(surepass)){Dao.AdminDao.modifypass(user,newpass);JOptionPane.shoMHessageDiaLog(null,"修改成功”)；JOptionPane.shoMMessageDiaLog(null,"請重新登陸");dispose();frame.dispose();newLandTest();)else{DOptionPane.shoMMessageDiaLog(null,"確認(rèn)密碼不相同"，"警告"，JOptionPane.UARNING_MESSAGE);empty。;}}}else(JOptionPane.shoMMessageDiaLog(r\ullf"原始密碼不正確"，"警告"，JOptionPane.MARNING_MESSAGE);empty。；}}})；)

privatevoidempty()(field.setText("");field2.setText("”)；field3.setText(H,');}}UserFace.java:packageView;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importTest.LandTest;publicclassUserFacepublicDPaneljPanelZ=newpublicclassUserFacepublicDPaneljPanelZ=newJPanel();privateDLabeljLabel=newJLabel("賬戶管理”);privateDButtonprivateDButtonbutton2new3Button("修改密碼");privateJButtonprivateJButtonbutton?newJButton（"借書記錄”）；privateJButtonbutton4privateJButtonbutton4newJButton("退出登陸");privateFontfont=privateFontfont=newFont("宋體Font.BOLD,60);privateFontfontl=newFont("宋體”,Font.BOLD,25);privateStringuser;privateDFrameframe;publicUserFace(){Iconi=newImag