用户状态判断与登录逻辑实现

ublic void checkUser(int loginSign) throws UserNotFoundException,
            Exception {
        DBConnect dbc = null;
        try {
            dbc = new DBConnect(
                    "select * from User where UserName=? and UserPassword=?");

            dbc.setString(1, userName);
            dbc.setString(2, (userPassword));
            ResultSet rs = dbc.executeQuery();

            if (rs.next()) {
                if (loginSign == 4) {
                    this.setUserClass(rs.getInt("userclass"));
                    this.setLastLogin(rs.getString("lastlogin"));
                    dbc.close();
                    return;
                }
                // use the resultset to define the varible used!
                lastLogin = rs.getString("lastlogin");
                article = rs.getInt("Article");
                userClass = rs.getInt("userclass");
                if (userClass < 18) {
                    if (article < SkinUtil.getPoint(2))
                        userClass = 1;
                    for (int i = 2; i < 17; i++) {
                        if (article >= SkinUtil.getPoint(i)
                                && article < SkinUtil.getPoint(i + 1))
                            userClass = i;
                    }