《数据库应用》课程设计人事管理系统(java源代码)

《数据库应用》课程设计——人事管理系统（java源代码）


//用户登陆类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Land extends JFrame{
JFrame jf ;

JTextField textName=new JTextField();
JPasswordField textage=new JPasswordField();

JLabel label = new JLabel("员工管理系统");
JLabel labelName=new JLabel("用户名：");
JLabel labelage=new JLabel("密码：");


JButton buttonEnter=new JButton("登录");
JButton buttoncancel=new JButton("清空");

public Land(){
jf=this;
setTitle("登录");
Font f = new Font("新宋体",Font.PLAIN,12);
Container con = getContentPane();
con.setLayout(null);
label.setBounds(95,10,110,20);
label.setFont(new Font("新宋体",Font.PLAIN,14));
con.add(label);
labelName.setBounds(45,40,55,20);
labelName.setFont(f);
con.add(labelName);
textName.setBounds(95,40,120,20);
con.add(textName);

labelage.setBounds(45,70,45,20);
con.add(labelage);
labelage.setFont(f);
textage.setBounds(95,70,120,20);
con.add(textage);



buttonEnter.setBounds(90,110,60,20);
buttonEnter.setFont(f);
con.add(buttonEnter);

//登陆的鼠标监听

buttonEnter.addMouseListener(new MouseAdapter(){
public void mouseClicked(MouseEvent me){
if(textName.getText().equals("")){
new JOptionPane().showMessageDialog(null,"用户名不能为空!");
}
else if(textage.getText().equals("")){
new JOptionPane().showMessageDialog(null,"密码不能为空!");
}
else{
String sql="select * from UserInformation where User_Name = '" + textName.getText() + "' and Password = '" + textage.getText()+ "'";
System.out.println(sql);
Judge(sql);
}
}
});

buttoncancel.setBounds(155,110,60,20);
buttoncancel.setFont(f);
con.add(buttoncancel);

//清空按钮的鼠标监听方法
buttoncancel.addMouseListener(new MouseAdapter(){
public void mouseClicked(MouseEvent me){
textName.setText("");
textage.setText("");
}
});

setResizable(false);

Image img=Toolkit.getDefaultToolkit().getImage("image\\main.gif");
setIconImage(img);
Toolkit t = Toolkit.getDefaultToolkit();
int w = t.getScreenSize().width;
int h = t.getScreenSize().height;
setBounds(w/2-150,h/2-90,300,180);
setVisible(true);
}

private void Judge(String sqlString) {

if (Database.joinDB()) {
if (Database.query(sqlString))
try{
if(Database.rs.isBeforeFirst()) {
System.out.println("密码正确");
jf.setVisible(false);

https://www.wendangku.net/doc/a03760022.html,.close();
new Main();
}
else {
System.out.println("错误");
new JOptionPane().showMessageDialog(null,"用户

名或密码错误!","",JOptionPane.ERROR_MESSAGE);
}
}catch(Exception ex) {
System.out.println(ex.getMessage());
}
}
else{
System.out.println("连接数据库不成功!!!");
}
}

public static void main(String args[]){
new Land();
}
}


//主函数类，可以独立运行

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Main extends JFrame implements Runnable{

Thread t=new Thread(this);
JDesktopPane deskpane = new JDesktopPane();
JPanel p = new JPanel();
Label lp1=new Label("欢 迎 使 用 员 工 管 理 系 统 !");

ImageIcon icon1=new ImageIcon("imagetjsc.gif");
ImageIcon icon2=new ImageIcon("imagecxdl.gif");
ImageIcon icon3=new ImageIcon("imagexgmm.gif");
ImageIcon icon4=new ImageIcon("imagetcxt.gif");
ImageIcon icon5=new ImageIcon("imagejj.gif");
ImageIcon icon6=new ImageIcon("imagehelp.gif");
ImageIcon icon7=new ImageIcon("imagecx.gif");
ImageIcon icon8=new ImageIcon("imagegl.gif");
ImageIcon icon9=new ImageIcon("imagext.gif");
ImageIcon icon10=new ImageIcon("imagexxgl.gif");
ImageIcon icon11=new ImageIcon("imagexxcx.gif");
ImageIcon icon12=new ImageIcon("imagebz.gif");
ImageIcon icon13=new ImageIcon("imagegy.gif");
ImageIcon icon14=new ImageIcon("imageglxx.gif");
ImageIcon icon15=new ImageIcon("imagecxxx.gif");
//完--------------------------------------------------------------------------------

public Main(){
setTitle("员工管理系统");
Container con = getContentPane();
con.setLayout(new BorderLayout());
con.add(deskpane,BorderLayout.CENTER);

Font f =new Font("新宋体",Font.PLAIN,12);

JMenuBar mb = new JMenuBar();

JMenu systemM = new JMenu("系统管理");
systemM.setFont(f);
JMenu manageM = new JMenu("信息管理");
manageM.setFont(f);
JMenu employeeMM = new JMenu("员工信息管理");
employeeMM.setFont(f);
JMenu selectM = new JMenu("信息查询");
selectM.setFont(f);
JMenu employeeSM =new JMenu("员工信息查询");
employeeSM.setFont(f);

JMenu helpM = new JMenu("帮助");
helpM.setFont(f);
JMenu aboutM=new JMenu("关于");
aboutM.setFont(f);

JMenuItem password = new JMenuItem("密码修改");
password.setFont(f);
JMenuItem land = new JMenuItem("重新登陆");
land.setFont(f);
JMenuItem addDelete = new JMenuItem("添加/删除用户");
addDelete.setFont(f);
JMenuItem exit = new JMenuItem("退出系统");
exit.setFont(f);
systemM.add(password);
systemM.add(land);
systemM.add(addDelete);
systemM.add(exit);


//为系统管理菜单加事件
password.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("AmendPassword");
deskpane.add(new AmendPassword());
}
});

