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() {                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;        }        /**         * 執行查詢         * @return         * @throws java.lang.Exception         */        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;        }};