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

蕾蕾

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

import java.sql.*;
" U8 N4 S, H$ ?3 e! Nimport java.awt.*;
import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
Statement stmt;
String sql;
* Y  {/ D2 e8 R5 JResultSet 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()
  \; c% F. v) N8 w3 S; FsearchEmp();
3 K: j7 v* d5 Q* A6 J& L0 y( v} 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();
  G, ]& t& H+ {} else if ("撤除".equals(str)) {

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

//this is the constructor.

EmpManageSys() {
createGUI();
5 [& V6 c& _) X: O5 YconnectToDataBase();
3 r. _5 j, o3 @+ P// searchEmp();
// addEmp();
! k0 K; b# f) U) w2 U/ f- X4 E// deleteEmp();
+ i, u# H) M4 c, f  PalterEmp();
. v: n1 ?+ F: C6 M/ @- k}

//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();
+ I4 s* B+ y6 |System.out.println(con);
/ `: V4 d. m  H7 {7 }return con;

}

public void searchEmp() {
9 a9 c  t$ P. E/ ?jta10.setText("");
try {
$ ?* N3 {, f, z# u* D4 mstmt = con.createStatement();
% E) Z; h( |% B/ v// sql = "select * from Mstar where id=" + jtf3.getText();
7 h# b: y9 N8 z  G// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
2 P& z3 e/ v: d7 X+ jtf2.getText().toLowerCase().trim() + "or id="
( k, E% C* D# g8 H+ }; T2 f( M+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
: s/ Z+ M0 R5 |0 X+ jtf5.getText().toLowerCase().trim() + "or TEAM="
0 Y0 D3 [% b5 i9 @+ jtf6.getText().toLowerCase().trim() + "or Phone="
: z. H& g% w" ]& {1 n+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
3 a7 H$ _& _* W+ jtf9.getText().toLowerCase().trim();
1 B4 q* f& c. \) b6 f+ J0 k7 _8 estmt.executeQuery(sql);
5 N  ]; W. P3 c" q1 [$ jrs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
' C. w& E5 b$ B8 e2 d9 {6 iwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
7 |; e, e1 q% I) e9 ^1 `sb.append(" " + meta.getColumnName(i) + " =");
* l1 k. ?; I, J( a+ a! fsb.append(rs.getString(i));
9 \( D; h& L4 {8 k( G}
sb.append("\n");
jta10.setText(sb.toString());
}
7 x& r3 J% j3 f' B/ m7 B* }* U} catch (SQLException e11) {
e11.printStackTrace();
}

}

public void addEmp() {
try {
, d5 ?( V8 [1 N$ z* H; Hstmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
# C5 |1 X( t* i+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
if ((jtf2.getText() != null) && (jtf4.getText() != null)
&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
. O! [; `- i! b; {stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
} else {
( W! r3 o# {2 Y+ }! [$ T) ^1 r4 Wjta10.setText("带*号项为添加记录时不能为空");
/ Z$ |2 Q3 ?1 I# E9 X}
5 |( [: z2 x( K. m; }6 i  e} catch (SQLException e1) {
5 ~3 V4 _4 @) j6 E# [+ C: }e1.printStackTrace();
& ~5 g( c& M! h$ S}
% N0 J6 b! |. F( ^}

public void deleteEmp() {
searchEmp();
! R: z5 ?# O6 W4 E7 W) G( xtry {
, `: Y% d* i. s. z/ U- Lstmt = con.createStatement();
sql = "delete 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="
* k! t: y4 ]# l' {7 Z1 Q5 B+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
6 t8 [2 A& Q, X- J) ijta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
# b$ k% J" ~, Z' x, qe.printStackTrace();
8 e7 o2 K3 g# V/ _" Z$ V3 I}

}

public void alterEmp() {
- N  d7 V/ s4 ]( v. bsearchEmp();
sql = "update Mstar set chineseName="
  n) |0 U+ I+ ]! E+ jtf2.getText().toLowerCase().trim() + "and id="
) R. L1 [! L+ r+ G( o+ jtf3.getText().toLowerCase().trim() + "and engName="
+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
$ a6 {+ E+ b, i. X* s) c8 W+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ jtf7.getText().toLowerCase().trim() + "and region="
1 v  s3 T1 E0 e# B% N8 g3 u+ @+ jtf8.getText().toLowerCase().trim() + "and busStation="
+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
5 X, N9 j; K4 b4 Q; r0 e8 ?' n! pstmt.executeUpdate(sql);
' \  }7 o$ m$ T4 A, w/ `i = stmt.getUpdateCount();
} catch (SQLException e) {
e.printStackTrace();
' _# T' R1 |; Z8 R}
/ b! f* O" z0 Z! C' P* T& l0 ijta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
$ T6 W: y+ W, }JFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
# C% v: i, j' @( o7 V, v// jf.setLayout(new GridLayout(10,2));
+ r6 H+ z7 ^+ M  X' bJPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
JButton jb11 = new JButton("查询");
jb11.addActionListener(this);
JButton jb12 = new JButton("增加");
+ t" ]/ b  R: `& Z3 u9 z; l2 Njb12.addActionListener(this);
0 H. \8 y% ~, S( Q+ Hjp1.add(jb11);
/ Z& `! I$ l! F' Q; i3 v1 @9 P1 njp1.add(jb12);
7 s5 x' s3 D3 Z- ^) j8 W3 @" Yjp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
/ R/ M. u1 s' P% n) vjb111.addActionListener(this);
7 s3 {. p9 ~' {! O7 b2 jJButton jb112 = new JButton("撤除");
2 b! ?& A1 |# M. Q6 @jb112.addActionListener(this);
. J% y" H0 j( }jp11.add(jb111);
! f5 z% i4 s$ O- Xjp11.add(jb112);
- K) P/ b2 a/ Y; Vjp00.add(jp11);
JPanel jp2 = new JPanel();
( F% P+ I% N, m% A) g8 c' fJLabel jl2 = new JLabel("中 文 名 * ");
# d* s, G- H/ D& g2 z" H3 Z8 Wjp2.add(jl2);
jp2.add(jtf2);
jp00.add(jp2);
JPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
) z9 I' \+ G% B3 F/ ijp00.add(jp3);
& V# C. p" L5 m7 y" J0 LJPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
jp4.add(jtf4);
3 y8 v; i, W# s  a, g( ojp00.add(jp4);
JPanel jp5 = new JPanel();
8 U( }- p" X* Q6 LJLabel jl5 = new JLabel("UNIT ");
. W1 ^6 p# h: T! E  V- ^8 o4 [jp5.add(jl5);
jp5.add(jtf5);
jp00.add(jp5);
; }$ E; Z  z6 i; GJPanel jp6 = new JPanel();
5 J0 Q$ l3 y" R1 wJLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
( ?- T5 H3 w+ g8 yjp6.add(jtf6);
  f8 B. O' ^  z9 ojp00.add(jp6);
: l" m; z- P/ ^+ [# D! |JPanel jp7 = new JPanel();
JLabel jl7 = new JLabel("Phone* ");
0 ~) g6 X9 Y9 N6 r. l, ijp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
" w# l# e- n! V7 Z* _* VJLabel jl8 = new JLabel("区域 ");
jp8.add(jl8);
: a; G; K- ~. l; g4 r# D' fjp8.add(jtf8);
0 I- y# p7 j- K/ K" vjp00.add(jp8);
JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
# s+ u7 O4 g* D$ r( e4 H; Q0 Zjp9.add(jl9);
: q! I& o' t0 b( O9 r8 ujp9.add(jtf9);
jp00.add(jp9);
; u. Z- `* }( l5 V$ Mjf.add(jp00);
JPanel jp01 = new JPanel();
6 F+ ?3 |  s  W8 Z; K% W0 S) l3 Ijta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
jf.add(jp01);
5 ]" l2 F* T* V8 _jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.setVisible(true);

}

public static void main(String[] args) {
2 T2 i5 [- N, y, onew EmpManageSys();
( E+ B8 J% G) V; `1 }, _, l}
' q! d, B9 I2 r}

5 K0 J- c4 F- T9 r4 G9 L! R) D: M

蕾蕾

//---------------------------------------------------------------------
& W  v4 C1 W, g, S0 s1 KSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
6 Y8 \" G: r- [$ c/ ?8 Y1 Iimport java.sql.*;
public class JdbcUtil
{
//load driver from file
7 [4 _7 o7 J8 _- Ystatic{
6 N) [2 M3 T) z! Jtry{
! _' R% F3 M- d& I- oString driverName =
"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
+ K" `- b0 I  _}catch(Exception e){
e.printStackTrace();
: x8 B5 {' D& M' j}
}
2 o( k& w2 O* ?$ w3 K  ]$ d9 ~6 m//establish connection
public static Connection getConnection(){
Connection con = null;
) L6 }! |0 x+ K1 W2 ctry{
String url =
"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
String pwd = "open123";
7 h1 q5 j% b/ s2 r: vcon = DriverManager.getConnection(
url,usr,pwd);
3 v$ Z4 a! \7 w- W/ F3 }}catch(Exception e){
e.printStackTrace();
}
: l1 v8 r4 D4 }6 d; _return con;
% c/ Q6 l9 H$ N3 @8 y( S}

//close resultSet,statement and connection
$ D( v3 S$ b8 e6 Npublic static void close(ResultSet rs,Statement stmt,Connection con){
: U$ ]1 o" X: ~- F1 ~$ V& f# Btry{
if(rs!=null) rs.close();
}catch(Exception ex){
* Z- T1 z7 E8 ~; Yex.printStackTrace();
}
' N* m6 I: S3 P# E7 |5 |7 M. p/ btry{
if(stmt!=null) stmt.close();
}catch(Exception ex){
6 P7 S0 A+ D) }  h2 S- n0 dex.printStackTrace();
}
& e9 L6 G: l7 g# @. Htry{
5 B8 s. A4 j( b' n" |if(con!=null) con.close();
$ ~4 f2 }/ Y3 n9 ^; X1 h9 U}catch(Exception ex){
# z# c% u" u* lex.printStackTrace();
, Z0 X- P" ?) d- e}
  h! ]" }2 {8 J! |9 {}
}