land.addActionL

istener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Land");
setVisible(false);
new Land();
}
});

addDelete.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
deskpane.add(new AddDeleteUser());
}
});

exit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
//new JOptionPane().showMessageDialog(
setVisible(false);
}
});

JMenuItem departmentM = new JMenuItem("部门信息管理");
departmentM.setFont(f);
JMenuItem employeeM = new JMenuItem("基本信息管理");
employeeM.setFont(f);
JMenuItem trainM = new JMenuItem("培训信息管理");
trainM.setFont(f);
JMenuItem encouragementPunishM = new JMenuItem("奖罚信息管理");
encouragementPunishM.setFont(f);
JMenuItem wageM =new JMenuItem("薪资信息管理");
wageM.setFont(f);
employeeMM.add(trainM);
employeeMM.add(employeeM);
employeeMM.add(encouragementPunishM);
employeeMM.add(wageM);
manageM.add(employeeMM);
manageM.add(departmentM);

//为管理菜单加事件
departmentM.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Departmentmanage");
deskpane.add(new Departmentmanage());
}
});

employeeM.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Employeemanage");
deskpane.add(new Employeemanage());
}
});

trainM.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Trainmanage");
deskpane.add(new Trainmanage());
}
});

encouragementPunishM.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("EncouragementPunish");
deskpane.add(new EncouragementPunish());
}
});

wageM.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("WageManage");
deskpane.add(new WageManage());
}
});

JMenuItem departmentS = new JMenuItem("部门信息查询");
departmentS.setFont(f);
JMenuItem employeeS = new JMenuItem("基本信息查询");
employeeS.setFont(f);
JMenuItem trainS = new JMenuItem("培训信息查询");
trainS.setFont(f);
JMenuItem encouragementPunishS = new JMenuItem("奖罚信息查询");
encouragementPunishS.setFont(f);
JMenuItem wageS =new JMenuItem("薪资信息查询");
wageS.setFont(f);
employeeSM.add(trainS);
employeeSM.add(employeeS);
employeeSM.add(encouragementP

unishS);
employeeSM.add(wageS);
selectM.add(employeeSM);
selectM.add(departmentS);


//为查询菜单加事件

departmentS.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("DIQ");
deskpane.add(new DIQ());
}
});


employeeS.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("BIQ");
deskpane.add(new BIQ());
}
});

trainS.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("TIQ");
deskpane.add(new TIQ());
}
});

encouragementPunishS.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("EPIQ");
deskpane.add(new EPIQ());
}
});


wageS.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("SIQ");
deskpane.add(new SIQ());
}
});




JMenuItem help = new JMenuItem("帮助");
help.setFont(f);
JMenuItem about =new JMenuItem("关于");
about.setFont(f);
helpM.add(help);
aboutM.add(about);

//为帮助菜单加事件
about.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
deskpane.add(new About());
}
});

mb.add(systemM);
mb.add(manageM);
mb.add(selectM);
mb.add(helpM);
mb.add(aboutM);
setJMenuBar(mb);


Image img=Toolkit.getDefaultToolkit().getImage("imagemain.gif");
setIconImage(img);

systemM.setIcon(icon9);
manageM.setIcon(icon8);
selectM.setIcon(icon7);
helpM.setIcon(icon6);
addDelete.setIcon(icon1);
land.setIcon(icon2);
password.setIcon(icon3);
exit.setIcon(icon4);
employeeMM.setIcon(icon5);
employeeSM.setIcon(icon5);
departmentM.setIcon(icon10);
departmentS.setIcon(icon11);

help.setIcon(icon6);
aboutM.setIcon(icon13);
about.setIcon(icon13);

employeeM.setIcon(icon14);
trainM.setIcon(icon14);
encouragementPunishM.setIcon(icon14);
wageM.setIcon(icon14);

employeeS.setIcon(icon15);
trainS.setIcon(icon15);
encouragementPunishS.setIcon(icon15);
wageS.setIcon(icon15);


JToolBar jToolBar1 = new JToolBar();
jToolBar1.setLayout(new GridLayout(9,1));
JButton jButton1 = new JButton();
jButton1.setToolTipText("员工基本信息管理");
JButton jButton2 = new JButton();
jButton2.setToolTipText("员工基本信息查询");
JButton jButton3 = new JButton();
jButton3.setToolTipText("修改密码");
JButton jButton5 = new JButton();
jButton5.setToolTipText("计算器");
JButton jButton6 = new JButton();
jButton6.setToolTipText("退出系统");

jToolBar1.setMaximumSize(new java.awt.Dimension(600, 50));
jToolBar1.setMinimumSize(new java.awt

.Dimension(600, 50));

//添加工具栏中按钮的方法

jButton1.setIcon(new ImageIcon("image1.png"));
jButton1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Employeemanage");
deskpane.add(new Employeemanage());
}
});
jToolBar1.add(jButton1);

jButton2.setIcon(new ImageIcon("image2.png"));
jButton2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
deskpane.add(new BIQ());
}
});
jToolBar1.add(jButton2);

jButton3.setIcon(new ImageIcon("image3.png"));
jButton3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
deskpane.add(new AmendPassword());
}
});
jToolBar1.add(jButton3);

jButton5.setIcon(new ImageIcon("image5.png"));
jButton5.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("Calculator");
deskpane.add(new Calculator());
}
});
jToolBar1.add(jButton5);


jButton6.setIcon(new javax.swing.ImageIcon("image6.png"));
jButton6.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.exit(0);
}
});
jToolBar1.add(jButton6);




jToolBar1.setBounds(0, 0, 30, 600);
jToolBar1.setEnabled(false);
con.add(jToolBar1,BorderLayout.WEST);

p.setLayout(new BorderLayout());
p.add(lp1,BorderLayout.EAST);
t.start();

con.add(p,BorderLayout.SOUTH);

