对部分选中的商品进行删除
前端jsp
<input type="checkbox" name="ids" class="small_checkbox" value="<%=rsCart.getString("cart_id")%>"/>
<button onclick="delectpart()">删除选中的药品</button>
jquery代码:
<script>
//8.多选 部分选中商品
function delectpart()
{
var cart_id = "" ;
var sel = document . getElementsByName ( "ids" ) ; //获取checkbox的值
for ( var i = 0 ; i < sel . length ; i ++ )
if ( sel [ i ] . checked == true )
cart_id += sel [ i ] . value + "," ;
console.log(cart_id);
alert(cart_id);
location.href="Drug_CartDelPart?cart_id="+cart_id;
}
</script>
后端servlet
System.out.println("进入删除部分购物车后台");
String cart_id=request.getParameter("cart_id");
System.out.println("cart_id:"+cart_id);
MysqlConn db=new MysqlConn();
int res=0;
String [] arr=cart_id.split (",");
//System.out.println("arr[0]:"+arr[0]);
for ( int i = 0 ; i <= arr . length -1 ; i ++ )
{
System.out.println("arr[i]:"+arr[i]);
res=db.doExecute("delete from cart where cart_id=?", new Object[]{arr[i]});
}