java删除表_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/SiteServlet?fun=deleteclassification&ClassifyColumnID="+date1, 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 ：

publicvoiddeleteclassification(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 实现类：

@Override

publicint deleteclassification(int ClassifyColumnID) {

int flog=0;

try {

con = DbUtil.getConnection();

ps = con.prepareStatement("DELETE FROMjc_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 实现类:

@Override

public String deleteclassification(int ClassifyColumnID) {

String str = null;

if (userSite.deleteclassification(ClassifyColumnID)>0){

str= "删除成功";

} else {

str= "删除失败";

}return str;

}