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/SiteServletfun=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 :
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 实现类:
@Override
public int deleteclassification(int ClassifyColumnID) {
int flog=0;
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 实现类:
@Override
public String deleteclassification(int ClassifyColumnID) {
String str = null;
if (userSite.deleteclassification(ClassifyColumnID)>0) {
str= "删除成功";
} else {
str= "删除失败";
}
return str;
}