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

1、（完整word版）JAVAswing界面实现数据库増删改查（精）编辑整理:尊敬的读者朋友们：这里是精品文档编辑中心,本文档内容是由我和我的同事精心编辑整理后发布的，发布之前我们 对文中内容进行仔细校对，但是难免会有疏漏的地方,但是任然希望（完整word 版）JAVAswing界面实现数据库增删改查（精）的内容能够给您的工作和学习带来便利。同时也真 诚的希望收到您的建议和反馈，这将是我们进步的源泉，前迸的动力。本文可编辑可修改,如果觉得对您有帮助请收藏以便随时查阅,最后祝您生活愉快业绩进步,以 下为（完整word版）JAVAswing界面实现数据库增删改查（精）的全部内容。数据库程序设计大作业班

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

3、码）（4）在PC机的dos命令控制台ping虚拟机的IP,确保正常，能pi ng通（即将虚拟机内外 ping 通）.（5）配置好虚拟机下的oracle的数据库和监听。（6）在eclipse中编写相关代码，并用jtable实现图形化界面，用以实现与数据库的连接 和操作数据库等功能。（7）在eclipse中导入数据库的驱动。（8）运行ecl ipse,查看运行结果.2. 核心代码2. 1ftl母员王戯無;匚軌；1o数据库连接package orgo Ixho info.dbc； import javao sql. Connection;import java.sql。Dr i verManager