Toolkit t = Toolkit.getDefaultToolkit();
int width = t.getScreenSize().width - 200;
int height = t.getScreenSize().height - 100;
setSize(width,height);
setLocation(150,100);
setVisible(true);
setResizable(false);
}


//线程的方法
public void run(){
System.out.println("线程启动了!");
Toolkit t = Toolkit.getDefaultToolkit();
int x=t.getScreenSize().width;
System.out.println("x=" + x);


lp1.setForeground(Color.red);
while(true)
{
if(x<-600){
x=t.getScreenSize().width;
}
lp1.setBounds(x,0,700,20);
x-=10;
try{Thread.sleep(100);}catch(Exception e){}

}
}

public static void main(String[] args){
new Main();
}
}


//数据库联接类
package classsource;

import java.sql.*;

public class Database {
public static Connection cn;
public static Statement st;
public static ResultSet rs;

p

ublic static boolean joinDB() {
boolean joinFlag;
try {
joinFlag = true;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn = DriverManager.getConnection("jdbc:odbc:EmployeeInformationMS","sa","");

cn.setCatalog("EmployeeInformationMS");
System.out.println("数据库连接成功");
st = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
return joinFlag;

} catch (SQLException sqlEx) {
System.out.println(sqlEx.getMessage());

joinFlag = false;
return joinFlag;

} catch (ClassNotFoundException notfoundEX) {
System.out.println(notfoundEX.getMessage());

joinFlag = false;
return joinFlag;
}
}

public static boolean executeSQL(String sqlString) {
boolean executeFlag;
try {
st.execute(sqlString);
executeFlag = true;
} catch (Exception e) {
executeFlag = false;
System.out.println("sql exception:" + e.getMessage());
}
return executeFlag;
}


public static boolean query(String sqlString) {

try {
rs = null;
//System.out.println(sqlString);
rs = st.executeQuery(sqlString);
} catch (Exception Ex) {
System.out.println("sql exception:" + Ex);
return false;
}
return true;
}
}



//添加删除用户类


package classsource;

import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.sql.*;

public class AddDeleteUser extends javax.swing.JInternalFrame {

private JButton butACancel,butDCancel,butDelete,butOk;
private JComboBox cbUserName;
private JLabel jLabel1,jLabel2,jLabel3,jLabel4,jLabel5;
private JPasswordField pas1,pas2,pas3;
private JTextField txtname;

public AddDeleteUser() {
initComponents();
this.setVisible(true);
this.setClosable(true);
this.setSize(268,350);

}

private void initComponents() {

jLabel1 = new JLabel();
jLabel2 = new JLabel();
jLabel3 = new JLabel();
txtname = new JTextField();
pas1 = new JPasswordField();
pas2 = new JPasswordField();
butOk = new JButton();
butACancel = new JButton();
jLabel4 = new JLabel();
cbUserName = new JComboBox();
jLabel5 = new JLabel();
pas3 = new JPasswordField();
butDelete = new JButton();
butDCancel = new JButton();

getContentPane().setLayout(null);

jLabel1.setText("新用户名:");
getContentPane().add(jLabel1);
jLabel1.setBounds(30, 30, 70, 20);

jLabel2.setText("输入密码:");

getContentPane().add(jLabel2);
jLabel2.setBounds(30, 60, 70, 18);

jLabel3.setText("确认密码:");
getContentPane().add(jLabel3);
jLabel3.setBounds(30, 90, 60, 18);

getContentPane().add(txtname);
txtname.setBounds(100, 30, 130, 24);

getContentPane().add(pas1);
pas1.setBounds(100, 60, 130, 24);

getContentPane().add(pas2);
pas2.setBounds(100, 90, 130, 24);

butOk.setText("添加");

getContentPane().add(butOk);
butOk.setBounds(80, 130, 70, 27);

butACancel.setText("清空");
getContentPane().add(butACancel);
butACancel.setBounds(160, 130, 70, 27);

jLabel4.setText("已有用户名:");
getContentPane().add(jLabel4);
jLabel4.setBounds(30, 180, 80, 18);

getContentPane().add(cbUserName);
cbUserName.setBounds(100, 180, 130, 24);

jLabel5.setText("密码:");
getContentPane().add(jLabel5);
jLabel5.setBounds(30, 210, 60, 18);

getContentPane().add(pas3);
pas3.setBounds(100, 216, 130, 24);

butDelete.setText("删除");
getContentPane().add(butDelete);
butDelete.setBounds(79, 260, 70, 27);

butDCancel.setText("清空");
getContentPane().add(butDCancel);
butDCancel.setBounds(160, 260, 70, 27);


//将所有用用户名读出来
Database.joinDB();
String sql="select * from UserInformation";
try{
if(Database.query(sql)){
while(Database.rs.next()){
String name=Database.rs.getString("User_Name");
cbUserName.addItem(name);
}
}
}
catch(Exception e){}

//为添加和取消按钮加事件-----------------------------------------
butOk.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
if(txtname.getText().equals("")){
new JOptionPane().showMessageDialog(null,"用户名不能为空!");
}
else if(pas1.getText().equals("")){
new JOptionPane().showMessageDialog(null,"密码不能为空!");
}
else if(pas1.getText().equals(pas2.getText())){
String sql="insert UserInformation values('"+ txtname.getText() +"','"+ pas1.getText() +"','B')";
try{
if(Database.executeSQL(sql)){
new JOptionPane().showMessageDialog(null,"添加成功！");
cbUserName.addItem(txtname.getText());
}
}
catch(Exception ea){}
}
}
});

butACancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
txtname.setText("");
pas1.setText("");
pas2.setText("");
}
});

//为删除和取消按钮加事件---------------------------------------
butDelete.addActionListen

