field_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("CustomID");//获取从webinfo.jsp文件中传输过来的参数。
String sql="select * from crm_syscustom where CustomID='"+delID+"'";
ResultSet rs=stmt.executeQuery(sql);
if(!rs.next()) {
out.print("没有找到记录");
}
else{
String sCustomName=rs.getString("CustomName");//保存查询到的自定义名称
int intID=Integer.parseInt(rs.getString("CustomGroup"));//将自定义分组ID查询的结果保存，否则后面无法获取。
stmt.executeUpdate("DELETE FROM crm_syscustom where CustomID='"+delID+"'");
String sqlType="select * from crm_card where id='"+intID+"'";//在系统分类表查询自定义分组ID，并获取数据表名称。
ResultSet rsType=stmt.executeQuery(sqlType);
if(rsType.next()){
String Stable=rsType.getString("CardValue");//得到数据表名称
stmt.executeUpdate("ALTER TABLE "+Stable+" DROP "+sCustomName);
}out.print("删除成功,3秒后跳转到列表页");
}
response.setHeader("refresh", "3;url=field_list.jsp");
%>
- 文章导航