package com.shopping.dao;

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

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

public class PayMethodDao {

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

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

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

    public void modify(GenericVO gvo) throws SQLException {
        String payMethodId = gvo.getItemStr("PAYMETHOD_ID");
        String name = gvo.getItemStr("NAME");
        String description = gvo.getItemStr("DESCRIPTION");

        Vector param = new Vector();
        String sql =
                "UPDATE paymethod SET name = ?, description = ? WHERE paymethod_id = ?";
        param.addElement(name);
        param.addElement(description);
        param.addElement(payMethodId);

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

    public void delete(int payMethodId) throws SQLException {
        String sql = "DELETE FROM paymethod WHERE paymethod_id=" + payMethodId;

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

    public GenericVO getDetail(int payMethodId) throws SQLException {
        String sql = "SELECT * FROM paymethod WHERE paymethod_id=" +
                     payMethodId;

        Vector r = DBFactory.getDBI().getResult(sql);
        if (r.size() > 0) {
            return (GenericVO) r.elementAt(0);
        } else {
            return null;
        }
    }

    public Vector get() throws SQLException {
        String sql = "SELECT * FROM paymethod ORDER BY paymethod_id";

        return DBFactory.getDBI().getResult(sql);
    }
}