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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
. ~5 [! y2 |$ H// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
' o* E  G; [+ j4 C3 F2 I2 i! L; `// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
0 v* S" z6 B8 O7 A; gimport java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
Connection con;
5 B' @- @& b/ ]9 V5 T& EStatement stmt;
0 U, O! E4 F# c0 y1 ]String sql;
ResultSet rs;
+ m& {1 U* H2 i; H4 |6 O' n& VStringBuffer 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()
' k( L, ?' ]7 {8 [: k+ YsearchEmp();
} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
5 y, T6 k' t# M" OaddEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
0 m0 ^* X2 m  v' n} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
, r5 [$ o( `  r8 ]4 tdeleteEmp();
/ x# s4 f( h) m: h) m6 u}
% o0 n- \( d) v4 H7 v! @}

//this is the constructor.

EmpManageSys() {
4 ~# }: q4 q2 l) c2 o$ ~createGUI();
5 ?  `& y6 Q2 r8 n( I. I8 F3 BconnectToDataBase();
8 Y" A& B5 l5 t; f// searchEmp();
// addEmp();
. S% {9 D7 V4 R0 W% @! Q// deleteEmp();
! n) a8 k9 ~- ~9 V& RalterEmp();
6 x7 B2 Y2 R+ B# M! Z/ y' s$ j}

//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);
# h9 I) x/ L( a: |return con;

}

public void searchEmp() {
* E5 K3 O) b" d, d& [jta10.setText("");
try {
4 p& `' r! Y, D* C# L, }) Ostmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
3 |& M7 ]' a: h( d( ~// sql1="select * from sd100343 where ="+jtf3.getText();
) Y6 l* }% k! N1 {4 t" ]sql = "select * from Mstar where chineseName="
" I5 p6 v6 _2 \. c% K+ jtf2.getText().toLowerCase().trim() + "or id="
+ \2 [; G" `5 Z7 c/ g: [; j) E! D7 Z+ jtf3.getText().toLowerCase().trim() + "or engName="
, I3 @# W3 V9 E) S  J" O- L2 M+ jtf4.getText().toLowerCase().trim() + "or UNIT="
% S5 z# C& @9 M$ ~+ jtf5.getText().toLowerCase().trim() + "or TEAM="
- K! o/ }1 j: v# X' s+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
# @. ^% {/ O) R  }3 a8 v. K+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
stmt.executeQuery(sql);
0 X9 z" H6 ]9 {& L7 Crs = stmt.getResultSet();
ResultSetMetaData meta = rs.getMetaData();
7 y* S5 _1 l' L+ s( uint cols = meta.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
  _% x; M. |3 F! c; _3 Isb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
. ^6 C5 n: Q' T, A, Q. M1 D# w5 b}
sb.append("\n");
/ g/ N2 N' g6 o2 \6 a8 G2 \7 g: Vjta10.setText(sb.toString());
}
} catch (SQLException e11) {
e11.printStackTrace();
- ~. n4 A% N" O2 e}

}

public void addEmp() {
try {
stmt = con.createStatement();
sql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
" O7 K* D2 u  h# F& e" Z+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
int i = stmt.getUpdateCount();
5 l0 h+ ^! ?! Cif ((jtf2.getText() != null) && (jtf4.getText() != null)
) E! i# S" z7 m# ?4 r- x&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
stmt.executeUpdate(sql);
jta10.setText("添加记录成功" + i + "条");
/ M# s- j. N, i  A" o} else {
jta10.setText("带*号项为添加记录时不能为空");
6 z6 M7 J% k7 n6 J/ _}
} catch (SQLException e1) {
e1.printStackTrace();
}
}

public void deleteEmp() {
* y3 ?% v# S: \. MsearchEmp();
' H5 T+ M) W3 wtry {
8 E* i* D9 `7 ~8 U/ T3 R& e2 qstmt = con.createStatement();
8 J, U" B& f/ osql = "delete from Mstar where chineseName="
! B# }; R6 M# `' _. E1 y+ jtf2.getText().toLowerCase().trim() + "or id="
+ jtf3.getText().toLowerCase().trim() + "or engName="
+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
- B& b8 e, ^) z! i3 S+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
; L; u5 p9 Y4 y+ jtf8.getText().toLowerCase().trim() + "or busStation="
+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
0 B5 i' P8 R) E, f3 u( ejta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
+ w+ t) z# e' d; B  ?e.printStackTrace();
}

}

public void alterEmp() {
searchEmp();
; D  D' c9 u6 Q9 ^$ K4 p9 c1 [sql = "update Mstar set chineseName="
3 g' G6 u1 ]) v* y# D* G+ jtf2.getText().toLowerCase().trim() + "and id="
+ jtf3.getText().toLowerCase().trim() + "and engName="
0 T: v4 t% v/ q9 d; m: y/ @" Z+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ d* z  T4 d6 ]" j0 |+ jtf7.getText().toLowerCase().trim() + "and region="
5 l: P/ R3 u8 J. s% ^' O+ jtf8.getText().toLowerCase().trim() + "and busStation="
5 L- ^0 ~( t3 }6 ^7 [. z+ jtf9.getText().toLowerCase().trim();

int i = 0;
try {
' @& f. W- A9 L9 V2 R+ g+ s# Fstmt.executeUpdate(sql);
i = stmt.getUpdateCount();
, o4 C0 \$ K2 c& U} catch (SQLException e) {
e.printStackTrace();
& r) v: V, I; M/ W0 X}
+ l- U8 x9 V) c0 @/ ?" w- wjta10.setText("修改操作成功" + i + "条");
& ]- W% f- D; |: v2 g' b# ]" m}

public void createGUI() {
5 ~" E. h9 t; c1 Q1 |( e* I: v8 TJFrame jf = new JFrame("员工信息管理系统");
jf.setLayout(new GridLayout(2, 1));
// jf.setLayout(new GridLayout(10,2));
JPanel jp00 = new JPanel(new GridLayout(5, 4));

JPanel jp1 = new JPanel();
; O$ h+ t" C! n* i5 \JButton jb11 = new JButton("查询");
# w- ?+ @& d- l! b& ?9 P" Xjb11.addActionListener(this);
! e2 `* z: ^" L  j, O2 e1 LJButton jb12 = new JButton("增加");
jb12.addActionListener(this);
jp1.add(jb11);
jp1.add(jb12);
  ?% b3 @1 s7 y! k  P( @8 ejp00.add(jp1);
( W6 n" J, w7 t5 a4 Z  F, M, f0 J3 SJPanel jp11 = new JPanel();
! v1 G& W- }( H8 y# XJButton jb111 = new JButton("修改");
jb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
  q; j1 j0 m3 n* ]# ~2 q0 Njb112.addActionListener(this);
jp11.add(jb111);
! A" B3 U. U: T( R+ sjp11.add(jb112);
- u4 Q# w, }) v( o0 |jp00.add(jp11);
JPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
- r8 q; `! `& F3 K% ^/ mjp2.add(jtf2);
% c' K5 A, g2 d5 d% |6 V( ajp00.add(jp2);
" r) W' v  W" w( P! t; TJPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
$ T- Z3 O' A) c( e1 ~4 ]jp3.add(jl3);
0 q2 i# I4 d' T- l1 Cjp3.add(jtf3);
* `/ E/ B' A! j) x. [" W2 K) y# gjp00.add(jp3);
- Y4 C5 k3 {- y) g7 u, E+ l9 VJPanel jp4 = new JPanel();
/ \9 N* D, p6 QJLabel jl4 = new JLabel("EngName*");
jp4.add(jl4);
  O- k2 }2 C0 o. C9 cjp4.add(jtf4);
+ U+ Y6 j8 Q8 ^jp00.add(jp4);
JPanel jp5 = new JPanel();
% H7 u3 V; U4 g# h$ ?JLabel jl5 = new JLabel("UNIT ");
jp5.add(jl5);
jp5.add(jtf5);
% ~8 `4 N/ x5 a% |jp00.add(jp5);
& g8 c( `; Q: gJPanel jp6 = new JPanel();
JLabel jl6 = new JLabel("TEAM* ");
# q6 v2 {0 ~% q+ ljp6.add(jl6);
jp6.add(jtf6);
" F* b* |$ P- y" @. v+ s3 kjp00.add(jp6);
JPanel jp7 = new JPanel();
9 z. n0 U5 z- AJLabel jl7 = new JLabel("Phone* ");
6 F7 [3 T3 Y4 l* w8 c* @' G( Jjp7.add(jl7);
jp7.add(jtf7);
jp00.add(jp7);
JPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
& F: n4 K4 I; P8 n1 X& S0 W5 b% gjp8.add(jl8);
6 \' X+ K6 @& L' Ojp8.add(jtf8);
1 Q- Q+ ]1 O2 R/ e, l; i7 i3 Mjp00.add(jp8);
JPanel jp9 = new JPanel();
6 ~' u( T( |8 H9 z$ oJLabel jl9 = new JLabel("公交站 ");
2 v' L5 h- R6 M+ Bjp9.add(jl9);
# K3 a5 a+ x1 M; ]7 Z6 ijp9.add(jtf9);
jp00.add(jp9);
jf.add(jp00);
JPanel jp01 = new JPanel();
- h! V; B9 N2 kjta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
; K, n/ x$ D( m0 R, Ljp01.add(jta10);
jf.add(jp01);
jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
" \0 X* v- P+ v! \% jjf.setVisible(true);

}

public static void main(String[] args) {
new EmpManageSys();
}
# b4 d3 [- ]0 U  {}

蕾蕾

//---------------------------------------------------------------------
$ x2 W* U2 M* N6 M6 z  R% ?. zSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
import java.sql.*;
( t! B1 F1 w/ K+ C) Ppublic class JdbcUtil
, r4 S/ v0 e5 y) C{
//load driver from file
" L2 b( D' y5 i; D& gstatic{
: N4 t4 s$ y  p+ Btry{
String driverName =
: W4 H5 F* j/ |+ P. v3 y7 f"oracle.jdbc.driver.OracleDriver";
$ _& D- ]2 p, Z$ R/ u% K% C8 DClass.forName(driverName);
}catch(Exception e){
e.printStackTrace();
8 |$ n' h+ z/ q  |/ I}
/ H7 l$ u( n' s1 C8 h& }}
//establish connection
public static Connection getConnection(){
Connection con = null;
/ `7 ]2 @0 A3 S2 d/ d- H3 h& ltry{
String url =
' d+ o7 }' n( a' \0 N. C8 `& s7 Z4 \"jdbcracle:thin192.168.0.26:1521:tarena";
String usr = "openlab";
String pwd = "open123";
con = DriverManager.getConnection(
' {. k7 R, j6 ]7 Z% R$ Q3 Hurl,usr,pwd);
}catch(Exception e){
9 @& M; a+ W. P' |/ n+ ~e.printStackTrace();
5 k% @; q; e3 y- A, k3 L}
% P0 F8 f6 N! R* I# R' S2 lreturn con;
}
7 Q4 {. N  S) q% w" y7 H
9 I" h( T+ O# E//close resultSet,statement and connection
+ ~# C- g: g4 g4 w) s$ t! kpublic static void close(ResultSet rs,Statement stmt,Connection con){
try{
if(rs!=null) rs.close();
( c  |& M! c+ F/ x7 s1 Z/ }}catch(Exception ex){
ex.printStackTrace();
}
" S8 N* g9 L0 }& s- n' ctry{
if(stmt!=null) stmt.close();
}catch(Exception ex){
' d" P: E: k/ s6 R% b% ]ex.printStackTrace();
}
! _. u! [0 j* U7 T/ b  Z/ qtry{
$ U( _# r; k' K9 A. U$ Tif(con!=null) con.close();
}catch(Exception ex){
% R$ t  y5 X/ ]$ S9 r2 bex.printStackTrace();
}
0 v" f; ], @0 \4 d6 y9 N}
}