userbookmark.java

BBS-CS是采用JSP+JavaBean+Servlet开发的一套网络虚拟社区系统。

package com.laoer.bbscs.user;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.db.*;
import com.laoer.bbscs.txthtml.*;

/**
 * <p>Title: BBS-CS</p>
 * <p>Description: BBS-CS(BBS式虚拟社区系统)</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: loveroom.com.cn</p>
 * @author 龚天乙（laoer）
 * @version 3.0
 */

public class UserBookMark {

  String SQL = "";
  DbTrans DBSQL;
  //DoText myDoText;
  ResultSet rs = null;

  private String strsqname = "";
  private String url = "";
  private String alt = "";

  public UserBookMark() {
      this.DBSQL = new DbTrans();
      //this.myDoText = new DoText();
  }

  public void setUserBookMark(String strUserID, String sqID) {
      SQL = "select * from shuqian where ID="+ sqID +" and UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              this.strsqname = rs.getString("sqname");
              this.url = rs.getString("url");
              this.alt = rs.getString("alt");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      try {
          DBSQL.close();
      }
      catch (SQLException e){
      }
  }

  public String getsqname() {
      return this.strsqname;
  }

  public String geturl() {
      return this.url;
  }

  public String getalt() {
      return this.alt;
  }

  public void close() {
      try {
          DBSQL.close();
      }
      catch (SQLException e) {
      }
  }

}