package ppp.dao;
import java.sql.Connection;
import ppp.exception.AppSQLException;
public class CustomerInsertDAO extends UpdateNoTxDAOBase {
private static final String SQL_BASE
= "INSERT INTO customer" + " (customer_id, company_name, address, telno, dept, customer_name, customer_kana, email, password, last_id, last_time, delete_flag)" +
" VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, false)";
super(conn);
}
@Override
protected String makeSql
(Object[] params
) throws AppSQLException
{
if (params == null || params.length != 10) {
throw new AppSQLException("パラメータ数が不正です");
}
System.
out.
println(SQL_BASE.
toString()); return SQL_BASE;
}
}
最終更新:2013年06月08日 15:44