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){}
	}
	//設(shè)置屬性值、獲取屬性值的方法
	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;
	}
	//查詢數(shù)據(jù)庫(kù)的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="輸入的員工工號(hào)或密碼不正確!";
				success="false";
			}
			con.close();
			return message;
		   }catch(SQLException e){
			   message="輸入的員工工號(hào)或密碼不正確!";
			   success="false";
			   return message;
		   }
	}

}