article.java

来自「用java实现的一个bbs的portal」· Java 代码 · 共 114 行

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Jul 17, 2003
 * Time: 11:46:59 AM
 * To change this template use Options | File Templates.
 */
package Kernel;

import DBConnection.DBConnector;

import java.util.Vector;

public class Article {
    boolean Type; //true = article,false = re
    String BBS;
    String Board;
    String Author;
    String Alias;
    String Title;
    String Content;
    String Date;
    String IP;
    String XMLFile;

    public Article(boolean type,String bbs,String board,String author,
                   String alias,String title,String content,String date,String ip,String xmlfile){
        BBS = bbs.trim();
        Board = board.trim();
        Type = type;
        Author = author.trim();
        Alias = alias.trim();
        Title = title.trim();
        Content = content.trim();
        Date = date.trim();
        IP = ip.trim();
        XMLFile = xmlfile.trim();
    }

    public boolean insertBBSInfo(){
        // suix add,for the max size of varchar in sql server is 8000 char
        if(Content.length()>8000)
        {
          System.err.println(Title+" length>8000,could not insert");
             return false;
        }
         try{
            String sql = "INSERT INTO BBSXINXI" +
                    "(XMLFILE,BBSNAME,BOARDNAME,AUTHOR,ALIAS,TITLE,CONTENT,POSTDATE,IP ) " +
                    "VALUES ('"+getXMLFile()+"', '"+getBBS()+
                    "', '"+getBoard()+"', '"+getAuthor()+"', '"+
                    getAlias()+"', '"+getTitle()+"', '"+getContent()+
                    "', '"+getDate()+"', '"+getIP()+"') ";
            System.out.println("BBSInfo : "+sql);

          java.sql.Statement s=DBConnector.getInstance().stmt;
           if(s==null)
             System.out.println("statement is null---------error");
           else
             s.execute(sql);
             return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return false;
    }


    public Vector getBBSInfo(short tradetype,String commodity){
        //search in the BBSXINXI and return the matched bbs info.
        return null;
    }

    public boolean isType() {
        return Type;
    }

    public String getAuthor() {
        return Author;
    }

    public String getAlias() {
        return Alias;
    }

    public String getTitle() {
        return Title;
    }

    public String getContent() {
        return Content;
    }

    public String getDate() {
        return Date;
    }

    public String getIP() {
        return IP;
    }

    public String getBBS() {
        return BBS;
    }

    public String getBoard() {
        return Board;
    }

    public String getXMLFile(){
        return XMLFile;
    }
}