usercollection.java

用java实现的一个bbs的portal

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Sep 10, 2003
 * Time: 4:59:48 PM
 * To change this template use Options | File Templates.
 */
package Kernel;

import DBConnection.DBBridge;

import Kernel.comTool;
import java.util.Vector;
import java.sql.ResultSet;

public class UserCollection {

    public UserCollection() {
    }

    public  boolean insertMyCollection(String id,String commodity,String xmlfile){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "INSERT INTO COLLECTION " +
                    "(XMLFILE,COMMODITY,ID) " +
                    "VALUES ('"+xmlfile+"', '"+commodity+"', '"+id+"')";
            System.out.println(sql);
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  boolean removeMyCollection(String id, String xmlfile){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "DELETE FROM COLLECTION WHERE XMLFILE ='"+xmlfile+"' and ID ='"+id+"'";
            System.out.println(sql);
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  boolean clearCollection(String id){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "DELETE FROM COLLECTION WHERE ID ='"+id+"'";
            System.out.println(sql);
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  String getCollectionIndex(String id){
        DBBridge bridge = new DBBridge();
        String indexes = "";
        try{
            String sql = "select XMLFILE from COLLECTION where ID ='"+id+"' ORDER BY COMMODITY, NUM";
            //ResultSet rs = DBConnector.getInstance().stmt.executeQuery(sql);
            ResultSet rs = bridge.getStmt().executeQuery(sql);
            while (rs.next()){
                String xmlfile = rs.getString("XMLFILE");
                indexes = indexes+xmlfile+"%";
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return indexes;
    }

    public  Vector getMyCollection(String id){
        DBBridge bridge = new DBBridge();
        Vector TradeInfo = new Vector();
        try{
            String sql = "SELECT COLLECTION.XMLFILE, COLLECTION.COMMODITY,JIAOYIXINXI.TRADE, JIAOYIXINXI.DESCRIPTION," +
                    "JIAOYIXINXI.CONTACT, JIAOYIXINXI.POSTDATE, BBSXINXI.BBSNAME," +
                    "BBSXINXI.BOARDNAME, BBSXINXI.AUTHOR, BBSXINXI.ALIAS, BBSXINXI.IP" +
                    " FROM COLLECTION INNER JOIN  JIAOYIXINXI ON COLLECTION.XMLFILE = JIAOYIXINXI.XMLFILE AND COLLECTION.COMMODITY=JIAOYIXINXI.COMMODITY "+
                    "INNER JOIN  BBSXINXI ON COLLECTION.XMLFILE = BBSXINXI.XMLFILE AND COLLECTION.COMMODITY=JIAOYIXINXI.COMMODITY WHERE (COLLECTION.ID = '"+id+"') "+
                    "ORDER BY COLLECTION.COMMODITY, COLLECTION.NUM";
            System.out.println(sql);
            ResultSet rs = bridge.getStmt().executeQuery(sql);
            bridge.setConnectionSwitch("off");
            while (rs.next()){
                String XMLFile = comTool.getChineseStr(rs.getString("XMLFILE"));
                String Commodity = comTool.getChineseStr(rs.getString("COMMODITY"));
                int Trade = rs.getInt("TRADE");
                String Description = comTool.getChineseStr(rs.getString("DESCRIPTION"));
                String Contact = comTool.getChineseStr(rs.getString("CONTACT"));
                String PostDate = comTool.getChineseStr(rs.getString("POSTDATE"));
                PostDate = PostDate.substring(0,PostDate.length()-2);
                String Bbsname = comTool.getChineseStr(rs.getString("BBSNAME"));
                String Boardname = comTool.getChineseStr(rs.getString("BOARDNAME"));
                String Author = comTool.getChineseStr(rs.getString("AUTHOR"));
                String Alias = comTool.getChineseStr(rs.getString("ALIAS"));
                String Ip = comTool.getChineseStr(rs.getString("IP"));
                String tradeinfo = "COLLECTIONINFO"+"%"+Trade+"%"+Commodity+"%"+Description+"%"+Contact+"%"+PostDate+"%"+XMLFile
                        +"%"+Bbsname+"%"+Boardname+"%"+Author+"%"+Alias+"%"+Ip;
                TradeInfo.add(tradeinfo);
            }
            return TradeInfo;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return null;
    }

    public static void main(String[] args) {
        //UserCollection.getMyCollection("coco");
    }

}