xgmm.java

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

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class XGMM extends Frame implements ActionListener{
	String url="jdbc:odbc:test";
	Connection con;
	String sql,sql1;
	Statement stmt;
	TextField UserName = new TextField(15);
	TextField Pass = new TextField(15);
	TextField N_Pass = new TextField(15);
	Button ok = new Button("修改");
	Button back = new Button("后退");
	String ssx;
	public XGMM(String sss){
		ssx=sss;
		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 panel2 = new Panel();
		panel2.add(new Label("用户名："));
		panel2.add(UserName);
		panel2.add(new Label("原密码："));
		panel2.add(Pass);
		Pass.setEchoChar('*');
		panel2.add(new Label("新密码："));
		panel2.add(N_Pass);
		N_Pass.setEchoChar('*');
		add("Center",panel2);
		Panel panel3 = new Panel();
		panel3.add(ok);
		panel3.add(back);
		add("South",panel3);
		ok.addActionListener(this);
		back.addActionListener(this);
		UserName.addActionListener(this);
		Pass.addActionListener(this);
		N_Pass.addActionListener(this);
		setBackground(Color.lightGray);
		setSize(250,200);
		setVisible(true);
		setTitle("密码修改");
		setResizable(false);
		setLocationRelativeTo(null);
		}
	public void actionPerformed(ActionEvent e){
		if (e.getActionCommand().equals("修改")|e.getSource()==UserName|e.getSource()==Pass|e.getSource()==N_Pass) 
		{ 
			String UN=UserName.getText();
			String P=Pass.getText();
			String np=N_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","sa");
				stmt = con.createStatement();
				String sql="select * from usemen where 用户='"+UN+"' and 密码='"+P+"'";
	    		stmt=con.createStatement();
	    		ResultSet rs=stmt.executeQuery(sql);
	    	if(rs.next()){
	    		String sql1="Update usemen set 密码='"+np+"' where 用户='"+UN+"'";
	    		stmt.executeUpdate(sql1);
	    		new Sucess();
	    		setVisible(false);
	    	}
	    	else{
	    		new Error1();
	    	}
			UserName.setText(null);
		    Pass.setText(null);
		    N_Pass.setText(null);
		    stmt.close();
			con.close();
		}catch(SQLException ex){
			System.err.println("SQLException:"+ex.getMessage());
		}
		
		} 
		if (e.getActionCommand().equals("后退"))
		{
			setVisible(false);
		}

	}
	
}