1、数据库应用课程设计人事管理系统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
2、 = 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); labe
3、l.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.setB
4、ounds(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,用户名不能为空!)
5、; 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); buttonca
6、ncel.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(imagemain.gif); setIconImage(img); Toolkit t = T
7、oolkit.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
8、.setVisible(false); D.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(); /主函数类,可以独
9、立运行 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(欢 迎 使 用 员 工 管 理 系 统 !
10、); 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 Ima
11、geIcon(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); ImageIc
12、on 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(); JMe
13、nu 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
14、(帮助); 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.
15、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 A
16、ctionListener() 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 v
17、oid 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); JMenuI
18、tem 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(department
19、M); /为管理菜单加事件 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(Emp
20、loyeemanage); 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(Act
21、ionEvent 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(部门信息查询); dep
22、artmentS.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); empl
23、oyeeSM.add(trainS); employeeSM.add(employeeS); employeeSM.add(encouragementPunishS); employeeSM.add(wageS); selectM.add(employeeSM); selectM.add(departmentS); /为查询菜单加事件 departmentS.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) System.out.println(DIQ); deskpane.add
24、(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(); );
25、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(); ); JMe
26、nuItem 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);
27、 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.se
28、tIcon(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(icon1
29、4); 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