content.java

JAVA+JSP程序系统-华源网络科技论坛

package org.jetic.web.techbbs;
import java.sql.*;
import java.text.SimpleDateFormat;
import org.jetic.util.Format;

/**
 * Title:        华源技术论坛
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      GBSOURCE
 * @author fainter
 * @version 1.0
 */

public class content {
    private Mssql mssql;
    private Format format = new Format();
    private SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    private Information info = new Information();
    private ResultSet rs ;
    private String content,title,time,memo,writer,sql;
    private int re,icon,boardID;
    private int id;

  //  public content(){}
    //public content(int id) {
      //  this.setid(id);
    //}
    public void setid(int newid) {
      this.id = newid;
      try{
        mssql = new Mssql();
  //      id = info.getid();
        sql = "select fdimain,fdiicon,fdire,fdctitle,fdtime,fdcmemo,fdcwriter from tbtopic where id=" + id;
        rs = mssql.executeQuery(sql) ;
        while (rs.next()) {
          boardID = rs.getInt("fdimain");
          icon = rs.getInt("fdiicon");
          re = rs.getInt("fdire");
          title = format.toHtml(rs.getString("fdctitle"));
          time = formatter.format(rs.getTimestamp("fdtime"));
          memo = format.toHtml(rs.getString("fdcmemo"));
          writer = rs.getString("fdcwriter");
        }
      }
      catch (Exception ex) {
        ex.printStackTrace(System.err);
      }
   }
    public int getid() {
        return id;
    }
    public void setboardID(int newboardID) {
        boardID = newboardID;
    }
    public int getboardID() {return boardID;}
    public void seticon(int newicon) {
        icon = newicon;
    }
    public int geticon() {return icon;}
    public void settitle(String newtitle) {
        title = newtitle;
    }
    public String gettitle() {return title;}
    public void settime(String newtime) {
        time = newtime;
    }
    public String gettime() {return time;}
    public void setmemo(String newmemo) {
        memo = newmemo;
    }
    public String getmemo() {return memo;}
    public void setwriter(String newwriter) {
        writer = newwriter;
    }
    public String getwriter() {return writer;}
}