Пример #1
0
  public NoticeVO getTitleInfo(int no) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    NoticeVO notice = (NoticeVO) sqlmap.queryForObject("getTitleInfo", no);

    return notice;
  }
Пример #2
0
  public List<NoticeVO> getNoticeRange(HashMap<String, Object> range) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    List<NoticeVO> list = sqlmap.queryForList("getNoticeRange", range);

    return list;
  }
Пример #3
0
  public int getTotalRow(int no) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    int totalRow = (Integer) sqlmap.queryForObject("getTotalRow", no);

    return totalRow;
  }
Пример #4
0
  public String coachCheck(int memNo) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    String check = (String) sqlmap.queryForObject("coachCheck", memNo);
    return check;
  }
Пример #5
0
  public void updateNotice(HashMap<String, Object> update) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    sqlmap.update("updateNotice", update);
  }
Пример #6
0
  public void deleteNotice(int no) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    sqlmap.delete("deleteNotice", no);
  }
Пример #7
0
  public void getHate(int no) throws Exception {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    sqlmap.update("getHate", no);
  }
Пример #8
0
  public void addNewNotice(NoticeVO notice) throws SQLException {

    SqlMapClient sqlmap = IbatisUtil.getSqlmap();
    sqlmap.insert("addNewNotice", notice);
  }