圖書管理系統(tǒng)軟件工程課程設(shè)計

招標(biāo)參數(shù)：圖書管理系統(tǒng)指導(dǎo)老師： 學(xué)生姓名： 專業(yè)： 頁腳內(nèi)容招標(biāo)參數(shù) (一)項目內(nèi)容 0 (一)數(shù)據(jù)流圖 1 (三)加工說明 5(四)結(jié)構(gòu)圖 5 (一)用例圖 11(二)對象行為模型 12(三)系統(tǒng)包圖 13(四)類圖 14 (一)程序代碼 15(二)功能演示 30 招標(biāo)參數(shù)一、項目計劃(一)項目內(nèi)容(二)開發(fā)環(huán)境RationalRoseEnterpriseEdition2003管理員書管理員書理管理員用戶(三)進(jìn)度安排Edition2003畫數(shù)據(jù)流圖、結(jié)構(gòu)圖、流程圖、用例圖和包圖類圖。二、結(jié)構(gòu)化分析設(shè)計(一)數(shù)據(jù)流圖用信息用信息戶查更查詢詢添刪更刪查查詢請求審無效請求查有效查用戶詢(二)數(shù)據(jù)字典招標(biāo)參數(shù)招標(biāo)參數(shù)學(xué)號學(xué)號數(shù)據(jù)項名取招標(biāo)參數(shù)值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)姓名性別年齡密碼系別索書號招標(biāo)參數(shù)取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值數(shù)據(jù)項名取值書名數(shù)量作者出版社(三)加工說明審查用戶查詢書籍信息請求到到書籍表中檢索用戶輸入的索書號如果書籍表中無此索書號則返回?zé)o效請求否則按索書號檢索書籍表，獲得該書籍的信將信息返回給用戶(四)結(jié)構(gòu)圖圖書管理系統(tǒng)主系統(tǒng)管理書籍管理系統(tǒng)管理書籍管理查更添查退退用刪查更添查退退用籍新籍籍新籍錄戶錄讀者信招標(biāo)參數(shù)命統(tǒng)命命令書籍管理讀者管理查添刪修書索書書數(shù)作出1：添加命令2：刪除命令3：修改命令1：添加命令2：刪除命令3：修改命令4：查詢命令性年密系分析用戶命令選擇用戶所需功能1234退招標(biāo)參數(shù)(五)流程圖開輸入用戶名輸入用戶名和驗證用戶名和提示“用戶名不存在或者密碼不進(jìn)入圖書管理系統(tǒng)主選擇相應(yīng)管理退出系統(tǒng)結(jié)開查詢讀者信招標(biāo)參數(shù)結(jié)開添加書籍成結(jié)開開輸入要刪除的圖書索刪除書籍成結(jié)頁添加書籍失在，請重新輸入索書號!”招標(biāo)參數(shù)開開輸入新的圖書結(jié)開請輸入書名或者索驗證提示“對不起，沒查詢書籍信結(jié)招標(biāo)參數(shù)三、面向?qū)ο蠓治鲈O(shè)計(一)用例圖招標(biāo)參數(shù)(二)對象行為模型擇服務(wù)選擇服務(wù)類書選擇服務(wù)類書籍詢讀者信息輸入證件輸入證件招標(biāo)參數(shù)添添加顯示讀者添加(三)系統(tǒng)包圖輸入書籍輸入索刪除的借口招標(biāo)參數(shù)(四)類圖招標(biāo)參數(shù)(一)程序代碼importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.border.TitledBorder;importjava.awt.Font;importjavax.swing.JMenu;publicclassMainWindowextendsJFrameimplementsActionListener{privatestaticfinallongserialVersionUID=1L;staticStringloginName;staticStringloginNo;JLabelmlabel;JPaneljp=newJPanel();//建立菜單欄JMenuBarmenu=newJMenuBar();招標(biāo)參數(shù)nuanewJMenunubnewJMenunucnewJMenu統(tǒng)管理菜單組JMenuItemaa=newJMenuItem();JMenuItemab=newJMenuItem();JMenuItemac=newJMenuItem();者管理菜單組JMenuItembb=newJMenuItem();//建立書籍管理菜單組JMenuItemca=newJMenuItem();JMenuItemcb=newJMenuItem();JMenuItemcc=newJMenuItem();JMenuItemcd=newJMenuItem();publicMainWindow(){addWindowListenernewWindowAdapter(){publicvoidwindowClosing(WindowEvente){Systemexit});Containerd=getContentPane();thissetSizethissetTitle;d.add(menu);menu.add(a);menu.add(b);menu.add(c);//添加菜單組asetText);asetFontnewFontDialog",0,12));bsetText"讀者管理");b.setFont(newFont("Dialog",0,12));etTextcsetFontnewFontDialog2));//生成系統(tǒng)管理菜單組的選項aasetText錄");aa.setFont(newFont("Dialog",0,12));absetText退出登錄");ab.setFont(newFont("Dialog",0,12));acsetText退出系統(tǒng)");ac.setFont(newFont("Dialog",0,12));//生成讀者管理菜單組的選項bb.setText("查詢讀者信息");bb.setFont(newFont("Dialog",0,12));//生成書籍管理菜單組的選項招標(biāo)參數(shù)setTextsetFontnewFontDialogsetTextsetFontnewFontDialogccsetTextsetFontnewFontDialogsetTextsetFontnewFontDialog//添加系統(tǒng)管理菜單組a.add(aa);a.add(ab);a.add(ac);//添加讀者管理菜單組b.add(bb);//添加書籍管理菜單組c.add(ca);//添加事件偵聽aa.addActionListener(this);ab.addActionListener(this);ac.addActionListener(this);bb.addActionListener(this);ca.addActionListener(this);cb.addActionListener(this);cc.addActionListener(this);cd.addActionListener(this);setJMenuBar(menu);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==aa){UserLoginlogin=newUserLogin(this);login.setVisible(true);}if(e.getSource()==ab){setVisible(false);MainWindowmainFrame=newMainWindow();mainFrame.setLocation(400,150);mainFrame.setVisible(true);}if(e.getSource()==ac)if(e.getSource()==cc)招標(biāo)參數(shù)tVisibletrue}{FindReaderfindreadernewFindReadersetVisibletrue}{AddBookaddBooknewAddBook();setVisibletrue}{DeleteBookdelBooknewDeleteBook;isibletrue}{UpdateBookupdBooknewUpdateBook);pdBooksetVisibletruepublicvoidsetenabled(intright){b.setEnabled(true);c.setEnabled(true);}ght{b.setEnabled(true);c.setEnabled(true);}}publicstaticvoidmain(String[]args){MainWindowmainFrame=newMainWindow();mainFrame.setLocation(400,200);mainFrame.setVisible(true);}}錄界面importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;招標(biāo)參數(shù)blicclassUserLoginextendsJFrameimplementsActionListener{privatestaticfinallongserialVersionUID=1L;meDataBaseMangerdbnewDataBaseMangerMainWindowmainFrameefnullelpanelpanelserLabelPasswordLabelldUserTextFielddFieldPasswordTextFieldYesBtnCancelBtnContainerc;ltSetrslicUserLoginMainWindowmainFrame{mainFramemainFrameJLabelCENTERYesBtnnewJButton定");YesBtn.addActionListener(this);CancelBtn.addActionListener(this);panel1=newJPanel();panel1.setLayout(newGridLayout(2,2));panel2=newJPanel();c=getContentPane();c.setLayout(newBorderLayout());panel1.add(UserLabel);panel1.add(UserTextField);panel1.add(PasswordLabel);panel1.add(PasswordTextField);c.add(panel1,BorderLayout.CENTER);panel2.add(YesBtn);panel2.add(CancelBtn);c.add(panel2,BorderLayout.CENTER);JLabelJLnewJLabel;LNorthpanelCenter招標(biāo)參數(shù)hpanelpanelsetBackgroundnewColor5,255,255));}publicvoidactionPerformed(ActionEvente)ldgetPasswordStringpasswordSTR=newString(password);ringstrSQLstrSQL="select*fromuserswhereuname='"+UserTextField.getText().trim()+"'andupassword'"+passwordSTR+"'";rsdbgetResultstrSQL;booleanisExist=false;mainFrame.loginNo=rs.getString(1);name=rs.getString(1);mainFrame.loginName=name;right=rs.getInt(1);mainFrame.setenabled(right);if(name.length()!=0)sttrue}catch(Exceptionpe){pe.printStackTrace();}if(UserTextField.getText().trim().equals("")){JOptionPane.showMessageDialog(null,"用戶名不可為空!");rn}STRequals{JOptionPaneshowMessageDialognull"密碼不可為空!");rn}lognullispose招標(biāo)參數(shù)詢importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.event.*;importjava.sql.*;importjava.lang.String;publicclassFindReaderextendsJFrameimplementsActionListener{DataBaseMangerdb=newDataBaseManger();MainWindowmw=newMainWindow();ResultSetrs;JLabelselectnewJLabel"請輸入證件號");JTextFieldjtf=newJTextField(10);JPanelp1=newJPanel();JPanelp2=newJPanel();JPanelp3=newJPanel();JPanelp4=newJPanel();JLabellbnewJLabel讀者信息");JButtonfindbtnewJButton("查詢");JButtonyesbtnewJButton"確定");JTextAreajta=newJTextArea(10,10);publicFindReader()ContainercgetContentPane);paddselect;paddjtf;paddfindbt;pBorderLayoutNORTHpadd(lb);p2.add(jta);pBorderLayoutCENTERpaddyesbt;ddpBorderLayoutSOUTHsbtaddActionListenerthistaddActionListenerthision}publicvoidactionPerformed(ActionEvente){mandthis.dispose();mand39頁腳內(nèi)容招標(biāo)參數(shù){gsnojtfgetTextqlstrRbgetResultsqlstrRjta.setText("");為:"+rs.getString(3)+"\n");+rs.getString(6)+"\n");Stringsqlstr="select*fromlendbookwheresno='"+sno+"'";rsdbgetResultsqlstr);}ceptionpe{JOptionPaneshowMessageDialognull,"請輸入正確的證件號!");.增加圖書信息importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.event.*;importjava.sql.*;publicclassAddBookextendsJFrameimplementsActionListener{MainWindowmw=newMainWindow();DataBaseMangerdb=newDataBaseManger();ResultSetrs;JPanela,b,c,d,e,f;JLabelbname=newJLabel();JLabelbno=newJLabel();JLabelbnum=newJLabel();JLabelauthor=newJLabel();JLabelpublisher=newJLabel();JTextFieldtname=newJTextField(20);JTextFieldJTextFieldJTextFieldJTextFieldtno=newJTextField(20);tnum=newJTextField(20);tauthor=newJTextField(20);tpublisher=newJTextField(20);JButtonaddbtnewJButton"添加");JButtonyesbtnewJButton");招標(biāo)參數(shù)anelpnewJPanelcAddBook{anewJPanelb=newJPanel();PanelPanelanelJPanelbnamesetText名：");logbno.setText("索書號：");bno.setFont(newFont("Dialog",0,12));bnum.setFont(newFont("Dialog",0,12));author.setFont(newFont("Dialog",0,12));etTextpublisher.setFont(newFont("Dialog",0,12));a.add(bname);a.add(tname);baddbnobaddtnororhersherttsetLayoutnewGridLayoutaddbt.addActionListener(this);yesbt.addActionListener(this);zeLocation}招標(biāo)參數(shù)publicvoidactionPerformed(ActionEvente){namebnoauthorpublishermandthis.dispose();mand{bname=tname.getText();bno=tno.getText();author=tauthor.getText();publisher=tpublisher.getText();bnum=Integer.parseInt(tnum.getText());Stringsqlstr1="selectbnofrombook";rs=db.getResult(sqlstr1);{ifrsgetStringtrimequalsbno{JOptionPane.showMessageDialog(null,"此書號已存在，請重新輸入索書}}}chExceptionpe{pe.printStackTrace();}Stringsqlstr="insertintobook(bno,bname,bnum,author,publisher)valuesbnobnamebnumauthor"+publisher+"')";booleanresult=db.updateSql(sqlstr);loseConnection{JOptionPaneshowMessageDialognull,"添加書籍成功!");}{JOptionPaneshowMessageDialognull,"添加書籍失敗!");息招標(biāo)參數(shù)blicclassDeleteBookextendsJFrameimplementsActionListenerDataBaseMangerdbnewDataBaseMangerltSetrsJLabelbno=newJLabel("<html><fontcolor=#000000size='4'>請輸入要刪除的圖書索引號：</font>",SwingConstants.CENTER);abelLJTextFieldtno=newJTextField(10);abletableJButtondelbtnewJButton"刪除");JButtonyesbtnewJButton"確定");JPanelp1=newJPanel();JPanelp2=newJPanel();publicDeleteBook()ContainercgetContentPane);paddbno;paddtno;pBorderLayoutNORTHpadddelbt;paddyesbt;ddpBorderLayoutSOUTHddActionListenerthissbtaddActionListenerthisionJPanelpnewJPanel;utpublicvoidactionPerformed(ActionEvente)ommandxtStringsqlstr="deletebnofrombookwherebno='"+bno+"'";booleanresult=db.updateSql(sqlstr);db.closeConnection();招標(biāo)參數(shù)新圖書信息importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.event.*;importjava.sql.*;publicclassUpdateBookextendsJFrameimplementsActionListener{MainWindowmw=newMainWindow();DataBaseMangerdb=newDataBaseManger();sultSetrsJPanelabcde,f;JLabelbnamenewJLabel);JLabelbnonewJLabel);JLabelbnumnewJLabel);JLabelauthornewJLabel();JLabelpublishernewJLabel();eldnewJTextFieldeldwJTextFieldeldewJTextFieldeldhornewJTextFieldJTextFieldtpublisher=newJTextField(20);JButtonaddbtnewJButton"更新");JButtonyesbtnewJButton");JPanelp3=newJPanel();publicUpdateBook()wJPanelbnewJPanel);elellPanelbname.setText("書名：");bname.setFont(newFont("Dialog",0,12));bnosetText：");bno.setFont(newFont("Dialog",0,12));bnum.setFont(newFont("Dialog",0,12));author.setFont(newFont("Dialog",0,12));publishersetText版社：");招標(biāo)參數(shù)publishersetFontnewFontDialog0,12));memebaddbnobaddtnororhersherttutnewGridLayoutdbtaddActionListenerthissbtaddActionListenerthissetLocation(400,150);}publicvoidactionPerformed(ActionEvente)mandthis.dispose();mandetnamegetTextbno=tno.getText();author=tauthor.getText();publisher=tpublisher.getText();bnum=Integer.parseInt(tnum.getText());Stringsqlstr1="selectbnofrombook";rs=db.getResult(sqlstr1);try{while(rs.next()){if(rs.getString(1).trim().equals(bno)){JOptionPaneshowMessageDialognull,"此書號已存在，請重新輸入索書號!");}chExceptionpe招標(biāo)參數(shù){pe.printStackTrace();}Stringsqlstr="updatebooksetherr}JOptionPaneshowMessageDialognull書籍失敗!");}}}}importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.event.*;importjava.sql.*;publicclassFindBookextendsJFrameimplementsActionListener{DataBaseMangerdb=newDataBaseManger();ResultSetrs;JLabelselect=newJLabel("請輸入書名或者索書號");JTextFieldjtf=newJTextField(20);JPanela=newJPanel();JPanelb=newJPanel();JLabellbnewJLabel書籍信息");JButtonfindbtnewJButton("查詢");JButtonyesbtnewJButton"確定");JTextAreajta=newJTextArea(10,10);publicFindBook()ContainercgetContentPane);electtfindbtBorderLayoutNORTHbaddlbbaddjtabaddyesbt;bBorderLayoutSOUTHsbtaddActionListenerthistaddActionListenerthis招標(biāo)參數(shù)}publicvoidactionPerformed(ActionEvente)osemandStringbname=jtf.getText();Stringbno=jtf.getText();Stringsqlstr;sqlstr="select*frombookwherebname='"+bname+"'orbno='"+bno+"'";rs=db.getResult(sqlstr);jta.append("索書號為:"+rs.getString(1)+"\n");jta.append("書名為:"+rs.getString(2)+"\n");njta.append("作者為:"+rs.getString(4)+"\n");}chExceptionpe連接importjava.sql.*;importjava.io.*;publicclassDataBaseManger{ngnameConnectioncontementstmtsultSetrspublicDataBaseManger{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Systemoutprintln載完成");Systemoutprintln接");con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=library","sa","sqlserver2005");stmt=con.createStatement();}catch(Exceptione){e.printStackTrace();招標(biāo)參數(shù)}}publicResultSetgetResult(S