er(new ActionListener(){
public void actionPerformed(ActionEvent e){
String name="" + cbUserName.getSelectedItem();
String sql="select * from UserInformation where User_Name='"+ name +"'";
try{
if(Database.query(sql)){
Database.rs.next();
String pas=pas3.getText();
String password=Database.rs.getString("Password");
System.out.println(password);
if(pas.equals(password)){
String sdelete="delete from UserInformation where User_Name='"+ name +"'";
if(Database.executeSQL(sdelete)){
new JOptionPane().showMessageDialog(null,"删除成功！");
pas3.setText("");
cbUserName.removeAllItems();
String sql1="select * from UserInformation";
if(Database.query(sql1)){
while(Database.rs.next()){
String name1=Database.rs.getString("User_Name");
cbUserName.addItem(name1);
}
}
}
}
else{
new JOptionPane().showMessageDialog(null,"密码不正确！");
}
}
}
catch(Exception el){
System.out.println(el);
}
}
});

butDCancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
pas3.setText("");
}
});

}
}


//修改密码类


package classsource;


import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;


public class AmendPassword extends JInternalFrame
{
JLabel lbe1=new JLabel("修改密码");
JPanel p=new JPanel();
public AmendPassword()
{
setTitle("修改密码");
p.add(lbe1);
AmendPanel panel=new AmendPanel();
Container contentPane=getContentPane();
contentPane.add(p,"North");
contentPane.add(panel,"Center");

setBounds(100, 100, 280, 260);
this.setClosable(true);
setVisible(true);
}

}

class AmendPanel extends JPanel
{
JButton b1,b2;
JLabel lbe2,lbe3,lbe4,lbe5;
JPasswordField pas1,pas2,pas3;
JComboBox tf;
public AmendPanel()
{
lbe2=new JLabel("用户名:");
lbe3=new JLabel("输入旧密码:");
lbe4=new JLabel("输入新密码:");
lbe5=new JLabel("确定新密码:");
tf=new JComboBox();
pas1=new JPasswordField();
pas2=new JPasswordField();
pas3=new JPasswordField();
b1=new JButton("确定");
b2=new JButton("清空");

add(lbe2);
lbe2.setBounds(16,10,90,25);
this.add(tf);
tf.setBounds(100,10,120,25);
add(lbe3);
lbe

3.setBounds(16,45,90,25);
add(pas1);
pas1.setBounds(100,45,120,25);
add(lbe4);
lbe4.setBounds(16,80,80,25);
add(pas2);
pas2.setBounds(100,80,120,25);
add(lbe5);
lbe5.setBounds(16,115,80,25);
add(pas3);
pas3.setBounds(100,115,120,25);
add(b1);
b1.setBounds(100,160,60,30);
add(b2);
b2.setBounds(160,160,60,30);
setLayout(null);

//将所有用用户名读出来
Database.joinDB();
String sql="select * from UserInformation";
try{
if(Database.query(sql)){
while(Database.rs.next()){
String name=Database.rs.getString("User_Name");
tf.addItem(name);
}
}
}
catch(Exception e){}

//为确定取消按钮加事件
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){

String name="" + tf.getSelectedItem();
System.out.println(name);
String sql="select * from UserInformation where User_Name='"+ name +"'";
System.out.println(sql);
try{
if(Database.query(sql)){
Database.rs.next();
String ps1=pas1.getText();
String password=Database.rs.getString("Password");
if(ps1.equals(password)){
if(pas2.getText().equals(pas3.getText())){
String supdate="update UserInformation set Password='"+ pas3.getText()+"' where User_Name='"+ name +"'";
Database.executeSQL(supdate);
new JOptionPane().showMessageDialog(null,"密码更改成功！");
}
else{
new JOptionPane().showMessageDialog(null,"两次密码不同！");
}
}
else{
new JOptionPane().showMessageDialog(null,"旧密码不正确！");
}
}
}
catch(Exception el){
System.out.println(el);
}
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
pas1.setText("");
pas2.setText("");
pas3.setText("");
}
});
}
}


//关于类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

public class About extends JInternalFrame {
JLabel label = new JLabel("运行环境：Windows");
JLabel labe2 = new JLabel("开发语言：JAVA");
JLabel labe3 = new JLabel("数据库类型：SqlServer2000");

public About(){
setTitle("关于");
Container con=getContentPane();
con.setLayout(new GridLayout(4,1));
con.add(label);
con.add(labe2);
con.add(labe3);

con.setBackground(Color.white);

setResizable(false);
setSize(380,220);
setVisible(true);
setClosable(true);
}
}

//员工信息查询类
package classsource;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.JScrollPane.*;
import java.sql.*;

public class BIQ extends JInternalFrame{

JLabel lbl1=new JLabel("基 本 信 息 查 询");
JLabel lbl2=new JLabel("员工编号：");
JLabel lbl3=new JLabel("员工姓名：");
JTextField btxtid=new JTextField(10);
JTextField btxtname=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;

String columns[] = {"员工编号","员工姓名"," 性别 ","出生日期","婚姻状况","政治面貌"," 学历 ","进入公司时间","转正时间"," 部门 "," 职务 ","员工状态"," 备注 "};
public BIQ(){
setTitle("基 本 信 息 查 询");

dtm = new DefaultTableModel();
table = new JTable(dtm);


JScrollPane sl = new JScrollPane();
sl.getViewport().add(table);
dtm.setColumnCount(5);
dtm.setColumnIdentifiers(columns);

getContentPane().setLayout(null);
lbl1.setBounds(240,10,300,30);
lbl1.setFont(new Font("宋体",Font.BOLD,24));
getContentPane().add(lbl1);

Font f=new Font("宋体",Font.PLAIN,12);
lbl2.setBounds(10,60,80,25);
lbl2.setFont(f);
getContentPane().add(lbl2);
btxtid.setBounds(80,60,80,23);
btxtid.setFont(f);
getContentPane().add(btxtid);
lbl3.setBounds(10,90,80,25);
lbl3.setFont(f);
getContentPane().add(lbl3);
btxtname.setBounds(80,90,80,23);
btxtname.setFont(f);
getContentPane().add(btxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);


sl.setBounds(180,60,500,370);
getContentPane().add(sl);

//设置边框
btxtid.setBorder(BorderFactory.createLineBorder(Color.black));
btxtname.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));

