?? login.java
字號:
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; }};
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -