delitem.jsp

来自「新闻管理系统实现对新闻添加修改删除外挂了一个用户的注册还有一个外挂的投票」· JSP 代码 · 共 19 行

<%@page import="java.sql.*"%>

<%@include file="opendata.jsp"%>
<%@include file="check.jsp"%>
<%
 int itemid = Integer.parseInt(request.getParameter("itemid"));
 //out.print(itemid);
 int questionid = 0;
 sql = "SELECT QuestionID from Items where ItemID ="+itemid;
 rs = smt.executeQuery(sql);
 while(rs.next())
   questionid = rs.getInt(1);
 
 sql = "delete from Items where ItemID= "+itemid;
 smt.executeUpdate(sql);
  
 response.sendRedirect("edit.jsp?questionid="+questionid);
%>