branddao.java

大象购物管理程序

package com.shopping.dao;

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

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

public class BrandDao {

    public void add(GenericVO gvo) throws SQLException {
        String name = gvo.getItemStr("NAME");

        Vector param = new Vector();
        String sql = "INSERT INTO brand (name) VALUES (?)";
        param.addElement(name);

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

    public void modify(GenericVO gvo) throws SQLException {
        String brandId = gvo.getItemStr("BRAND_ID");
        String name = gvo.getItemStr("NAME");

        Vector param = new Vector();
        String sql = "UPDATE brand SET name=? WHERE brand_id=?";
        param.addElement(name);
        param.addElement(brandId);

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

    public void delete(int brandId) throws SQLException {
        String sql = "DELETE FROM brand WHERE brand_id=" + brandId;
        DBFactory.getDBI().execute(sql);
    }

    public GenericVO getDetail(int brandId) throws SQLException {
        String sql = "SELECT * FROM brand WHERE brand_id=" + brandId;
        return (GenericVO) DBFactory.getDBI().getResult(sql).elementAt(0);
    }

    public Vector get() throws SQLException {
        String sql = "SELECT * FROM brand WHERE status=1 ORDER BY brand_id";
        return DBFactory.getDBI().getResult(sql);
    }

    public void updateLogo1(int brandId, String logo1) throws SQLException {
        String sql = "UPDATE brand SET logo1='" + logo1 + "' WHERE brand_id=" +
                     brandId;
        DBFactory.getDBI().execute(sql);
    }

    public void updateLogo2(int brandId, String logo2) throws SQLException {
        String sql = "UPDATE brand SET logo2='" + logo2 + "' WHERE brand_id=" +
                     brandId;
        DBFactory.getDBI().execute(sql);
    }
}