<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% String username=(String)session.getAttribute("username"); String type=""; type=request.getParameter("Type"); String sql_r=""; if(type.equals("null") || type.equals("")){ out.println(""); }else{ sql_r="select * from V_goods where subID="+type; ResultSet rs_r=conn.executeQuery(sql_r); int goodsID=-1; String goodsName=""; String introduce=""; float nowprice=(float)0.0; String subTypename=""; String superTypename=""; ResultSet rs_type=conn.executeQuery("select * from V_type where subID="+type); if(rs_type.next()){ superTypename=rs_type.getString(2); subTypename=rs_type.getString(3); } %>

>> 当前选择的类别：[ <%=superTypename%> ]->[ <%=subTypename%> ] <% while(rs_r.next()){ goodsID=rs_r.getInt("ID"); goodsName=rs_r.getString("goodsName"); introduce=rs_r.getString("introduce"); nowprice=rs_r.getFloat("nowprice"); if(introduce.length()>8){ introduce=introduce.substring(0,8)+"..."; } %> <%if (username!=null && username!=""){%> <%}%> <%=goodsName%>  <%=introduce%> <%=nowprice%>(元)   <%}}%>

<%conn.close();%>