remitdao.java

大象购物系统

package com.shopping.dao;

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

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

public class RemitDao {

    public void add(GenericVO gvo) throws SQLException {
        String userId = gvo.getItemStr("USER_ID");
        String orderId = gvo.getItemStr("ORDER_ID");
        String payMethodId = gvo.getItemStr("PAYMETHOD_ID");
        String remitTime = gvo.getItemStr("REMITTIME");
        String remitMoney = gvo.getItemStr("REMITMONEY");
        String description = gvo.getItemStr("DESCRIPTION");
        Timestamp createTime = new Timestamp(System.currentTimeMillis());

        Vector param = new Vector();
        String sql = "INSERT INTO remit " +
                     "(order_id, user_id, paymethod_id, remittime, remitmoney, " +
                     "description, createtime) " +
                     "VALUES (?, ?, ?, ?, ?, ?, ?)";
        param.addElement(orderId);
        param.addElement(userId);
        param.addElement(payMethodId);
        param.addElement(remitTime);
        param.addElement(remitMoney);
        param.addElement(description);
        param.addElement(createTime);
        DBFactory.getDBI().execute(sql, param);
    }
}