vote.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 15 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="dbBean.DBBean" scope="session"/>

<%
	String id=request.getParameter("id");
	ResultSet rs=db.executeQuery("select * from vote where id="+id);
	int num=0;
	if(rs.next())
		num=rs.getInt("count");
	num++;
	rs.close();
	db.executeUpdate("update vote set count="+num+" where id="+id);
	db.close();
%>
<jsp:forward page="info.jsp"/>