JAVAswing界面實(shí)現(xiàn)數(shù)據(jù)庫增刪改查

1、數(shù)據(jù)庫程序設(shè)計(jì)大作業(yè)班級：2012級軟件外包服務(wù)一班學(xué)號：7時(shí)間：2013-6-191. 功能描述1.1功能簡介用swing做出圖形化界面形式，實(shí)現(xiàn)數(shù)據(jù)庫的增刪改查 把員工表跟部門表連接起來，實(shí)現(xiàn)數(shù)據(jù)的增加，刪除，修 改，查找。1.2實(shí)現(xiàn)步驟(1) 安裝好虛擬機(jī)，并在其下確認(rèn)oracle已安裝成功(可 以在dos下輸入相關(guān)命令來檢查是否安裝成功)。(2) 在網(wǎng)絡(luò)中心修改pc機(jī)上的VMware Network Adapter 的IP、子網(wǎng)頁碼(默認(rèn))、網(wǎng)關(guān)。(3) 修改虛擬機(jī)的IP、網(wǎng)掩碼(默認(rèn))、網(wǎng)關(guān)，確保PC機(jī) 上的網(wǎng)關(guān)和虛擬機(jī)的IP致。(在控制面板網(wǎng)絡(luò)和共享中 心本地連接3屬性中，修改IP

2、、網(wǎng)掩碼)(4) 在PC機(jī)的dos命令控制臺ping虛擬機(jī)的IP,確保正 常，能ping通(即將虛擬機(jī)外ping通)。(5) 配置好虛擬機(jī)下的oracle的數(shù)據(jù)庫和監(jiān)聽。(6) 在ecl ipse中編寫相關(guān)代碼，并用jtable實(shí)現(xiàn)圖形化 界面，用以實(shí)現(xiàn)與數(shù)據(jù)庫的連接和操作數(shù)據(jù)庫等功能。(7) 在eclipse中導(dǎo)入數(shù)據(jù)庫的驅(qū)動(dòng)。(8) 運(yùn)行ecl ipse,查看運(yùn)行結(jié)果。2. 核心代碼2. 1頁腳刪除更朝查棧1.數(shù)據(jù)庫連接 package org lxh info.dbc;import java sql.Connection;import java sql Dr i verManager;i

3、mport java sql ResuItSet;import java sql. SQLException;import java sql Statement;pub I ic class DatabaseConnection pub Iic static void main(Str ing args) Connection conn = null;Statement stmt 二 null;ResultSet rs = nulI;try Class forName(”oracle jdbc dr i ver OracleDriver”); String url = Mjdbc:oracle

