<form action="buy.jsp" method="post">
<table bgcolor=DodgerBlue>
<tr bgcolor=SkyBlue>
<td><b><div><center>书名</center></div></b></td>
<td><b><div><center>作者</center></div></b></td>
<td><b><div><center>出版社</center></div></b></td>
<td><b><div><center>出版日期</center></div></b></td>
<td><b><div><center>价格</center></div></b></td>
<td><b><div><center>备注</center></div></b></td>
<td><b><div><center>购买</center></div></b></td>
<td><b><div><center>数量</center></div></b></td>
</tr>
<%
while(sure.rs.next())
{
String BID=sure.rs.getString("bookId");
String txtval=request.getParameter("txt"+BID);
%>
<tr bgcolor=LightGoldenrodYellow>
<td><b><div><center><%=sure.rs.getString("bookname")%></center></div></b></td>
<td><b><div><center><%=sure.rs.getString("author")%></center></div></b></td>
<td><b><div><center><%=sure.rs.getString("publish")%></center></div></b></td>
<td><b><div><center><%=sure.rs.getString("pdate")%></center></div></b></td>
<td><b><div><center><%=sure.rs.getFloat("price")%></center></div></b></td>
<td><b><div><center><%=sure.rs.getString("memo")%></center></div></b></td>
<!--checkbox框-->
<td><b><div><center>
<input type="checkbox" name=ck<%=BID%> value=<%=txtval%> checked>
</center></div></b></td>
<!--text框-->
<td><b><div><center>
<input type="text" size=5 name=txt<%=BID%> value=<%=txtval%>>
</center></div></b></td>
</tr>
<%
}
sure.disCon();//断开数据库的连接
%>
</table><br>
<input type="submit" value="确认">  
<input type="reset" value="重置">
</form>
buy.jsp
<form action="complete.jsp" method="post">
<table bgcolor=DodgerBlue>
<tr bgcolor=SkyBlue>
<td><b><div><center>书名</center></div></b></td>
<td><b><div><center>作者</center></div></b></td>
<td><b><div><center>出版社</center></div></b></td>
<td><b><div><center>出版日期</center></div></b></td>
<td><b><div><center>数量</center></div></b></td>
<td><b><div><center>合计</center></div></b></td>
</tr>
<%
resure.allProduct();//显示所有商品
float total=0.0f;
while(resure.rs.next())
{
String BID=resure.rs.getString("bookId");
String txtval=request.getParameter("txt"+BID);//数量
String ckval=request.getParameter("ck"+BID);
if(ckval!=null)
{
int num=Integer.parseInt(txtval);
%>
<tr bgcolor=LightGoldenrodYellow>
<td><b><div><center><%=resure.rs.getString("bookname")%></center></div></b></td>
<td><b><div><center><%=resure.rs.getString("author")%></center></div></b></td> <td><b><div><center><%=resure.rs.getString("publish")%></center></div></b></td>
<td><b><div><center><%=resure.rs.getString("pdate")%></center></div></b></td>
<td><b><div><center><%=num%></center></div></b></td>
<td><b><div><center><%=num*resure.rs.getFloat("price")%></center></div></b></td>
<%
}
}
resure.disCon();//断开数据库的连接
%>
</table><br><br>
<input type="submit" value="付款">  
<input type="reset" value="重新购买" onClick="rebuy()">
</form>