package guanli;

import beans.*;
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語句

		 */
		public String getSql() {
				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 + "'";
				}
				return sqlStr;
		}
		/**
		 * 執行查詢
		 */
		public boolean excute() throws Exception {
				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;
		}
};