@Override
 public int deleteCruiseSequenceByCruise(int cruiseid) {
   int res = 0;
   Object rows = sqlmapclienttemplate.delete("deleteCruiseSequenceByCruise", cruiseid);
   if (rows != null && Integer.class.isInstance(rows)) {
     res = Integer.parseInt(rows.toString());
   }
   return res;
 }
Exemple #2
0
  public void delete(long no, long member_no) {
    System.out.println(no + " : " + member_no);
    // 두개 이상을 넘길때 Map를 사용해라
    Map<String, String> map = new HashMap<String, String>();

    map.put("no", String.valueOf(no));
    map.put("member_no", String.valueOf(member_no));

    System.out.println(map);
    sqlMapClientTemplate.delete("board.delete", map);
    // String sql = "DELETE FROM guest_table WHERE no=? AND password=?";

    /*public BoardVo getView(long no){
    //System.out.println("BoardDao getView : " + no);
    BoardVo vo = (BoardVo) sqlMapClientTemplate.queryForObject("board.getView", no);
    return vo;*/

    // System.out.println("boardDao : " + boardVo);
    // sqlMapClientTemplate.insert("board.updateform", boardVo);
    /*
    		String sql = "insert into board values (board_no_seq.nextval, ?, ?, ?, ?, 0, sysdate, ?, ?, ?)";
    */
  }
 public int delete(Object obj) throws DataAccessException {
   logger.debug("Ruuning statement: " + namespace + DELETE);
   validateNameSpace();
   return sqlMapClientTemplate.delete(namespace + DELETE, obj);
 }
Exemple #4
0
 public void removeSysLog(Long id) {
   SysLogDto dto = new SysLogDto();
   dto.setId(id);
   sqlMapClientTemplate.delete("removeSysLogById", dto);
 }
Exemple #5
0
 public int removeOrder(SysOrderDto dto) {
   return sqlMapClientTemplate.delete("removeOrder", dto);
 }
 public void deleteCertAccessHistoryByPersonalCertId(String ids) {
   sqlMapClientTemplate.delete("deleteCertAccessHistoryByPersonalCertId", ids);
 }
 public void deleteCertAccessHistory(Long id) {
   sqlMapClientTemplate.delete("deleteCertAccessHistory", id);
 }