public NoticeVO getTitleInfo(int no) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
NoticeVO notice = (NoticeVO) sqlmap.queryForObject("getTitleInfo", no);
return notice;
}
public List<NoticeVO> getNoticeRange(HashMap<String, Object> range) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
List<NoticeVO> list = sqlmap.queryForList("getNoticeRange", range);
return list;
}
public int getTotalRow(int no) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
int totalRow = (Integer) sqlmap.queryForObject("getTotalRow", no);
return totalRow;
}
public String coachCheck(int memNo) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
String check = (String) sqlmap.queryForObject("coachCheck", memNo);
return check;
}
public void updateNotice(HashMap<String, Object> update) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
sqlmap.update("updateNotice", update);
}
public void deleteNotice(int no) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
sqlmap.delete("deleteNotice", no);
}
public void getHate(int no) throws Exception {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
sqlmap.update("getHate", no);
}
public void addNewNotice(NoticeVO notice) throws SQLException {
SqlMapClient sqlmap = IbatisUtil.getSqlmap();
sqlmap.insert("addNewNotice", notice);
}