category_del.jsp

来自「本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server20」· JSP 代码 · 共 29 行

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="../admin/checkmaster.jsp"%>
<%@ include file="../admin/check_admin_qs.jsp"%>
<%
String sql,strsql;
//String BBS_Cate_PID = request.getParameter("BBS_Cate_PID");
String BBS_Cate_ID = request.getParameter("BBS_Cate_ID");
//删除自身
sql="delete from BBS_CATE where BBS_Cate_ID='"+BBS_Cate_ID+"'";
stmt.executeUpdate(sql);

sql="select * from BBS_CATE where BBS_Cate_PID='"+BBS_Cate_ID+"'";
ResultSet rs=stmt.executeQuery(sql);
//while(rs.next()){
if(rs.next()){
		BBS_Cate_ID=rs.getString("BBS_Cate_ID");
		strsql="delete from BBS_CATE where BBS_Cate_ID='"+BBS_Cate_ID+"'";
		stmt.executeUpdate(strsql);
}
rs.close(); 
stmt.close(); 
conn.close(); 
response.sendRedirect(request.getHeader("referer"));
%>