圖書管理系統(tǒng)java代碼

1、圖書管理系統(tǒng)-java代碼圖書管理系統(tǒng)-java代碼:importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;/-classTsglpublicstaticvoidmain(Stringargs)dbframedb=newdbframe(圖書管理程序);圖書管理系統(tǒng)主界面classdbframeextendsFrameimplementsActionListenerMenuBardaohang=newMenuBar();/成立菜單欄Menumfile=newMe

2、nu(功能);/成立“功能”菜單組Menumhelp=newMenu(幫助);/成立“幫助”菜單組MenuItemmdenglu=newMenuItem(登岸);MenuItemmchaxun=newMenuItem(查問);MenuItemmtianjia=newMenuItem(增添);MenuItemmshanchu=newMenuItem(刪除);MenuItemmexit=newMenuItem(退出);MenuItemmhelpp=newMenuItem(對(duì)于);Denglupdenglu=newDenglu();Ptianjiaptianjia=newPtianjia();Pma

3、inpmain=newPmain();Pchaxunpchaxun=newPchaxun();Pshanchupshanchu=newPshanchu();dbframe(Strings)/在窗口上增添菜單項(xiàng)選擇項(xiàng)setTitle(s);mfile.add(mdenglu);mfile.add(mtianjia);mfile.add(mchaxun);mfile.add(mshanchu);mfile.add(mexit);mhelp.add(mhelpp);daohang.add(mfile);daohang.add(mhelp);setMenuBar(daohang);add(pmain)

4、;addWindowListener(newWindowAdapter()publicvoidwindowClosing(WindowEvente)System.exit(0););setBounds(200,200,340,250);setResizable(false);setVisible(true);mexit.addActionListener(this);mdenglu.addActionListener(this);mtianjia.addActionListener(this);mchaxun.addActionListener(this);mshanchu.addAction

5、Listener(this);mhelpp.addActionListener(this);validate();/窗口事件監(jiān)聽publicvoidactionPerformed(ActionEvente)if(e.getSource()=mexit)System.exit(0);if(e.getSource()=mdenglu)removeAll();add(pdenglu);validate();if(e.getSource()=mtianjia)removeAll();add(ptianjia);validate();/圖書增添功能if(e.getSource()=mchaxun)rem

6、oveAll();add(pchaxun);validate();/圖書查問功能if(e.getSource()=mshanchu)removeAll();add(pshanchu);validate();/圖書刪除功能if(e.getSource()=mhelpp)JOptionPane.showMessageDialog(this,歡迎使用圖書管理系統(tǒng),對(duì)于本系統(tǒng),JOptionPane.INFORMATION_MESSAGE);/各功能菜單事件監(jiān)聽/classPtianjiaextendsPanelimplementsActionListenerTextFieldtname,tautho

7、r,tpublish,tdate,tcomment;Labellname,lauthor,lpublish,ldate,lcomment;Buttonbtn;Ptianjia()setLayout(null);btn=newButton(增添);/tname=newTextField();tauthor=newTextField();tpublish=newTextField();tdate=newTextField();創(chuàng)立“增添”按鈕tcomment=newTextField();/創(chuàng)立5個(gè)文本框lname=newLabel(書名);lauthor=newLabel(作者);lpublis

8、h=newLabel(第一版社);ldate=newLabel(第一版日期);lcomment=newLabel(議論);add(lname);add(tname);add(lauthor);add(tauthor);add(lpublish);add(tpublish);add(ldate);add(tdate);add(lcomment);add(tcomment);add(btn);/增添“按鈕”到窗口面板上lname.setBounds(10,10,70,25);tname.setBounds(90,10,220,25);lauthor.setBounds(10,40,70,25);t

9、author.setBounds(90,40,220,25);lpublish.setBounds(10,70,70,25);tpublish.setBounds(90,70,220,25);ldate.setBounds(10,100,70,25);tdate.setBounds(90,100,220,25);lcomment.setBounds(10,130,70,25);tcomment.setBounds(90,130,220,25);btn.setBounds(130,160,70,25);/設(shè)置按鈕地點(diǎn)btn.addActionListener(this);/設(shè)置按鈕監(jiān)聽setSi

