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

//项目目标：建立员工管理系统第一个版本。

//实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。

//模块：1.GUI界面2.数据库连接3.查询4.增、5删6改(操作数据库）

importjava.sql.*;importjava.awt.*;importjava.awt.event.*;

importjavax.swing.*;

publicclassEmpManageSysimplementsActionListener{

Connectioncon;

Statementstmt;

Stringsql;

ResultSetrs;

StringBuffersb

=

new

StringBuffer();

JTextFieldjtf2

=

new

JTextField(张飞,10);

JTextFieldjtf3

=

new

JTextField(10);

JTextFieldjtf4

=

new

JTextField(10);

JTextFieldjtf7

=

new

JTextField(10);

JTextFieldjtf5

=

new

JTextField(10);

JTextFieldjtf6

=

new

JTextField(10);

JTextFieldjtf8

=

new

JTextField(10);

JTextFieldjtf9

=

new

JTextField(10);

JTextAreajta10

=

new

JTextArea(50,40);

publicvoidactionPerformed(ActionEvente){Stringstr=e.getActionCommand();

if(查询.equals(str)){

//ifcheckthebuttonof查询，thengotomethodofsearchEmp()searchEmp();

}elseif(增加.equals(str)){

//ifcheckthebuttonof增加，then

addEmp();

}elseif(修改.equals(str)){

go

to

method

of

addEmp()

//ifcheckthebuttonof修改，thenalterEmp();

}elseif(撤除.equals(str)){

go

to

method

of

alterEmp()

//ifcheckthebuttonof撤除，thendeleteEmp();

}

}

go

to

method

of

deleteEmp()

//thisistheconstructor.

EmpManageSys(){createGUI();connectToDataBase();

//

searchEmp();

//

addEmp();

//

deleteEmp();

alterEmp();

}

//connecttothedatabasebyusingthemethodgetConnectionfromtheclassofJdbcUtil.

//YoucanfindtheclassofJdbcUtilatthebuttonofthispage.publicConnectionconnectToDataBase(){

con=JdbcUtil.getConnection();

System.out.println(con);returncon;

}

publicvoidsearchEmp(){jta10.setText();

try{

stmt=con.createStatement();

//sql=select*fromMstarwhereid=+jtf3.getText();

//sql1=select*fromsd100343where=+jtf3.getText();sql=select*fromMstarwherechineseName=

+jtf2.getText().toLowerCase().trim()+orid=

+jtf3.getText().toLowerCase().trim()+orengName=

+jtf4.getText().toLowerCase().trim()+orUNIT=

+jtf5.getText().toLowerCase().tr