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/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;
 }