10、ze(340,250);/設(shè)置窗口大小setBackground(Color.white);/setVisible(true);validate();設(shè)置窗口背景顏色publicvoidactionPerformed(ActionEvente)Stringsname=tname.getText();Stringsauthor=tauthor.getText();Stringspublish=tpublish.getText();Stringsdate=tdate.getText();Stringscomment=tcomment.getText();Stringinsertstr=insert

11、intobookvalues+(+sname+,+sauthor+,+spublish+,+sdate+,+scomment+);/SQLConnectioncon;Statementsta;ResultSetrs;try語(yǔ)句Class.forName(oracle.jdbc.driver.OracleDriver);/加載JDBC驅(qū)動(dòng)catch(ClassNotFoundExceptionee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:oracle:thin:localhost:1521:orcl,sa,o

12、rcl);/連結(jié)數(shù)據(jù)庫(kù)sta=con.createStatement();sta.executeUpdate(insertstr);/履行SQL語(yǔ)句con.close();/封閉數(shù)據(jù)庫(kù)tname.setText();tauthor.setText();tpublish.setText();tdate.setText();tcomment.setText();/從頭初始化文本框內(nèi)容JOptionPane.showMessageDialog(this,增添成功,圖書管理系統(tǒng),JOptionPane.INFORMATION_MESSAGE);catch(SQLExceptioneee)System.

13、out.println(+eee);tname.setText();tauthor.setText();tpublish.setText();tdate.setText();tcomment.setText();JOptionPane.showMessageDialog(this,增添失敗,圖書管理系統(tǒng),JOptionPane.WARNING_MESSAGE);classPmainextendsPanel/窗口面板布局Labell1=newLabel(圖書管理系統(tǒng),Label.CENTER);Labell2=newLabel(計(jì)算機(jī)學(xué)院,Label.RIGHT);Labell3=newLabe

14、l(,Label.RIGHT);Labell4=newLabel(Pmain()setLayout(null);作者:JHL,Label.RIGHT);setBackground(Color.white);add(l1);add(l2);add(l3);add(l4);l1.setBounds(10,60,320,40);l2.setBounds(240,120,80,22);l3.setBounds(240,142,80,22);l4.setBounds(240,164,80,22);setSize(340,250);setVisible(true);validate();classPcha

15、xunextendsPanelimplementsActionListener/Choicecchaxun;TextFieldtchaxun;Buttonbtnchaxun;TextAreatachaxun;Pchaxun()setLayout(null);圖書查問cchaxun=newChoice();/創(chuàng)立下拉菜單cchaxun.add(書名);cchaxun.add(作者);cchaxun.add(第一版社);tchaxun=newTextField();btnchaxun=newButton(查問);/創(chuàng)立按鈕tachaxun=newTextArea();/創(chuàng)立多行文本框add(cch

16、axun);add(tchaxun);add(btnchaxun);add(tachaxun);tchaxun.setText();cchaxun.setBounds(10,10,65,20);tchaxun.setBounds(85,10,180,20);btnchaxun.setBounds(275,10,40,20);tachaxun.setBounds(10,40,305,145);cchaxun.select(0);/下拉菜單的初始選項(xiàng)setSize(340,250);/設(shè)置窗口大小setBackground(Color.white);setVisible(true);btnchax

