简易图书管理系统

简易图书管理系统简易图书管理系统简易图书管理系统xxx公司简易图书管理系统文件编号：文件日期：修订次数：第1.0次更改批准审核制定方案设计，管理制度本程序以java为设计语言，能够实现一个简单的图书管理系统，可以实现简单的增加图书，查询图书，删除图书的功能，其中用到数据库的连接，窗体的布局管理。本程序有以下几个功能函数组成所有模块都在名为bookmanager的包中1：主函数2：增加模块3:查询模块4:查询结果模块5:书本类6：数据库连接类主界面添加模块查询模块输出模块源程序如下bookmanager;import.*;import.*;importclassmainframeextendsJFrameimplementsActionListener{privateJToolBartb;String[]btntitle={"增加","查询","删除","退出"};String[]tabeltitle={"图书编号","书名","定价","出版社"};JButtonbtn[]=newJButton[4];JTabletable;DefaultTableModelmodel;publicmainframe(){ super("图书管理系统"); ddActionListener(this); (btn[i]); } how(); }}******************************************************************************************************************添加模块packagebookmanager;import.*;import.*;publicclassadddialogimplementsActionListener{JLabellabel[]=newJLabel[4];JTextFieldtxt[]=newJTextField[4];String[]ltitle={"图书编号","图书名称","单价","出版社"};String[]btitle={"上一个","下一个","确定","取消"};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,"价格必须是数字，请重新输入!","错误",);}returnprice;}etEnabled(false);etEnabled(false);etEnabled(true);etEnabled(true);;import.*;importclasssearchdialogimplementsActionListener,ItemListener{JRadioButton[]radio=newJRadioButton[3];ButtonGroupgroup;String[]rtitle={"图书编号","图书名称","出版社"};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); }}}查找结果packagebookmanager;import.*;import.*;importclasssearchresultextendsJFrameimplementsActionListener{ JTabletable; DefaultTableModelmodel; String[]rtitle={"图书编号","图书名称","单价","出版社"}; JDialogdialog;publicsearchresult(){super("查询结果"); 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,"添加数据时发生错误!","信息",); }}本类packagebookmanager;publicclassbook{privateStringid,name,publish;privatefloa