login_1.java

这是一个用JAVA做的人力资源系统

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Login_1 extends Frame implements ActionListener{
	String url="jdbc:odbc:LocalServer";
	Connection con;
	String sql;
//	String x=null;
	Statement stmt;
	TextField UserName = new TextField(15);
	TextField  Pass = new TextField(15);
	Button ok = new Button("登陆");
	Button cancel = new Button("取消");
	public Login_1(){
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				System.exit(0);
			}
		});	
		Color c1=new Color(241,250,249);
		Color c2=new Color(200,239,250);
//		Color c3=new Color(150,220,250);
		setLayout(new GridLayout(4,0));
		Panel panel1 = new Panel();
		Label x=new Label("欢迎登陆工资管理系统");
//		x.setFont(new Font("SansSerif",Font.BOLD|Font.ITALIC,20));
		panel1.add(x);
		add(panel1);
		panel1.setBackground(c2);
		Panel panel2 = new Panel();
		panel2.add(new Label("用户名："));
		panel2.add(UserName);
		add(panel2);
		panel2.setBackground(c1);
		Panel panel3=new Panel();
		panel3.add(new Label("密    码："));
		panel3.add(Pass);
		Pass.setEchoChar('*');
		add(panel3);
		panel3.setBackground(c1);
		Panel panel4 = new Panel();
		panel4.add(ok);
		panel4.add(cancel);
		add(panel4);
		panel4.setBackground(c2);
		ok.addActionListener(this);
		cancel.addActionListener(this);
		UserName.addActionListener(this);
		Pass.addActionListener(this);
		setBackground(Color.white);
		
		
		}
	public void actionPerformed(ActionEvent e){
		if (e.getActionCommand().equals("登陆")|e.getSource()==UserName|e.getSource()==Pass) 
		{ 
			String UN=UserName.getText().trim();
			String P=Pass.getText();
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}catch(ClassNotFoundException e1){
				System.err.print("ClassNotFoundException:");
				System.err.print("e.getMessage()");
			}
			
			try{
				con = DriverManager.getConnection(url,"sa","123");
				stmt = con.createStatement();
				String sql="select * from usemen where 用户='"+UN+"'"+"and 密码='"+P+"'";
	    		stmt=con.createStatement();
	    		ResultSet rs=stmt.executeQuery(sql);
	    	if(rs.next()){
	         new Main_common(UN);
	         setVisible(false);
	         stmt.close();
			 con.close();
	    	}
	    	else{
				if(UN.equals("Ada")&&P.equals("123") )
					{new Main_adamin();
					setVisible(false);
					
					}
				else{
					new Error1();
					}}
				stmt.close();
				con.close();
			}catch(SQLException ex){
				System.err.println("SQLException:"+ex.getMessage());
			}
			
		} 
		if (e.getActionCommand().equals("取消"))
		{
			System.exit(0);
		}
		

	}
	
	public static void main(String args[]){
		Login_1 Log=new Login_1();
		Log.setSize(250,200);
		Log.setVisible(true);
		Log.setTitle("登陆界面");
		Log.setResizable(false);
		Log.setLocationRelativeTo(null);
	}
}