gooddao.java

大象购物管理程序

package com.shopping.dao;

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

import com.comm.db.*;
import com.comm.vo.*;

public class GoodDao {

    public void add(GenericVO gvo) throws SQLException {
        String goodsId = gvo.getItemStr("GOODS_ID");
        String item = gvo.getItemStr("ITEM");

        String sql = "INSERT INTO good (goods_id, item) VALUES (?, ?)";
        Vector param = new Vector();
        param.addElement(goodsId);
        param.addElement(item);

        DBFactory.getDBI().execute(sql, param);
    }

    public void delete(int goodId) throws SQLException {
        String sql = "DELETE FROM good WHERE good_id=" + goodId;
        DBFactory.getDBI().execute(sql);
    }

    public Vector getByItem(String item) throws SQLException {
        String sql =
                "SELECT gs.*, g.good_id, b.logo1, gt.goodstype_id, gt.typename " +
                "FROM good g, goods gs, brand b, goodstype gt " +
                "WHERE gs.brand_id=b.brand_id AND gs.goodstype_id2=gt.goodstype_id " +
                "AND g.goods_id=gs.goods_id AND g.item='" +
                item + "' ORDER BY g.good_id DESC";
        return DBFactory.getDBI().getResult(sql);
    }
}