<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.ResultSet"%> <% int typeSystem = Integer.parseInt(request.getParameter("typeSystem")); int hot_ID = 0; String hot_goodsName = ""; float hot_nowprice = 0; String hot_picture = ""; %>
<% ResultSet rs_relate = conn.executeQuery( "select top 6 ID,GoodsName,nowprice,picture from tb_goods where typeID=" + typeSystem + " "); int relate_ID = 0; String relate_goodsName = ""; float relate_nowprice = 0; String relate_picture = ""; int s3 = 0; while (rs_relate.next()) { relate_ID = rs_relate.getInt(1); relate_goodsName = rs_relate.getString(2); relate_nowprice = rs_relate.getFloat(3); relate_picture = rs_relate.getString(4); %>
名称: <%=relate_goodsName%>

价格:<%=relate_nowprice%> 元

<% s3++; } %>