网站开发项目 工作分解图,ps建模教程,丹东seo推广优化报价,河南省招标投标信息网官网Java删除表
这里页面我用了layui 框架做删除的#xff0c;这里需要引入layui 的css 与js 插件#xff0c;这里写出主要的代码。 Jsp #xff1a;
//监听行工具事件table.on(tool(test), function(obj){var data obj.data; //获得当前行数据var date1 data.classifyColum…Java删除表
这里页面我用了layui 框架做删除的这里需要引入layui 的css 与js 插件这里写出主要的代码。 Jsp
//监听行工具事件table.on(tool(test), function(obj){var data obj.data; //获得当前行数据var date1 data.classifyColumnID;if(obj.event del){//删除layer.confirm(确认删除吗?, {icon: 3,btn: [确定, 取消]}, function (index) {layer.close(index); $.post(servlet/SiteServletfundeleteclassificationClassifyColumnIDdate1, function(jsonObject) {data JSON.parse(jsonObject);if (data.state true) {layer.alert(data.msg,{icon:1,title:提示,offset:100px,btn: [确定,取消]},function(index){layer.close(index); location.reload();//页面刷新}); }else{layer.alert(data.msg,{icon:2,title:提示,offset:100px,btn: [确定,取消]},function(index){layer.close(index); location.reload();//页面刷新});};}); });
}Servlet public void deleteclassification(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {JsonReturn jsonReturn new JsonReturn();int ClassifyColumnID Integer.parseInt(request.getParameter(ClassifyColumnID));String str iSite.deleteclassification(ClassifyColumnID);if (删除成功.equals(str)) {jsonReturn.setState(true);jsonReturn.setMsg(str);} else {jsonReturn.setState(false);jsonReturn.setMsg(str);}JSONObject jsonObject JSONObject.fromObject(jsonReturn);PrintWriter out response.getWriter();out.write(jsonObject.toString());out.flush();out.close(); }Dao 实现类
Overridepublic int deleteclassification(int ClassifyColumnID) {int flog0;try {con DbUtil.getConnection();ps con.prepareStatement(DELETE FROM jc_bas_classifycolumn WHERE ClassifyColumnID ?);ps.setInt(1, ClassifyColumnID);ff ps.executeUpdate();} catch (SQLException e) {e.printStackTrace();}finally{DbUtil.close(con, ps, rs); }return flog;}Service 实现类:
Overridepublic String deleteclassification(int ClassifyColumnID) {String str null;if (userSite.deleteclassification(ClassifyColumnID)0) {str 删除成功;} else {str 删除失败;}return str;}
