addvote.jsp

来自「JSP课程设计案例精编 源代码 共有12个哦 解说详细」· JSP 代码 · 共 17 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="connDbBean" scope="page" class="vote.VoteConn"/>
<%
  String nn = request.getParameter("note");
  if(nn != null && nn.length() >0) {
	 ResultSet tmpRs = connDbBean.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 + ",'";
	 sql += nn + "',0);";
	 connDbBean.executeUpdate(sql);
  }
%>
<jsp:forward page="admin.jsp"/>