checkuser.java

JSP论坛系统 数据库：mysql数据库； 技术平台：Tomcat 5.0服务器； 开发工具：Eclipse＋Lomboz、EditPlus开发工具； 操作系统：Windows XP Prof

package mybbs;

import java.sql.*;
import mybbs.DBConn;

public class CheckUser {

  String username, password, nickname, userid, userpower, forum;

  public void CheckUser() {}
  public boolean UserLocked(String userid) {
     DBConn conn=new DBConn();
     boolean bb = false;
     try {
       String sql2 = "SELECT islock FROM bbsuser WHERE id='"+userid;
       ResultSet rs = conn.query(sql2);
       rs.next();
       if(rs.getInt("islock")==1)
         bb = true;
       rs.close();
       conn.DBclose();
     }
     catch (Exception e) {
       System.out.print(e.toString());
     }
     return bb;
   }
  public boolean isExist(String user,String nickname) {
    DBConn conn=new DBConn();
    boolean bb = false;
    try {
      String sql2 = "SELECT * FROM bbsuser WHERE username='"+user+"' OR nickname='"+nickname+"'";
      ResultSet rs = conn.query(sql2);
      if (rs.next()) {
        bb = true;
      }
      rs.close();
      conn.DBclose();
    }
    catch (Exception e) {
      System.out.print(e.toString());
    }
    return bb;
  }
  public boolean nicknameExist(String userid,String nickname) {
    DBConn conn = new DBConn();
    boolean bb = false;
    try {
      String sql2 = "SELECT * FROM bbsuser WHERE id!=" + userid +
          " AND nickname='" + nickname + "'";
      ResultSet rs = conn.query(sql2);
      if (rs.next()) {
        bb = true;
      }
      rs.close();
      conn.DBclose();
    }
    catch (Exception e) {
      System.out.print(e.toString());
    }
    return bb;
  }



  public boolean checklogin(String user, String psw) {
    DBConn conn = new DBConn();
    this.username = user;
    this.password = psw;
    boolean b2 = false;
    try {
      String sql1 = "SELECT * FROM bbsuser WHERE username='" + username +
          "' AND password='" + password + "' AND islock=0";
      ResultSet rs1 = conn.query(sql1);
      if (rs1.next()) {
        nickname = rs1.getString("nickname");
        userpower = rs1.getString("userpower");
        userid = rs1.getString("id");
        b2 = true;
      }
      rs1.close();
      conn.DBclose();
    }
    catch (Exception e) {
      System.out.print(e.toString());
    }
    return b2;
  }

  public String getNickname() {
    return nickname;
  }

  public String getUserid() {
    return userid;
  }
  public  void UpdateUserInfo(String user,String ip){
    DBConn conn=new DBConn();
    String sql="UPDATE bbsuser SET last_time=SYSDATE(),online=1,last_ip='"+ip+"' WHERE  username='" +
            username + "'";
    try {
        conn.update(sql);
        conn.DBclose();
     }
      catch (Exception ex) {
    }
  }

  public String getUserpower() {
    return userpower;
  }
  public boolean forumAdmin(String user) {
    this.username = user;
    DBConn conn=new DBConn();
    boolean bb = false;
    try {
      String sql2 = "SELECT * FROM forums WHERE admin_author REGEXP '." +
          username + ".'";
      ResultSet rs2 = conn.query(sql2);
      if (rs2.next()) {
        forum = rs2.getString("id");
        bb = true;
      }
      rs2.close();
      conn.DBclose();
    }
    catch (Exception e) {
      System.out.print(e.toString());
    }
    return bb;
  }
  public String getForum() {
    return forum;
  }
  public void UserOut(String userid)  {
    DBConn conn=new DBConn();
    String sql="UPDATE bbsuser SET online=0 WHERE id="+userid;
    try{
      conn.update(sql);
      conn.DBclose();
    }
    catch(Exception e){
      System.out.print(e.toString());
    }
  }

  /*
   *Powered by Caxton
   */

}