addressdao.java

大象购物管理程序

package com.shopping.dao;

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

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

public class AddressDao {

    public void add(GenericVO gvo) throws SQLException {

        String userId = gvo.getItemStr("USER_ID");
        String name = gvo.getItemStr("NAME");
        String address = gvo.getItemStr("ADDRESS");
        String post = gvo.getItemStr("POST");
        String tel = gvo.getItemStr("TEL");
        String mobile = gvo.getItemStr("MOBILE");

        Vector param = new Vector();
        String sql =
                "INSERT INTO address (user_id, name, address, post, tel, mobile) " +
                "VALUES (?, ?, ?, ?, ?, ?)";
        param.addElement(userId);
        param.addElement(name);
        param.addElement(address);
        param.addElement(post);
        param.addElement(tel);
        param.addElement(mobile);

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

    public void modify(GenericVO gvo) throws SQLException {

        String addressId = gvo.getItemStr("ADDRESS_ID");
        String name = gvo.getItemStr("NAME");
        String address = gvo.getItemStr("ADDRESS");
        String post = gvo.getItemStr("POST");
        String tel = gvo.getItemStr("TEL");
        String mobile = gvo.getItemStr("MOBILE");

        Vector param = new Vector();
        String sql = "UPDATE address SET name=?, address=?, post=?, tel=?, mobile=? WHERE address_id=?";
        param.addElement(name);
        param.addElement(address);
        param.addElement(post);
        param.addElement(tel);
        param.addElement(mobile);
        param.addElement(addressId);

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

    public Vector getByUserId(int userId) throws SQLException {
        String sql = "SELECT * FROM address WHERE user_id=" + userId;
        return DBFactory.getDBI().getResult(sql);
    }

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