//----连接数据库--------------------------------------------------------------------------
Database.joinDB();
String sql="select * from EmployeeInformation";
if(Database.query(sql)){
System.out.println(sql);
try{
while(Database.rs.next()){
String eNumber=(""+Database.rs.getInt("E_Number"));
System.out.println(eNumber);
String eName=Database.rs.getString("E_Name");
System.out.println(eName);
String eSex=Database.rs.getString("E_Sex");
System.out.println(eSex);
String eBornDate=Database.rs.getString("E_BornDate");
System.out.println(eBornDate);
String eMarriage=Database.rs.getString("E_Marr

iage");
System.out.println(eMarriage);
String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
System.out.println(ePoliticsVisage);
String eSchoolAge=Database.rs.getString("E_SchoolAge");
System.out.println(eSchoolAge);
String eEnterDate=Database.rs.getString("E_EnterDate");
System.out.println(eEnterDate);
String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
System.out.println(eInDueFormDate);
String eDepartment=Database.rs.getString("E_Department");
System.out.println(eDepartment);
String eHeadship=Database.rs.getString("E_Headship");
System.out.println(eHeadship);
String eEstate=Database.rs.getString("E_Estate");
System.out.println(eEstate);
String eRemark=Database.rs.getString("E_Remark");
System.out.println(eRemark);

Vector v=new Vector();
v.add(eNumber);
v.add(eName);
v.add(eSex);
v.add(eBornDate);
v.add(eMarriage);
v.add(ePoliticsVisage);
v.add(eSchoolAge);
v.add(eEnterDate);
v.add(eInDueFormDate);
v.add(eDepartment);
v.add(eHeadship);
v.add(eEstate);
v.add(eRemark);
dtm.addRow(v);
}

}
catch(Exception eBIQ){
System.out.println("初始化数据失败！");
}

}
//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent eBIQ){
System.out.println("按钮事件");
String esql;

int rc=dtm.getRowCount();
for(int i=0;idtm.removeRow(0);
}
if(btxtid.getText().equals("")&&btxtname.getText().equals("")){
esql="select * from EmployeeInformation";
}
else if(btxtname.getText().equals("")){
esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"'";
}
else{
esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"' or E_Name like '%"+ btxtname.getText() +"%'";
}
System.out.println(esql);
if(Database.query(esql)){
try{
while(Database.rs.next()){
String eNumber=(""+Database.rs.getInt("E_Number"));
System.out.println(eNumber);
String eName=Database.rs.getString("E_Name");
System.out.println(eName);
String eSex=Database.rs.getString("E_Sex");
System.out.println(eSex);
String eBornDate=Database.rs.getString("E_BornDate");
System.out.println(eBornDate);
String eMarriage=Database.rs.getString("E_Marriage");
System.out.println(eMarriage);
String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
System.out.println(ePoliticsVisage);
String eSchoolAge=Database.rs.getString("E_Sch

oolAge");
System.out.println(eSchoolAge);
String eEnterDate=Database.rs.getString("E_EnterDate");
System.out.println(eEnterDate);
String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
System.out.println(eInDueFormDate);
String eDepartment=Database.rs.getString("E_Department");
System.out.println(eDepartment);
String eHeadship=Database.rs.getString("E_Headship");
System.out.println(eHeadship);
String eEstate=Database.rs.getString("E_Estate");
System.out.println(eEstate);
String eRemark=Database.rs.getString("E_Remark");
System.out.println(eRemark);

Vector v=new Vector();
v.add(eNumber);
v.add(eName);
v.add(eSex);
v.add(eBornDate);
v.add(eMarriage);
v.add(ePoliticsVisage);
v.add(eSchoolAge);
v.add(eEnterDate);
v.add(eInDueFormDate);
v.add(eDepartment);
v.add(eHeadship);
v.add(eEstate);
v.add(eRemark);
dtm.addRow(v);
}
}
catch(Exception eB){
}
}
}
});

setSize(700,480);
this.setClosable(true);
setVisible(true);
}
}



package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;

public class DIQ extends JInternalFrame{

JLabel lb1=new JLabel("部 门 信 息 查 询");
JLabel lb2=new JLabel("部门编号：");
JLabel lb3=new JLabel("部门名称：");
JTextField setxtid=new JTextField(10);
JTextField setxtname=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;
String columns[] = {"部门编号","部门名称","部门人数"};
public DIQ(){
setTitle("部 门 信 息 查 询");

dtm = new DefaultTableModel();
table = new JTable(dtm);

JScrollPane sl = new JScrollPane(table);


dtm.setColumnCount(3);
dtm.setColumnIdentifiers(columns);

getContentPane().setLayout(null);
lb1.setBounds(200,10,300,30);
lb1.setFont(new Font("宋体",Font.BOLD,24));
getContentPane().add(lb1);

Font f=new Font("宋体",Font.PLAIN,12);
lb2.setBounds(10,60,80,25);
lb2.setFont(f);
getContentPane().add(lb2);
setxtid.setBounds(80,60,80,23);
setxtid.setFont(f);
getContentPane().add(setxtid);
lb3.setBounds(10,90,80,25);
lb3.setFont(f);
getContentPane().add(lb3);
setxtname.setBounds(80,90,80,23);
setxtname.setFont(f);
getContentPane().add(setxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

//设置边框
setxtid.setBorder(BorderFactory.createLineBorder(Color.black));
setxtn

ame.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//为表格初使化数据
String csf="select * from DepartmentInformation";
if(Database.query(csf)){
try{
while(Database.rs.next()){
String num = ("" + Database.rs.getInt("D_Number"));
System.out.println(num);
String name = Database.rs.getString("D_Name");
System.out.println(name);
String count = Database.rs.getString("D_Count");
System.out.println(count);

Vector v=new Vector();
v.add(num);
v.add(name);
v.add(count);
dtm.addRow(v);

}
}
catch(Exception ecsf){
System.out.println("初使化表格数据出错!");}
}

//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String sql;
int rc=dtm.getRowCount();
//System.out.println(dtm.getRowCount());
for(int i=0;idtm.removeRow(0);
}
if(setxtid.getText().equals("")&&setxtname.getText().equals("")){
sql="select * from DepartmentInformation";
}
else if(setxtname.getText().equals("")){
sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"'";
}
else{
sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"' or D_Name like '%"+ setxtname.getText() +"%'";
}

System.out.println(sql);
if(Database.query(sql)){
try{
while(Database.rs.next()){
String num = ("" + Database.rs.getInt("D_Number"));
System.out.println(num);
String name = Database.rs.getString("D_Name");

System.out.println(name);
String count = Database.rs.getString("D_Count");
System.out.println(count);

Vector v=new Vector();
v.add(num);
v.add(name);
v.add(count);
dtm.addRow(v);

}
}
catch(Exception ee){}
}
}
});

