package myBeans;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class adminLogin {
	String adminname;
	String password;
	public String getAdminname() {
	return adminname;
}
	public void setAdminame(String name) {
	this.adminname = name;
}
	public String getPassword() {
	return password;
}
	public void setPassword(String password) {
	this.password = password;
}

	String success="false",message="";

	Connection con;
	Statement sql;
	ResultSet rs;
	public adminLogin(){
		//加載橋接器
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}
	public String getMessage(String name,String password){
		try{
			con=DriverManager.getConnection("jdbc:odbc:bysj","","");
			sql=con.createStatement();
			String condition="SELECT * FROM admin WHERE adminname="+"'"+name+"' and password='"+password+"'";
			System.out.println(condition);
			rs=sql.executeQuery(condition);
			int rowcount=0;
			//String ps=null;
			while(rs.next()){
				rowcount++;				
			}
			if((rowcount==1)&&(password.equals(password))){
				message="ok";
				success="ok";
				System.out.println(message);
			}
			else{
				message="管理員賬號或密碼不正確!";
				success="false";
			}
			sql.close();
			con.close();
			return message;
		   }catch(SQLException e){
			   message="管理員賬號或密碼不正確!";
			   success="false";
			   return message;
		   }
	}
}