goodsinfo_bean.java~22~

模仿Taobao购物网

package taobaoproject;

import java.sql.*;
import java.util.*;
import java.io.*;

public class GoodsInfo_Bean {
    private Connection conn;
    private PreparedStatement past;
    private ResultSet rst;
    private ArrayList class_List;
    private ArrayList goods_List;
    public Connection getConn() {
        DB_Bean dbBean = new DB_Bean();
        conn = dbBean.getConn();
        return conn;
    }

    public PreparedStatement getPast() {
        return past;
    }

    public ResultSet getRst() {
        return rst;
    }

    public ArrayList getGoods_List(int goodsID,int classID,int iserfinement,int isHot,int isDiscount) {
        String sql = "select * from tb_GoodsInfo where 1 = 1";
        if(goodsID != -1)
            sql += " and GoodsID = " +goodsID;
        if(classID != -1)
            sql += " and ClassID = " +classID;
        if(iserfinement != -1)
            sql += " and Iserfinement = " +iserfinement;
        if(isHot != -1)
            sql += " and IsHot = " +isHot;
        if(isDiscount != -1)
            sql += " and IsDiscount = " +isDiscount;
        sql += " order by AddDate";

        return goods_List;
    }

    public ArrayList getClass_List(String id) {
        String sql = "select * from tb_Class where ";
        if(id != "") {
            sql =sql + "ClassID=" + id;
        }
        else {
            sql += "1=1";
        }
        getConn();
        class_List = new ArrayList();
        java.lang.System.out.print(sql);
        try {
            past = conn.prepareStatement(sql);
            rst = past.executeQuery();
            while(rst.next())
            {
                GoodsBean goodBean = new GoodsBean();
                goodBean.setClassID(rst.getInt("ClassID"));
                goodBean.setClassName(rst.getString("ClassName"));
                class_List.add(goodBean);
            }
        } catch (SQLException ex) {
            java.lang.System.out.print(ex);
        }
        try {
            rst.close();
            past.close();
            conn.close();
        } catch (SQLException ex1) {
        }
        return class_List;
    }

    public String getGBK(String str)
    {
        try {
            String ff = new String(str.getBytes("ISO-8859-1"),"GBK");
            return ff;
        } catch (UnsupportedEncodingException ex) {
            return "";
        }
    }
}