用js获取要删除的数据的checkbox数组string[] ,把string[]变成string ,每个id用逗号隔开,delete方法中写 delete xxxx from xxx where xxx in string就可以了
String sql="delete from table where id in(0"; String id[]=要删除的ID数组; for(int i=0;i <id.length;i++) { sql+=","+id[i]; } sql+=")"; PreparedStatement ps=conn.prepareStatement(sql); ps.execute();
我在actionfrom里我定义的属性是这样的啊 Integer[] selects行不
attempt to create delete event with null entity at org.hibernate.event.DeleteEvent.<init>(DeleteEvent.java:24) at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:739) at org.springframework.orm.hibernate3.HibernateTemplate$25.doInHibernate(HibernateTemplate.java:790) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372) at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:784) at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:780) at com.iCharms.comm.impl.BeanDAOImpl.delect(BeanDAOImpl.java:69) at com.iCharms.admin.productComment.dao.impl.ProductCommentServerDAO.deleteComment(ProductCommentServerDAO.java:37) at com.iCharms.admin.productComment.biz.impl.ProductCommentServiceImpl.deleteComment(ProductCommentServiceImpl.java:31) at com.iCharms.struts.admin.action.CommentAction.deleteComment(CommentAction.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)这个错误啊
我删除的时候用的是hibernate的 public CommentModel getComment(Integer id);
public void deleteComment(CommentModel commentModel); 我先存在CommentModel 里 在删除CommentModel 里的值 行不啊
直接DELETE就可以了阿。.或者你自己写一个删除的方法.我给代码你. //删除 public void delete(int id) {
jsp 将被删除记录的 id 封装,传给控制器,控制器调用相关业务处理类直接通过 dao 删除了
delete from dddd where id between 1 and 4
我这个网站是用ssh框架做的
就是点全选时,把选中的按钮批量删除数据。
要求就是这样的
全选..
function qx(){
if(!form1.selects.length){form1.selects.checked=true;}
for(var i = 0; i < form1.selects.length;i++)
{ form1.selects[i].checked=true;}
}jsp里面的.删除选中..
<input type="submit" value="删除选中" onclick="function getSelectCount() {
var count=0;
if(!form1.selects.length){
if(form1.selects.checked==true)
{count++; }
return count;
}
for(var i=0;i < form1.selects.length;
i++)
{
if(form1.selects[i].checked==true){
count++;
}
}
return count;
}
if(getSelectCount()==0)
{ alert('请选择项您要是删除的记录!'); return false; }
if(confirm('真的要删除选中内容?'))form1.selects.submit()"/>Action里面取到selects.也就是.<input type="checkbox" name="selects" value="<bean:write name="ho" property="id" />" /> HouseRentsImpl houImp = new HouseRentsImpl();
Integer[] iid = houserentsDeleAllForm.getSelects();
for(Integer id:iid){
houImp.delete((int)id);
}
这样子就可以了..哈哈 超简单的..要加分哦 LZ..
你能说主体的吗
是阿 getSelects() 就是name="selects"阿.<input type="checkbox" name="selects" value=" <bean:write name="ho" property="id" />" /> 还没有搞定吗?
,把string[]变成string ,每个id用逗号隔开,delete方法中写 delete xxxx from xxx where xxx in string就可以了
String id[]=要删除的ID数组;
for(int i=0;i <id.length;i++)
{
sql+=","+id[i];
}
sql+=")";
PreparedStatement ps=conn.prepareStatement(sql);
ps.execute();
at org.hibernate.event.DeleteEvent.<init>(DeleteEvent.java:24)
at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:739)
at org.springframework.orm.hibernate3.HibernateTemplate$25.doInHibernate(HibernateTemplate.java:790)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:784)
at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:780)
at com.iCharms.comm.impl.BeanDAOImpl.delect(BeanDAOImpl.java:69)
at com.iCharms.admin.productComment.dao.impl.ProductCommentServerDAO.deleteComment(ProductCommentServerDAO.java:37)
at com.iCharms.admin.productComment.biz.impl.ProductCommentServiceImpl.deleteComment(ProductCommentServiceImpl.java:31)
at com.iCharms.struts.admin.action.CommentAction.deleteComment(CommentAction.java:96)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)这个错误啊
public CommentModel getComment(Integer id);
public void deleteComment(CommentModel commentModel);
我先存在CommentModel 里
在删除CommentModel 里的值
行不啊
public void delete(int id) {
Session s = HibernateSessionFactory.getSession();
Transaction tr = s.beginTransaction();
Object obj = findById(id);
s.delete(obj);
s.flush();
tr.commit(); }自己好好理清思路了在写.