setSize(630,400);
this.setClosable(true);
setVisible(true);
}
}

//奖惩查询类

package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;

public class EPIQ extends JInternalFrame{

JLabel lb1=new JLabel("奖 惩 信 息 查 询");
JLabel lb2=new JLabel("员工编号:");
JLabel lb3=new JLabel

("员工姓名：");
JTextField txt1=new JTextField(10);
JTextField txt2=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;
String columns[] = {"奖惩人编号","奖惩人姓名：","奖惩时间","奖惩地点","奖惩原因","备注"};
public EPIQ(){
setTitle("奖惩信息查询");

dtm = new DefaultTableModel();
table = new JTable(dtm);
JScrollPane sl = new JScrollPane(table);

dtm.setColumnCount(6);
dtm.setColumnIdentifiers(columns);

getContentPane().setLayout(null);
lb1.setBounds(200,10,300,30);
lb1.setFont(new Font("宋体",Font.BOLD,24));
getContentPane().add(lb1);

Font f=new Font("宋体",Font.PLAIN,12);
lb2.setBounds(10,60,80,25);
lb2.setFont(f);
getContentPane().add(lb2);
txt1.setBounds(80,60,80,23);
txt1.setFont(f);
getContentPane().add(txt1);
lb3.setBounds(10,90,80,25);
lb3.setFont(f);
getContentPane().add(lb3);
txt2.setBounds(80,90,80,23);
txt2.setFont(f);
getContentPane().add(txt2);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);

//设置边框
txt1.setBorder(BorderFactory.createLineBorder(Color.black));
txt2.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//初始化表数据
String scEPIQ="select * from EncouragementPunishInformation";

if(Database.query(scEPIQ)){
System.out.println(scEPIQ);
try{
while(Database.rs.next()){
String number = ("" + Database.rs.getInt("EP_Number"));
String name = Database.rs.getString("EP_Name");
System.out.println(name);
String date = Database.rs.getString("EP_Date");
System.out.println(date);
String address = Database.rs.getString("EP_Address");
System.out.println(address);
String causation = Database.rs.getString("EP_Causation");
System.out.println(causation);
String remark = Database.rs.getString("EP_Remark");
System.out.println(remark);


Vector v = new Vector();
v.add(number);
v.add(name);
v.add(date);
v.add(address);
v.add(causation);
v.add(remark);

dtm.addRow(v);
}
}
catch(Exception eEPIQ){}

}


//为查询按钮加事件--------------------------------------------------------
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("查询按钮事件执行");
String sEPIQ;
int rc=dtm.getRowCount();

//System.out.println(dtm.getRowCount());
for(int i=0;idtm.removeRow(0);
}

if(txt1.getText().equals("")&&txt2.getText().equals("")){
sEPIQ="select * from EncouragementPunishInformation";

}
else if(txt2.getText().equals("")){
sEPIQ="select * from EncouragementPunishInformation where EP_Number = '" + txt1.getText() +"'";
}
else{
sEPIQ="select * from EncouragementPunishInformation where EP_Number = '" + txt1.getText() +"' or EP_Name like '%"+ txt2.getText() +"%'";
}
System.out.println(sEPIQ);

if(Database.query(sEPIQ)){
System.out.println(sEPIQ);
try{
while(Database.rs.next()){
String number = ("" + Database.rs.getInt("EP_Number"));
String name = Database.rs.getString("EP_Name");
System.out.println(name);
String date = Database.rs.getString("EP_Date");
System.out.println(date);
String address = Database.rs.getString("EP_Address");
System.out.println(address);
String causation = Database.rs.getString("EP_Causation");
System.out.println(causation);
String remark = Database.rs.getString("EP_Remark");
System.out.println(remark);

Vector v = new Vector();
v.add(number);
v.add(name);
v.add(date);
v.add(address);
v.add(causation);
v.add(remark);

dtm.addRow(v);
}
}
catch(Exception eEPIQ){}

}
}
});

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

setSize(630,400);
this.setClosable(true);
setVisible(true);
}
}

//薪酬查询类

package classsource;

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;

