小型圖書管理系統(tǒng)Java課程設(shè)計(jì)

上傳人：唯*** IP屬地：廣東上傳時(shí)間：2023-01-13 格式：DOCX 頁數(shù)：65 大?。?80.62KB 積分：9.6 舉報(bào) 版權(quán)申訴

已閱讀5頁，還剩60頁未讀，繼續(xù)免費(fèi)閱讀

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡介

小型圖書管理系統(tǒng)Java課程設(shè)計(jì)課程名稱：Java應(yīng)用項(xiàng)目作者：***前言本系統(tǒng)是小型圖書管理系統(tǒng)，專為個(gè)人設(shè)計(jì)。本系統(tǒng)啟動(dòng)后需要登陸，然后進(jìn)入主界在這個(gè)界面我們可以選擇所需要的功能模塊來完成所要執(zhí)行的功能。系統(tǒng)共有4個(gè)功能模塊：圖書入庫、圖書查詢、圖書刪除、圖書概覽、修改密碼。支持一系列關(guān)于圖書管理方面的簡單操作,諸如查詢、刪除、添加、修改密碼等。系統(tǒng)流程圖圖書刪除圖書概覽修改密碼圖書查詢圖書入庫系統(tǒng)開始失敗退出判斷成功判斷輸入密碼圖書刪除圖書概覽修改密碼圖書查詢圖書入庫系統(tǒng)開始失敗退出判斷成功判斷輸入密碼說明：退出首先是輸入判斷，相當(dāng)于在登陸模塊，要求用戶輸入用戶名和密碼；然后判斷，如果判斷失敗退出系統(tǒng)，否則進(jìn)入圖書管理系統(tǒng)的主界面。進(jìn)入主界面后，用戶要選擇所需執(zhí)行的功能，即通過鼠標(biāo)點(diǎn)擊相應(yīng)項(xiàng)，來完成所需操作。退出圖書名圖書號(hào)圖書名圖書號(hào)單價(jià)作者出版社入庫時(shí)間表book表user用戶名密碼數(shù)據(jù)庫表數(shù)據(jù)庫設(shè)計(jì)在圖書管理系統(tǒng)中，共設(shè)計(jì)2張表。本系統(tǒng)使用Access來創(chuàng)建數(shù)據(jù)表。數(shù)據(jù)庫的名稱為Book.mdb。1.表book字段名稱數(shù)據(jù)類型圖書名文本圖書號(hào)文本（主鍵）單價(jià)文本作者文本出版社文本入庫時(shí)間文本2.表user字段名稱數(shù)據(jù)類型用戶名文本（主鍵）密碼文本系統(tǒng)源碼程序代碼1登陸界面:程序名Login.javaimportjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.Container;importjava.util.*;importjava.sql.*;classLoginextendsJFrameimplementsActionListener {Containercp=null;JFramef=null;JButtonj1,j2;JTextFieldt1;JPasswordFieldt2;JLabeljlable1,jlable2;Colorc;JPaneljp1,jp2; Login(){ f=newJFrame("小型圖書管理系統(tǒng)"); j1=newJButton("確定"); j2=newJButton("取消"); cp=f.getContentPane(); jlable1=newJLabel("輸入用戶名"); jlable2=newJLabel("用戶密碼"); jp1=newJPanel(); jp2=newJPanel(); t1=newJTextField(18); t2=newJPasswordField(18); jp1.add(jlable1);jp1.add(t1);jp1.add(jlable2); jp1.add(t2);JLabelJL=newJLabel("<html><fontcolor=#CC00FFsize='7'>歡迎登陸",SwingConstants.CENTER); cp.add(JL,"North"); jp2.add(j1); jp2.add(j2); cp.add(jp1,"Center"); cp.add("South",jp2); jp1.setBackground(newColor(255,153,255)); Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ //setSize(x,y);/*讓系統(tǒng)窗口平鋪整個(gè)顯示器窗口*/ f.setSize(300,300); intxcenter=(x-300)/2; intycenter=(y-300)/2; f.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f.setVisible(true);//----------------------------------------------------- j1.addActionListener(this);//注冊事件監(jiān)聽器j2.addActionListener(this);f.addWindowListener(newWindowAdapter(){ publicvoidwindowClosing(WindowEvente){ System.exit(0); } } ); }publicvoidconfirm()//驗(yàn)證用戶和密碼是否存在 {try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Statementsql=con.createStatement(); Stringuname=t1.getText().trim(); StringMima=t2.getText().trim(); StringqueryMima="select*fromuserwhere用戶名='"+uname+"'and密碼='"+Mima+"'"; ResultSetrs=sql.executeQuery(queryMima);if(rs.next()) { newBook(uname); f.hide(); con.close(); }else{ JOptionPane.showMessageDialog(null,"該用戶不存在","提示！", JOptionPane.YES_NO_OPTION); } t1.setText(""); t2.setText(""); }catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } }publicvoidactionPerformed(ActionEvente){ Stringcmd=e.getActionCommand(); if(cmd.equals("確定")){ confirm(); } elseif(cmd.equals("取消")){ f.dispose(); } }publicstaticvoidmain(String[]arg){ Logina=newLogin();}}2圖書概覽：程序名BookBrower.javaimportjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.Container;importjava.util.*;importjava.sql.*;classBookBrowerimplementsActionListener{ JFramef; Containercp; JPaneljpS,jpanelWest; JButtonjbt1,jbt2;//按鈕，查詢、取消、修改 JLabellabel,L; //標(biāo)簽 //定義文本框 JTabletable;//用來接收數(shù)據(jù)庫中返回的信息ObjectcolumnName[]={"圖書名","圖書號(hào)","單價(jià)","作者","出版社","入庫時(shí)間"};Objectar[][]=newObject[80][6]; Stringsno; Stringcount="xx"; BookBrower(){ f=newJFrame(); cp=f.getContentPane();//初始化面板、按鈕、標(biāo)簽、文本框 jpS=newJPanel();jpanelWest=newJPanel(); //------------------------------------------------ jbt1=newJButton("確定"); jbt2=newJButton("返回"); //------------------------------------------------ label=newJLabel("<html><fontcolor=#CC00FFsize='4'>圖書概覽",SwingConstants.CENTER); label.setForeground(Color.blue); L=newJLabel("書庫現(xiàn)在共有圖書"+count+"本"); //------------------------------------------------table=newJTable(ar,columnName);//ar存放表中的數(shù)據(jù)，columnname表示列名 JScrollPanescrollpane=newJScrollPane(table); //------------------------------------------------ //布局,添加控件 jpS.add(jbt1); jpS.add(jbt2); JPaneljpanel=newJPanel(); jpanel.add(label); JPanelpp4=newJPanel();JPaneljpE=newJPanel(); cp.add(jpanel,"North"); JPaneljp=newJPanel(); //jp.add(scrollpane); JPanelp=newJPanel();//用來放兩個(gè)表 p.setLayout(newBorderLayout()); p.add(L,"North"); p.add(scrollpane); cp.add(pp4,"West"); cp.add(p,"Center");cp.add(jpS,"South"); cp.add(jpE,"East"); //------------------------------------------------Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ f.setSize(400,330); intxcenter=(x-350)/2; intycenter=(y-330)/2;f.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f.setVisible(true);//-------------------------------------------------jbt1.addActionListener(this);//注冊監(jiān)聽器jbt2.addActionListener(this);/*f.addWindowListener(newWindowAdapter(){ publicvoidwindowClosing(WindowEvente){ System.exit(0); } } );*/ } //------------------------------------------------ inti=0;publicvoidshowRecord() { while(i>=0) { ar[i][0]=""; ar[i][1]=""; ar[i][2]=""; ar[i][3]=""; ar[i][4]=""; ar[i][5]=""; i--; } i=0;try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Strings="select*frombook";Statementsql=con.createStatement(); ResultSetrs=sql.executeQuery(s); while(rs.next()) { Stringbname=rs.getString(1); Stringbno=rs.getString(2); Stringprice=rs.getString(3); Stringwriter=rs.getString(4); Stringpublish=rs.getString(5); Stringindate=rs.getString(6); ar[i][0]=bname; ar[i][1]=bno; ar[i][2]=price; ar[i][3]=writer; ar[i][4]=publish; ar[i][5]=indate; i++; } count=""+i+""; L.setText("書庫現(xiàn)在共有圖書"+count+"本"); f.repaint(); con.close();}catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } } publicvoidactionPerformed(ActionEvente) { Stringcmd=e.getActionCommand(); if(cmd.equals("確定")) { f.hide(); } if(cmd.equals("返回")) f.hide(); }publicstaticvoidmain(String[]arg){ BookBrowera=newBookBrower(); a.showRecord();}}3圖書查詢：程序名QueryBook.javaimportjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.Container;importjava.util.*;importjava.sql.*;classQueryBookimplementsActionListener{ JFramef3; Containercp; JPaneljp1,jp2,jp3,jp4,jp,jpanelWest; JButtonjbt1,jbt2;//按鈕，確定、取消 JLabellabel; //標(biāo)簽：請輸入圖書號(hào) JTextFieldtf,tf1,tf2,tf3,tf4,tf5,tf6;//定義文本框 JLabellabel1,label2,label3,label4; QueryBook(){ f3=newJFrame(); cp=f3.getContentPane();//初始化面板、按鈕、標(biāo)簽、文本框 jp1=newJPanel(); jp2=newJPanel(); jp3=newJPanel(); jp4=newJPanel(); jpanelWest=newJPanel(); jp=newJPanel(); //------------------------------------------------ jbt1=newJButton("確定"); jbt2=newJButton("取消"); //------------------------------------------------ label=newJLabel("<html><fontcolor=#CC00FFsize='4'>請輸入圖書號(hào)：",SwingConstants.CENTER); label.setForeground(Color.blue); tf=newJTextField(20);//------------------------------------------------ tf1=newJTextField(20); tf2=newJTextField(20); tf3=newJTextField(20); tf4=newJTextField(20); tf5=newJTextField(20);tf6=newJTextField(20); //------------------------------------------------ //布局,添加控件 JPaneljpanel=newJPanel(); jpanel.add(label); jpanel.add(tf); JPanelpp4=newJPanel();JPaneljpane4=newJPanel(); cp.add(jpanel,"North"); JPanelpp2=newJPanel(newGridLayout(6,1)); JPanelpp3=newJPanel(); pp4.setLayout(newGridLayout(6,1)); pp4.add(newJLabel("圖書名",SwingConstants.CENTER)); pp2.add(tf1); pp4.add(newJLabel("圖書號(hào)",SwingConstants.CENTER)); pp2.add(tf2); pp4.add(newJLabel("單價(jià)",SwingConstants.CENTER)); pp2.add(tf3); pp4.add(newJLabel("作者",SwingConstants.CENTER)); pp2.add(tf4); pp4.add(newJLabel("出版社",SwingConstants.CENTER)); pp2.add(tf5); pp4.add(newJLabel("入庫時(shí)間",SwingConstants.CENTER)); pp2.add(tf6); pp3.add(jbt1);pp3.add(jbt2); cp.add(pp4,"West"); cp.add(pp2,"Center");cp.add(pp3,"South"); cp.add(jpane4,"East"); //------------------------------------------------Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ f3.setSize(350,330); intxcenter=(x-350)/2; intycenter=(y-330)/2; f3.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f3.setVisible(true);//-------------------------------------------------jbt1.addActionListener(this);//注冊監(jiān)聽器jbt2.addActionListener(this);/*f3.addWindowListener(newWindowAdapter(){ publicvoidwindowClosing(WindowEvente){ System.exit(0); } } );*/ } //------------------------------------------------publicvoidshowRecord() {try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Statementsql; Stringql=tf.getText().trim(); Strings="select*frombookwhere圖書號(hào)='"+ql+"'";sql=con.createStatement(); ResultSetrs=sql.executeQuery(s); if(rs.next()) { Stringbname=rs.getString(1); Stringbno=rs.getString(2); Stringprice=rs.getString(3); Stringwriter=rs.getString(4); Stringpublish=rs.getString(5); Stringindate=rs.getString(6); tf1.setText(bname); tf2.setText(bno); tf3.setText(price); tf4.setText(writer); tf5.setText(publish); tf6.setText(indate); }else {JOptionPane.showMessageDialog(null,"您輸入的圖書號(hào)不存在，請重新輸入", "輸入錯(cuò)誤",JOptionPane.YES_NO_OPTION); } con.close();}catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } tf1.setEditable(false); tf2.setEditable(false); tf3.setEditable(false); tf4.setEditable(false); tf5.setEditable(false); tf6.setEditable(false); } publicvoidactionPerformed(ActionEvente) { Stringcmd=e.getActionCommand(); if(cmd.equals("確定")) { showRecord(); tf.setText(""); } elseif(cmd.equals("取消")) f3.hide(); }publicstaticvoidmain(String[]arg){ QueryBooka=newQueryBook();}}4圖書刪除：程序名RemoveBook.javaimportjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.Container;importjava.util.*;importjava.sql.*;classRemoveBookimplementsActionListener{ JFramef; Containercp; JPaneljpS,jpanelWest; JButtonjbt1,jbt2,jbt3;//按鈕，查詢、取消、修改 JLabellabel,L; //標(biāo)簽：請輸入學(xué)號(hào) JTextFieldtf;//定義文本框 JTabletable;//用來接收數(shù)據(jù)庫中返回的信息ObjectcolumnName[]={"圖書名","圖書號(hào)","單價(jià)","作者","出版社","入庫時(shí)間"};Objectar[][]=newObject[80][6]; Stringsno; Stringcount="xx"; RemoveBook(){ f=newJFrame(); cp=f.getContentPane();//初始化面板、按鈕、標(biāo)簽、文本框 jpS=newJPanel();jpanelWest=newJPanel(); //------------------------------------------------ jbt1=newJButton("查詢"); jbt2=newJButton("取消");jbt3=newJButton("刪除"); //------------------------------------------------ label=newJLabel("<html><fontcolor=#CC00FFsize='4'>請輸入要?jiǎng)h除的圖書名：",SwingConstants.CENTER); label.setForeground(Color.blue); L=newJLabel("該種圖書共有"+count+"本"); //------------------------------------------------table=newJTable(ar,columnName);//ar存放表中的數(shù)據(jù)，columnname表示列名 JScrollPanescrollpane=newJScrollPane(table); //------------------------------------------------ tf=newJTextField(18); //------------------------------------------------ //------------------------------------------------ //布局,添加控件 jpS.add(jbt1); jpS.add(jbt2); jpS.add(jbt3); JPaneljpanel=newJPanel(); jpanel.add(label); jpanel.add(tf); JPanelpp4=newJPanel();JPaneljpE=newJPanel(); cp.add(jpanel,"North"); JPaneljp=newJPanel(); //jp.add(scrollpane); JPanelp=newJPanel();//用來放兩個(gè)表 p.setLayout(newBorderLayout()); p.add(L,"North"); p.add(scrollpane); cp.add(pp4,"West"); cp.add(p,"Center");cp.add(jpS,"South"); cp.add(jpE,"East"); //------------------------------------------------Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ f.setSize(400,330); intxcenter=(x-350)/2; intycenter=(y-330)/2; f.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f.setVisible(true);//-------------------------------------------------jbt1.addActionListener(this);//注冊監(jiān)聽器jbt2.addActionListener(this);jbt3.addActionListener(this);/*f.addWindowListener(newWindowAdapter(){ publicvoidwindowClosing(WindowEvente){ System.exit(0); } } );*/ } //------------------------------------------------ inti=0;publicvoidshowRecord(Stringql) { while(i>=0) { ar[i][0]=""; ar[i][1]=""; ar[i][2]=""; ar[i][3]=""; ar[i][4]=""; ar[i][5]=""; i--; } i=0;try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Statementsql; Strings="select*frombookwhere圖書名='"+ql+"'";sql=con.createStatement(); ResultSetrs=sql.executeQuery(s); while(rs.next()) { Stringbname=rs.getString(1); Stringbno=rs.getString(2); Stringprice=rs.getString(3); Stringwriter=rs.getString(4); Stringpublish=rs.getString(5); Stringindate=rs.getString(6); ar[i][0]=bname; ar[i][1]=bno; ar[i][2]=price; ar[i][3]=writer; ar[i][4]=publish; ar[i][5]=indate; i++; } count=""+i+""; L.setText("該種圖書共有"+count+"本"); f.repaint(); con.close();System.out.println(ar[0][1]);}catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } } publicvoiddeleteRecord(intindex) {try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Statementsql; Stringql=(String)(ar[index][1]); Strings="delete*frombookwhere圖書號(hào)='"+ql+"'";sql=con.createStatement(); intdel=sql.executeUpdate(s); if(del==1) {JOptionPane.showMessageDialog(null,"刪除成功！", "信息",JOptionPane.YES_NO_OPTION); } con.close(); f.repaint();}catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } }publicvoidactionPerformed(ActionEvente) { Stringremember=""; Stringql=""; Stringcmd=e.getActionCommand(); if(cmd.equals("查詢")) { ql=tf.getText().trim(); remember=ql; showRecord(ql); } if(cmd.equals("刪除")) { intindex=table.getSelectedRow(); if(index==-1) JOptionPane.showMessageDialog(null,"請選定要?jiǎng)h除的表格行", "輸入錯(cuò)誤",JOptionPane.YES_NO_OPTION); else{ deleteRecord(index); //showRecord(remember); } } if(cmd.equals("取消")) f.hide(); }publicstaticvoidmain(String[]arg){ RemoveBooka=newRemoveBook();}}5圖書入庫：程序名BookIn.javaimportjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.Container;importjava.util.*;importjava.sql.*;importjavax.swing.text.JTextComponent;//extendsJFrameclassBookInimplementsActionListener{ JFramef3; Containercp; JPaneljp1,jp2,jp3,jp4,jp,jpanelWest; JButtonjbt1,jbt2;//按鈕:確定、取消、 JLabellabel; //標(biāo)簽 JTextFieldtf1,tf2,tf3,tf4,tf5,tf6;//定義文本框 JLabellabel1,label2,label3,label4; Stringsno;BookIn(){ f3=newJFrame(); cp=f3.getContentPane();//初始化面板、按鈕、標(biāo)簽、文本框 jp1=newJPanel(); jp2=newJPanel(); jp3=newJPanel(); jp4=newJPanel(); jpanelWest=newJPanel(); jp=newJPanel(); //------------------------------------------------ jbt1=newJButton("確定"); jbt2=newJButton("取消"); //------------------------------------------------ label=newJLabel("<html><fontcolor=#CC00FFsize='4'>圖書入庫",SwingConstants.CENTER); label.setForeground(Color.blue); //------------------------------------------------ tf1=newJTextField(20); tf2=newJTextField(20); tf3=newJTextField(20); tf4=newJTextField(20); tf5=newJTextField(20);tf6=newJTextField(20); //------------------------------------------------ //布局,添加控件 jp1.add(jbt1); jp1.add(jbt2); sno=tf4.getText(); jp1.add(newJLabel("您好"+sno+"歡迎登陸學(xué)生信息系統(tǒng)")); JPaneljpanel=newJPanel(); jpanel.add(label); JPanelpp4=newJPanel();JPaneljpane4=newJPanel(); cp.add(jpanel,"North"); JPanelpp2=newJPanel(newGridLayout(6,1)); JPanelpp3=newJPanel(); pp4.setLayout(newGridLayout(6,1)); pp4.add(newJLabel("圖書名",SwingConstants.CENTER)); pp2.add(tf1); pp4.add(newJLabel("圖書號(hào)",SwingConstants.CENTER)); pp2.add(tf2); pp4.add(newJLabel("單價(jià)",SwingConstants.CENTER)); pp2.add(tf3); pp4.add(newJLabel("作者",SwingConstants.CENTER)); pp2.add(tf4); pp4.add(newJLabel("出版社",SwingConstants.CENTER)); pp2.add(tf5); pp4.add(newJLabel("入庫時(shí)間",SwingConstants.CENTER)); pp2.add(tf6); pp3.add(jbt1); pp3.add(jbt2); cp.add(pp4,"West"); cp.add(pp2,"Center");cp.add(pp3,"South"); cp.add(jpane4,"East"); //------------------------------------------------Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ f3.setSize(350,330); intxcenter=(x-350)/2; intycenter=(y-330)/2; f3.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f3.setVisible(true);//-------------------------------------------------jbt1.addActionListener(this);//注冊監(jiān)聽器jbt2.addActionListener(this);/*f3.addWindowListener(newWindowAdapter(){ publicvoidwindowClosing(WindowEvente){ System.exit(0); } } );*/ } //------------------------------------------------publicvoidinsertRecord() {if(tf1.getText().equals("")||tf2.getText().equals("")||tf3.getText().equals("")|| tf4.getText().equals("")||tf5.getText().equals("")||tf6.getText().equals("")) { JOptionPane.showMessageDialog(f3,"請?zhí)顚憟D書資料"); return; }try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundExceptione){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ Stringurl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=Book.mdb";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫文件 Connectioncon=DriverManager.getConnection(url); Statementsql; Strings="insertintobookvalues('"+tf1.getText()+"','"+tf2.getText()+"','"+ tf3.getText()+"','"+tf4.getText()+"','"+tf5.getText()+"','"+tf6.getText()+"');"; //查詢輸入的圖書號(hào)是否在數(shù)據(jù)庫中存在Stringquery="select*frombookwhere圖書號(hào)='"+tf2.getText()+"'"; sql=con.createStatement(); ResultSetrs=sql.executeQuery(query);//返回查詢結(jié)果集 booleanmoreRecords=rs.next();//判斷結(jié)果集是否有數(shù)據(jù) if(moreRecords) { JOptionPane.showMessageDialog(f3,"圖書號(hào)已經(jīng)被使用，請重新輸入"); con.close(); tf2.setText(""); return; } intinsert=sql.executeUpdate(s); if(insert==1) { JOptionPane.showMessageDialog(null,"圖書信息錄入成功！"); tf1.setText(""); tf2.setText(""); tf3.setText(""); tf4.setText(""); tf5.setText(""); tf6.setText(""); }}catch(SQLExceptiong) { System.out.println("ECode"+g.getErrorCode()); System.out.println("EM"+g.getMessage()); } } publicvoidactionPerformed(ActionEvente) { Stringcmd=e.getActionCommand(); if(cmd.equals("確定")) { insertRecord(); } elseif(cmd.equals("取消")) f3.hide(); }publicstaticvoidmain(String[]arg){ BookIna=newBookIn();}}6主界面：程序名Book.java/*本類為用戶界面*/.*;importjava.sql.*;importjava.awt.*;importjava.awt.event.*;importjava.io.*;importjava.util.*;importjavax.swing.*;importjavax.swing.border.*;importjava.util.*;classBookextendsJFrameimplementsActionListener{ JButtonQueryScore=newJButton("圖書查詢"); JButtonQueryXuefen=newJButton("圖書入庫"); JButtonjiangfa=newJButton("圖書刪除"); JButtonxuanke=newJButton("圖書概覽"); JButtongaiMima=newJButton("修改密碼"); JMenuBarmb=newJMenuBar();//菜單欄 JPaneljp=newJPanel();//用來填放子模塊 Containercp=getContentPane();String username; Book(){}Book(Stringusername) { this.username=username; mb.add(QueryScore); mb.add(QueryXuefen); mb.add(jiangfa); mb.add(xuanke); mb.add(gaiMima);cp.add(mb,"North"); //設(shè)置邊框 jp.setBorder(BorderFactory.createTitledBorder(BorderFactory .createLineBorder(Color.blue,2),null, TitledBorder.CENTER,TitledBorder.TOP)); jp.setLayout(newBorderLayout());JLabellabel1=newJLabel(newImageIcon("4.jpg")); jp.add(label1);/*JLabelJL=newJLabel("<html><fontcolor=#CC00FFsize='7'>歡迎登陸",SwingConstants.CENTER); jp.add(JL,"North");*/ JLabellabel2=newJLabel(newImageIcon("2.jpg")); //jp.add(label2,"South"); JScrollPanescrollpane=newJScrollPane(jp); cp.add(scrollpane); setTitle("歡迎登陸"); Toolkitkit=Toolkit.getDefaultToolkit(); Dimensionscreen=kit.getScreenSize(); intx=screen.width; /*取得顯示器窗口的寬度*/ inty=screen.height; /*取得顯示器窗口的高度*/ //setSize(x,y);/*讓系統(tǒng)窗口平鋪整個(gè)顯示器窗口*/ setSize(600,600); intxcenter=(x-600)/2; intycenter=(y-600)/2; setLocation(xcenter,ycenter);/*顯示在窗口中央*/ setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); //注冊臨聽器 QueryScore.addActionListener(this); QueryXuefen.addActionListener(this); jiangfa.addActionListener(this); xuanke.addActionListener(this); gaiMima.addActionListener(this); } publicvoidactionPerformed(ActionEvente) { Stringcmd=e.getActionCommand(); if(cmd.equals("圖書查詢")) { newQueryBook(); } if(cmd.equals("圖書入庫")) { newBookIn(); } if(cmd.equals("圖書刪除")) { newRemoveBook(); } if(cmd.equals("圖書概覽")) { newBookBrower().showRecord(); } if(cmd.equals("修改密碼")) { newUpdateMima(username); } } publicstaticvoidmain(String[]args) { newBook(""); } }7.密碼修改：程序名UpdateM.*;importjava.sql.*;importjava.awt.*;importjava.awt.event.*;importjava.io.*;importjava.util.*;importjavax.swing.*;classUpdateMimaextendsJFrameimplementsActionListener{ JFramef; Containercp; JPaneljp1,jp2,jp3,jp4,jp,jpanelWest; JButtonjbt1,jbt2;//按鈕，確定、取消 JLabellabel; //標(biāo)簽：修改密碼 JTextFieldname;JPasswordFieldtf1,tf2,tf3;//定義文本框 JLabellabel1,label2,label3,label4; Stringsno; UpdateMima(){}UpdateMima(Stringusername){ sno=username; f=newJFrame(); cp=f.getContentPane();//初始化 jp1=newJPanel(); jp2=newJPanel(); jp3=newJPanel(); jp4=newJPanel(); jpanelWest=newJPanel(); jp=newJPanel(); //------------------------------------------------ jbt1=newJButton("確定"); jbt2=newJButton("取消"); //------------------------------------------------ label=newJLabel("<html><fontcolor=#CC00FFsize='4'>修改密碼",SwingConstants.CENTER); label.setForeground(Color.blue); label.setFont(newFont("BOLD",Font.BOLD,15)); name=newJTextField(20);//name.setEditable(false); //------------------------------------------------ tf1=newJPasswordField(20); tf2=newJPasswordField(20); tf3=newJPasswordField(20); //------------------------------------------------ //布局,添加控件 jp1.add(jbt1); jp1.add(jbt2); jp1.add(newJLabel("您好"+"xx"+"歡迎登陸學(xué)生信息系統(tǒng)")); JPaneljpanel=newJPanel(); jpanel.add(label); JPanelpp4=newJPanel();JPaneljpane4=newJPanel(); cp.add(jpanel,"North"); JPanelpp2=newJPanel(newGridLayout(6,1)); JPanelpp3=newJPanel(); pp4.setLayout(newGridLayout(6,1)); pp4.add(newJLabel("用戶名:",SwingConstants.RIGHT)); pp2.add(name); pp4.add(newJLabel("原密碼:",SwingConstants.RIGHT)); pp2.add(tf1); pp4.add(newJLabel("新密碼:",SwingConstants.RIGHT)); pp2.add(tf2); pp4.add(newJLabel("確認(rèn)密碼:",SwingConstants.RIGHT)); pp2

人人文庫> 全部分類> 教育資料 > 課設(shè)設(shè)計(jì)

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

小型圖書管理系統(tǒng)Java課程設(shè)計(jì)

文檔簡介

溫馨提示

最新文檔

評論

小型圖書管理系統(tǒng)Java課程設(shè)計(jì)

文檔簡介

溫馨提示

最新文檔

評論

相關(guān)文檔