JAVAswing界面实现数据库增删改查(精)

1、数据库程序设计大作业班级：2012级软件外包服务一班学号：201215140117姓名：。°。时间：2013-6-191-功能描述1.1功能简介用swing做出图形化界而形式，实现数据库的增删改査把员工表跟部门表连接起來，实现数据的增加，删除，修改，查找。1.2实现步骤（1）安装好虚拟机，并在其下确认oracle己安装成功（可以在dos下输入相关命令来检查是否安装成功）。（2）在网络中心修改pc机上的VMwareNetworkAdapter的IP、子网页码（默认）、网关。（3）修改虚拟机的IP、网掩码（默认）、网关，确保PC机上的网关和虚拟机的IP致。（在控制面板网络和共享中心本地连

2、接3一属性中，修改IP、网掩码）（4）在PC机的dos命令控制台ping虚拟机的IP,确保正常，能ping通（即将虚拟机内夕卜ping通）。（5）配置好虚拟机下的oracle的数据库和监听。（6）在eclipse中编写相关代码，并用jtable实现图形化界面，用以实现与数据库的连接和操作数据库等功能。（7）在eclipse中导入数据库的驱动。（8）运行eclipse,査看运行结果。2.核心代码2.11.数据库连接packageorg.lxh.mfb.dbc;unpoitjava.sql.Comiectiou;mipoitjava.sql.DnvefManagei;unpoitjava.sql.

