<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% String username=(String)session.getAttribute("username"); ResultSet rs=conn.executeQuery("select ID,GoodsName,Introduce,nowprice,picture from tb_goods where newgoods=1 order by GoodsName"); int goodsID=-1; String goodsName=""; String introduce=""; float nowprice=(float)0.0; String picture=""; %>

<% while(rs.next()){ goodsID=rs.getInt(1); goodsName=rs.getString(2); introduce=rs.getString(3); nowprice=rs.getFloat(4); picture=rs.getString(5); %> <%}%> 产品名称：<%=goodsName%> 产品价格：<%=nowprice%>(元) 产品说明：<%=introduce%>   <%if (username!=null && username!=""){%>   <%}%>

<%conn.close();%>