遇到要从数据库删除某一字段为nodeId或 L+nodeId开头的所有记录
这个任务分两步
1 找到要删除的所有记录
2 执行批量删除
代码片断如下:
List<DirNode> dirList = getHibernateTemplate().find("from DirNode where nodeId=? or nodeId like ?",
new String[]{Integer.toString(id),"L"+id+"%"});
if (dirList != null)
{
this.getHibernateTemplate().deleteAll(dirList);
log.Info("##### delete succussfully");
return true;
}
else
{
log.Info("##### delete UNsuccussfully");
return false;
}