hibernate checkbox 根据id批量删除

来源：互联网发布：js是什么端语言编辑：程序博客网时间：2024/05/17 07:04

<td ><label class="i-checks"><input type="checkbox" name="subBox" value="${list.id}"><i></i></label></td><script type="text/javascript">$(function() {$("#del-vod").click(function() {var ids= new Array();var i=0;$("input:checkbox[name='subBox']:checked").each(function() { // 遍历name=test的多选框ids[i++]=$(this).val(); // 每一个被选中项的值});if(ids=="") {alert("请至少选择一条记录");return false;}if(window.confirm("确定删除吗？")) {window.location.href="deletes.do?ids="+ids; }});}) </script>

dao层

//该方法效率慢，生成多条HQL

public void deletes(List<Integer> idList) {for (Integer id : idList) {Timeliftinfo timeinfo = (Timeliftinfo)getSession().load(Timeliftinfo.class, id);if(timeinfo != null) {getSession().delete(timeinfo);}}}

//优化后，只生成一条HQL

public void deletes(List<Integer> idList) {String hql = "";for (int i = 0; i < idList.size(); i++) {if(i==0) {hql = "id="+idList.get(i);} else {hql =hql + " or id="+idList.get(i);}Session session= this.getSession();Query q= session.createQuery("delete from Timeliftinfo where "+hql);q.executeUpdate();}}

阅读全文

0 0