4、:thin:192. 168. 0. 128:1521/WFJH; conn 二 Dr i verManager.getConnection (url, hr”，hr”)； stmt = conn. createStatement ();Str ing sqI = select * from departments;rs = stmt, executeQuery(sql);while (rs. next () System. out. pr int(rs get I nt Cdepartment_id);System. out. pr int (t);Systeni. out. pr i nt

5、 (rs getStr i ng (department_name);System. out. pr int (t);System. out. pr int(rs. getInt (manager_id”);System. out. pr int (t);System. out. pr int(rs get Int (”location_id);System. out. pr i nt I n (); catch (ClassNotFoundException e) e. pr i ntStackTrace (); catch (SQLException e) e. pr i ntStackT

6、race (); finally if (rs !二 nul I) rs. closeO ;if (stmt != nulI) stmt, close();if (conn != nul I) conn, close(); catch (SQLException e) / TODO Auto-generated catch block e. pr i ntStackTrace ();12. 生成get set方法 package edu;pub Iic class Country private Str ing deparid; private Str ing department_name;

7、private Str ing area;private Str ing popuI ation;pub Iic Str ing getdepartment_id() return department_id;pub I i c void set depar tmerrt _id (S tring deparname) this n ame = departme rrt_ id;1pub Iic String getdeparname() return department_name;pub Iic void setdepartment_name(String department_name)

8、 thisdepartment_name = department_name;pub Ii c String getmanagerid() return managerid;pub Ii c void setmanager_id(Stri ng manager_id) thismanager_id二 manager_id;1pub Iic Str ing get I ocation_id() return I ocat i on_i d;pub Iic void set I ocation_id(String I ocation_idn) this Iocation_id = I ocatio

9、n_id;13實(shí)現(xiàn)方法package tux inghua;import java awt Color;import java awt event ActionEvent;import java awt event ActionListener;import java io. Serial izable;import java sql Dr i verManager;import java sql ResuItSet;import java utiI. ArrayList;import import import import import import import import impor

10、t importjava utiI.List;javax.javax.javax.javax.javax.javax.javax.swing. JButton;swing JFrame;sv/ing. JLabel ;swing. JScrolI Pane; swing. JTable;sv/ing. JTextField;sv/ing. table. DefaultTableModel;java awt. event MouseAdapter; java awt. event.MouseEvent;pub I icclass AppStudent extends JFrame pr ivat

11、e pr ivate pr ivate pr ivateJTextField JTextField JTextField JTextFielddepari dF i eId; department_nameF i eId; manager_idField;I ocat ion_idField;pr ivate JTable table;pr ivate DefauItTab I eMode I mode I;，rma nager_id”,pr i vate Str ing columns = department id”，departmerTt_name, location_id;pr iva

12、te List data;pr ivate Student tmp;pub I ic AppStudent () data = new ArrayList();getContentPane () setLayout (nuII);JLabeI IbIempIoyee = new JLabeI (Mdepartment_id); I b I emp I oyee. setBounds (12, 10, 220, 13);getContentPane() add(IbIempIoyee);deparidField = new JTextFieldO; departmenti dFi e I d.

13、setBounds (100, 7, 96, 19);getContentPane () add (deparidField); depar tmerrt_ idField set Col umns (10);JLabeI IbI Age = new JLabel Cdepartment_name”)；I b I Age. setBounds (252, 10, 220, 13); getContentPane (). add (IblAge);department_nameField = new JTextFieldO;department_nameField setBounds(365,

14、7, 96, 19); getContentPane() add(department_nameField);department_nameField setCo Iumns (10);JLabeI IblStuno = new JLabel (Mmanager_idM);I b I Stuno. setBounds (12, 36, 220, 13); getContentPane(). add(IblStuno); manager_idFieId = new JTextFieldO;manager_idField setColumns(10); manager_idField. setBo

15、unds(100t 33, 96, 19);getContentPane () add (manager_idField);JLabeI IbICIass = new JLabeI (nIocation_id); IbICIass. setBounds(252, 36, 220, 13); getContentPane(). add(IbICIass);I oca ti on_idField = new JTex tFieldO;Iocat ion_idField. setCoIumns(10);I ocat i on_ i dF i e I d setBounds (365, 33, 96,

16、 19); getContentPane () add(I ocat i on_ idField);JButton btnAdd = new JButtonC增加”);btnAdd addAct ionL i stener(new Act ionL i stener () pub Iic void actionPerformed(ActionEvent e) add (););btnAdd. setBounds(75, 59, 77, 21); getContentPane (). add(btnAdd);JButton btnDeI = new JButtonC刪除”)；btnDeI add

17、Act i onL i stener(new Act ionL i stener () pub Iic void actionPerformed (ActionEvent e) de I (););btnDeI. setBounds(180, 59, 77, 21); getContentPane (). add(btnDeI);JButton btnUpdate = new JButton (M 更新”);btnUpdate. addAct i onL i stener (new Act i onL i stener () pub Iic void actionPerformed (Acti

18、onEvent e) update (););btnUpdate. setBounds(280, 59, 77, 21);getContentPane (). add (btnUpdate);JButton btnFind = new JButton (n 查找”)；btnF i nd. addAct i onL i stener(new Act i onL i stener() pub Iic void actionPerformed (ActionEvent e) f i nd ();1)；btnF ind. setBounds (380, 59, 77, 21); getContentP

19、ane (). add (btnFi nd);mode I = new DefaultTableModel (columns, 0);table = new JTable(model);table.addMouseListener(new MouseAdapter ()pub Iic void moused icked (MouseEvent e)int row = table.getSeIectedRow();departmentidFieId. setText(Str ing) table. getVaIueAt (row, 0);department_nameField setText

20、(Str ing) table getValueAt (row, 2); manager_idField setText(String) table getValueAt (row, 3); locat ion_idField. setText(String) table. getVaIueAt(row, 4);tmp = get I nput ();)；JScroI I Pane scrolI Pane = new JScroI I Pane(tab Ie); scrol I Pane. setBounds (12, 100, 571, 248);getContentPane () add

21、(scroI I Pane);setDefauItCIoseOperat ion(EX IT_0N_CL0SE);setLocat i onReI at i veTo(nuI I):setLocat ion (350, 200);setSize (601, 380);setRes izabIe(fa Ise);setVi sible(true);1pr ivate Student get Input () Student stu = new Student();stu. depar tnierit_ id二 depar tment idField get Tex t ();stu. depar

22、tment_name = deparnameField getText();stu. manager_id = manager_idFieldgetText0;stu. I ocation_id = location_idFieldgetText();return stu;pr i vate void add() data, add (ge11 nput (); showTab le ();pr i vate void del () for (int i = 0; i datasize(); i+)if (tmp. equaIs(data. get (i)data.remove (i);bre

23、ak;showTab le ();pr ivate void update0 Stu den t stu 二 getlnputO;for (int i =0; i data.size(); i+)if (tmp. equaIs(data. get (i) data, remove(i); data. add(i, stu);break;showTabIe 0;pr i vate void f ind () removeRows ();Stu den t stu = getlnputO;for (int i = 0; i data. size() ; i+) Student tmp = (Stu

24、dent) data, get (i);if (tmp. equals(stu) mode I addRow (tnip. to Array (); break;1pr i vate void showTableO removeRows ();for (in t i = 0; i 0) mode I removeRow (0);pub Iic static void main(Str ing args) new AppStudent ();class Studentimp I ementsSerializablepub Iic String department_id;pub Iic Stri

25、ng department_name;pub I icString managerd;pub Iic StringI ocat ion_id;pub Iic boolean equals (Ob ject obj) return equals(Student) obj);pub Iic boo lean equaIs(Student obj) boolean isdepartment_id = true;if (obj department, id != null & !n,r. equa Is (obj. departments id) i sdepartment_id = department_idequals(objdepartment_id);boolean isdepartmename = true;if (obj. department_name != nulI &equals(objdepartment_name) i sdepartme