4、；import javao sql.ResuItSet；import java.sql。SQLException；import javao sqI Statement;pub I ic cI ass DatabaseConnection pub I ic static void main (String args Connection conn 二 null；Statement stmt 二 null；ResuItSet rs 二 nul I ；try CI assforName(” oracIe jdbc。 dr i ver0racleDr iverH；String url = jdbc:o

5、racle:thin： 192. 168. Oo 128:1521/WFJH； conn 二 Dr i verManager。getConnection(url, uhrn , ” hr； stmt 二 conn。 createStatement(;String sqI 二select * from departments” ；rs 二 stmt, executeQuery(sql;while (rs next (System. out. pr i nt(rs get I nt(” department_id” ;Systemo out. pri nt ( t;System. out。 pr

6、i nt (rs. getStr i ng (department_name,f;System. out。pr i nt (” t;System. out. pr i nt(rs。 get I nt (” manager_i du；System. out。pr i nt (t；System. out。 pr i nt (rs.get I nt (” I ocation_id乃;System。out. pr intln(; catch (ClassNotFoundException e e. pr i ntStackTrace (； catch (SQLException e e. pr i n

7、tStackTrace (; final Iy try if (rs != nul I rs. close(；if (stmt ! = nuI I stmt。 cIose (；if (conn !二 nul 丨conn。 cIose(; catch (SQLException e / TODO Auto-generated catch bIocke. pr intStackTrace (；)2.生成get set方法package edu;pub Iic class Country private String department_id;private String department_n

8、ame；private String area;private String popuI ation；pub Iic String getdepartment_id (return department_id；pub Iic void setdepartment_id (String department_name thisname 二 department_id；pub Iic String getdepartment_name( return department_name；1pub Iic void setdepartment_name(String department_name th

9、is. department name = department name;1pub Iic String getmanager_id ( return manager_id；pub Iic void setmanager一id(Stri ng manager一id thi So manager_id二 manager_id;pub Iic String get I ocationid (return I ocation_id；pub Iic void set I ocation一id (Str i ng I ocation_idnthis Iocation id 二 location id；

10、3实现方法package tux inghua；import java awt. Color；import javao awt. event。ActionEvent；import java .awt. event。 ActionLi stener;import javao io。Ser ial izable；import javao sqI Dr i verManager；import javao sqIo ResuItSet；import java.util。ArrayList;import java.util。Li st;import javax swingo JButton;import

11、 javaxo swing. JFrame;import javaxo swingo JLabeI;i mport javaxo swing。JScroI I Pane；import javaxo swingo JTable；import javax swing.JTextField；import javaxo swingtable。DefauItTab I eMode I；import javao awt。event. MouseAdapter；import javao awt. event. MouseEvent；pub I ic cI ass AppStudent extends JFr

12、ame pr i vate DefauItTab I eMode I mode I;pr i vateJTextFieIddepari dF i eId;pr i vateJTextFielddeparnameF ield;pr i vateJTextFieldmanager_i dF ield；pr i vateJTextFieldI ocation_idField；pr i vateJTabIe table;pr i vate Str ing columns 二 n deparid. ” department_name, manager_id” , n I ocation_id;pr i

13、vate Li st data；pr i vate Student tmp;pub I ic AppStudent( data 二 new ArrayLi st (；getContentPane (.setLayout (null;JLabeI IbIempIoyee 二 new JLabeldepartment_id;IbIempIoyeeo setBounds (12, 10, 220, 13；getContentPane (o add (I bl employee; department_idField 二 new JTextField (; department_idField. se

14、tBounds(100,7, 96, 19；getContentPane(o add(department_idFieId；department_idFieId。setCoIumns (10;JLabeI IbI Age 二 new JLabeI(department_namen ；IbIAgeo setBounds (252, 10, 220, 13;getContentPane (.add (IbI Age；deparnameField 二 new JTextField(；department_nameFieId.setBounds (365,7, 96, 19;getContentPan

15、e (。add (department_nameFieId;department_nameFieId。setCoIumns(10；JLabeI IblStuno 二 new JLabeI(n manager_idn ；I b I Stunoo setBounds (12, 36, 220, 13 ；getContentPane (o add (IblStuno;manager_idField 二 new JTextField (;manager_idField setColumns (10;manager_idFieId. setBounds (100, 33, 96, 19；getConte

16、ntPane (o add (manager_idField;JLabe I I b I Cl ass = new JLabe I (5, location_id ;lblClasso setBounds (252, 36, 220,13;getContentPane(o add (IbICIass;I ocation_idField 二 new JTextField (;I ocat i on_ i dF i eId。setCoIumns (10;Iocat i on_i dF i eId. setBounds (365,33, 96, 19;getContentPane(. add (I

17、ocat i on_ i dF i eId;JButton btnAdd = new JButton (增加；btnAdd addAct i onL i stener (new Act i onL i stener ( Ipub I ic void actionPerformed (ActionEvent e add(;btnAdd. setBounds (75, 59, 77, 21 ;getContentPane (add (btnAdd；JButton btnDe I = new JButton (5,删除；btnDel。addActionListener (new ActionL i

18、stener ( pub I ic void actionPerformed (ActionEvent e del (;btnDeI. setBounds(180,59, 77,21 ；getContentPane (. add (b tn De I ；JButton btnllpdate = new JButton (更新；btnUpdate. addActionListener (new ActionL i stener (pub I ic void actionPerformed (ActionEvent e update (;btnUpdate. setBounds(280, 59,7

19、7,21；getContentPane (. add (btnllpdate;JButton btnFi nd = new JButton (H查找”；btnFind。addActionL i stener (new ActionL i stener ( pub I ic vo i d actionPerformed (ActionEvent e find (;JbtnF i ndo setBounds (380, 59,77, 21 ；getContentPane (add (btnFind；mode I 二 new DefauItTab I eMode I (columns， 0;tabI

20、e = new JTabIe (mode I;tabIeo addMouseL i stener(new MouseAdapter(pub I ic void moused icked (MouseEvent eint row 二 tableo getSeIectedRow (；department_idField。setText ( (String tabIegetVa IueAt( row, 0；department_nameField。setText(String tabIegetVa IueAt (row， 2 manager_idField .setText ( (String ta

21、bIeo getVa IueAt (row. 3；I ocation_idField。setText(Str i ng table.getVa IueAt (row, 4；tmp 二 get Input (；;JScrolI Pane scrolI Pane 二 new JScroI I Pane(table;scrolI Pane. setBounds(12, 100, 571,248；getContentPane (o add (scrolI Pane;setDefauItCIoseOperation (EXIT_ON_CLOSE;setLocat i onReI at i veTo(nu

22、I I；setLocat i on (350,200；setS i ze (601, 380；setRes i zabIe (fa Ise;setVisible (true;pr i vate Student get Input (Student stu 二 new Student (；stu. deparid二 depar tinerit_ idField。get Tex t (;stu。 department_name 二 department_nameFieIdo getText (;stu。manager_id 二 manager_idFieldo getText(；stu. loca

23、tion_id 二 location_idField.getText(;return stu;)pr i vate void add ( data.add (get Input (；showTable (；)pr i vate void del (for (int i 二 0; i data。size (; i+if (tmp. equa Is (data.get(i data, remove (i ； break；showTable (；pr i vate void update( Student stu 二二 getlnput(；for (int i 二:0; i data。 size(;

24、 i+i f (tmpo equa I s (data。get(i data, remove (i;data。add (if stu；break；showTabIe (；pr i vate voidfind ( removeRows (；Student stu 二二 getInput (;for (int i 二0; i 0 mode 丨.removeRow(0；pub I ic static vo i d main (String new AppStudent (；)c I ass Studenti mpI ernents Ser i a Ii zabIe pub I ic String d

25、eparid；pub I ic String department_name;i+argspub I ic String manager_i d； pub I ic String I ocation_id;pub I ic boo Iean equaIs (Object obj return equaIs (Student obj;)pub I ic boo Iean equaIs (Student obj boolean isdepartment_id 二 true；i f (ob j depar tment_id !二 null & !” H o equa I s (obj o depar tment_id i sdepartment_id 二 department_id。equaIs(objo department_id；boolean i sdeparname 二 true；i f (obj. departmename !二 null & !”equaIs(ob jdepartment_name i sdepartment_name 二 d