delitem.jsp

来自「这个主要是运用JAVA+JAVABEAN实现的网上投票调查系统」· JSP 代码 · 共 27 行

<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@include file="check.jsp"%>
<jsp:useBean id="MyBean" scope="session" class="myjsp.MyBean"/>
<jsp:setProperty name="MyBean" property="*"/>

<% Connection con = MyBean.getConnection(); 
  Statement smt = con.createStatement();
  ResultSet rs= null;
  %>
<%
 int itemid = Integer.parseInt(request.getParameter("itemid"));
 //out.print(itemid);
 int questionid = 0;
 String 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);
 smt.close();
 MyBean.close();  //关闭Connection对象
%>