add.jsp

来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 16 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="vote" scope="page" class="ch9.VoteConn"/>
<%
  String nn = request.getParameter("note");
  if(nn != null && nn.length() >0) {
	 ResultSet tmpRs = vote.executeQuery("select max(id) As maxid from vote");
    tmpRs.next();
    int max_id = tmpRs.getInt("maxid") + 1;
    tmpRs.close();
    String sql = "insert into vote values (" + max_id + ",'"+ nn + "',0)";
	 vote.executeUpdate(sql);
  }
%>
<jsp:forward page="chap9-10.jsp"/>