Mapper接口
     //批量刪除商品的功能
    int deleteBatch(String[] ids);
Mapper.xml
  <!--  批量刪除-->
  <delete id="deleteBatch">
    delete from product_info where p_id in
    <foreach collection="array" item="pid" separator="," open="(" close=")">
      #{pid}
    </foreach>
  </delete>

Service接口
    int deleteBatch(String[] ids);



Service實現(xiàn)類
    @Override
    public int deleteBatch(String[] ids) {
        return productInfoMapper.deleteBatch(ids);
    }

   //批量刪除 pids是要刪除的商品的id字符串，例如:1,2,3,4,5,
    @RequestMapping("/deletebatch")
    public String deleteBatch(String pids,HttpServletRequest request) {
        String[] ps = pids.split(",");//轉為數組[1,2,3,4,5]
        int num= 0;
        try {
            num = productInfoService.deleteBatch(ps);
            if(num>0)
            {
                request.setAttribute("msg","批量刪除成功!");
            }else {
                request.setAttribute("msg","批量刪除失敗");
            }
        } catch (Exception e) {
          request.setAttribute("msg","商品不可刪除!");
        }
        //批量刪除后 重新分頁查詢
        return "forward:/prod/deleteAjaxSplit.action";
    }

<input type="button" class="btn btn-warning" id="btn1"
value="批量刪除" onclick="deleteBatch()">
</div>


js部分:

   //批量刪除
    function deleteBatch() {
        
        //取得所有被選中刪除商品的pid
        var zhi=$("input[name=ck]:checked");
        var str="";
        var id="";
        if(zhi.length==0){
            alert("請選擇將要刪除的商品！");
        }else{
            // 有選中的商品，則取出每個選 中商品的ID，拼提交的ID的數據
            if(confirm("您確定刪除"+zhi.length+"條商品嗎？")){
                //拼接ID
                $.each(zhi,function (index,item) {
                    id=$(item).val(); //22 33
                    if(id!=null)
                        str += id+",";  //22,33,44
                });
                //發(fā)送請求到服務器端
                // window.location="${pageContext.request.contextPath}/prod/deletebatch.action?str="+str;
                $.ajax({
                    url: "${pageContext.request.contextPath}/prod/deletebatch.action",
                    data: {"pids":str},
                    type: "post",
                    dataType:"text",
                    success:function (msg)
                    {
                        alert(msg);
                        $("#table").load("http://localhost:8099/admin/product.jsp #table");
                    }
                });
            }
        }
    }

//封裝查詢條件
public class ProductInfoVo {
    //商品名稱
    private String pname;
    //商品類型
    private Integer typeid;
    //最低價格
    private Double lprice;
    //最高價格
    private Double hprice;

    //補全get set  有/無參構造方法 toString()
}

Mapper接口:

    //多條件查詢商品
    List<ProductInfo> selectCondition(ProductInfoVo vo);

Mapper.xml:

<!--多條件查詢-->
  <select id="selectCondition" parameterType="com.rk.pojo.vo.ProductInfoVo" resultMap="BaseResultMap">
    select *
    from product_info
    <!--拼條件-->
    <where>
      <if test="pname!=null and pname!=''">
        and p_name like '%${pname}%'
      </if>
      <if test="typeid!=null and typeid!=-1">
        and type_id =#{typeid}
      </if>
      <if test="(lprice!=null and lprice!='') and  (hprice==null or hprice=='')">
        and p_price &gt;= #{lprice}
      </if>
      <if test="(lprice==null or lprice=='') and  (hprice!=null and hprice!='')">
        and p_price &lt;= #{hprice}
      </if>
      <if test="(lprice!=null and lprice!='') and  (hprice!=null and hprice!='')">
        and p_price between #{lprice} and #{hprice}
      </if>
    </where>
    order by p_id desc
  </select>

service接口:
     //多條件商品查詢
    List<ProductInfo> selectCondition(ProductInfoVo vo);

service實現(xiàn)類:

    @Override
    public List<ProductInfo> selectCondition(ProductInfoVo vo) {
        return productInfoMapper.selectCondition(vo);
    }

    //多條件查詢
    @ResponseBody
    @RequestMapping("/condition")
    public void condition(ProductInfoVo vo, HttpSession session)
    {
        List<ProductInfo> list = productInfoService.selectCondition(vo);
        session.setAttribute("list",list);
    }

  <div id="condition" style="text-align: center">
        <form id="myform">
            商品名稱：<input name="pname" id="pname">&nbsp;&nbsp;&nbsp;
            商品類型：<select name="typeid" id="typeid">
            <option value="-1">請選擇</option>
            <c:forEach items="${ptlist}" var="pt">
                <option value="${pt.typeId}">${pt.typeName}</option>
            </c:forEach>
        </select>&nbsp;&nbsp;&nbsp;
            價格：<input name="lprice" id="lprice">-<input name="hprice" id="hprice">
            <input type="button" value="查詢" onclick="condition()">
        </form>
    </div>


js部分:
     //多條件查詢
    function condition(){
        //取出查詢條件
        var pname=$("#pname").val();
        var typeid=$("#typeid").val();
        var lprice=$("#lprice").val();
        var hprice=$("#hprice").val();
        $.ajax({
            type:"post",
            url:"${pageContext.request.contextPath}/prod/condition.action",
            data:{"pname":pname,"typeid":typeid,
                "lprice":lprice,"hprice":hprice},
            success:function () {
                //刷新表格  后臺將查詢到的結果存儲到seession
                $("#table").load("http://localhost:8099/admin/product.jsp #table");
            }
            }
        )
    }