@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;
}
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);
}
public void removeSysLog(Long id) {
SysLogDto dto = new SysLogDto();
dto.setId(id);
sqlMapClientTemplate.delete("removeSysLogById", dto);
}
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);
}