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

蕾蕾

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

import java.sql.*;
3 r5 l6 P8 ~6 u6 rimport java.awt.*;
import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
" `% [& F6 Q$ e7 N. l' [  hString sql;
/ f, K/ {6 s1 M7 ~* x- a# D/ ]ResultSet rs;
7 s0 f9 r3 r; e) Y' E6 Q4 bStringBuffer 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) {
4 W" Y$ N& U( m3 C8 Q$ ^! ~4 d+ NString str = e.getActionCommand();
7 j" e1 D. R/ I8 c' t# ~9 Rif ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
searchEmp();
1 U* U; c. t% ]7 j. a+ N4 Y& K} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
) L5 [3 @4 k( J9 a! zaddEmp();
9 @* i- A5 k' b4 G) @} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
8 I: i0 A& c8 U4 Y7 B4 LalterEmp();
} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
, {) h4 b/ X2 ~1 K4 R$ w( `deleteEmp();
}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
7 b5 Y5 N! c) \// 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();
: A4 m# h8 B2 K/ A4 I8 RSystem.out.println(con);
return con;

}

public void searchEmp() {
8 L; c; ?( z+ P! Q6 k4 Ijta10.setText("");
7 [5 @/ J. d; w9 r2 ftry {
) g! m8 B! T" X+ |5 ystmt = 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="
- f2 `* }0 e; @0 c+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
$ m/ _; C- I, L+ k+ jtf6.getText().toLowerCase().trim() + "or Phone="
) {# u0 Y7 D8 M* N$ p0 `' O. q+ jtf7.getText().toLowerCase().trim() + "or region="
; F' U* ^' Y7 [$ ?! \$ S; F: f+ jtf8.getText().toLowerCase().trim() + "or busStation="
9 B9 ]3 p; F+ M3 i/ m# f# P! D+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
- N* @1 J& [* F4 b  \6 trs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
0 ^5 F0 v0 o0 j" Y1 ^3 Vwhile (rs.next()) {
: @/ ?8 C- {) [7 [5 vfor (int i = 1; i <= cols; i++) {
sb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
0 s/ Q! H7 d2 I# g# \% d}
- K" }$ |9 J9 |9 G; D, U' Rsb.append("\n");
jta10.setText(sb.toString());
% @9 e& T3 K% b, Y- w+ S7 i}
- J/ `% O5 P, K} catch (SQLException e11) {
) g8 T  x3 S- A8 j5 `4 E" Be11.printStackTrace();
}

}

public void addEmp() {
try {
stmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
6 E; R9 _( i' J7 k1 k: V8 s3 m6 O+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
# o, L; p6 D, b; a/ j% w0 \int i = stmt.getUpdateCount();
6 z, j! \5 T7 e( E4 Gif ((jtf2.getText() != null) && (jtf4.getText() != null)
&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
7 g8 |  p! E5 {1 ^stmt.executeUpdate(sql);
( ~6 c& G, I3 {* L' u2 {jta10.setText("添加记录成功" + i + "条");
- g, y7 j% C5 r} else {
jta10.setText("带*号项为添加记录时不能为空");
}
) q( a8 |+ j; N7 v( _} catch (SQLException e1) {
e1.printStackTrace();
}
0 L# e6 g) ~6 z1 o4 S}

public void deleteEmp() {
3 ]% a) f3 ~- G2 @searchEmp();
try {
stmt = con.createStatement();
# }6 t! O+ u( W4 r5 U) ksql = "delete from Mstar where chineseName="
+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
% \$ w+ G0 r# o% b* o; e+ jtf4.getText().toLowerCase().trim() + "or UNIT="
. g" Y3 r9 b) E0 Y+ jtf5.getText().toLowerCase().trim() + "or TEAM="
; M1 U& l$ T; [* L+ jtf6.getText().toLowerCase().trim() + "or Phone="
) X' I7 N4 M, }7 e4 ]0 V+ w+ jtf7.getText().toLowerCase().trim() + "or region="
5 f0 _  N' m; }+ B/ l8 T- j$ Y+ jtf8.getText().toLowerCase().trim() + "or busStation="
; J' t$ z6 a; g" t. s& [# q( t' C& t+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
e.printStackTrace();
1 X8 O4 s2 q# \, Q0 S- N  V}

}

public void alterEmp() {
searchEmp();
sql = "update Mstar set chineseName="
0 n* N: r9 r; C! s+ jtf2.getText().toLowerCase().trim() + "and id="
- B7 o4 _7 s# N: O. K+ jtf3.getText().toLowerCase().trim() + "and engName="
' y0 {! c* b$ I$ k/ K4 N2 j+ jtf4.getText().toLowerCase().trim() + "and UNIT="
6 Y: |' V; @7 R$ C; Y( C' H5 e/ `. }+ jtf5.getText().toLowerCase().trim() + "and TEAM="
3 D6 K7 `6 {( K! z0 T+ f/ k8 z) W+ jtf6.getText().toLowerCase().trim() + "and Phone="
2 Z. n# M/ I3 j2 y; t5 Z& ~; o+ jtf7.getText().toLowerCase().trim() + "and region="
+ jtf8.getText().toLowerCase().trim() + "and busStation="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
stmt.executeUpdate(sql);
i = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
}
jta10.setText("修改操作成功" + i + "条");
) V& b5 c; m: w6 d+ \8 w7 {}

public void createGUI() {
JFrame jf = new JFrame("员工信息管理系统");
# \3 Y% k+ J: W5 Q$ ~jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
. h& g: |+ I: ~0 V: v9 PJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
1 a! ~. U( r+ \* n/ C+ d+ K: SJButton jb11 = new JButton("查询");
jb11.addActionListener(this);
" t" ^/ [( C7 g* y$ p( A$ LJButton jb12 = new JButton("增加");
' U  T; E7 J) R# L- L+ mjb12.addActionListener(this);
; d  L4 a9 v5 L2 d1 Fjp1.add(jb11);
jp1.add(jb12);
jp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
0 n/ M: g: T) `' @) Ejb111.addActionListener(this);
  r# n' H6 e2 A/ L; r7 U+ GJButton jb112 = new JButton("撤除");
2 ~  d6 s# J8 _1 f/ B& ~jb112.addActionListener(this);
jp11.add(jb111);
jp11.add(jb112);
7 F+ \6 V$ ?/ v/ vjp00.add(jp11);
JPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
6 @; u) S+ h3 P  \- f$ Wjp2.add(jl2);
' u/ X! O) l; ^/ j2 `0 Fjp2.add(jtf2);
jp00.add(jp2);
9 Z3 ]" A- H2 D$ E% ?. \# VJPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
jp00.add(jp3);
JPanel jp4 = new JPanel();
! v6 L. Z" X5 R; xJLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
6 t8 k; P& ~) @3 _jp4.add(jtf4);
jp00.add(jp4);
! s/ R2 j& K1 T" _8 oJPanel jp5 = new JPanel();
JLabel jl5 = new JLabel("UNIT ");
' V2 j3 d9 G9 ?) b5 W* y7 V! U/ h6 k8 ~jp5.add(jl5);
3 M$ [* A7 n9 H" [' K: j' rjp5.add(jtf5);
: O* J6 _2 P3 A* ~% Yjp00.add(jp5);
  x+ t  A3 M  K' {2 t: S, g- IJPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
: O+ k& f6 q9 u- [7 v6 I9 Jjp6.add(jtf6);
2 t6 E* A5 G# L- K2 I& \" Hjp00.add(jp6);
3 n& {2 N6 H1 A2 h4 F8 eJPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
* o$ G7 J" u6 J' }  H& Qjp7.add(jl7);
6 h+ D; J, L7 |* A  p4 `. n+ I& M8 tjp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
) c, @0 j6 a% ^& @0 J6 kJLabel jl8 = new JLabel("区域 ");
2 s. r' v3 G& v) L9 xjp8.add(jl8);
jp8.add(jtf8);
jp00.add(jp8);
' I& T( f, ^, I8 w% w) ]JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
jp9.add(jtf9);
2 i9 k) g: `/ n  Gjp00.add(jp9);
jf.add(jp00);
% z4 J' G$ u0 |( aJPanel jp01 = new JPanel();
" b/ l+ I  ^. ^, ]8 `" U. Xjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
! ^# i' U! S" b# Z; Rjp01.add(jta10);
jf.add(jp01);
jf.setSize(700, 500);
( [% O7 @; N( S4 \jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
1 J7 P; x# w. D' V! gjf.setVisible(true);

}

public static void main(String[] args) {
2 e/ [6 b" f  ]2 knew EmpManageSys();
}
) u. U4 F  l, a$ N6 Z}

蕾蕾

//---------------------------------------------------------------------
SQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
public class JdbcUtil
8 i. n- `0 E& E+ a- n2 p: c{
% h6 ~4 @6 p: v& Y" W//load driver from file
5 S; s- g% S/ xstatic{
try{
String driverName =
, X: N+ D" D2 D4 r$ x6 z- T/ ~- s"oracle.jdbc.driver.OracleDriver";
& {9 C4 c2 |. D" sClass.forName(driverName);
1 }1 @& a- [. a9 A# A# B- ]}catch(Exception e){
; Y9 x/ j8 F1 c, ^' ^+ `" X1 he.printStackTrace();
& l( p) @; A- \  f/ d7 W}
}
//establish connection
2 [: F; h: ^, y2 Dpublic static Connection getConnection(){
9 G: R# ?# S- `8 f% uConnection con = null;
try{
String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
String pwd = "open123";
& x; Y; M8 I6 ^con = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
e.printStackTrace();
}
( ~6 G( U0 M  E% a7 f% Hreturn con;
}
) z8 n7 \9 ~/ t: |
9 A( r! y( T6 i//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
}catch(Exception ex){
$ K0 w) z  g1 B4 `ex.printStackTrace();
% j6 j* t9 J) c1 q}
try{
if(stmt!=null) stmt.close();
: _7 e. {8 ]$ S* P" o9 O, n# z}catch(Exception ex){
ex.printStackTrace();
- |) l5 h, ~- F7 |6 p}
, p& y  V9 R7 g% N2 ]( f0 ttry{
if(con!=null) con.close();
$ m1 R7 A8 W% @# o  p' q4 d* d}catch(Exception ex){
9 v+ p2 [9 q9 `4 R- iex.printStackTrace();
. K+ K$ }5 P. }5 |4 w7 J; j. K}
}
}