package bookshop.run;
/**
 * <p>管理用戶登錄的類 </p>
 */
import bookshop.util.*;
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;
		}
		/**
		 * 獲得查詢用戶信息的sql語句
		 * @return
		 */
		public String getSql() {
			   System.out.println("to getstr");
				if (isadmin) {
						sqlStr = "select * from bookadmin where AdminUser = '" +
							dataFormat.toSql(username) + "' and AdminPass = '" +
							dataFormat.toSql(passwd) + "'";
				}else {
						sqlStr = "select * from shop_user where username = '" +
							username + "' and password = '" + passwd + "'";
				}
				System.out.println(sqlStr);
				return sqlStr;
		}
		/**
		 * 執行查詢
		 * @return
		 * @throws java.lang.Exception
		 */
		public boolean excute() throws Exception {
			    System.out.println("excute");
				boolean flag = false;
				DataBase db = new DataBase();
				//db.connect();
				//stmt = db.conn.createStatement ();
				rs = stmt.executeQuery(getSql());
				if (rs.next()){
						if (!isadmin)
						{
								userid = rs.getLong("id");
						}
						flag = true;
				}
				rs.close();
				return flag;
		}
};