ofm-ticket-handle-service/handle-service/src/main/java/com/gccloud/handle/service/afOrder/impl/EeOperationHangupHandleServiceImpl.java
DELETE FROM item_cat WHERE id=“二级id” ##删除的是二级id
DELETE FROM item_cat WHERE parientId =“二级id” ###删除的是三级id
DELETE FROM item_cat WHERE id=“一级id” OR parientId=“一级id” ###删除的是二级id和三级id
or指只要数据库有了or前面的连接条件直接失效(只针对于查询条件)
//日期格式转为String类型的写法
dto.setCreatedTime(new DateTime().toString(“yyyy-MM-dd HH:mm:ss”));
dto.setModifiedTime(new DateTime().toString(“yyyy-MM-dd HH:mm:ss”));