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

蕾蕾

// 项目目标：建立员工管理系统第一个版本。
3 k: y3 H5 `- R( r, o// 实现图形用户界面的员工信息查询、增、删、改；与数据库建立，并将修改结果时时保存到数据库。
( Q9 b& I" G9 K' C2 y1 W; I// 模块：1.GUI界面 2.数据库连接 3.查询 4.增、5删 6改(操作数据库）

import java.sql.*;
import java.awt.*;
4 G' R1 }5 r) U0 i9 Y8 s3 X. c* ^import java.awt.event.*;

import javax.swing.*;

public class EmpManageSys implements ActionListener {
+ }" V/ J9 [% ?+ K; wConnection con;
4 o* f5 u) x" M0 {" a6 M8 n2 A+ QStatement stmt;
% v% T4 g/ F9 [. Q. OString sql;
ResultSet 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) {
, n) B. M5 K" DString str = e.getActionCommand();
if ("查询".equals(str)) {

//if check the button of 查询，then go to method of searchEmp()
4 \' N7 g3 A  O! m4 w9 k+ UsearchEmp();
% U( s" L0 r  c9 `* j. g} else if ("增加".equals(str)) {

//if check the button of 增加，then go to method of addEmp()
. O$ a; O$ d9 T* t6 xaddEmp();
} else if ("修改".equals(str)) {

//if check the button of 修改，then go to method of alterEmp()
alterEmp();
1 S* e/ Y4 O, W# B6 |1 k/ z} else if ("撤除".equals(str)) {

//if check the button of 撤除，then go to method of deleteEmp()
deleteEmp();
3 v6 ?9 `/ W" Y! u6 E}
}

//this is the constructor.

EmpManageSys() {
createGUI();
connectToDataBase();
/ p; ~' a- R6 B- ~2 E- A' @// searchEmp();
0 t; {* `9 m6 I& P// addEmp();
" C8 w  ?" b) @: e, I. E// deleteEmp();
alterEmp();
9 b5 X- |! b5 {; 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() {
* u2 x2 B  t6 g; |* Q0 x7 Ycon = JdbcUtil.getConnection();
System.out.println(con);
return con;

}

public void searchEmp() {
, A( o  F$ m' f# [jta10.setText("");
try {
stmt = con.createStatement();
// sql = "select * from Mstar where id=" + jtf3.getText();
// sql1="select * from sd100343 where ="+jtf3.getText();
sql = "select * from Mstar where chineseName="
7 @0 t" J% S. g8 K- C+ jtf2.getText().toLowerCase().trim() + "or id="
2 [* y" P1 H, n7 B8 Q5 h7 x+ jtf3.getText().toLowerCase().trim() + "or engName="
% `' P7 O+ D" p- R5 Y+ jtf4.getText().toLowerCase().trim() + "or UNIT="
+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
$ W; S6 X$ S3 p) s8 `: t+ jtf8.getText().toLowerCase().trim() + "or busStation="
: m: ~4 J$ P, `0 r# U! ?+ jtf9.getText().toLowerCase().trim();
: d! {0 y1 a  R2 R# F' hstmt.executeQuery(sql);
rs = stmt.getResultSet();
# z2 ?; ^* `6 u( J* TResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
# Q6 r+ T' k9 j3 hwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
, v" H$ W+ a" e. Dsb.append(" " + meta.getColumnName(i) + " =");
sb.append(rs.getString(i));
  D6 u( [7 ^% ^8 J  p8 l% R}
( |1 f5 s" ?: B' ?$ e1 Asb.append("\n");
jta10.setText(sb.toString());
}
} catch (SQLException e11) {
e11.printStackTrace();
}

}

public void addEmp() {
# j2 k: s1 C- Y" Z" M0 t8 Ftry {
% w. H5 z1 d7 }" ~7 d; E$ B6 E# gstmt = con.createStatement();
5 j& z2 }7 n' A9 N" Rsql = "update Mstar values(" + jtf2.getText() + jtf3.getText()
+ jtf4.getText() + jtf5.getText() + jtf6.getText()
+ jtf7.getText() + jtf8.getText() + jtf9.getText() + ")";
: n& k0 U: j4 f# f/ ?% f' Jint i = stmt.getUpdateCount();
! t( X4 l2 L! Y! l2 ?if ((jtf2.getText() != null) && (jtf4.getText() != null)
' ?" T- e+ {- q  L&& (jtf6.getText() != null) && (jtf7.getText() != null)) {
$ _. X8 Y( C3 t, H. u: v/ j* astmt.executeUpdate(sql);
9 A  e3 Y5 o  wjta10.setText("添加记录成功" + i + "条");
- w# V, Y  ?5 @} else {
# R" l* M2 x) L6 i1 Jjta10.setText("带*号项为添加记录时不能为空");
}
} catch (SQLException e1) {
& S, }& c  F) m& W2 F( ~0 J( ae1.printStackTrace();
# O+ u: Y0 E* E9 L}
6 r- t1 X6 q! m}

public void deleteEmp() {
+ [/ \) Y5 G( ~$ I! K3 FsearchEmp();
try {
stmt = 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="
5 f( `' m# k! S, Z7 I% W: Z+ jtf5.getText().toLowerCase().trim() + "or TEAM="
+ jtf6.getText().toLowerCase().trim() + "or Phone="
+ jtf7.getText().toLowerCase().trim() + "or region="
9 r  x$ a/ [7 n) s9 F+ jtf8.getText().toLowerCase().trim() + "or busStation="
9 Q0 h- n; |) A1 e+ jtf9.getText().toLowerCase().trim();
stmt.executeUpdate(sql);
int i = stmt.getUpdateCount();
jta10.setText("撤除操作成功" + i + "条");
} catch (SQLException e) {
8 k' t4 }, b9 B! d. ~e.printStackTrace();
$ R' u/ p$ Z8 m9 q}

}

public void alterEmp() {
searchEmp();
) Y8 W! r/ q: L8 \$ n3 q% h) fsql = "update Mstar set chineseName="
+ jtf2.getText().toLowerCase().trim() + "and id="
# _3 j* R* j  j) E- W. t+ jtf3.getText().toLowerCase().trim() + "and engName="
2 W5 W  J7 K" I0 F8 z+ jtf4.getText().toLowerCase().trim() + "and UNIT="
+ jtf5.getText().toLowerCase().trim() + "and TEAM="
+ jtf6.getText().toLowerCase().trim() + "and Phone="
+ 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();
$ F0 Y1 M6 x4 U} catch (SQLException e) {
6 i  ]/ u! Q8 [& L& we.printStackTrace();
}
$ K3 v) Z$ n, x6 S* Zjta10.setText("修改操作成功" + i + "条");
}

public void createGUI() {
  K- Y7 ~. k& [6 f* J( W" k& 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();
JButton jb11 = new JButton("查询");
jb11.addActionListener(this);
  ?8 L3 @0 c2 V! N2 y; _* f5 F; kJButton jb12 = new JButton("增加");
, ]9 g# ]' T( j7 U# ]+ `jb12.addActionListener(this);
jp1.add(jb11);
/ I* z2 |9 _3 J9 c  [+ X! f/ s! pjp1.add(jb12);
" m% p  V$ K) [jp00.add(jp1);
JPanel jp11 = new JPanel();
JButton jb111 = new JButton("修改");
! S8 i1 Q9 w2 b. n) Yjb111.addActionListener(this);
JButton jb112 = new JButton("撤除");
# B) b( L, o3 F% Hjb112.addActionListener(this);
jp11.add(jb111);
jp11.add(jb112);
! e5 q) n( g9 ~/ X  Ojp00.add(jp11);
; P; d/ z9 U! K" H$ p+ bJPanel jp2 = new JPanel();
JLabel jl2 = new JLabel("中 文 名 * ");
jp2.add(jl2);
( O- N% R* I; \" o  Ejp2.add(jtf2);
/ p7 ]6 M6 k8 v8 o! ]- s/ Mjp00.add(jp2);
JPanel jp3 = new JPanel();
JLabel jl3 = new JLabel("工 号 ");
jp3.add(jl3);
jp3.add(jtf3);
5 u6 S3 L: S! Mjp00.add(jp3);
JPanel jp4 = new JPanel();
JLabel jl4 = new JLabel("EngName*");
$ M/ N% l- P6 M! z& Q2 t+ djp4.add(jl4);
jp4.add(jtf4);
0 R9 d7 u  f* ]% _+ y3 B4 `; Hjp00.add(jp4);
JPanel jp5 = new JPanel();
: [+ R6 Q0 v% ^9 t$ X! dJLabel jl5 = new JLabel("UNIT ");
( o8 |0 O' S  y; \jp5.add(jl5);
2 t" f+ F5 h! V$ `jp5.add(jtf5);
jp00.add(jp5);
' W2 y" E% y& b9 S5 ^JPanel jp6 = new JPanel();
  g! B4 u% ?; sJLabel jl6 = new JLabel("TEAM* ");
jp6.add(jl6);
1 p0 j: Q7 O1 v5 w3 _4 l3 q$ f4 ujp6.add(jtf6);
+ m$ i& l! F1 A1 u0 jjp00.add(jp6);
JPanel jp7 = new JPanel();
; j# t' [6 Q0 pJLabel jl7 = new JLabel("Phone* ");
jp7.add(jl7);
$ q6 H$ R4 H) {) A' G/ S  Zjp7.add(jtf7);
* y6 P. F1 q8 ?6 njp00.add(jp7);
9 N* @/ a8 ?% R6 ~6 U# Y5 K1 dJPanel jp8 = new JPanel();
JLabel jl8 = new JLabel("区域 ");
" G& x5 r8 o( x0 Mjp8.add(jl8);
/ a$ X1 J6 F5 \2 n, a. n0 E/ Ojp8.add(jtf8);
2 T) U. R* I% N% c) g' U. xjp00.add(jp8);
JPanel jp9 = new JPanel();
JLabel jl9 = new JLabel("公交站 ");
jp9.add(jl9);
. u8 i0 W5 l( v6 v7 |9 {jp9.add(jtf9);
jp00.add(jp9);
; W3 R1 J. e1 I6 Tjf.add(jp00);
# X) T2 {6 {5 I) `3 xJPanel jp01 = new JPanel();
jta10.setText("--用户使用手册-- \n1、查询：选择一个字段，如 EngName 在文本框中输入相应内容，点击查询\n2、增加：在各个文本框中输入相应内容后，点击增加。\n3、修改：先查询到你要的记录，在更改相应内容，点击修改。\n4、撤除：类似于修改操作");
jp01.add(jta10);
4 B4 C5 C5 h; y! `5 ~# f7 Ujf.add(jp01);
jf.setSize(700, 500);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
3 L: P- i# o! @2 m+ l+ _6 Y! _2 hjf.setVisible(true);

}

public static void main(String[] args) {
% D4 p" h0 S  F, z: _+ @% ?7 inew EmpManageSys();
3 D/ \+ P6 ~* S4 m7 A7 y- z6 R}
/ ]! d) ~3 t- R9 n: ?}

蕾蕾

//---------------------------------------------------------------------
& z5 N/ Z  {* ?) I, a! Y, J, D( VSQL工具类JdbcUtil：用于实现数据库连接和数据库关闭。上面程序用到了这个类
# Z! c. U- ]& V; E6 N% b$ gimport java.sql.*;
2 {8 Y2 F, X2 B% Epublic class JdbcUtil
& W* W/ O) e4 u- ~9 Q{
& j  C* S7 E2 }//load driver from file
% u8 x2 O4 `4 Q6 J5 t: H8 tstatic{
- M1 ^, c0 c1 |, @) R; Atry{
String driverName =
"oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
. k3 D; [$ v% C$ M, F8 N, Z* k}catch(Exception e){
e.printStackTrace();
& B* ~8 V% [2 o. j: p}
}
//establish connection
4 _( w" @* W9 V6 |! v6 T) Z2 }& b  z* \public static Connection getConnection(){
Connection con = null;
+ d; I6 A- r& `try{
4 i" o8 O: _/ z: W6 KString url =
"jdbcracle:thin192.168.0.26:1521:tarena";
5 @  E2 s! J9 V! n4 @! M7 _1 |* MString usr = "openlab";
String pwd = "open123";
con = DriverManager.getConnection(
url,usr,pwd);
}catch(Exception e){
e.printStackTrace();
; r* s4 B+ p+ y# _- ]7 [; u. I}
return con;
}
. h$ M3 H2 \- F* `; B& {6 J
$ u* n  Y: P7 T. o; K//close resultSet,statement and connection
public static void close(ResultSet rs,Statement stmt,Connection con){
% H+ I. `3 W& v. }7 ]. _try{
if(rs!=null) rs.close();
/ I$ l7 P+ g, V}catch(Exception ex){
ex.printStackTrace();
}
4 }0 R: {4 A4 n8 C9 @" j% i: Q  Gtry{
# k) k3 |6 M7 e' [0 r1 o% W6 {if(stmt!=null) stmt.close();
) J5 z( X5 z8 E}catch(Exception ex){
$ P; i& d1 E% x+ d* g0 c5 mex.printStackTrace();
}
try{
if(con!=null) con.close();
# B2 h) W9 V7 t( i. L}catch(Exception ex){
$ j; }0 a  s  f0 G' wex.printStackTrace();
}
9 H- U* V* ~/ T% }}
$ F4 e4 _" [* Y) q, q+ n}