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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
0 J7 T$ |* i7 w6 C1 y' Fimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
4 w+ U+ w/ T0 K+ a7 QConnection con;
Statement stmt;
String sql;
ResultSet rs;
5 G  \( r0 W8 ?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();
: Z9 d8 P, K  x3 n5 \' C} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
8 v3 n( p' e5 k: e% \0 S$ YaddEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
) X7 i8 C: N6 g2 m7 U: J} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
deleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
createGUI();
& S! h, }$ ?# }; AconnectToDataBase();
/ m) b( S# x+ C5 H3 I! b2 y// searchEmp();
+ d  E; r' j( k1 _) ^& a7 F6 {// addEmp();
8 a0 Z$ A' O3 z// deleteEmp();
. g3 t. @% |" K& }7 P+ y4 R4 E, jalterEmp();
: D+ z) T  V1 j/ A& \}

//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);
+ C+ D, ?( J% B. ]3 Qreturn con;

}

public void searchEmp() {
jta10.setText("");
* ~3 k6 {: }& Dtry {
& H# [; P6 f2 Sstmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
$ h% m9 W2 B6 U+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
, J3 C4 M- F8 A1 \) b' w. J+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
' O* ]/ j5 a4 Q5 r! S- ?+ jtf6.getText().toLowerCase().trim() + "or Phone="
& V2 p) Y$ ^# s; a$ c/ d% L+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
  z* x. k: G4 `6 O) A* Q+ jtf9.getText().toLowerCase().trim();
9 }- O% l" }$ Z: i  a5 `' w+ f( _stmt.executeQuery(sql);
rs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
# Q9 S' g: ^( V/ ?2 c2 gint cols = meta.getColumnCount();
& [- O+ \7 W  o' Q  Fwhile (rs.next()) {
% D2 K& D2 R% M% Ifor (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
# Y0 P7 G" h( K* v% D6 o}
sb.append("\n");
jta10.setText(sb.toString());
5 V6 m- R! I1 `( x9 D% F# S}
} catch (SQLException e11) {
/ X8 E/ J4 D. C# Be11.printStackTrace();
}

}

public void addEmp() {
try {
stmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
( {- l& S, D7 Y5 i, {; y+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
. t! }6 u- _6 _# V0 Z7 r&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
7 N- q& B. h4 b: ^! ~} else {
" h/ m  ~7 x& [* D* }! mjta10.setText("带*号项为添加记录时不能为空");
}
} catch (SQLException e1) {
( W; G2 x$ A8 |e1.printStackTrace();
}
}

public void deleteEmp() {
searchEmp();
try {
stmt = con.createStatement();
sql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
" s0 l/ L% H, p4 B2 c* a, ^, B+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
$ ]7 `* X3 f. Z5 `) ?6 S+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
# d& R% a3 {7 \; l: V4 c+ jtf8.getText().toLowerCase().trim() + "or busStation="
1 R7 ^* |* g. C+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
8 D( c  R0 r& A+ c, R; ?' u/ ?* T3 gint i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
0 f# B" l- r- A} catch (SQLException e) {
/ M9 u; `1 c! x# _. We.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
4 ^1 e7 t" {) _  v+ jtf2.getText().toLowerCase().trim() + "and id="
+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
4 k& b& B- U& T+ r& ^5 ?+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
# W6 u, j/ ^  _! u' C) i+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
stmt.executeUpdate(sql);
. `2 b/ b/ N+ C9 _2 }i = stmt.getUpdateCount();
} catch (SQLException e) {
1 s( K9 a) N( V: De.printStackTrace();
}
4 P* q: ]9 M: }* zjta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
3 \7 t( ~* U% F  a9 o* {// jf.setLayout(new GridLayout(10,2));
: z3 x2 y% g. K9 \( jJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
) {3 u9 `# C6 ?% `6 \  B5 L/ OJButton jb11 = new JButton("查询");
jb11.addActionListener(this);
JButton jb12 = new JButton("增加");
jb12.addActionListener(this);
5 ^! {4 @0 b" H2 Q1 q: m4 ?jp1.add(jb11);
  N& R6 J! H& [8 U/ T0 W, s! ^0 zjp1.add(jb12);
; z- o8 ?& K& v2 w+ L; @jp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
# x# t3 m$ O# e" V6 Ejb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
jb112.addActionListener(this);
jp11.add(jb111);
4 a3 X1 A5 r' n3 `1 ]  c2 Ejp11.add(jb112);
2 H/ K* C5 [. x0 W" Wjp00.add(jp11);
JPanel jp2 = new JPanel();
5 `; y# T  L7 t0 a5 }5 lJLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
jp2.add(jtf2);
3 v" v, N; [5 c8 y, pjp00.add(jp2);
! Z, u. t' P5 i# \JPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
2 d! q( `8 u; i8 b: m4 P# Ajp3.add(jl3);
* J( |" ?3 }2 s& S% H) ]! N& b/ Ujp3.add(jtf3);
" z1 p  [! g4 z0 _$ u2 @jp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
jp4.add(jtf4);
jp00.add(jp4);
JPanel jp5 = new JPanel();
) a' n" U" f5 k" ZJLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
jp00.add(jp5);
JPanel jp6 = new JPanel();
' f. \! I4 H1 kJLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
. f- V1 w, S7 j9 k  mjp6.add(jtf6);
$ S9 \; X  F# G. `+ l- F3 j% O" Qjp00.add(jp6);
JPanel jp7 = new JPanel();
0 p; Z# g1 E, uJLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
jp7.add(jtf7);
! @0 s. E! t$ q4 T, o2 k* [jp00.add(jp7);
1 Y# d0 R5 Q3 l* X& E8 a; y# k$ IJPanel jp8 = new JPanel();
% u" }/ Z8 w8 O5 oJLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
2 ^4 B* q3 L2 D* s1 D1 _1 Gjp8.add(jtf8);
jp00.add(jp8);
JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
7 ~8 m% I; h8 C; ^; Q# W1 I, c2 bjp9.add(jl9);
jp9.add(jtf9);
# t2 }1 Y! f. ^* Ajp00.add(jp9);
jf.add(jp00);
JPanel jp01 = new JPanel();
, p  }7 m  v' A8 Wjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
jf.add(jp01);
5 j2 W' C$ ?/ y3 K, njf.setSize(700, 500);
, |! I" g6 \3 p  M, C7 Tjf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
( r8 V# l2 K( W; l% K8 W2 Njf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
}
2 X1 Q: {1 f) n4 A) g}

! F9 g5 E9 ~$ i9 [0 q3 q

蕾蕾

//---------------------------------------------------------------------
SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
! B" \0 n3 s! fimport java.sql.*;
/ P8 N1 w) \& t, `4 Bpublic class JdbcUtil
{
2 K$ j& [7 i0 z, ]//load driver from file
static{
) ?& _: ]- {" H* v6 S% Q  `) _2 Mtry{
6 E! n6 k3 U. B8 G- QString driverName =
3 F+ U3 d* H; D( c6 {"oracle.jdbc.driver.OracleDriver";
& m. Q- T% X7 JClass.forName(driverName);
6 I6 i9 o7 Q' v3 e4 p/ Y0 }}catch(Exception e){
/ S  }+ K; ~9 ]- }3 Ee.printStackTrace();
4 x/ S' U9 S+ s& D% a' ^}
+ x& K& a: [- u+ j! U1 h" Q}
//establish connection
$ j( X; i9 Z3 I" P$ m% jpublic static Connection getConnection(){
Connection con = null;
0 b! q* ?- c& z1 g& L, otry{
0 h1 F9 G) e/ r# M  m$ L: \String url =
8 Z. I7 s. P/ W, k/ D7 c"jdbcracle:thin192.168.0.26:1521:tarena";
2 `; y6 ~$ f* K9 y+ SString usr = "openlab";
String pwd = "open123";
' |) f, m6 w# `! r# t2 ]con = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
e.printStackTrace();
. X3 Q+ l5 {8 l# B}
  }8 B) b. N9 Y7 O; Nreturn con;
- w9 v0 V' i5 `& `9 S+ v1 r1 ^) x}
+ L* B( b6 R: T: o; z
; t  r. {( a- A& o//close resultSet,statement and connection
; B2 n( x' T4 S- l6 Ipublic static void close(ResultSet rs,Statement stmt,Connection con){
4 Q$ h' T+ P& n' P' y) B9 L( S4 mtry{
) K. Y. I5 r9 |+ V- M- H- Xif(rs!=null) rs.close();
}catch(Exception ex){
ex.printStackTrace();
1 z: p+ T' _$ S: `; F$ \}
try{
) _2 }% c( P2 y+ j# _7 dif(stmt!=null) stmt.close();
! t" X% ]" B# E6 x* b}catch(Exception ex){
5 N7 l- u& Q3 q" }- O& ]ex.printStackTrace();
6 E3 e+ n5 f/ `- R8 h) `4 G}
( |8 j8 g  X; o! _try{
2 z* w' v& I/ o+ x- t5 h" ^8 Cif(con!=null) con.close();
6 p; X4 [8 |) S- H  N}catch(Exception ex){
# o& H. I1 ]  H% _' rex.printStackTrace();
% \9 t4 |7 X6 Z; L6 ?* }}
6 H; h! {+ Y. L8 q& o8 i; \$ v}
}