package check;import java.sql.*;import check.dbconn;import check.strformat;public class login extends database {	private String username;	//登錄用戶名	private String passwd;		//登錄密碼	private boolean isadmin;	//是否管理員登錄	private long userid=0;		//用戶ID號	public login() throws Exception{		super();		username = "";		passwd = "";		isadmin = false;	}	public String getUsername() {		return username;	}	public void setUsername(String newusername) {		username = newusername;	}	public String getPasswd() {		return passwd;	}	public void setPasswd(String newpasswd) {		passwd = newpasswd;	}	public boolean getIsadmin() {		return isadmin;	}	public void setIsadmin(boolean newIsadmin) {		isadmin = newIsadmin;	}	public long getUserid() {		return userid;	}	public void setUserid (long uid) {		userid = uid;	}	public String getSql() {		if (isadmin) {			sqlStr = "select * from My_BookAdminuser where AdminUser = '" + strformat.toSql(username) + "' and AdminPass = '" + strformat.toSql(passwd) + "'";		}else {			sqlStr = "select * from My_Users where UserName = '" + strformat.toSql(username) + "' and PassWord = '" + strformat.toSql(passwd) + "'";		}		return sqlStr;	}	public boolean excute() throws Exception {		boolean flag = false;		rs = stmt.executeQuery(getSql());		if (rs.next()){			if (!isadmin)			{				userid = rs.getLong("Id");			}			flag = true;		}		rs.close();		close();		return flag;	}};