usermessage.java

这是一个JSP做的主页管理系统

package com.gbsource.homepage.admin;

import java.sql.*;

/**
 * Title:        华源网络主页基地管理
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      Gbsource Studio
 * @author fishwu
 * @version 1.0
 */

public class UserMessage
{
  private String userid;
  private static BeansConstants CONST;
  private String password;
  private String truename;
  private String nickname;
  private String email;
  private String birthday;
  private String address;
  private String phone;
  private String pagename;
  private String pagetype;
  private String pagecontent;
  private String forumname;
  private String forumbg;
  private String gbookname;
  private String gbookbg;
  private String logintime;
  private String lastip;
  private int upfileenable;
  private int click;
  private int space;
  private int authorized;
  private int gbooksize;
  private int forumsize;
  private int works;
  private int sex;
  public int getMessage()
  {
    String sql = "select * from VIEW_TOTAL where userid = ?";
    try{
        Database db = new Database(sql);
        db.setString(1,userid);
        ResultSet rs = db.executeQuery();
        if(rs.next())
        {
          try{
            password = rs.getString("password");
          }catch(Exception e){password = "";}
          try{
            truename = rs.getString("truename");
          }catch(Exception e){truename = "";}
          try{
            nickname = rs.getString("nickname");
          }catch(Exception e){nickname = "";}
          try{
            email = rs.getString("email");
          }catch(Exception e){email = "";}
          sex = rs.getInt("sex");
          try{
            birthday = rs.getString("birthday");
          }catch(Exception e){birthday = "不知";}
          works = rs.getInt("works");
          try{
            address = rs.getString("address");
          }catch(Exception e){address = "不知道";}
          try{
            phone = rs.getString("phone");
          }catch(Exception e){phone = "不知道";}
          try{
            pagename = rs.getString("pagename");
          }catch(Exception e){pagename = "";}
          try{
            pagetype = rs.getString("pagetype");
          }catch(Exception e){pagetype = "";}
          try{
            pagecontent = rs.getString("pagecontent");
          }catch(Exception e){pagecontent = "";}
          try{
            forumname = rs.getString("forumname");
          }catch(Exception e){forumname = "";}
          try{
            forumbg = rs.getString("forumbg");
          }catch(Exception e){forumbg = "";}
          try{
            forumsize = rs.getInt("forumsize");
          }catch(Exception e){forumsize = 0;}
          try{
            gbookname = rs.getString("gbookname");
          }catch(Exception e){gbookname = "";}
          try{
            gbookbg = rs.getString("gbookbg");
          }catch(Exception e){gbookbg = "";}
          try{
            gbooksize = rs.getInt("gbooksize");
          }catch(Exception e){gbooksize = 0;}
          try{
            logintime = rs.getString("logintime");
          }catch(Exception e){logintime = "不知道";}
          authorized = rs.getInt("authorized");
          space = rs.getInt("space");
          click = rs.getInt("click");
          lastip = rs.getString("lastip");
          upfileenable = rs.getInt("upfileenable");
        }
        else
        {
          rs.close();
          rs = null;
          db.close();
          db = null;
          return CONST.UNKNOWN_ERR;
        }
        rs.close();
        rs = null;
        db.close();
        db = null;
        return CONST.RUN_OK;
      }catch(Exception e){return CONST.DB_ERR;}
      finally{sql = null;}
  }
  public String getUserid() {
    return userid;
  }
  public void setUserid(String newUserid) {
    userid = newUserid;
  }
  public String getPassword() {
    return password;
  }
  public String getTruename() {
    return truename;
  }
  public String getNickname() {
    return nickname;
  }
  public String getEmail() {
    return email;
  }
  public int getSex() {
    return sex;
  }
  public String getBirthday() {
    return birthday;
  }
  public int getWorks() {
    return works;
  }
  public String getAddress() {
    return address;
  }
  public String getPhone() {
    return phone;
  }
  public String getPagename() {
    return pagename;
  }
  public String getPagetype() {
    return pagetype;
  }
  public String getPagecontent() {
    return pagecontent;
  }
  public String getForumname() {
    return forumname;
  }
  public String getForumbg() {
    return forumbg;
  }
  public int getForumsize() {
    return forumsize;
  }
  public String getGbookname() {
    return gbookname;
  }
  public String getGbookbg() {
    return gbookbg;
  }
  public int getGbooksize() {
    return gbooksize;
  }
  public String getLogintime() {
    return logintime;
  }
  public int getAuthorized() {
    return authorized;
  }
  public int getSpace() {
    return space;
  }
  public int getClick() {
    return click;
  }
  public String getLastip() {
    return lastip;
  }
  public int getUpfileenable() {
    return upfileenable;
  }
}