showvote.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<%
String sql="select * from vote where start='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
int id=rs.getInt("id");
String matter=rs.getString("matter");
rs.close();
%>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20" colspan="3"><div align="center"><%=matter%></div></td>
</tr>
<%
sql="select * from addvote where titleid='"+id+"'";
rs=data.executeQuery(sql);
String vote="";
int i=0;
int number=0;
while(rs.next())
{
i++;
vote=rs.getString("vote");
number=rs.getInt("number");
%>
<tr>
<td height="20" width="30"><div align="center"><%=i%></div></td>
<td width="150"><%=vote%></div>
<td width="70"><div align="center"><font color="#FF0000"><%=number%></font>Ʊ</div></td>
</tr>
<%}%>
</table>