commodityinfo.java

用java实现的一个bbs的portal

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Jul 22, 2003
 * Time: 1:12:57 PM
 * To change this template use Options | File Templates.
 */
package Kernel;

import DBConnection.DBBridge;

import java.util.Vector;
import java.util.Enumeration;
import java.util.StringTokenizer;
import java.sql.ResultSet;

public class CommodityInfo {
    private String CommodityNo;
    private String Commodity;
    private String Kind;
    private String KindName;

    private synchronized static Vector getAllKindVec(){
        DBBridge bridge = new DBBridge();
        Vector kindVec = new Vector();
        try{
            String sql = "select * from KIND,COMMODITY where KIND.KIND = COMMODITY.KIND order by KIND.KIND asc";
            //ResultSet rs = DBConnector.getInstance().stmt.executeQuery(sql);
            ResultSet rs = bridge.getStmt().executeQuery(sql);
            while (rs.next()){


                String Name = comTool.getChineseStr(rs.getString("NAME"));
                String Commodity = comTool.getChineseStr(rs.getString("COMMODITY"));
                String kindInfo = Name + "|" + Commodity;
                kindVec.add(kindInfo);
            }
            bridge.setConnectionSwitch("off");
            return kindVec;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return null;
    }

    public synchronized static String getAllKind(){
        Vector kindVec = getAllKindVec();
        String kindStr = "";
        if (kindVec == null)
            return kindStr;
        String lastkind = "";
        String kind = "";
        String commodity = "";
        for (Enumeration e = kindVec.elements(); e.hasMoreElements();) {
            String kindVecStr = (String)e.nextElement();
            StringTokenizer st = new StringTokenizer(kindVecStr,"|");
            if (st.hasMoreTokens()){
                kind = st.nextToken();
                commodity = st.nextToken();
            }
            if (!lastkind.equals(kind)){
                kindStr = kindStr + "%" + kind + "|"+commodity;
                lastkind = kind;
            }else kindStr = kindStr + "#"+commodity;
        }
        return kindStr;
    }

    public String getCommodityNo() {
        return CommodityNo;
    }

    public String getCommodity() {
        return Commodity;
    }

    public String getKind() {
        return Kind;
    }

    public String getKindName() {
        return KindName;
    }

    public static void main(String[] args) {
       System.out.println(CommodityInfo.getAllKind());
    }
}