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

首頁

Java

java教程

mybatis springmvc批量刪除程式碼分享

Jul 24, 2017 pm 01:50 PM

mybatis springmvc 最新

服務層：

#@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}

##>

#頁：

<腳本類型=“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 {

# } 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();

## });

});

</script>

</head>

<body>

</select>

</div>

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

<td>

& td >信箱</td>

## "address">提交狀態</td>

</tr>

## : <

: <

for: < "${creditVOList}" varStatus="status">

卷<td><input type="checkbox" name="creditIdbox" id="creditIdbox" value="${credit.creditId }"></td>

<td>${status.index}</td>

<td> ## <td>${credit.loginPwd}</td>

<td>

<td>${credit.IDCard}</td>

相信< ;

<td>${credit.telephoneNumber}</td>

; </td>

<td id="address">${credit.address}</td>

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

${creditVO.createtime}

刪除

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

沒有任何員工資料。 <br/>

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

##服務層：@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;"#>身分證:&lt ;/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;"/> </div> <input type="hidden" name="status" id="statushidden" value="${status }" /> <input type="hidden" name="totalcount" id="totalcount" value= "${totalcount }" /> <table border="0" cellpadding="0" cellspacing="0"> <tr style="width:100%; height: 50px;"> <td> ; <input type="checkbox" id="SelectAll" name="SelectAll" onclick="selectAll();" style="margin-right:5px;"/>全選</td> <td> <td&gt ;序列</td> <td >登入名稱</td> <td >登入密碼</td> <td >確認密碼</td> <td >身分證;td >身分證;td >確認密碼</td> <td >身分證;td >身分證;號</td> <td >固定電話</td> <td >手機號碼</td> <td >信箱</td> <td >住址< /td> <td id="address">提交狀態</td> <td >創建時間</td> <td >操作</td> </tr> < c:forEach var="credit" items="${creditVOList}" varStatus="status"> <tr style="width: 300px;"> <td><input type="checkbox" name= "creditIdbox" id="creditIdbox" value="${credit.creditId }"></td> <td>${status.index}</td> <td>${credit.loginName} </td> <td>${credit.loginPwd}</td> <td>${credit.againPwd}</td> <td>${credit.IDCard}</td> <td>${credit.fixedTelephoneNumber}</td> <td>${credit.telephoneNumber}</td> <td>${credit.email}</td> <td 這;td>${credit.email}</td> <td id=; "address">${credit.address}</td> <td>${credit.status ==0 ? '已提交':'未提交'}</td> <td>${ creditVO.createtime}</td> <td>  <a id="delete" href="http://localhost:8080/ssmy2/CreditController/deleteuser.do?creditIdbox=${credit.creditId }">刪除</a> </td> </tr> </c:forEach> </table> <c:if test="${empty creditVOList }"> 沒有任何員工資訊. </c:if> <br/> <input type="button" value="刪除" id ="deleteuser" > <input type="text" name="username"/ > <input type="file" name="uploadFile"/> <input type="submit" id="uploadFile" name="開始上傳檔案" value="開始上傳檔案"/> < div id="box" style="border: 1px solid #ccc;"></div> </form>