settingdbaccess.java

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

/**
 * 论坛的设置：查询和修改
 */
package bbs.db;
import com.db.Databasec;
import java.util.ArrayList;
import bbs.bean.BbsSetting;
import bbs.bean.SuperSetting;

public class SettingDBAccess extends Databasec {
  private java.sql.ResultSet rst = null;
  /**
   * 插入论坛信息
   * @param setting BbsSetting
   * @return int
   * @throws Exception
   */
  public int insert(BbsSetting setting) throws Exception {
    this.open();
    try {
      String sql = "INSERT INTO bbsSetting VALUES('"
          + setting.getSname() + "','"
          + setting.getSsynopsis() + "','"
          + setting.getSad() + "')";
      return pst.executeUpdate(sql);
    }
    finally {
      this.close();
    }
  }

  /**
   * 更新论坛信息
   * @param setting BbsSetting
   * @return int
   * @throws Exception
   */
  public int update(BbsSetting setting) throws Exception {
    this.open();
    try {
      String sql = "UPDATE bbsSetting SET Sname='"
          + setting.getSname() + "', Ssynopsis='"
          + setting.getSsynopsis() + "',Sad= '"
          + setting.getSad() + "' WHERE SID="
          + setting.getSid();
      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 BbsSetting getdata() throws Exception {
    BbsSetting setting = new BbsSetting();
    String sql = "SELECT * FROM bbsSetting";
    try {
      this.open();
      pst = con.prepareStatement(sql);
      rst = pst.executeQuery();
      while (rst.next()) {
        setting.setSid(rst.getInt("SID"));
        setting.setSname(rst.getString("Sname"));
        setting.setSsynopsis(rst.getString("Ssynopsis"));
        setting.setSad(rst.getString("Sad"));
      }
    }
    finally {
      this.close();
    }
    return setting;
  }

}