简单的JAVA员工信息管理系统源码.docx

// 项目目标：建立员工管理系统第一个版本。// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库） import java.sql.*;import java.awt.*;import java.awt.event.*; import javax.swing.*; public class EmpManageSys implements ActionListener {Connection con;Statement stmt;String sql;ResultSet rs;StringBuffer sb = new StringBuffer(); JTextField jtf2 = new JTextField(张飞,10); JTextField jtf3 = new JTextField(10); JTextField jtf4 = new JTextField(10); JTextField jtf7 = new JTextField(10); JTextField jtf5 = new JTextField(10); JTextField jtf6 = new JTextField(10); JTextField jtf8 = new JTextField(10); JTextField jtf9 = new JTextField(10); JTextArea jta10 = new JTextArea(50, 40); public void actionPerformed(ActionEvent e) {String str = e.getActionCommand();if (查询.equals(str)) { //if check the button of 查询，then go to method of searchEmp()searchEmp();} else if (增加.equals(str)) { //if check the button of 增加，then go to method of addEmp()addEmp();} else if (修改.equals(str)) { //if check the button of 修改，then go to method of alterEmp()alterEmp();} else if (撤除.equals(str)) { //if check the button of 撤除，then go to method of deleteEmp()deleteEmp();}} //this is the constructor. EmpManageSys() {createGUI();connectToDataBase();// searchEmp();// addEmp();// deleteEmp();alterEmp();} //connect to the database by using the method getConnection from the class of JdbcUtil. //You can find the class of JdbcUtil at the button of this page. public Connection connectToDataBase() {con = JdbcUtil.getConnection();System.out.println(con);return con; } public void searchEmp() {jta10.setText();try {stmt = con.createStatement();// sql = select * from Mstar where id= + jtf3.getText();// sql1=select * from sd100343 where =+jtf3.getText();sql = select * from Mstar where chineseName=+ jtf2.getText().toLowerCase().trim() + or id=+ jtf3.getText().toLowerCase().trim() + or engName=+ jtf4.getText().toLowerCase().trim() + or UNIT=+ jtf5.getText().toLowerCase().trim(