public int insert(ThesysShipFeeVO vo) throws SQLException {
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
int r = 0;
try {
con = getConnection();
String sql =
" INSERT INTO LAPHONE_SHIP_FEE(SITE_ID, FEE_TYPE, COND_END, FEE_AMT, CRT_USR_ID, CRT_DATE, LM_USR_ID, LM_DATE) "
+ " VALUES(?, ?, ?, ?, ?, ?, ?, ?)";
stmt = con.prepareStatement(sql);
int idx = 1;
stmt.setString(idx++, vo.getSiteId());
stmt.setInt(idx++, vo.getFeeType());
stmt.setInt(idx++, vo.getConditionEnd());
stmt.setInt(idx++, vo.getFeeAmount());
stmt.setString(idx++, vo.getCreater());
stmt.setTimestamp(idx++, convert(vo.getCreateDate()));
stmt.setString(idx++, vo.getLastUpdater());
stmt.setTimestamp(idx++, convert(vo.getLastUpdatedDate()));
r = stmt.executeUpdate();
} finally {
closeAll(con, stmt, rs);
}
return r;
}
public int update(ThesysShipFeeVO vo) throws SQLException {
int res = 0;
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "";
try {
con = getConnection();
sql =
"UPDATE LAPHONE_SHIP_FEE SET FEE_AMT=?,LM_USR_ID=?,LM_DATE=? WHERE FEE_TYPE=? AND COND_END=?";
stmt = con.prepareStatement(sql);
// 寫入一筆資料
int idx = 1;
stmt.setInt(idx++, vo.getFeeAmount());
stmt.setString(idx++, vo.getLastUpdater());
stmt.setTimestamp(idx++, convert(vo.getLastUpdatedDate()));
stmt.setInt(idx++, vo.getFeeType());
stmt.setInt(idx++, vo.getConditionEnd());
res = stmt.executeUpdate();
} finally {
closeAll(con, stmt, rs);
}
return res;
}