17、un.addActionListener(this);validate();publicvoidactionPerformed(ActionEvente)inti=cchaxun.getSelectedIndex();Strings=tchaxun.getText();if(s.equals()JOptionPane.showMessageDialog(this,查問內(nèi)容不可以為空,查問系統(tǒng),JOptionPane.WARNING_MESSAGE);elseConnectioncon;Statementsql;ResultSetrs;tryClass.forName(oracle.jdbc.d

18、river.OracleDriver);/加載JDBC驅(qū)動(dòng)catch(ClassNotFoundExceptionee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:oracle:thin:localhost:1521:orcl,sa,orcl);/連結(jié)數(shù)據(jù)庫(kù)sql=con.createStatement();if(i=0)/依據(jù)下拉菜單的選項(xiàng)履行不一樣的SQL語(yǔ)句rs=sql.executeQuery(select*frombookwherebookName=+s+);elseif(i=1)rs=sql.exe

19、cuteQuery(select*frombookwhereauthor=+s+);elsers=sql.executeQuery(select*frombookwherepublisher=+s+);tachaxun.setText();Stringpanduan=false;while(rs.next()panduan=true;tachaxun.append(書名:+rs.getString(1)+n);tachaxun.append(作者:+rs.getString(2)+n);tachaxun.append(第一版社:+rs.getString(3)+n);tachaxun.appe

20、nd(第一版日期:+rs.getString(4)+n);tachaxun.append(議論:+rs.getString(5)+n);/顯示查問到的圖書信息rs=sql.executeQuery(selectcount(*)frombook);/統(tǒng)計(jì)全部圖書數(shù)while(rs.next()tachaxun.append(圖書室暫有+rs.getString(1)+本圖書);/顯示全部圖書數(shù)目信息con.close();/封閉數(shù)據(jù)庫(kù)if(panduan.equals(false)JOptionPane.showMessageDialog(this,沒有該記錄,查問系統(tǒng),JOptionPane.

21、WARNING_MESSAGE);catch(SQLExceptioneee)System.out.println(eee);classPshanchuextendsPanelimplementsActionListener/刪除功能模塊Choicecshanchu;TextFieldtshanchu;Buttonbtnshanchu;Labell1=newLabel(,Label.CENTER);Labell2=newLabel(計(jì)算機(jī)學(xué)院,Label.RIGHT);Labell3=newLabel(,Label.RIGHT);Labell4=newLabel(Pshanchu()setLa

22、yout(null);作者:ZCS,Label.RIGHT);cshanchu=newChoice();/創(chuàng)立下拉菜單cshanchu.add(書名);tshanchu=newTextField();btnshanchu=newButton(刪除);/創(chuàng)立按鈕add(cshanchu);add(tshanchu);add(btnshanchu);add(l1);add(l2);add(l3);add(l4);/增添標(biāo)簽、按鈕等到窗口面板tshanchu.setText();cshanchu.setBounds(10,10,65,20);tshanchu.setBounds(85,10,180,

23、20);btnshanchu.setBounds(275,10,40,20);l1.setBounds(10,40,300,40);l2.setBounds(240,130,80,22);l3.setBounds(240,152,80,22);l4.setBounds(240,174,80,22);cshanchu.select(0);setSize(340,250);/設(shè)置窗口大小setBackground(Color.white);setVisible(true);btnshanchu.addActionListener(this);validate();publicvoidactionP

24、erformed(ActionEvente)Strings=tshanchu.getText();if(s.equals()JOptionPane.showMessageDialog(this,請(qǐng)輸入要?jiǎng)h除的圖書,刪除功能,JOptionPane.WARNING_MESSAGE);elseConnectioncon;Statementsql;ResultSetrs;tryClass.forName(oracle.jdbc.driver.OracleDriver);catch(ClassNotFoundExceptionee)System.out.println(+ee);trycon=Driv

25、erManager.getConnection(jdbc:oracle:thin:localhost:1521:orcl,sa,orcl);sql=con.createStatement();rs=sql.executeQuery(select*frombookwherebookName=+s+);if(!rs.next()JOptionPane.showMessageDialog(this,沒有該圖書,刪除功能,JOptionPane.WARNING_MESSAGE);elseintn=JOptionPane.showConfirmDialog(this,確認(rèn)刪除嗎?,刪除功能,JOptionPane.YES_NO_OPTION);if(n=JOptionPane.YES_OPTION)sql.executeUpdate(deletefrombookwherebookName=+s+);JOptionPane.showMessageDialog(this,刪除成功,刪除功能,JOptionPane.INFORMATION_MESSAGE);tshanchu.setText();elsetshanchu.setText();con.close();catch(SQLExceptioneee)System.out.println(eee);classDengluextendsP