public class SIQ extends JInternalFrame{

JLabel lbl4=new JLabel("薪 资 信 息 查 询");
JLabel lbl5=new JLabel("员工编号：");
JLabel lbl6=new JLabel("员工姓名：");
JTextField stxtid=new JTextField(10);
JTextField stxtname=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;
String columns[] = {"员工编号","员工姓名","基本工资","福利","奖金","计算方法","实发工资"};
public SIQ(){
setTitle("薪 资 信 息 查 询");

dtm = new DefaultTableModel();
table = new JTable(dtm);
table.setPreferredScrollableViewportSize(new Dimension(400, 80));
JScrollPane sl = new JScrollPane(table);

dtm.setColumnCount(7);
dtm.setColumnIdentifiers(columns);

getContentPane().setLayout(null);
lbl4.setBounds(200,10,300,30);
lbl4.setFont(new Font("

宋体",Font.BOLD,24));
getContentPane().add(lbl4);

Font f=new Font("宋体",Font.PLAIN,12);
lbl5.setBounds(10,60,80,25);
lbl5.setFont(f);
getContentPane().add(lbl5);
stxtid.setBounds(80,60,80,23);
stxtid.setFont(f);
getContentPane().add(stxtid);
lbl6.setBounds(10,90,80,25);
lbl6.setFont(f);
getContentPane().add(lbl6);
stxtname.setBounds(80,90,80,23);
stxtname.setFont(f);
getContentPane().add(stxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);

//设置边框
stxtid.setBorder(BorderFactory.createLineBorder(Color.black));
stxtname.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

//初始化表格数据
String sql;

sql="select * from WageInformation";

if(Database.query(sql)){
try{
System.out.println(sql);
while(Database.rs.next()){
String number =("" + Database.rs.getInt("W_Number"));
String name = Database.rs.getString("W_Name");
String basicwage = Database.rs.getString("W_BasicWage");
String boon = Database.rs.getString("W_Boon");
String bonus = Database.rs.getString("W_Bonus");
String countmethod = Database.rs.getString("W_CountMethod");
String factwage = Database.rs.getString("W_FactWage");

Vector v =new Vector();
v.add(number);
v.add(name);
v.add(basicwage);
v.add(boon);
v.add(bonus);
v.add(countmethod);
v.add(factwage);

dtm.addRow(v);
}
}
catch(Exception ex){}
}

//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String sql;
int rc=dtm.getRowCount();
//System.out.println(dtm.getRowCount());
for(int i=0;idtm.removeRow(0);
}

if(stxtid.getText().equals("")&&stxtname.getText().equals("")){
sql="select * from WageInformation";
}
else if(stxtname.getText().equals("")){
sql="select * from WageInformation where W_Number = '"+ stxtid.getText() +"'";
}
else{
sql="select * from WageInformation where W_Number = '"+ stxtid.getText() +"' or W_Name like '%"+ stxtname.getText()+"%'";
}

if(Database.query(sql)){
try{
System.out.println(sql);
while(Database.rs.next()){
String num

ber =("" + Database.rs.getInt("W_Number"));
String name = Database.rs.getString("W_Name");
String basicwage = Database.rs.getString("W_BasicWage");
String boon = Database.rs.getString("W_Boon");
String bonus = Database.rs.getString("W_Bonus");
String countmethod = Database.rs.getString("W_CountMethod");
String factwage = Database.rs.getString("W_FactWage");

Vector v =new Vector();
v.add(number);
v.add(name);
v.add(basicwage);
v.add(boon);
v.add(bonus);
v.add(countmethod);
v.add(factwage);

dtm.addRow(v);
}
}
catch(Exception ex){}
}
}

});

sl.setBounds(180,60,425,290);
getContentPane().add(sl);

setSize(630,450);
this.setClosable(true);
setVisible(true);
}
}


//培训查询类
package classsource;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.awt.event.*;
import java.sql.*;

public class TIQ extends JInternalFrame{

JLabel lb1=new JLabel("培 训 信 息 查 询");
JLabel lb2=new JLabel("培训编号:");
JLabel lb3=new JLabel("员工姓名:");
JTextField ttxtid=new JTextField(10);
JTextField ttxtname=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;
String columns[] = {"培训编号","培训内容","员工姓名","培训天数","培训费用"};
public TIQ(){
setTitle("培 训 信 息 查 询");

dtm=new DefaultTableModel();
table = new JTable(dtm);
JScrollPane s1=new JScrollPane(table);

dtm.setColumnCount(5);
dtm.setColumnIdentifiers(columns);

getContentPane().setLayout(null);
lb1.setBounds(200,10,300,30);
lb1.setFont(new Font("宋体",Font.BOLD,24));
getContentPane().add(lb1);

Font f=new Font("宋体",Font.PLAIN,12);
lb2.setBounds(10,60,80,25);
lb2.setFont(f);
getContentPane().add(lb2);
ttxtid.setBounds(80,60,80,23);
ttxtid.setFont(f);
getContentPane().add(ttxtid);
lb3.setBounds(10,90,80,25);
lb3.setFont(f);
getContentPane().add(lb3);
ttxtname.setBounds(80,90,80,23);
ttxtname.setFont(f);
getContentPane().add(ttxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);

s1.setBounds(180,60,425,290);
getContentPane().add(s1);

//设置边框
ttxtid.setBorder(BorderFactory.createLineBorder(Color.black));
ttxtname.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
s1.setBorder(BorderFactory.createLineBorder(Color.black));

//连接数据库
Database.joinDB();

String Tim="select * from Trai

nInformation";
if(Database.query(Tim)){
System.out.println(Tim);
try{
while(Database.rs.next()){
String number=(""+Database.rs.getString("T_Number"));
System.out.println(number);
String Content=Database.rs.getString("T_Content");
System.out.println(Content);
String name=Database.rs.getString("T_Name");
System.out.println(name);
String date=Database.rs.getString("T_Date");
System.out.println(date);
String Money=Database.rs.getString("T_Money");
System.out.println(Money);

Vector v=new Vector();
v.add(number);
v.add(Content);
v.add(name);
v.add(date);
v.add(Money);

dtm.addRow(v);


}
}
catch(Exception eTIQ){
System.out.println("初始化表格失败！");
}
}
//为查询按钮加事件
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.out.println("查询按钮加事件");
String STIQ;
int rc=dtm.getRowCount();
for(int i=0;idtm.removeRow(0);
}

if(ttxtid.getText().equals("")&&ttxtname.getText().equals("")){
STIQ="select * from TrainInformation";
}
else if(ttxtname.getText().equals("")){
STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"'";
}
else{
STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"' or T_Name like '%"+ ttxtname.getText() +"%'";
}
System.out.println(STIQ);
if(Database.query(STIQ)){
try{
while(Database.rs.next()){
String number=(""+Database.rs.getString("T_Number"));
System.out.println(number);
String Content=Database.rs.getString("T_Content");
System.out.println(Content);
String name=Database.rs.getString("T_Name");
System.out.println(name);
String date=Database.rs.getString("T_Date");
System.out.println(date);
String Money=Database.rs.getString("T_Money");
System.out.println(Money);

Vector v=new Vector();
v.add(number);
v.add(Content);
v.add(name);
v.add(date);
v.add(Money);

dtm.addRow(v);
}
}
catch(Exception eT){}
}
}

});
setSize(630,400);
this.setClosable(true);
setVisible(true);
}
}


