项目——通过自动回复机器人学Mybatis(ajax优化)(四)

首先修改list.jsp

<a href="javascript:deleteOne('<%=basePath%>','${message.id}');">删除</a>

编写js方法deleteOne()

function deleteOne(basePath,id) {
var url=basePath+"del_One.action";
$.ajax({
type:"post",
url:url,
data:{"id":id},
async:false,
success:function(data){
if(jQuery.isEmptyObject(data)){
return;
}else{
if(data=="del_success"){
alert("删除成功");
}else if(data=="del_false"){
alert("删除失败");
}    
window.location.reload();
}
    },
    error:function(data){
    alert("请求失败");
}
});
}

目前只要通过window.location.reload()重新请求list数据，同样也能达到目标效果

修改MessageDao的deleteOne

public boolean deleteOne(int id){
DBAccess dbAccess = new DBAccess();
SqlSession sqlSession=null;
boolean is_ok=false;
try {
sqlSession=dbAccess.getSqlSession();
//通过sqlSession执行SQL语句
if(sqlSession.delete("Message.deleteOne",id)>0){
is_ok=true;
}
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
}finally{
if(sqlSession!=null){
sqlSession.close();
}
}
return is_ok;
}

修改MaintainService

public class MaintainService {

public boolean deleteOne(String id){
boolean is_ok=false;
if(id!=null&&!"".equals(id)){
MessageDao messageDao=new MessageDao();
is_ok=messageDao.deleteOne(Integer.valueOf(id));
}
return is_ok;
}
}

修改deleteOneServlet

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// TODO Auto-generated method stub
//设置编码
req.setCharacterEncoding("UTF-8");
PrintWriter writer = resp.getWriter();
String id=req.getParameter("id");

MaintainService maintainService = new MaintainService();
if(maintainService.deleteOne(id)){
writer.write("del_success");
}else{
writer.write("del_false");
}
writer.flush();
writer.close();

}