goodstypedao.java

大象购物管理程序

package com.shopping.dao;

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

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

public class GoodsTypeDao {

    public void add(GenericVO gvo) throws SQLException {
        String typeName = gvo.getItemStr("TYPENAME");
        String parentId = gvo.getItemStr("PARENTID");

        Vector param = new Vector();
        String sql = "";
        if (parentId.length() == 0) {
            sql = "INSERT INTO goodstype (typename) VALUES(?)";
            param.addElement(typeName);
        } else {
            sql = "INSERT INTO goodstype (typename, parentid) VALUES(?, ?)";
            param.addElement(typeName);
            param.addElement(parentId);
        }
        DBFactory.getDBI().execute(sql, param);
    }

    public void modify(GenericVO gvo) throws SQLException {
        String goodsTypeId = gvo.getItemStr("GOODSTYPE_ID");
        String typeName = gvo.getItemStr("TYPENAME");

        Vector param = new Vector();
        String sql =
                "UPDATE goodstype SET typename=? WHERE goodstype_id=?";
        param.addElement(typeName);
        param.addElement(goodsTypeId);
        DBFactory.getDBI().execute(sql, param);
    }

    public void delete(int goodsTypeId) throws SQLException {
        String sql =
                "DELETE FROM goodstype WHERE goodstype_id=" + goodsTypeId;
        DBFactory.getDBI().execute(sql);
    }

    public Vector getTop() throws SQLException {
        String sql =
                "SELECT * FROM goodstype WHERE parentid IS NULL ORDER BY goodstype_id";
        return DBFactory.getDBI().getResult(sql);
    }

    public GenericVO getDetail(int goodsTypeId) throws SQLException {
        String sql =
                "SELECT * FROM goodstype gt WHERE goodstype_id=" + goodsTypeId;
        Vector r = DBFactory.getDBI().getResult(sql);
        if (r.size() > 0) {
            return (GenericVO) r.elementAt(0);
        } else {
            return null;
        }
    }

    public Vector getByPid(int parentId) throws SQLException {
        String sql = "SELECT * FROM goodstype WHERE parentid = " + parentId +
                     " ORDER BY goodstype_id";
        return DBFactory.getDBI().getResult(sql);
    }
}