mybatis springmvc批量刪除程式碼分享-java教程-PHP中文網

首頁

Java

java教程

mybatis springmvc批量刪除程式碼分享

巴扎黑

Jul 24, 2017 pm 01:50 PM

mybatisspringmvc最新

服務層：

#@Override

public void batchDeletes(List list) {

##creditDao.batchDeletes(list);

#控制層控制器：

/**

* 批次刪除 batch
*/
# @RequestMapping(value="/batchDeletes")
@ResponseBody
## 公用清單 batchDeletes(HttpServletRequest 請求,HttpServletResponse 回應){
## String items = request.getParameter("creditIdbox");##String();
String[] strs = items.split(",");
for (String str : strs) {
delList.add(str);
# }
# # creditService。列出; list=creditService.queryUserInfo(null);
ModelAndView mv = new ModelAndView();
Map; model = new HashMap();
model.put("creditVOList", list);
mv.addAllObjects(model);
mv.addAllObjects(model);
# mv.setViewName("queryregister");
# return list;
}
mapper.xml:

DELETE FROM t_credit where t_credit_id in

. "item" open="("separator=","close=")">

#{item}

##>

#頁：

$(function(){

$("#button").click(function(){

var form=$("#registerform");

form.prop("action","http://localhost:8080/ssmy2/CreditController/intiqu.do");

# form.submit() ;

#});

//方式二：

/*$(function(){

$("#button").click(function(){

# document.registerform.action="http://localhost:8080/ssmy/CreditController/intiqu.do";

document.registerform.submit();

});**/

# //定死查詢按鈕

$("#status").val($("#statushidden").val());

});

function selectAll(){

if ($("#SelectAll").is(":checked")) {

$(":checkbox").prop("checked", true);//所有選擇方塊都選取

} else {

# } else {

# }”

## $(":checkbox").prop("checked", false);

###### }################## }#######################################################################################################################################################################################################1 }############ ###$(function(){############### $("#deleteuser").click(function() {############ //判斷至少寫了一項############ var checkedNum = $("input[name='creditIdbox']:checked" ) 。 ##### alert("請至少選擇一項!");############ ####### if(confirm("確定刪除所選項目?")){############ # var checkedList = new Array(##)# #### $("input[name='creditIdbox']:checked").each(function(){############ . );############ });############ 1 # $.ajax({########### # :"http://localhost:8080/ssmy2/CreditController /batchDeletes.do",#######

data:{"creditIdbox":checkedList.toString()},

# success:function(data){

$("[name='creditIdbox']:checkbox").attr("checked",#name='creditIdbox']:checkbox").attr("checked",#se='creditIdbox']:checkbox").attr("checked",#se='credit ## alert('成功中!');

# alert('刪除失敗!');

}

與 #

# /* var form=$("#registerform");

form.prop("action","http://localhost:8080/ssmy/CreditController/deleteuser.do" );

form.submit(); */

});

$ ("#exports").click(function(){

var form =$("#registerform");

# form. prop("action","http://localhost:8080/ssmy2/CreditController/exprotExcel.do");

form.submit();

# form.submit();

## });

$("#delete").click(function(){

var form =$("#registerform");

form.prop("action","http://localhost:8080/ssmy2/ CreditController/batchDeletes.do?creditIdbox=${credit.creditId}");

form.submit();

## });

# $("#uploadFile").click(function(){

var form =$("#registerform");

form.prop("action","http://localhost:8080/ssmy2/CreditController/uploadFile.do");

form.submit();

## });

});

"0" cellpadding="0" cellspacing="0">

全選

序列

登入名稱

確認密碼

##固定電話

手機號碼 & td >信箱

居住地址

## "address">提交狀態

建立時間 … td >作業

## :

: for:

卷

${status.index}

## ${credit.loginPwd}

${credit.IDCard}

相信

${credit.telephoneNumber}

;

${credit.address}

${credit.status ==0 ? '已提交':'未提交'}

${creditVO.createtime}

刪除

## #c:if test ="${empty CreditVOList }">

沒有任何員工資料。

############ ########### ## ####### ########

##服務層：@Override public void batchDeletes(List list) {creditDao.batchDeletes(list); } 控制層controller/** * 批次刪除 batch*/ @RequestMapping(value="/batchDeletes") @ResponseBody public List#Credit >batchDeletes(HttpServletRequest request,HttpServletResponse response){ String items = request.getParameter("creditIdbox");列表#String> delList = new ArrayList >(); String[] strs = items.split(","); for (String str : strs) { delList.add(str); } CreditService.batchDeletes(delList); List##Credit> list=creditService.queryUserInfo(null); ModelAndView mv = new ModelAndView();映射 model = new HashMap(); model.put("creditVOList", 列表); mv.addAllObjects(模型); mv.setViewName("queryregister");返回列表； }mapper.xml#delete #id##="batchDeletes" parameterType=##"java.util.List"#># 從t# 移除_ #credit where t_credit_id in #foreach collection ##="列表" 索引=##"index" item="item"# #open##="(" 分隔符號= ＃＃＃“ ＃＃＃，＃＃＃“＃＃＃＃＃##=")"#> #{item} ##foreach> # # 刪除>頁：## # #type##="text/javascript" src#= "../jquery/jquery-2.1.3.js"#>#腳本>腳本 ##type="text/javascript" src="../easyui/jquery.easyui.min.js"###>#########腳本># scripttype##="text/javascript" src#="../easyui/locale/easyui-lang-zh_CN.js" > 腳本># script ##type ="text/javascript" src##=##" ../easyui/js/index.js"#>########## ##>#######################="樣式表" 類型=##"text/css" href#="../easyui/themes/default/easyui . css" />### rel="stylesheet" type="text/css" href#="../easyui/themes/ icon.css" /># type##="text/javascript"> $(function(){ $("#button").click(function(){ var form=$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/intiqu.do"); form.submit(); }); //方式二： /*$(function(){ $("#button").click(function(){ document.registerform.action="http://localhost:8080/ssmy /CreditController/intiqu.do"; document.registerform.submit(); });**/ //對查詢按鈕定死狀態$("#status").val($("#statushidden").val( )); }); function selectAll(){ if ($("#SelectAll").is(":checked")) {# $( ":checkbox").prop("checked", true);//所有選擇框都選取 } else { $(":checkbox").prop("checked" , false); } } $(function(){# $("#deleteuser").click(function(){ //判斷至少寫了一項 var checkedNum = $("input[name='creditIdbox']:checked").length;# console.log (checkedNum); if(checkedNum==0){# alert("請至少選一項!"); return false; } if(confirm("確定刪除所選項目?")){# var checkedList = new Array(); $("input[name= 'creditIdbox']:checked").each(function(){ checkedList.push($(this).val()); }); console.log(checkedList[0]); $.ajax({ type:"POST", url:" http://localhost:8080/ssmy2/CreditController/batchDeletes.do", 資料:{"creditIdbox":checkedList.toString()}, 資料型態:"json", success:function(data){ $("[name='creditIdbox']:checkbox").attr("checked",false);alert('刪除成功!'); setTimeout("location.reload()",1000);//頁面重新整理 }, error:function(data){alert('刪除失敗!');# } }); } /* var form=$("#registerform"); form.prop("action","http://localhost:8080/ssmy/CreditController/deleteuser.do "); form.submit(); */ }); $("#exports").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/exprotExcel.do"); form.submit(); }); $("#delete").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/batchDeletes.do? CreditIdbox=${credit.creditId}"); form.submit(); }）； $("#uploadFile").click(function(){ var form =$("#registerform"); form.prop("action","http://localhost:8080/ssmy2/CreditController/uploadFile.do" ); 提交(); }); }）； ##腳本> head>##body> ;##div id#="head "##>form ##id#="註冊表格" 名稱 ##= ##"註冊表格" 操作="###"# #####方法#### ####=######"###post"#enctype="multipart/form-data" >###div class#=##"搜尋框" #風格="寬度：100% ;高度:40px;"#>標籤 > 登入名稱: label> 輸入#類型="文字" ##name##="loginName" id="登入名稱"/> label style= "margin-left:10px;"#>身分證:< ;/label> input type="text" name=" IDCard" id="IDCard" /> label style##="margin-left:10px;"#> 提交狀態:##label> select id#=##"狀態"#名稱#=##"狀態"#風格##="寬度:100px;高度:20px;" >##選項#值#=""##>全部選項 >##選項#值#="0 "##>已提交#選項###>##選項#值#=##"1"##>未提交##選項##>選擇>#輸入#類型##="按鈕" id#="#button"##value ##="查詢" 風格=##」寬度：65px；高度：22px；左距：20px；"/> input type="submit" id="exports" value="导出" style="width:65px;height:22px;margin-left:20px;"/>