1.jsp頁面刪除按鈕的單擊事件

Jsp:

$('#delbtn_wait').click(function(){
            var data=getValue();
            if(data==""){
                alert("請選擇需要刪除的選項");
                return;
            }
            $("#checkList").val(data);
            if(confirm("確定刪除該立項信息嗎？刪除后不可回復")){
                $.ajax({
                    async:false,
                    type: "POST",
                    data:$("form").serialize(),
                    url: '/bistone/showdelProjectApprove.action?data='+data
                });
                alert("刪除樣本庫成功!");
                refreshwindow();
            }           
        //關閉子窗口,刪除后自動刷新頁面
        function refreshwindow() {
            window.location.href = window.location.href.replace(/#/g, '');
        }               
        });

2.配置Action的的映射文件

Strul.xml:

<action name="showdelProjectApprove" class="projectApproveAction" method="showdelProjectApprove">
            <result name="success">/jsp/ptl/listApproveDraft.action?sDto.approveUserId=${approveUserId}&amp;sDto.approveDeptId=${approveDeptId}</result>
        </action>

3.Action文件相當于Servlet層

ProjectApproveaction.java:

public String showdelProjectApprove(){
        HttpServletRequest request = ServletActionContext.getRequest();
        SearchConditionDto sdto = (SearchConditionDto)MemcacheUtil.getMemcached("sdto",request);
        this.ids = checkList.split(",");//要刪除樣本的所有的id
        if (ids != null && ids.length > 0) {
            boolean flag = false;
            for (int i = 0; i < ids.length; i++) {
                projectApprove = new ProjectApproveDto();
                projectApprove.setApproveId(ids[i]);
                //執(zhí)行刪除
                String opName = projectApproveService.listProjectApproveDraft(uid).get(0).getProjectName();
                flag = this.projectApproveService.showdelProjectApprove(projectApprove);
/**當projectApproveService里面還沒有創(chuàng)建showdelProjectApprove方法時蘸吓，鼠標放上去會提示在Service文件中創(chuàng)建showdelProjectApprove方法（ctrl+1也行)洪囤，點擊該選項會自動跳轉到Service界面延届，找到Service層的實行按類鼠標放在類名處，實現接口未實現的方法即可钱床。不用手動敲吼畏。*/
            }
            if (flag) {
                return SUCCESS;
            } else {
                addActionError("刪除失斎猛！");
                return INPUT;
            }
        }
        addActionError("刪除失敶怯选栅哀！");
        return INPUT;
    }

4.service的接口類

public boolean showdelProjectApprove(ProjectApproveDto dto);

4.1service接口的實現類

@Override
    public boolean showdelProjectApprove(ProjectApproveDto dto) {
        // 調用Dao里面的showdelProjectApprove方法
        return this.projectApproveDao.showdelProjectApprove(dto);
    }

5.Dao的接口類

public boolean showdelProjectApprove(ProjectApproveDto dto);

5.1Dao接口的實現類

@Override
    public boolean showdelProjectApprove(ProjectApproveDto dto) {
        // TODO Auto-generated method stub
        boolean flag = false;   
        try {
            flag = getSqlMapClientTemplate().delete("showdelProjectApprove", dto) > 0 ? true : false;
            
        } catch (DataAccessException e) {
            // TODO Auto-generated catch block
            logger.error("刪除立項數據錯誤showdelProjectApprove:"+e.getMessage());
        }
        return flag;
    }

6.找到showdelProjectApprove的sql映射文件

sqlmap.xml

<delete id="showdelProjectApprove" parameterClass="projectApproveDto">
        delete from tb_d_project_approve where approve_id = #approveId#
    </delete>