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

《《数据库应用》课程设计——人事管理系统(java源代码).docx》由会员分享，可在线阅读，更多相关《《数据库应用》课程设计——人事管理系统(java源代码).docx（140页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、数据库应用课程设计人事管理系统（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(员工管理系统); JL

2、abel 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

3、,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,

4、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(te

5、xtage.getText().equals()new JOptionPane().showMessageDialog(null,密码不能为空!);elseString 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); c

6、on.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 = Toolkit.getDefaultToolkit(

7、); 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); D.close(

8、);new Main();else System.out.println(错误);new JOptionPane().showMessageDialog(null,用户名或密码错误!,JOptionPane.ERROR_MESSAGE);catch(Exception ex) System.out.println(ex.getMessage();elseSystem.out.println(连接数据库不成功);public static void main(String args) new Land();/主函数类，可以独立运行package classsource; import java.

9、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( 欢 迎 使 用 员 工 管 理 系 统 !);ImageIconicon1=newImageIcon(imagetjsc

10、.gif);ImageIconicon2=newImageIcon(imagecxdl.gif);ImageIconicon3=newImageIcon(imagexgmm.gif);ImageIconicon4=newImageIcon(imagetcxt.gif);ImageIconicon5=newImageIcon(imagejj.gif);ImageIconicon6=newImageIcon(imagehelp.gif);ImageIconicon7=newImageIcon(imagecx.gif);ImageIconicon8=newImageIcon(imagegl.gif)

11、;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 Ima

12、geIcon(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

13、= 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);

14、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

15、); 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(L

16、and); 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(f

17、alse););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);JMenuIte

18、m 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 actionPe

19、rformed(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 ActionLi

20、stener() 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();

21、);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

22、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(encouragementPunishS); employeeSM.add(wa

23、geS); 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(Action

24、Event 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) S

25、ystem.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.ad

26、d(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().getI

27、mage(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(i

28、con10); 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(ico

29、n15); 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.setToolTipTex

30、t(修改密码);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(im

31、age1.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 voi

32、d 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 Ima

33、geIcon(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

34、()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

35、 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.getDefaultTool

36、kit(); 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;tryThread.sleep(100);catch(Exception e)public static void main(String args) new Main();/数据库联接类package classsource; import jav

37、a.sql.*;public class Database public static Connection cn; public static Statement st; public static ResultSet rs;public static boolean joinDB() boolean joinFlag;try joinFlag = true; Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); cn =DriverManager.getConnection(jdbc:odbc:EmployeeInformationMS,sa,);cn.

38、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 notfo

39、undEX) 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

40、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.*; impo

41、rt 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 txtnam

42、e; 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(); b

43、utOk = 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(jLabe

44、l1); 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); getConte

45、ntPane().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,