📄 index.jsp~173~
字号:
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td height="33" colspan="11" background="images/zuihou.png"> 饰品</td>
</tr>
<tr><td width="9%" height="25"><div align="center">编号</div></td>
<td width="10%" height="25"><div align="center">物品名</div></td>
<td width="8%"><div align="center">颜色</div></td>
<td width="8%"><div align="center">厂家</div></td>
<td width="9%"><div align="center">材料</div></td>
<td width="10%"><div align="center">使用年限</div></td>
<td width="10%"><div align="center">生产日期</div></td>
<td width="11%"><div align="center">购买次数</div></td>
<td width="10%"><div align="center">推荐指数</div></td>
<td width="7%"><div align="center">优点</div></td>
<td width="8%"><div align="center">价格</div></td>
</tr>
<%
while (rs_shipin.next()) {
s_shipinid=rs_shipin.getInt(1);
s_swupinming = rs_shipin.getString(2);
s_syanse = rs_shipin.getString(3);
s_schangjia = rs_shipin.getString(4);
s_scailiao = rs_shipin.getString(5);
s_sshiyongnianxian = rs_shipin.getString(6);
s_sshengchanriqi = rs_shipin.getString(7);
s_sgoumaichishu= rs_shipin.getString(8);
s_stuijianzhishu= rs_shipin.getString(9);
s_syoudian= rs_shipin.getString(10);
s_sprice= rs_shipin.getString(12);
if (username==null || username==""){%>
<tr> <td height="28"><a href="shipin_detail.jsp?ID=<%=s_shipinid%>"><%=s_shipinid%></a></td>
<td height="28"><%=s_swupinming%></td>
<td><%=s_syanse%></td>
<td><%=s_schangjia %></td>
<td><%=s_scailiao%></td>
<td><%=s_sshiyongnianxian%></td>
<td><%=s_sshengchanriqi%></td>
<td><%=s_sgoumaichishu%></td>
<td><%=s_stuijianzhishu%></td>
<td><%=s_syoudian%></td>
<td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
</tr>
<%}else{%>
<tr> <td height="31" align="top"><a href="shipin_detail.jsp?ID=<%=s_shipinid%>"><%=s_shipinid%></a></td>
<td height="31"><%=s_swupinming%></td>
<td><%=s_syanse%></td>
<td><%=s_schangjia %></td>
<td><%=s_scailiao%></td>
<td><%=s_sshiyongnianxian%></td>
<td><%=s_sshengchanriqi%></td>
<td><%=s_sgoumaichishu%></td>
<td><%=s_stuijianzhishu%></td>
<td><%=s_syoudian%></td>
<td><%=s_sprice%></td>
</tr>
<tr>
<td height="31" colspan="11" align="top"> </td>
</tr>
<%}}%>
</table>
<table width="100%" height="149" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td height="32" colspan="11" background="images/zuihou.png"> 生活用品</td>
</tr>
<tr> <td width="9%" height="27"><div align="center">编号</div></td>
<td width="10%"><div align="center">物品名</div></td>
<td width="7%"><div align="center">颜色</div></td>
<td width="9%"><div align="center">厂家</div></td>
<td width="9%"><div align="center">材料</div></td>
<td width="10%"><div align="center">使用年限</div></td>
<td width="10%"><div align="center">生产日期</div></td>
<td width="11%"><div align="center">购买次数</div></td>
<td width="10%"><div align="center">推荐指数</div></td>
<td width="7%"><div align="center">优点</div></td>
<td width="8%"><div align="center">价格</div></td>
</tr>
<%
while (rs_shenghuoyongpin.next()) {
s_shenghuoyongpinid=rs_shenghuoyongpin.getInt(1);
s_hwupinming = rs_shenghuoyongpin.getString(2);
s_hyanse = rs_shenghuoyongpin.getString(3);
s_hchangjia = rs_shenghuoyongpin.getString(4);
s_hcailiao = rs_shenghuoyongpin.getString(5);
s_hshiyongnianxian = rs_shenghuoyongpin.getString(6);
s_hshengchanriqi = rs_shenghuoyongpin.getString(7);
s_hgoumaichishu= rs_shenghuoyongpin.getString(8);
s_htuijianzhishu= rs_shenghuoyongpin.getString(9);
s_hyoudian= rs_shenghuoyongpin.getString(10);
s_hprice= rs_shenghuoyongpin.getString(12);
if (username==null || username==""){%>
<tr><td><a href="shenghuoyongpin_detail.jsp?ID=<%=s_shenghuoyongpinid%>"><%=s_shenghuoyongpinid%></a></td>
<td><%=s_hwupinming%></td>
<td><%=s_hyanse %></td>
<td><%=s_hchangjia%></td>
<td><%=s_hcailiao%></td>
<td><%=s_hshiyongnianxian%></td>
<td><%=s_hshengchanriqi%></td>
<td><%=s_hgoumaichishu%></td>
<td><%=s_htuijianzhishu%></td>
<td><%=s_hyoudian%></td>
<td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
</tr>
<%}else{%>
<tr><td height="30"><a href="shenghuoyongpin_detail.jsp?ID=<%=s_shenghuoyongpinid%>"><%=s_shenghuoyongpinid%></a></td>
<td><%=s_hwupinming%></td>
<td><%=s_hyanse %></td>
<td><%=s_hchangjia%></td>
<td><%=s_hcailiao%></td>
<td><%=s_hshiyongnianxian%></td>
<td><%=s_hshengchanriqi%></td>
<td><%=s_hgoumaichishu%></td>
<td><%=s_htuijianzhishu%></td>
<td><%=s_hyoudian%></td>
<td><%=s_hprice%></td>
</tr>
<tr>
<td height="30" colspan="11"> </td>
</tr>
<%}}%>
</table>
<table width="100%" height="130" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td height="34" colspan="11" background="images/zuihou.png"> 其他</td>
</tr>
<tr><td width="9%"><div align="center">物品名</div></td>
<td width="10%"><div align="center">物品名</div></td>
<td width="7%"><div align="center">颜色</div></td>
<td width="9%"><div align="center">厂家</div></td>
<td width="9%"><div align="center">材料</div></td>
<td width="10%"><div align="center">使用年限</div></td>
<td width="10%"><div align="center">生产日期</div></td>
<td width="11%"><div align="center">购买次数</div></td>
<td width="10%">推荐指数</td>
<td width="7%"><div align="center">优点</div></td>
<td width="8%"><div align="center">价格</div></td>
</tr>
<%
while (rs_qita.next()) {
s_qitaid=rs_qita.getInt(1);
s_qwupinming = rs_qita.getString(2);
s_qyanse = rs_qita.getString(3);
s_qchangjia = rs_qita.getString(4);
s_qcailiao = rs_qita.getString(5);
s_qshiyongnianxian = rs_qita.getString(6);
s_qshengchanriqi = rs_qita.getString(7);
s_qgoumaichishu= rs_qita.getString(8);
s_qtuijianzhishu= rs_qita.getString(9);
s_qyoudian= rs_qita.getString(10);
s_qprice= rs_qita.getString(12);
if (username==null || username==""){%>
<tr><td height="33"><a href="qita_detail.jsp?ID=<%=s_qitaid%>"><%=s_qitaid%></a></td>
<td height="33"><%=s_qwupinming%></td>
<td><%=s_qyanse%></td>
<td><%=s_qchangjia%></td>
<td><%=s_qcailiao%></td>
<td><%=s_qshiyongnianxian%></td>
<td><%=s_qshengchanriqi%></td>
<td><%=s_qgoumaichishu%></td>
<td><%=s_qtuijianzhishu%></td>
<td><%=s_qyoudian%></td>
<td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
</tr>
<%}else{%>
<tr><td height="33"><a href="qita_detail.jsp?ID=<%=s_qitaid%>"><%=s_qitaid%></a></td>
<td height="33"><%=s_qwupinming%></td>
<td><%=s_qyanse%></td>
<td><%=s_qchangjia%></td>
<td><%=s_qcailiao%></td>
<td><%=s_qshiyongnianxian%></td>
<td><%=s_qshengchanriqi%></td>
<td><%=s_qgoumaichishu%></td>
<td><%=s_qtuijianzhishu%></td>
<td><%=s_qyoudian%></td>
<td><%=s_qprice%></td>
</tr>
<tr>
<td height="33" colspan="11"> </td>
</tr>
<%}}%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table> </tr>
</table>
</body>
</html>
<%conn.close();%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -