SSH批量删除数据！

Question

请问下各位，你们在用SSH批量删除数据是怎么样优化的？谢谢

Answer 1

[code="java"]
public String staffDel() throws IOException{
String pid = Param.get("pid");
pid = pid.replace(",", "','");
try {
String hql = "delete BsStaff where staffNo in ('"+pid+"')";
bsStaffService.hqlExecuteUpdate(hql, null);
log.warn("操作员："+Param.getUserStaffName()+"\t删除了员工staffNo为:" + pid);
return staffList();
} catch (Exception e) {
PrintWriter out = ServletActionContext.getResponse().getWriter();
out.println("&quot;);<br> out.println(&quot;alert(&#39;删除失败，此记录已被其他信息引用！&#39;);location=&#39;&quot;+Param.getAction(&quot;staff!staffList.action&quot;)+&quot;&#39;&quot;);<br> out.println(&quot;");
return null;
}
}
[/code]