bbsinfo.java

用java实现的一个bbs的portal

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Sep 19, 2003
 * Time: 2:57:08 PM
 * To change this template use Options | File Templates.
 */
package Kernel;

import DBConnection.DBBridge;
import DBConnection.DBConnector;
import DBConnection.SQLBridge4Web;

import java.sql.ResultSet;

public class BBSInfo {
    private String XmlFile;
    private String BbsName;
    private String BoardName;
    private String Author;
    private String Alias;
    private String Title;
    private String Content;
    private String PostDate;
    private String Ip;

    private SQLBridge4Web sqlBridge;

    public void setSqlBridge( SQLBridge4Web theBridge ){
        this.sqlBridge = theBridge;
    }

    public BBSInfo(){

    }

    public void getBBSInfo(String xmlfile){
        this.XmlFile = xmlfile;
        try{
            String sql = "select * from BBSXINXI WHERE XMLFILE='"+xmlfile+"'";
            System.out.println(sql);
            //ResultSet rs = DBConnector.getInstance().stmt.executeQuery(sql);
            sqlBridge.execSQL(sql);
            ResultSet rs = sqlBridge.getResultSet();
            if (rs.next()){
                BbsName = rs.getString("BBSNAME");
                BoardName = comTool.getChineseStr(rs.getString("BOARDNAME"));
                Author = comTool.getChineseStr(rs.getString("AUTHOR"));
                Alias = comTool.getChineseStr(rs.getString("ALIAS"));
                Title = comTool.getChineseStr(rs.getString("TITLE"));
                Content = comTool.getChineseStr(rs.getString("CONTENT"));
                PostDate = rs.getString("POSTDATE");
                Ip = rs.getString("IP");
            }
            System.out.println("heihei");
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }


    public String getXmlFile() {
        return XmlFile;
    }

    public void setXmlFile(String xmlFile) {
        XmlFile = xmlFile;
    }

    public String getBbsName() {
        return BbsName;
    }

    public void setBbsName(String bbsName) {
        BbsName = bbsName;
    }

    public String getBoardName() {
        return BoardName;
    }

    public void setBoardName(String boardName) {
        BoardName = boardName;
    }

    public String getAuthor() {
        return Author;
    }

    public void setAuthor(String author) {
        Author = author;
    }

    public String getAlias() {
        return Alias;
    }

    public void setAlias(String alias) {
        Alias = alias;
    }

    public String getTitle() {
        return Title;
    }

    public void setTitle(String title) {
        Title = title;
    }

    public String getContent() {
        return Content;
    }

    public void setContent(String content) {
        Content = content;
    }

    public String getPostDate() {
        return PostDate;
    }

    public void setPostDate(String postDate) {
        PostDate = postDate;
    }

    public String getIp() {
        return Ip;
    }

    public void setIp(String ip) {
        Ip = ip;
    }

    public static void main(String[] args) {
        BBSInfo bi = new BBSInfo();
        bi.getBBSInfo("bbs.pku.edu.cn_House_2003-08-19 10-18-48.xml");
    }

}