userlogin.java

一个日程管理和通讯录管理的软件,采用的Access数据库,其中用到了三个自已写的三个控件:无售点按钮(NFButton.ocx)、带图片的按钮(ImageButton.ocx)、改进的日历控件(Gol

package myBeans;
import java.sql.*;

public class userLogin {
	String eno,name,password,email,phone;
	String success="false",message="";

	Connection con;
	Statement sql;
	
	ResultSet rs;
	public userLogin(){
		//加载桥接器
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}
	//设置属性值、获取属性值的方法
	public void setEno(String num){
		eno=num;
	}
	public String getEno(){
		return eno;
	}
	public void setName(String name){
		this.name=name;
	}
	public String getName(){
		return name;
	}
	public void setPassword(String str){
		password=str;
	}
	public String getPassword(){
		return password;
	}
	public void setEmail(String em){
		email=em;
	}
	public String getEmail(){
		return email;
	}
	public void setPhone(String ph){
		phone=ph;
	}
	public String getphone(){
		return phone;
	}
	public String getSuccess(){
		return success;
	}
	//查询数据库的User表
	public String getMessage(String Eno, String password){
		try{
			con=DriverManager.getConnection("jdbc:odbc:bysj","","");
			sql=con.createStatement();
			String condition="SELECT * FROM users WHERE Eno="+"'"+Eno+"'";
			System.out.println(condition);
			rs=sql.executeQuery(condition);
			int rowcount=0;
			String ps=null;
			while(rs.next()){
				rowcount++;
				eno=rs.getString("Eno");
				/*Eno=rs.getString("Eno");
				logname=rs.getString("logname");
				password=rs.getString("password");
				realname=rs.getString("realname");
				email=rs.getString("email");
				phone=rs.getString("phone");				
					*/	
			}
			if((rowcount==1)&&(password.equals(password))){
				message="ok";
				success="ok";
				System.out.println(message);
			}
			else{
				message="输入的员工工号或密码不正确!";
				success="false";
			}
			con.close();
			return message;
		   }catch(SQLException e){
			   message="输入的员工工号或密码不正确!";
			   success="false";
			   return message;
		   }
	}

}