//部门管理类
package classsource;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Departmentmanage extends JInternalFrame{

JLabel lb1 = new JLabel("部 门 信 息");
JLabel lb2 = new JLabel("部门编号：");
JLabel lb3 = new JLabel("部门名称：");
JLabel lb4 = new JLabel("部门人数：");
JTextField tnumber = new JTextField();
JTextField tname = new JTextFiel

d();
JTextField tcount = new JTextField();
JButton btright = new JButton("<<");
JButton btleft = new JButton(">>");
JButton btdelet = new JButton("删除");
JButton btamend = new JButton("修改");
JButton btsave = new JButton("保存");
JButton btadd = new JButton("添加");
public Departmentmanage(){

setTitle("部门信息管理!");
btsave.setEnabled(false);

getContentPane().setLayout(null);
Font f = new Font("新宋体",0,14);
btleft.setFont(f);

lb1.setFont(new java.awt.Font("新宋体", 1, 18));
lb1.setForeground(new Color(0, 51, 255));
getContentPane().add(lb1);
lb1.setBounds(110, 20, 160, 30);

lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(40, 85, 70, 20);
lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(40, 125, 70, 20);
lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(40,165,70,20);

getContentPane().add(tnumber);
tnumber.setBounds(155,85,100,23);
getContentPane().add(tname);
tname.setBounds(155,125,120,23);
getContentPane().add(tcount);
tcount.setBounds(155,165,120,23);

btright.setFont(f);
getContentPane().add(btright);
btright.setBounds(330, 250, 50, 20);

btleft.setFont(f);
getContentPane().add(btleft);
btleft.setBounds(330, 230, 50, 20);


btdelet.setFont(f);
getContentPane().add(btdelet);
btdelet.setBounds(250, 240, 70, 25);

btamend.setFont(f);
getContentPane().add(btamend);
btamend.setBounds(170, 240, 70, 25);

btsave.setFont(f);
getContentPane().add(btsave);
btsave.setBounds(10, 240, 70, 25);

btadd.setFont(f);
getContentPane().add(btadd);
btadd.setBounds(90, 240, 70, 25);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);

//连接数据库
Database.joinDB();

//初始化窗体数据
String sqlc="select * from DepartmentInformation";
try{
if(Database.query(sqlc)){
//System.out.println("ok");
Database.rs.next();
String number=("" + Database.rs.getInt("D_Number"));
//System.out.println(number);
String name=Database.rs.getString("D_Name");
String count=Database.rs.getString("D_Count");
tnumber.setText(number);
tname.setText(name);
tcount.setText(count);
}
}
catch(Exception e){
System.out.println(e);
}


//为左右按钮加事件
btright.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
try{
if(Database.rs.previous()){
String number=("" + Database.rs.getInt("D_

Number"));
String name=Database.rs.getString("D_Name");
String count=Database.rs.getString("D_Count");
tnumber.setEditable(true);
tnumber.setText(number);
tname.setText(name);
tcount.setText(count);
}
}
catch(Exception el){
System.out.println(el);
}
}
});


btleft.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
try{
if(Database.rs.next()){
String number=("" + Database.rs.getInt("D_Number"));
String name=Database.rs.getString("D_Name");
String count=Database.rs.getString("D_Count");
tnumber.setEditable(true);
tnumber.setText(number);
tname.setText(name);
tcount.setText(count);
}
}
catch(Exception er){
System.out.println(er);
}
}
});


//为添加删除保存修改按钮加事件
btadd.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
btsave.setEnabled(true);
tnumber.setText("");
tnumber.setEditable(false);
tname.setText("");
tcount.setText("");
}
});
btsave.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
if(tname.getText().equals("") || tcount.getText().equals("")){
new JOptionPane().showMessageDialog(null,"部门名和部门人数都不能为空！");
}
else{
String name=tname.getText();
String count=tcount.getText();
String sInsert = "insert DepartmentInformation values('"+ name +"','"+ count +"')";
try{
if(Database.executeSQL(sInsert)){
tnumber.setEditable(true);
btsave.setEnabled(false);
new JOptionPane().showMessageDialog(null,"添加数据成功！");
Database.joinDB();
String sql="select * from DepartmentInformation";
Database.query(sql);
https://www.wendangku.net/doc/a03760022.html,st();
String number1=("" + Database.rs.getInt("D_Number"));
//System.out.println(number);
String name1=Database.rs.getString("D_Name");
String count1=Database.rs.getString("D_Count");
tnumber.setText(number1);
tname.setText(name1);
tcount.setText(count1);
}

else{
new JOptionPane().showMessageDialog(null,"添加数据不成功！");
}
}
catch(Exception ei){
new JOptionPane().showMessageDialog(null,"添加数据不成功！");
}
}
}
});

btdelet.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
try{
String sql="delete from DepartmentI