/** * 대상자를 보여준다. * * @param targetID * @return * @throws DataAccessException */ public TargetList viewTargetList(int targetID) throws DataAccessException { TargetList targetList = new TargetList(); Map<String, Object> resultMap = null; String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.viewtargetinfo"); Map<String, Object> param = new HashMap<String, Object>(); param.put("targetID", new Integer(targetID)); // SQL문이 실행된다. try { resultMap = getSimpleJdbcTemplate().queryForMap(sql, param); } catch (EmptyResultDataAccessException e1) { } if (resultMap != null) { targetList.setTargetID(Integer.parseInt(String.valueOf(resultMap.get("targetID")))); targetList.setTargetName((String) resultMap.get("targetName")); targetList.setDescription((String) resultMap.get("description")); targetList.setUserID((String) resultMap.get("userID")); targetList.setGroupID((String) resultMap.get("groupID")); targetList.setBookMark((String) resultMap.get("bookMark")); targetList.setShareType((String) resultMap.get("shareType")); targetList.setShareID((String) resultMap.get("shareID")); targetList.setTargetType((String) resultMap.get("targetType")); targetList.setTargetGroupID(Integer.parseInt(String.valueOf(resultMap.get("targetGroupID")))); } return targetList; }