productbo.java

bs_网上购物系统每个例子文件夹都附有数据库表、程序源文件和一个war包（或者jar包）。如果是cs结构的

package bo;

import java.util.*;

import myjdbc.*;
import struts.actionform.*;
import util.*;
import util.uid.*;
import vo.*;

public class ProductBo {
    private static ProductBo bo = null;
    private static DatabaseOperation db = null;
    private ProductBo() {
        db = DatabaseOperation.getInstance();
    }

    public static ProductBo getInstance() {
        if (bo == null) {
            bo = new ProductBo();
        }
        return bo;
    }

    /**
     * 获得所有的商品
     * @param form ManagedProductForm
     */
    public List getProductList() {
        return db.executeSQL("select * from products");
    }

    /**
     * 添加一个商品
     * @param form ManagedProductForm
     */
    public void addProduct(ManagedProductForm form) {
        StringBuffer sb = new StringBuffer();
        sb.append("insert into products values ('" + UUIDGener.getUUID() + "',");
        sb.append("'" + Util.convertEncoding(form.getName()) + "',");
        sb.append("'" + Util.convertEncoding(form.getNote()) + "',");
        sb.append("'" + Util.convertEncoding(form.getPrice()) + "')");
        db.executeSQL(sb.toString());
    }

    /**
     * 修改指定id的商品
     * @param form ManagedProductForm
     */
    public void editProdcut(ManagedProductForm form) {
        StringBuffer sb = new StringBuffer();
        sb.append("select * from products where productid = '" +
                  form.getProductId() + "'");
        List list = db.executeSQL(sb.toString());
        if (list.size() != 0) {
            Products product = (Products) list.get(0);
            form.setName(product.getName());
            form.setNote(product.getNote());
            form.setPrice(product.getPrice().toString());
            form.setProductId(product.getProductId());
        }
    }

    /**
     * 保存修改后的商品
     * @param form ManagedProductForm
     */
    public void saveEditProduct(ManagedProductForm form) {
        StringBuffer sb = new StringBuffer();
        sb.append("update products set name = ");
        sb.append("'" +Util.convertEncoding(form.getName()) + "',note = ");
        sb.append("'" + Util.convertEncoding(form.getNote()) + "',price = ");
        sb.append(Util.convertEncoding(form.getPrice()));
        sb.append(" where productid = '" + form.getProductId()+"'");
        db.executeSQL(sb.toString());
    }

    /**
     * 删除指定id的商品
     *
     * @param form ManagedProductForm
     */
    public void removeProduct(ManagedProductForm form) {
        db.executeSQL("delete from products where productid = '"+ form.getProductId()+"'");
    }


}