3、ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassDatabaseComiectionpublicstaticvoidniaui(StiingaigsComiectionconn=null;Statementstmt=null;ResultSetis=null;tryClass.fbiNaiiie(noiaclejdbc.diivei.OiacleDnveiM;Snmgml=Mjdbc:oracle:thin:2&1521/WFJ"coim=DriveiMa

4、nager.getConiiection(ufLm1hu,m1hu;stmt=coim.cieateStatement(;Suingsql="select*fiomdepaitmentsM;is=stmt.executeQueiy(sql;while(rs.next(Systeni.out.pnnt(is.getInt(ndepaitment_idM;System.out.pimtCV;System.out.print(rs.getStimg(ndepaitment_namefl;System.out.pimtCV;Systemoi】tpimtUsgetIiHCmaiiagei_ic

5、r；System.out.pimtCV;System.out.print(rs.getIiit(Hlocation_idn;Systeni.out.pnntln(;catch(ClassNotFoundExceptionee.pnntStackTiace(;catch(SQLExceptionee.pnntStackTiace(;filiallytryif(is!=nullrs.close(;if(stmt!=nullstm匚close(;if(comi!=nullcoim.close(;catch(SQLExceptione/TODOAuto-geneiatedcatchblocke.pnn

6、tStackTiace(;2生成getset方法packageedu;publicclassCountryprivateStringdepartment_id;privateStringdepartment_name;privateStringarea;privateStringpopulation;publicStringgetdepartment_id(returndepartment_id;publicvoidsetdepartment_id(Stringdepartment_namethisname二department_id;publicStringgetdepartment_nam

7、e(returndepartment_name;publicvoidsetdepartment_name(Stringdepartment_namethisdepartnient_naine二department_name;publicStringgetmanager_id(returnmanager_id;publicvoidsetmanager_id(Stringmanager_idthismanagei'id二manager_id;publicStringgetlocation_id(returnlocation_id;publicvoidsetlocation_id(Strin

8、glocation_idnthislocation_id二location_id;3实现方法packagetuxmgliua;unpoitjava.awt.Color;mipoitjava.awt.event.ActionEvent;unpoitjava.aw匸even匸AchonListenei;mipoitjava.io.Serializable;unpoitjava.sql.DfiveiManagei;importjava.sql.ResultSet;mipoitjava.util.AiiayList;mipoitjava.util.List;mipoitjavax.swing.JBut

9、ton;mipoitjavax.swiiig.JFiame;unpoitjavax.swmg.JLabel;mipoitjavax.swing.JSciollPane;unpoitjavax.swing.JTable;mipoitjavax.swing.JTextField;unpoitjavax.swing.table.DefaultTableModel;unpoitjava.awt.event.MouseAdapter;unpoitjava.awt.event.MouseEvent;publicclassAppStiidentextendsJFrameprivateJTextFieldde

10、paitment_idField;privateJTextFielddepaitment_nameField;privateJTextFieldmanagei_idField;privateJTextFieldlocation_idField;privateJTabletable;privateDefaultTableModelmodel;privateStfingcolunms=Mdepaitment_id,udepaitment_name,nnianagei_idu,nlocation_idn;privateListdata;privateStudenttmp;publicAppStiid

11、ent(data=newAiiayList(;getContentPane(.setLavout(null;JLabellblemplovee=newJLabelCdepaitmeiH_id"lblemployee.setBounds(12,10.220,13;getContentPane(.add(lblemployee;depaitment_idFleld=newJTextField(;depailment_idField.setBounds(100,7,96,19;getContentPane(.add(depaitment_idField;depaitmencidField.

12、setColunuis(10;JLabellblAge=newJLabelCdepamneiH_iiame”;lblAge.setBounds(252,10,220,13;getContentPane(.add(lblAge;depaitmencnameField=newJTextField(;depaitment_nameFleld.setBounds(365,7、96.19;getContentPaiie(.add(depaitment_nameField;department_nameField.setColuniiis(l0;JLabellblStuno=newJLabel(”mana

13、gei_icT;lblStuno.setBounds(12,36,220,13;getContentPane(.add(lblStuno;managei_idField=newJTextField(;managei_idFleld.setColumns(l0;managei_idField.setBounds(100,33,96,19;getContentPaiie(.add(managei_idField;JLabellblClass=newJLabel(,location_idn;lblClass.setBounds(252,36,220,13;getContentPane(.add(lb

14、lClass;location_idField=newJTextField(;location_idFleld.setColunms(l0;location_idFleld.setBounds(365,33,96,19;getContentPane(.add(location_idField;JButtonbtnAdd=newJButton(M增加”；btiiAdd.addActionListenei(newActionListenei(publicvoidactionPeifbimed(ActioiiEventeadd(;btiiAdd.setBounds(75,59,77,21;getCo

15、ntentPane(.add(btiiAdd;JButtonbtnDel=newJButton("删除"；btiiDel.addActionListenei(newActioiiListenei(publicvoidactionPeifdimed(ActioiiEventedel(;btnDel.setBounds(180,59,77,21;getContentPane(.add(btiiDel;JButtonbtnUpdate=newJButton("更新”;btnUpdate.addActionListenei(newActioiiListenei(publi

16、cvoidactionPeifdimed(ActioiiEventeupdate(;btnUpdate.setBounds(280,59,77,21;getContentPane(.add(btnUpdate;JButtonbtnFind=newJButton("查找"btiiFind.addActionListenei(newActionListenei(publicvoidactionPeifdimed(ActioiiEventebtnFind.setBounds(380,59,77,21;getContentPane(.add(btiiFind;model=newDe

17、faultTableModel(colunms,0;table=newJTable(model;table.addMouseListenei(newMouseAdapter(publicvoidmouseClicked(MouseEventemtlow=table.getSelectedRow(;depaitment_idField.setText(Stimgtable.getValueAt(iow,0;depaitmencnameField.setText(Stinigtable.getValueAt(iow,2;managei.idFleld.setText(Stiingtable.get

18、ValueAt(iow,3;location_idFleld.setText(Stiingtable.getValueAt(iow,4;tmp=getlnput(;JSciollPanesciollPane=newJSciollPane(table;scrollPane.setBounds(12,100,571,248;getContentPane(.add(sciollPane;setDefaultCloseOpeiation(EXIT_ON_CLOSE;setLocatioiiRelativeTo(null;setLocation(350,200;setSize(601,380;setRe

19、sizable(false;setVisible(tme;privateStudentgetbiput(Studentstu=newStudent(;sm.depaitment_id=depaitment_idField.getText(;sm.depaitmenoiame=depaitment_nameField.getText(;snLnianagei_id=nianagei_idField.getText(;sni.location_id=location_idField.getText(;reuuiistu;privatevoidadd(data.add(getlnput(;sliow

20、Table(;privatevoiddel(for(niti=0;i<data.size(;i+if(tmp.equals(data.get(idata.remove(i;bieak;sliowTable(;privatevoidupdate(Studentstu=getbiput(;for(inti=0;i<data.size(;i十十if(tmp.equals(data.get(idata.iemove(i;data.add(i,stu;break;sliowTable(;privatevoidfind(removeRows(;Studentstu=getbiput(;for(

21、inti=0;i<data.size(;i十十Suidenttmp=(Studentdata.get(i;if(tmp.equals(stumodel.addRow(tmp.toAiTay(;break;privatevoidshowTable(iemoveRows(;for(niti=0;i<data.size(;i+Studentstu=(Studentdata.get(i;model.addRow(sni.toAiiay(;privatevoidiemoveRows(wlule(model.getRowCount(>0model.iemoveRow(0;publicst

22、aticvoidmam(StnngaigsnewAppStudent(;classSuidentunplementsSerializablepublicSuingdepaitment_id;publicSuingdepaitment_nanie;publicSuingmanagei_id;publicSuinglocation_id;publicbooleanequals(Objectobjreturnequals(Snidentobj;publicbooleanequals(Studentobjbooleanisdepaitment_id=tine;if(obj.depaitment_id!=null&&?HH.equals(obj.depaitmencidisdepaitment_id=depanmeiit_id.equals(obj.depaitment_id;booleanisdepaitment_name=tme;if(obj.depaitment_name!=null&&!,M,.equals(obj.depaitment_nanieisdepaitment_name=depaitment_name.equals(obj.depaitmencname;bo