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

// 项目目标：建立员工管理系统第一个版本。// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）import java.sql.*;import java.awt.*;import java.awt.event.*;importjavax.swing.*;public class EmpManageSys implements ActionListener {Connection con;Statement stmt;String sql;ResultSetrs;StringBuffersb = 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() + or TEAM=+ jtf6.getText().toLowerCase().trim() + or Phone=+ jtf7