frontuserdbaccess.java

功能描述 1） 后台：管理员负责对整个论坛进行管理

/**
 * 用户表前台的个人信息的查询，更新
 */
package bbs.db;

import com.db.Databasec;
import bbs.bean.BbsUsers;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.sql.ResultSetMetaData;

public class FrontUserDBAccess
    extends Databasec {
  private java.sql.ResultSet rst = null;

  /**
   * 更新个人信息的方法
   * @param user BbsUsers
   * @return int
   * @throws Exception
   */
  public int update(BbsUsers user) throws Exception {
    this.open();
    try {
      String sql = "UPDATE bbsUsers SET Uname='"+ user.getUname() + "', Upassword='"+ user.getUpassword() + "',Uemail= '" + user.getUemail() + "',Usex='" + user.getUsex() + "',Uremark='"+user.getUremark()+"' WHERE UID="+ user.getUid();
      pst = con.prepareStatement(sql);
      return pst.executeUpdate();
    }
    finally {
      this.close();
    }
  }

  /**
   * 查询个人信息的方法
   * @param tabName String
   * @return ArrayList
   * @throws Exception
   */
  public ArrayList select(String tabName) throws Exception {
    return null;
  }

  public BbsUsers getdata(String name) throws Exception {
    BbsUsers user = new BbsUsers();

    try {
      this.open();
      String sql = "SELECT * FROM bbsUsers where UName='" + name + "'";
      pst = con.prepareStatement(sql);
      rst = pst.executeQuery();
      rst.next();
      user.setUid(rst.getInt("UID"));
      user.setUname(rst.getString("UName"));
      user.setUpassword(rst.getString("Upassword"));
      user.setUemail(rst.getString("Uemail"));
      user.setUsex(rst.getString("Usex"));
      user.setUip(rst.getString("UIP"));
      user.setUisAdmin("" + rst.getInt("UPepedomID"));
      user.setUtopicCount(rst.getInt("UtopicCount"));

      user.setUreplayCount(rst.getInt("UreplayCount"));
      user.setUremark(rst.getString("Uremark"));
      user.setUregdate(rst.getString("UregDate"));
      user.setUhonor("" + rst.getInt("Uhonorid"));
      user.setUstate(rst.getInt("Ustate"));
      user.setUpoint(rst.getInt("Upoint"));
      user.setUlogintime(rst.getString("UloginTime"));
      user.setUexittime(rst.getString("Uexittime"));
      sql = "select HonorDuty from honor where HonorID = " + user.getUhonor();
      pst = con.prepareStatement(sql);
      rst = pst.executeQuery();
      rst.next();
      user.setUhonor(rst.getString("HonorDuty"));
      sql = "select PepedomName from Pepedom where PepedomID = " + user.getUisAdmin();
      pst = con.prepareStatement(sql);
      rst = pst.executeQuery();
      rst.next();
      user.setUisAdmin(rst.getString("PepedomName"));

    }
    finally {
      this.close();
    }
    return user;
  }

}