列表的批量删除,案例使用前端ext框架,其他都可,具体代码如下:
----xml--------sql-------
<!-- 删除列表 -->
<delete id="commonResourceConfig_delete" parameterClass="java.util.List">
delete from commonResourceConfig
<dynamic prepend="where">
<iterate open=" id in (" close=")" conjunction=",">
#ids[]#
</iterate>
</dynamic>
</delete>
---------------dao---------
public void commonResourceConfigDelete(List<String> ids)throws Exception{
this.getSqlMapClient().delete("commonResourceConfig_delete", ids);
}
-------------service-----------
public boolean commonResourceConfigDelete(List<String> ids){
try {
getCommonResourceConfigDao().commonResourceConfigDelete(ids);
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
----------------action-------------------------
//删除列表,
public String deleteCommonResourceConfig(){
boolean flag = false;
try{
String ids = Struts2Utils.getParameter("ids");
if(null != ids && ids.length() >0){
this.getCommonResourceConfigService().commonResourceConfigDelete(Arrays.asList(ids.split(",")));
}else {
throw new Exception("没有选择要删除的信息");
}
flag = true;
}catch(Exception e){
flag = false;
logger.error("删除失败 ", e);
}
Struts2Utils.renderJson(flag);
return null;
}
-----------------------jsp&js--------------------
注:ids获取的是列表的主键id,使用复选框,获取选中的id
{
text : '删除',
xtype:"cirbutton",
iconCls:"circle-delete",
handler : function() {
var ids = getCheckArrId("ckb");
if (ids.length > 0) {
Ext.Msg.confirm('确认','确认删除选中的项??',function(btn){
if('yes'==btn){
Ext.Ajax.request({
url:'commonResourceConfigAction!deleteCommonResourceConfig.do',
params :{ids:ids.join()},
success:function(flag){
ds1.load({
params:{
start:0,
limit:20
}
});
_alert('删除成功');
},
failure:function(flag){
_alert('删除失败');
}
});
}
else{
return false;
}
});
}else{
_alert("请至少选择一列删除!");
}
}
}