card_del.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../data/conn.jsp"%>
<%@ include file="check.jsp"%>
<%
String delID=request.getParameter("id");//获取从webinfo.jsp文件中传输过来的参数。
String sql="select * from crm_card where id='"+delID+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
int IntisDel=Integer.parseInt(rs.getString("isDel"));
String SCardValue=rs.getString("CardValue");
if(IntisDel==1){//非系统字段可以删除
stmt.execute("DROP TABLE "+SCardValue);
stmt.executeUpdate("DELETE FROM crm_card where id='"+delID+"'");
stmt.executeUpdate("DELETE FROM crm_syscustom where CustomGroup='"+delID+"'");
stmt.executeUpdate("ALTER TABLE `crm_level` DROP "+SCardValue);
out.print("Delete Sucess");
}else{
out.print("没有权限，请向管理员申请。");
}
}else{
out.print("No Fount Record");
}
stmt.close();
conn.close();
response.setHeader("refresh","3;url=card_list.jsp");
%>
- 文章导航