《数据库应用》课程设计——人事管理系统(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);
Database.cn.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.addActionListener(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());
}
})