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

2、>本地連接3>屬性中，修改IP、網(wǎng)掩碼）（4）在PC機(jī)的dos命令控制臺(tái)ping虛擬機(jī)的IP，確保正常，能ping通（即將虛擬機(jī)內(nèi)外ping通）。（5）配置好虛擬機(jī)下的oracle的數(shù)據(jù)庫(kù)和監(jiān)聽(tīng)。（6）在eclipse中編寫(xiě)相關(guān)代碼，并用jtable實(shí)現(xiàn)圖形化界面，用以實(shí)現(xiàn)與數(shù)據(jù)庫(kù)的連接和操作數(shù)據(jù)庫(kù)等功能。（7）在eclipse中導(dǎo)入數(shù)據(jù)庫(kù)的驅(qū)動(dòng)。（8）運(yùn)行eclipse，查看運(yùn)行結(jié)果。2. 核心代碼2.11. 數(shù)據(jù)庫(kù)連接package .dbc;import java.sql.Connection;import java.sql.DriverManager

3、;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DatabaseConnection public static void main(String args) Connection conn = null;Statement stmt = null;ResultSet rs = null;try Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jd

4、bc:oracle:thin:28:1521/WFJ"conn = DriverManager.getConnection(url, "hr", "hr");stmt = conn.createStatement();String sql = "select * from departments"rs = stmt.executeQuery(sql);while (rs.next() System.out.print(rs.getInt("department_id");System

5、.out.print("t");System.out.print(rs.getString("department_name");System.out.print("t");System.out.print(rs.getInt("manager_id");System.out.print("t");System.out.print(rs.getInt("location_id");System.out.println(); catch (ClassNotFoundExcept

6、ion e) e.printStackTrace(); catch (SQLException e) e.printStackTrace(); finally try if (rs != null) rs.close();if (stmt != null) stmt.close();if (conn != null) conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();2. 生成get set方法package edu;public class Country pri

7、vate String department_id; private String department_name; private String area; private String population; public String getdepartment_id() return department_id; public void setdepartment_id(String department_name) = department_id; public String getdepartment_name() return department_name;

8、 public void setdepartment_name(String department_name) this.department_name = department_name; public String getmanager_id() return manager_id; public void setmanager_id(String manager_id) this.manager_id= manager_id; public String getlocation_id() return location_id; public void setlocation_id(Str

9、ing location_idn) this.location_id = location_id; 3實(shí)現(xiàn)方法package tuxinghua;import java.awt.Color;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.io.Serializable;import java.sql.DriverManager;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;i

10、mport javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.table.DefaultTableModel;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;public class AppStudent

11、extends JFrameprivate JTextField department_idField;private JTextField department_nameField;private JTextField manager_idField;private JTextField location_idField;private JTable table;private DefaultTableModel model;private String columns = "department_id", "department_name", &qu

12、ot;manager_id", "location_id"private List data;private Student tmp; public AppStudent() data = new ArrayList();getContentPane().setLayout(null);JLabel lblemployee = new JLabel("department_id");lblemployee.setBounds(12, 10, 220, 13);getContentPane().add(lblemployee);departmen

13、t_idField = new JTextField();department_idField.setBounds(100, 7, 96, 19); getContentPane().add(department_idField);department_idField.setColumns(10);JLabel lblAge = new JLabel("department_name");lblAge.setBounds(252, 10, 220, 13);getContentPane().add(lblAge);department_nameField = new JTe

14、xtField();department_nameField.setBounds(365, 7, 96, 19);getContentPane().add(department_nameField);department_nameField.setColumns(10);JLabel lblStuno = new JLabel("manager_id");lblStuno.setBounds(12, 36, 220, 13);getContentPane().add(lblStuno);manager_idField = new JTextField();manager_i

15、dField.setColumns(10);manager_idField.setBounds(100, 33, 96, 19);getContentPane().add(manager_idField);JLabel lblClass = new JLabel("location_id");lblClass.setBounds(252, 36, 220, 13);getContentPane().add(lblClass);location_idField = new JTextField();location_idField.setColumns(10);locatio

16、n_idField.setBounds(365, 33, 96, 19);getContentPane().add(location_idField);JButton btnAdd = new JButton("增加");btnAdd.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) add(););btnAdd.setBounds(75, 59, 77, 21);getContentPane().add(btnAdd);JButton btnDel = new

17、 JButton("刪除");btnDel.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) del(););btnDel.setBounds(180, 59, 77, 21);getContentPane().add(btnDel);JButton btnUpdate = new JButton("更新");btnUpdate.addActionListener(new ActionListener() public void action

18、Performed(ActionEvent e) update(););btnUpdate.setBounds(280, 59, 77, 21);getContentPane().add(btnUpdate);JButton btnFind = new JButton("查找");btnFind.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) find(););btnFind.setBounds(380, 59, 77, 21);getContentPane(

19、).add(btnFind);model = new DefaultTableModel(columns, 0);table = new JTable(model);table.addMouseListener(new MouseAdapter()public void mouseClicked(MouseEvent e)int row = table.getSelectedRow();department_idField.setText(String) table.getValueAt(row, 0);department_nameField.setText(String) table.ge

20、tValueAt(row, 2);manager_idField.setText(String) table.getValueAt(row, 3);location_idField.setText(String) table.getValueAt(row, 4);tmp = getInput(););JScrollPane scrollPane = new JScrollPane(table);scrollPane.setBounds(12, 100, 571, 248);getContentPane().add(scrollPane);setDefaultCloseOperation(EXI

21、T_ON_CLOSE);setLocationRelativeTo(null);setLocation(350,200);setSize(601, 380);setResizable(false);setVisible(true);private Student getInput() Student stu = new Student();stu.department_id= department_idField.getText();stu.department_name = department_nameField.getText();stu.manager_id = manager_idF

22、ield.getText();stu.location_id = location_idField.getText();return stu;private void add() data.add(getInput();showTable();private void del() for (int i = 0; i < data.size(); i+)if (tmp.equals(data.get(i) data.remove(i);break;showTable();private void update() Student stu = getInput();for (int i =

23、0; i < data.size(); i+)if (tmp.equals(data.get(i) data.remove(i);data.add(i, stu);break;showTable();private void find() removeRows();Student stu = getInput();for (int i = 0; i < data.size(); i+) Student tmp = (Student) data.get(i);if (tmp.equals(stu) model.addRow(tmp.toArray();break;private vo

24、id showTable() removeRows();for (int i = 0; i < data.size(); i+)Student stu = (Student) data.get(i);model.addRow(stu.toArray();private void removeRows() while (model.getRowCount() > 0) model.removeRow(0);public static void main(String args) new AppStudent();class Studentimplements Serializable

25、 public String department_id;public String department_name;public String manager_id;public String location_id;public boolean equals(Object obj) return equals(Student) obj);public boolean equals(Student obj) boolean isdepartment_id = true;if (obj.department_id != null && !"".equals(obj.department_id) isdepartment_id = department_id.equals(obj.department_id);boolean isdepartment_name = true;if (obj.department_name != null && !"".equals(obj.department_name) isdepartment_name = department_name.equals(