login.java

jsp开发常用信息管理系统适合初学者学习 网上购物

package ch09.web;

import ch09.util.strFormat;

/**
 * @author <a href='[e-mail]'>chengwei</a>
 * 用户登录信息检查
 */

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 BookAdminuser where adminuser = '"
                    + strFormat.formatSql(username) + "' and adminpass = '"
                    + strFormat.formatSql(passwd) + "'";
        } else {
            sqlStr = "select * from users where username = '"
                    + strFormat.formatSql(username) + "' and password = '"
                    + strFormat.formatSql(passwd) + "'";
        }
        System.out.println(sqlStr);
        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;
    }
}