login.java

实习时做的人事系统

package com.personnel;

import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.SwingUtilities;

import java.awt.Dimension;
import java.awt.GridBagLayout;
import java.awt.Toolkit;

import javax.swing.JLabel;
import java.awt.GridBagConstraints;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import java.awt.Font;
import java.awt.Insets;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;

import javax.swing.JButton;

/**
 * 用户登录界面
 */

/**
 * @author 陈辉鸿
 *
 */
public class Login extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;
	
	private Main parent;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JTextField jtfUser = null;

	private JPasswordField jpfKey = null;

	private JButton jbtOk = null;

	private JButton jbtCancel = null;
	
	private DbManager dbManager = new DbManager(DbManager.MYSQL_DRIVER, DbManager.MYSQL_URL,
			 "root", "6581502",
				 DbManager.TYPE_SCROLL_SENSITIVE,DbManager.CONCUR_UPDATABLE); 
	
	ResultSet rs;
	
	String sql=new String();

	public Login() {
		super();
		initialize();
	}
	
	public Login(Main parent){
		super();
		this.parent=parent;
		initialize();
	}

	public static void main(String[] args) {
		try {
			javax.swing.UIManager.setLookAndFeel(new com.jgoodies.looks.plastic.Plastic3DLookAndFeel());
	    } 
		catch (Exception exc) {
System.err.println("Could not load LookAndFeel");
	    }
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				Login inst = new Login();
				inst.setLocationRelativeTo(null);
				inst.setVisible(true);
			}
		});
	}
	
	private void initialize() {
		this.setSize(459, 220);
		this.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
		this.setContentPane(getJContentPane());
		this.setTitle("登录");
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		//The frame is placed in the middle;
		this.setLocation(screenSize.width/2 - this.getWidth()/2, screenSize.height/2 - this.getHeight()/2);
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			GridBagConstraints gridBagConstraints5 = new GridBagConstraints();
			gridBagConstraints5.gridx = 1;
			gridBagConstraints5.insets = new Insets(20, 0, 0, 60);
			gridBagConstraints5.gridy = 2;
			GridBagConstraints gridBagConstraints4 = new GridBagConstraints();
			gridBagConstraints4.gridx = 0;
			gridBagConstraints4.insets = new Insets(20, 130, 0, 0);
			gridBagConstraints4.gridy = 2;
			GridBagConstraints gridBagConstraints3 = new GridBagConstraints();
			gridBagConstraints3.fill = GridBagConstraints.VERTICAL;
			gridBagConstraints3.gridy = 1;
			gridBagConstraints3.weightx = 1.0;
			gridBagConstraints3.insets = new Insets(0, 0, 0, 100);
			gridBagConstraints3.gridx = 1;
			GridBagConstraints gridBagConstraints2 = new GridBagConstraints();
			gridBagConstraints2.fill = GridBagConstraints.VERTICAL;
			gridBagConstraints2.gridy = 0;
			gridBagConstraints2.weightx = 1.0;
			gridBagConstraints2.insets = new Insets(0, 0, 0, 100);
			gridBagConstraints2.gridx = 1;
			GridBagConstraints gridBagConstraints1 = new GridBagConstraints();
			gridBagConstraints1.gridx = 0;
			gridBagConstraints1.insets = new Insets(0, 120, 0, 0);
			gridBagConstraints1.gridy = 1;
			jLabel1 = new JLabel();
			jLabel1.setText("密码：");
			jLabel1.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jLabel1.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 24));
			GridBagConstraints gridBagConstraints = new GridBagConstraints();
			gridBagConstraints.gridx = 0;
			gridBagConstraints.insets = new Insets(0, 120, 0, 0);
			gridBagConstraints.gridy = 0;
			jLabel = new JLabel();
			jLabel.setText("帐号：");
			jLabel.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jLabel.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 24));
			jContentPane = new JPanel();
			jContentPane.setLayout(new GridBagLayout());
			jContentPane.add(jLabel, gridBagConstraints);
			jContentPane.add(jLabel1, gridBagConstraints1);
			jContentPane.add(getJtfUser(), gridBagConstraints2);
			jContentPane.add(getJpfKey(), gridBagConstraints3);
			jContentPane.add(getJbtOk(), gridBagConstraints4);
			jContentPane.add(getJbtCancel(), gridBagConstraints5);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jtfUser	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJtfUser() {
		if (jtfUser == null) {
			jtfUser = new JTextField();
			jtfUser.setColumns(12);
			jtfUser.setText("陈辉鸿");
			jtfUser.addKeyListener(new java.awt.event.KeyListener() {
				public void keyPressed(java.awt.event.KeyEvent e) {
					checkPasswd(); // 
				}
				public void keyTyped(java.awt.event.KeyEvent e) {
				}
				public void keyReleased(java.awt.event.KeyEvent e) {
				}
			});
		}
		return jtfUser;
	}

	/**
	 * This method initializes jpfKey	
	 * 	
	 * @return javax.swing.JPasswordField	
	 */
	private JPasswordField getJpfKey() {
		if (jpfKey == null) {
			jpfKey = new JPasswordField();
			jpfKey.setColumns(12);
			jpfKey.setText("123");
			jpfKey.addKeyListener(new java.awt.event.KeyListener() {
				public void keyPressed(java.awt.event.KeyEvent e) {
					if(e.getKeyCode()==java.awt.event.KeyEvent.VK_ENTER){
						checkPasswd();
					}
				}
				public void keyTyped(java.awt.event.KeyEvent e) {
				}
				public void keyReleased(java.awt.event.KeyEvent e) {
				}
			});
		}
		return jpfKey;
	}

	/**
	 * This method initializes jbtOk	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJbtOk() {
		if (jbtOk == null) {
			jbtOk = new JButton();
			jbtOk.setText("确定");
			jbtOk.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jbtOk.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jbtOk.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					checkPasswd();
				}
			});
		}
		return jbtOk;
	}
	
	private void checkPasswd(){
		if(jtfUser.getText().trim().toString().equals("")||
				jpfKey.getPassword().toString().equals("")){
			JOptionPane.showMessageDialog(null,"帐号或密码为空，请重新输入");// 
		}
		else{
			sql="SELECT * FROM";
			sql=sql+" admin WHERE";
			sql=sql+" 帐号='"+jtfUser.getText().trim()+"'";
			sql=sql+" and 密码='"+String.valueOf(jpfKey.getPassword())+"';";
			rs=dbManager.executeQuery(sql);
			try{
				if(rs.next()){
					parent = new Main(jtfUser.getText().trim());
					parent.setVisible(true);
					rs.close();
					dbManager.closeDb();
					dispose();
				}
				else{
					JOptionPane.showMessageDialog(null, "帐号或者密码错误，请重新输入");
					rs.close();
				}
			}
			catch(SQLException ex){
				JOptionPane.showMessageDialog(null, "查询用户失败");
			}
		}
	}

	/**
	 * This method initializes jbtCancel	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJbtCancel() {
		if (jbtCancel == null) {
			jbtCancel = new JButton();
			jbtCancel.setText("取消");
			jbtCancel.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jbtCancel.setFont(new Font("\u5b8b\u4f53", Font.PLAIN, 18));
			jbtCancel.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					dispose(); 
				}
			});
		}
		return jbtCancel;
	}

}