yhcx2.java

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

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class YHCX2 extends Frame implements ActionListener{
	String url="jdbc:odbc:LocalServer";
	Connection con;
	String sql,sql1;
	Statement stmt;
	TextField UserNo = new TextField(15);
	TextField Pass = new TextField(15);
	TextArea ta=new TextArea(5,60);
	Button ok = new Button("确定");
	Button cancel = new Button("取消");
	String ssx;

	public YHCX2(String sss){
		ssx=sss;
//		System.out.println(ssx);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				setVisible(false);
			}
		});	
		setLayout(new BorderLayout());
		Panel panel1 = new Panel();
		panel1.add(new Label("用户查询界面"));
		add("North",panel1);
		Panel panel4 = new Panel();
		panel4.add(new Label("用户"+ssx+",请问需要查询什么？（您无法查询他人数据）"));
		add("North",panel4);
		Panel panel2 = new Panel();
		panel2.add(ta,BorderLayout.WEST);
		add("Center",panel2);
		Panel panel3 = new Panel();
		panel3.add(ok);
		panel3.add(cancel);
		add("South",panel3);
		ok.addActionListener(this);
		cancel.addActionListener(this);
		UserNo.addActionListener(this);
		Pass.addActionListener(this);
		setBackground(Color.lightGray);
		setSize(600,250);
		setVisible(true);
		setTitle("用户查询界面");
		setResizable(false);
		setLocationRelativeTo(null);
		}
	public void actionPerformed(ActionEvent e){
		if (e.getActionCommand().equals("确定")|e.getSource()==UserNo|e.getSource()==Pass) 
		{ 
			
			
			
			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 sql1="select * from usemen where 用户='"+ssx+"'";
		    		stmt=con.createStatement();
		    		ResultSet rs1=stmt.executeQuery(sql1);
		    		if(rs1.next()){
		    			String bh=rs1.getString(1);
		    			String ygh=rs1.getString(2);
		    			String s1="用户名:"+bh+"  密码:"+ygh+"\n";
		    	        ta.append(s1);
		    	    }
		    	
				else{
					new Error();
					}
				stmt.close();
				con.close();
				}catch(SQLException ex){
					System.err.println("SQLException:"+ex.getMessage());
				}
			
			
		} 
		if (e.getActionCommand().equals("取消"))
		{
			setVisible(false);
		}

	}
	
}