簡(jiǎn)易圖書管理系統(tǒng)

簡(jiǎn)易圖書管理系統(tǒng)簡(jiǎn)易圖書管理系統(tǒng)簡(jiǎn)易圖書管理系統(tǒng)xxx公司簡(jiǎn)易圖書管理系統(tǒng)文件編號(hào)：文件日期：修訂次數(shù)：第1.0次更改批準(zhǔn)審核制定方案設(shè)計(jì)，管理制度本程序以java為設(shè)計(jì)語(yǔ)言，能夠?qū)崿F(xiàn)一個(gè)簡(jiǎn)單的圖書管理系統(tǒng)，可以實(shí)現(xiàn)簡(jiǎn)單的增加圖書，查詢圖書，刪除圖書的功能，其中用到數(shù)據(jù)庫(kù)的連接，窗體的布局管理。本程序有以下幾個(gè)功能函數(shù)組成所有模塊都在名為bookmanager的包中1：主函數(shù)2：增加模塊3:查詢模塊4:查詢結(jié)果模塊5:書本類6：數(shù)據(jù)庫(kù)連接類主界面添加模塊查詢模塊輸出模塊源程序如下bookmanager;import.*;import.*;importclassmainframeextendsJFrameimplementsActionListener{privateJToolBartb;String[]btntitle={"增加","查詢","刪除","退出"};String[]tabeltitle={"圖書編號(hào)","書名","定價(jià)","出版社"};JButtonbtn[]=newJButton[4];JTabletable;DefaultTableModelmodel;publicmainframe(){ super("圖書管理系統(tǒng)"); ddActionListener(this); (btn[i]); } how(); }}******************************************************************************************************************添加模塊packagebookmanager;import.*;import.*;publicclassadddialogimplementsActionListener{JLabellabel[]=newJLabel[4];JTextFieldtxt[]=newJTextField[4];String[]ltitle={"圖書編號(hào)","圖書名稱","單價(jià)","出版社"};String[]btitle={"上一個(gè)","下一個(gè)","確定","取消"};JButtonbtn[]=newJButton[4];JDialogdialog;JPanelp;LinkedListlist;publicadddialog(JFramef,intx,inty){ dialog=newJDialog(f,"增加",true); (x,y); p=newJPanel(); list=newLinkedList();etFont(newFont("宋體",,18)); txt[i]=newJTextField(); btn[i]=newJButton(btitle[i]); btn[i].addActionListener(this); btn[i].setFont(newFont("幼圓",,15)); (label[i]); (txt[i]); (btn[i]); } (null); (10,150,310,160);); label[0].setBounds(10,10,90,25);txt[0].setBounds(110,10,200,25); label[1].setBounds(10,45,90,25);txt[1].setBounds(110,45,200,25); label[2].setBounds(10,80,90,25);txt[2].setBounds(110,80,200,25); label[3].setBounds(10,115,90,25);txt[3].setBounds(110,115,200,25); (p); btn[0].setBounds(60,180,80,25);btn[1].setBounds(175,180,80,25); btn[2].setBounds(60,250,80,25);btn[3].setBounds(175,250,80,25); (400,400); (); );}publicvoidactionPerformed(ActionEvente){ intsize=(); etText());etText());etText()));etText());etText());etText());etText()));etText());etText(); Stringname=txt[1].getText(); floatprice=getprice(txt[2].getText()); Stringpublish=txt[3].getText(); Objectstr[]={id,name,price,publish}; (),str); } }privatefloatgetprice(Stringstr){floatprice=0;try{ price=(str);}catch(Exceptionex){ (null,"價(jià)格必須是數(shù)字，請(qǐng)重新輸入!","錯(cuò)誤",);}returnprice;}etEnabled(false);etEnabled(false);etEnabled(true);etEnabled(true);;import.*;importclasssearchdialogimplementsActionListener,ItemListener{JRadioButton[]radio=newJRadioButton[3];ButtonGroupgroup;String[]rtitle={"圖書編號(hào)","圖書名稱","出版社"};String[]btitle={"確定(Yes)","取消(Esc)"};JTextFieldtxtfield[]=newJTextField[3];JButtonbtn[]=newJButton[2];JDialogdialog;searchresultst;publicsearchdialog(JFramef,intx,inty){ ddActionListener(this); radio[i].setFont(newFont("宋體",,15)); radio[i].addItemListener(this); (radio[i]); txtfield[i]=newJTextField(); txtfield[i].setEditable(false); } for(inti=0;i<2;i++){ btn[i]=newJButton(btitle[i]); btn[i].addActionListener(this); btn[i].setFont(newFont("宋體",,15)); } dialog=newJDialog(f,"查詢",true);etSelected(true); txtfield[0].setEditable(true); (x,y); (null); etBounds(10,10,90,25);txtfield[0].setBounds(110,10,250,25); radio[1].setBounds(10,45,90,25);txtfield[1].setBounds(110,45,250,25); radio[2].setBounds(10,80,90,25);txtfield[2].setBounds(110,80,250,25); for(inti=0;i<;i++){ (radio[i]); (txtfield[i]); } btn[0].setBounds(20,135,120,25);btn[1].setBounds(200,135,120,25); (btn[0]);(btn[1]); (400,250); ); }publicvoidactionPerformed(ActionEvente){ if()==btn[0]){ (); Connectioncon=(); PreparedStatementstmt=null; ResultSetrs=null; LinkedListlist=newLinkedList(); try{ if(radio[0].isSelected()){ stmt=("select*frombookwherebidlike'%"+txtfield[0].getText().trim()+"%'"); } if(radio[1].isSelected()){ stmt=("select*frombookwherebnamelike'%"+txtfield[1].getText().trim()+"%'"); } if(radio[2].isSelected()){ stmt=("select*frombookwherebpublishlike'%"+txtfield[2].getText().trim()+"%'"); }rs=();while()){ Stringid=(1); Stringname=(2); Stringprice=(3); Stringpublish=(4);bookb=newbook(id,name,(price),publish); (b);}for(inti=0;i<();i++){ bookb=(book)(i); Objectob[]={(),(),(),()}; }(null,"總共找到"+()+"條記錄!","信息",); (); }catch(SQLExceptione1){ sSelected()){ txtfield[i].setEditable(true); } elsetxtfield[i].setEditable(false); }}}查找結(jié)果packagebookmanager;import.*;import.*;importclasssearchresultextendsJFrameimplementsActionListener{ JTabletable; DefaultTableModelmodel; String[]rtitle={"圖書編號(hào)","圖書名稱","單價(jià)","出版社"}; JDialogdialog;publicsearchresult(){super("查詢結(jié)果"); model=newDefaultTableModel(rtitle,0); table=newJTable(model); add(newJScrollPane(table),); (25); (newFont("楷體",,18)); setSize(600,400);}publicvoidinit(){ (0);}publicvoidactionPerformed(ActionEvente){;import.*;importclassdbcon{publicfinalstaticConnectiongetconnectin(){ Connectioncon=null; try{ (""); Stringurl="jdbc:;integratedSecurity=true;"; con=(url); ("book"); } catch(ClassNotFoundExceptionex){ (); } catch(SQLExceptionex){ (); } returncon;}oString()); (2,obj[1].toString()); (3,(obj[2].toString())); (4,obj[3].toString()); (); (null,"添加成功!","操作提示",); }catch(SQLExceptione){ (null,"添加數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤!","信息",); }}本類packagebookmanager;publicclassbook{privateStringid,name,publish;privatefloa