第3章业务功能开发（删除线索）

1.根据功能需求分析，删除线索传递的参数为id，由于可以同时删除多个参数，所以传递的参数应该为string数据。返回值为int类型

ClueMapper接口

 

2.ClueMapper.xml文件

 <delete id="deleteClueById" parameterType="string">
    delete from tbl_clue
    where id in
    <foreach collection="array" item="id" open="(" separator="," close=")">
      #{id}
    </foreach>
  </delete>

3.ClueService接口

 

4.ClueServiceImpl类

 5.ClueController

 @RequestMapping(value = "/workbench/clue/removeClueChecked.do")
    @ResponseBody
    public Object removeClueChecked(String[] id){
        ReturnObject returnObject=new ReturnObject();
        try{
            int i = clueService.removeClueChecked(id);
            if (i>0){
                returnObject.setCode(Contants.RETURN_OBJECT_CODE_SUCCESS);
            }else {
                returnObject.setCode(Contants.RETURN_OBJECT_CODE_FAIL);
                returnObject.setMessage("系统忙，请稍后重试！");
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        return returnObject;
    }

6.clue的index.jsp页面

js代码

//给删除按钮添加删除事件
		$("#removeClueBtn").click(function () {
			//收集参数
			var checkedIds=$("#tBody input[type='checkbox']:checked");
			//验证表单
			if (checkedIds.size()==0){
				alert("请选择要删除的市场活动！");
				return;
			}
			var ids="";
			$.each(checkedIds,function () {
				ids+="id="+this.value+"&";
			});
			ids=ids.substr(0,ids.length-1);
			if (window.confirm("确认删除吗？")) {
				//发送请求
				$.ajax({
					url: "workbench/clue/removeClueChecked.do",
					type: 'post',
					dataType: 'json',
					data:ids,
					success:function (data) {
						if (data.code=='1'){
							queryClueByConditionForPage(
							$("#demo_page").bs_pagination("getOption","currentPage"),
							$("#demo_page").bs_pagination("getOption","rowsPerPage")
							);
						} else {
							alert(data.message);
						}
					}
				});
			}
		});

功能测试

选中任意一条数据，点击删除按钮

确认刷出后，刷新页面