package community.login;

import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;

import community.DBConnectionManager;
import community.strFormat;


public class loginbean {
	private String glyid="";
	private String yhname="";
	private String mima="";
	private String glylxid="";
	String sqlStr; //檢索數據庫SQL語句
	DBConnectionManager sqlbean = new DBConnectionManager();	
	public String getGlyid(){
		return glyid;
	}
	public void setGlyid(String id){
		this.glyid=id;
	}
	public String getYhname(){
		return yhname;
	}
	public void setYhname(String name){
		this.yhname=name;
	}
	public String getMima(){
		return mima;
	}
	public void setMima(String pwd){
		this.mima=pwd;
	}
	public String getGlylxid(){
		return glylxid;
	}
	public void setGlylxid(String type){		
		try {
			byte b[] = type.getBytes("ISO-8859-1");
			this.glylxid=new String(b);
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
	}
	public String getSql() {

		sqlStr =
			"select * from glyxxb where yhname = '"
				+ strFormat.toSql(yhname)
				+ "' and mima = '"
				+ strFormat.toSql(mima)
				+ "'";

		return sqlStr;
	}
	public boolean excute() throws Exception {
		boolean flag = false;
		ResultSet rs = sqlbean.executeQuery(getSql());
		if (rs.next()) 
		{
				
			if(glylxid.equals(rs.getString("glylxid")))
				flag = true;
			//flag=true;
		}
		rs.close();
		sqlbean.closeConn();
		return flag;
	}
	public void setinfo(String lastip, String username) throws Exception {

		sqlbean.executeUpdate(
			"UPDATE admin SET lasttime = getdate(),lastip='"
				+ lastip
				+ "' where adminuser='"
				+ username
				+ "' ");

		sqlbean.closeConn();
	}
}