Example #1
0
  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;
  }
Example #2
0
 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;
 }
Example #3
0
  public List<ThesysShipFeeVO> listByFeeType(String siteId, int feeType) throws SQLException {
    Connection con = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    List<ThesysShipFeeVO> result = new ArrayList<ThesysShipFeeVO>();

    try {
      con = getConnection();
      String sql =
          "SELECT * FROM LAPHONE_SHIP_FEE where SITE_ID=?  AND FEE_TYPE=? ORDER BY COND_END";
      stmt = con.prepareStatement(sql);
      stmt.setString(1, siteId);
      stmt.setInt(2, feeType);
      rs = stmt.executeQuery();
      while (rs.next()) {
        result.add(ThesysShipFeeVO.getInstance(rs));
      }
    } finally {
      closeAll(con, stmt, rs);
    }
    return result;
  }
Example #4
0
 public ThesysShipFeeVO getRow(String siteId, int feeType, int conditionEnd) throws SQLException {
   Connection con = null;
   PreparedStatement stmt = null;
   ResultSet rs = null;
   ThesysShipFeeVO result = null;
   try {
     con = getConnection();
     String sql =
         "SELECT top 1 * FROM LAPHONE_SHIP_FEE where SITE_ID=? AND FEE_TYPE=? AND  COND_END=? ORDER BY COND_END";
     stmt = con.prepareStatement(sql);
     int idx = 1;
     stmt.setString(idx++, siteId);
     stmt.setInt(idx++, feeType);
     stmt.setInt(idx++, conditionEnd);
     rs = stmt.executeQuery();
     if (rs.next()) {
       result = ThesysShipFeeVO.getInstance(rs);
     }
   } finally {
     closeAll(con, stmt, rs);
   }
   return result;
 }