<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.ResultSet" %> <%--创建com.tools.ConnDB类的对象 --%> <% /* 商品信息 */ int Type=Integer.parseInt(request.getParameter("type")); ResultSet rs_new = conn.executeQuery( "select top 12 t1.ID, t1.GoodsName,t1.price,t1.picture,t2.TypeName " +"from tb_goods t1,tb_subType t2 where t1.typeID=t2.ID and " +"t2.superType="+ Type + "order by t1.INTime desc"); //查询商品信息 int new_ID=0; //保存商品的id变量 String new_goodsname=""; //保存商品名称的变量 float new_nowprice=0; //保存商品的价格变量 String new_picture=""; //保存商品的图片变量 String typeName=""; //保存商品的分类变量 %> <%@ include file="common-header.jsp"%> <%@ include file="common-footer.jsp"%>