コード例 #1
0
 /**
  * 新增/修改婚嫁建议
  *
  * @param wedisleMarrySuggest
  * @throws Exception
  */
 public static void saveOrUpdateWedisleExistMarry(WedisleMarrySuggest wedisleMarrySuggest)
     throws Exception {
   if (isWedisleExistMarrySuggest(wedisleMarrySuggest.getYear(), wedisleMarrySuggest.getMonth())) {
     updateWedisleExistMarry(wedisleMarrySuggest);
   } else {
     saveWedisleExistMarry(wedisleMarrySuggest);
   }
 }
コード例 #2
0
 /**
  * 修改婚嫁建议
  *
  * @param wedisleMarrySuggest
  * @throws Exception
  */
 private static void updateWedisleExistMarry(WedisleMarrySuggest wedisleMarrySuggest)
     throws Exception {
   String sql =
       "update wedisle_marry_suggest set legal_from='"
           + wedisleMarrySuggest.getLegalFrom()
           + "',legal_end='"
           + wedisleMarrySuggest.getLegalEnd()
           + "',late_from='"
           + wedisleMarrySuggest.getLateFrom()
           + "',late_end='"
           + wedisleMarrySuggest.getLateEnd()
           + "' WHERE year="
           + wedisleMarrySuggest.getYear()
           + " AND month="
           + wedisleMarrySuggest.getMonth();
   DB.executeUpdate(sql);
 }
コード例 #3
0
 /**
  * 新增婚嫁建议
  *
  * @param wedisleMarrySuggest
  * @throws Exception
  */
 private static void saveWedisleExistMarry(WedisleMarrySuggest wedisleMarrySuggest)
     throws Exception {
   String sql =
       "insert into wedisle_marry_suggest"
           + "(year,month,legal_from,legal_end,late_from,late_end)"
           + "values"
           + "("
           + wedisleMarrySuggest.getYear()
           + ","
           + wedisleMarrySuggest.getMonth()
           + ",'"
           + wedisleMarrySuggest.getLegalFrom()
           + "','"
           + wedisleMarrySuggest.getLegalEnd()
           + "','"
           + wedisleMarrySuggest.getLateFrom()
           + "','"
           + wedisleMarrySuggest.getLateEnd()
           + "')";
   DB.executeUpdate(sql);
 }