예제 #1
0
 /**
  * 대상자그룹등록
  *
  * @param targetList
  * @return
  * @throws DataAccessException
  */
 public int insertTargetList(TargetList targetList) throws DataAccessException {
   String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.insert");
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("targetName", targetList.getTargetName());
   param.put("description", targetList.getDescription());
   param.put("userID", targetList.getUserID());
   param.put("bookMark", targetList.getBookMark());
   param.put("shareType", targetList.getShareType());
   param.put("shareID", targetList.getShareID());
   param.put("targetType", targetList.getTargetType());
   param.put("upload_key", targetList.getUploadKey());
   param.put("dbID", targetList.getDbID());
   param.put("queryText", targetList.getQueryText());
   param.put("countQuery", targetList.getCountQuery());
   param.put("targetCount", targetList.getTargetCount());
   param.put("directText", targetList.getDirectText());
   param.put("state", targetList.getState());
   param.put("sendedDate", targetList.getSendedDate());
   param.put("successYN", targetList.getSuccessYN());
   param.put("openYN", targetList.getOpenYN());
   param.put("clickYN", targetList.getClickYN());
   param.put("rejectcallYN", targetList.getRejectcallYN());
   param.put("connectedDbID", targetList.getConnectedDbID());
   param.put("massmailGroupID", targetList.getMassmailGroupID());
   param.put("targetGroupID", targetList.getTargetGroupID());
   param.put("targetUIID", targetList.getTargetUIID());
   return getSimpleJdbcTemplate().update(sql, param);
 }
예제 #2
0
 public int updateTargetList(TargetList targetList) throws DataAccessException {
   String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.update");
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("targetID", targetList.getTargetID());
   param.put("targetName", targetList.getTargetName());
   param.put("description", targetList.getDescription());
   param.put("shareType", targetList.getShareType());
   param.put("shareID", targetList.getShareID());
   param.put("targetType", targetList.getTargetType());
   param.put("dbID", targetList.getDbID());
   param.put("queryText", targetList.getQueryText());
   param.put("countQuery", targetList.getCountQuery());
   param.put("targetCount", targetList.getTargetCount());
   param.put("targetGroupID", targetList.getTargetGroupID());
   return getSimpleJdbcTemplate().update(sql, param);
 }