upvote.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String id=request.getParameter("id");
String gsid=request.getParameter("gsid");
String setvote=request.getParameter("setvote");
setvote=new String(setvote.getBytes("ISO8859_1"),"GBK");
String sql="update addvote set vote='"+setvote+"',number='"+0+"' where id='"+gsid+"'";
ResultSet rs=data.executeQuery(sql);
response.sendRedirect("vote.jsp?show="+id);
%>