<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.ResultSet" %> <%@ page import="com.tools.ChStr" %> <% String searchword=request.getParameter("searchword"); searchword = new String(searchword.getBytes("ISO8859-1"),"UTF-8"); /* 最新上架商品信息 */ 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 " +"t1.goodsname like '%"+searchword+"%'" +"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"%>