📄 wangshangzhanding.jsp~2~
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@page import="liangjuyan.conndb"%>
<%
conndb conn = new conndb();
ResultSet rs_haha = conn.executeQuery("select top 3 id,title from haha ");
int s_id = 0;
String s_title="";
String s_detail="";
ResultSet rs_fuzhuang = conn.executeQuery("select top 3 fuzhuangid,wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian from fuzhuang ");
int s_fuzhuangid = 0;
String s_fwupinming ="";
String s_fyanse="";
String s_fchangjia ="";
String s_fcailiao = "";
String s_fshiyongnianxian = "";
String s_fshengchanriqi = "";
String s_fgoumaichishu = "";
String s_ftuijianzhishu = "";
String s_fyoudian = "";
String s_ftupian="";
ResultSet rs_shipin = conn.executeQuery("select top 3 shipinid, wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian from shipin ");
int s_shipinid = 0;
String s_swupinming = "";
String s_syanse= "";
String s_schangjia = "";
String s_scailiao = "";
String s_sshiyongnianxian = "";
String s_sshengchanriqi = "";
String s_sgoumaichishu = "";
String s_stuijianzhishu = "";
String s_syoudian = "";
String s_stupian="";
ResultSet rs_shenghuoyongpin = conn.executeQuery("select top 3 shenghuoyongpinid,wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian from shenghuoyongpin ");
int s_shenghuoyongpinid = 0;
String s_hwupinming = "";
String s_hyanse= "";
String s_hchangjia = "";
String s_hcailiao = "";
String s_hshiyongnianxian = "";
String s_hshengchanriqi = "";
String s_hgoumaichishu = "";
String s_htuijianzhishu = "";
String s_hyoudian = "";
String s_htupian="";
ResultSet rs_qita = conn.executeQuery("select top 3 qitaid,wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian from qita ");
int s_qitaid = 0;
String s_qwupinming = "";
String s_qyanse= "";
String s_qchangjia = "";
String s_qcailiao = "";
String s_qshiyongnianxian = "";
String s_qshengchanriqi = "";
String s_qgoumaichishu = "";
String s_qtuijianzhishu = "";
String s_qyoudian = "";
String s_qtupian="";
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
.style1 {color: #CC3300}
.style2 {color: #FF3300}
.style3 {color: #FF6600}
</style>
</head>
<body>
<table width="760
" height="934" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="934" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/3.png">
<tr>
<td width="23%" height="57" valign="top">
<img src="images/2.png" width="162" height="88">
</td>
<td width="77%" valign="midder" align="center">
<marquee>
<span class="style1">欢迎您登陆**网,请必须先登陆.会员惊喜多多!!</span>
</marquee>
</td>
</tr>
</table>
<table width="100%" height="37" border="0" cellpadding="0" cellspacing="0" background="images/4.png">
<tr>
<td width="12%"><a href="wangshangzhanting.jsp">网上展厅</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="18%"> <a href="gongqiuxinxi.jsp"> 发布供求信息</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="17%"> <a href="qiugouxinxi.jsp"> 发布求购信息</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="14%"> <a href="zaixiandiaocha.jsp"> 在线调查</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"> <a href="liuxingshishang.jsp"> 流行时尚</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"> <a href="hangyezhixun.jsp"> 行业资讯</a>
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"><a href="aboutus.jsp"> 关于我们</a>
<img src="images/1.png" width="22" height="22"/>
</td>
</tr>
</table>
<table width="100%" height="52" border="0" cellpadding="0" cellspacing="0" background="images/5.png">
<tr>
<td height="52" background="images/li.png">
<form action="#" method="post"> <table width="758">
<tr>
<td> 用户名
<input name="username" type="text" size="16"/>
<input name="Submit１" type="button" id="Submit１" value="登陆" onClick="window.location.href='denglu.jsp'"/>
<input type="button" name="Submit2" id="Submit2" value="注册" onClick="window.location.href='zhuce.jsp'"/>
</td>
</tr></table> </form>
<form id="form1" name="form1" method="post" action="">
请选择查询条件</span>
<select name="select">
<option>服装</option>
<option>饰品</option>
<option>生活用品</option>
<option>其他</option>
</select>
<input type="submit" name="Submit" value="搜索"/>
</form>
</td>
</tr>
</table>
<table width="759" height="38">
<tr>
<td width="751" height="32" background="images/haozhao.png"> </td>
</tr>
</table>
<p> <img src="images/db1.png"> <img src="images/db2.png"> <img src="images/db4.png"> <img src="images/db30.png">
<img src="images/db29.png"></p>
<p> <span class="style2"><a href="welcomefuzhuang.jsp" class="style1 style3">最受欢迎的服装</a> <a href="welcomeshipin.jsp" class="style3">最受欢迎的饰品</a><a href="detaild.jsp" class="style3"></a> <a href="welcomeshenghuoyongpin.jsp" class="style3">最受欢迎的生活用品</a> <a href="welcomeguangpan.jsp" class="style3">光盘</a> <a href="welcomedianzichanpin.jsp" class="style2">电子产品</a> </p>
<table width="759" height="37">
<tr>
<td width="751" height="30" background="images/cm.png"> </td>
</tr>
</table>
<table width="100%" height="453" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="25%" height="453" valign="top">
<table width="192" height="140" border="0" bordercolor="#cccccc">
<tr>
<td valign="top">
<p class="style9"> </p>
<p class="style9"> <span class="style3"> <strong>网上购物安全可靠，速度快。安全行好，不出门就可以知道最前沿的信息</strong>
</span> </p>
</td>
</tr>
</table>
<table width="192" cellspacing="0" cellpadding="0" border="1" bordercolor="#cccccc">
<tr bordercolor="#FF9966">
<td width="192" height="33" valign="midder" background="images/haha.png"> 最新资讯 </td>
</tr>
<%
while (rs_haha.next()) {
s_title=rs_haha.getString(2);
%>
<tr>
<td height="278">
<table >
<tr>
<td height="31" valign="midder "><%=s_title%> </td>
</tr>
</table> </td>
</tr> <%}%>
</table> </td>
<td width="1%"> </td>
<td width="74%" valign="top">
<table width="100%" height="452" cellpadding="0" cellspacing="0" border="1" bordercolor="#cccccc">
<tr>
<td height="32" background="images/dafadf.png" bgcolor="#ff9966"> 网上展厅 </td>
</tr>
<tr>
<td height="418" valign="top">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#cccccc">
<tr>
</tr>
<tr>
<td width="7%"><div align="center">编号</div></td>
<td width="9%" height="27"><div align="center">物品名</div></td>
<td width="7%"><div align="center">颜色</div></td>
<td width="7%"><div align="center">厂家</div></td>
<td width="7%"><div align="center">材料</div></td>
<td width="11%"><div align="center">使用年限</div></td>
<td width="10%"><div align="center">生产日期</div></td>
<td width="10%"><div align="center">购买次数</div></td>
<td width="10%"><div align="center">推荐指数</div></td>
<td width="6%"><div align="center">优点</div></td>
</tr>
<%
while (rs_fuzhuang.next()) {
s_fuzhuangid=rs_fuzhuang.getInt(1);
s_fwupinming = rs_fuzhuang.getString(2);
s_fyanse = rs_fuzhuang.getString(3);
s_fchangjia = rs_fuzhuang.getString(4);
s_fcailiao = rs_fuzhuang.getString(5);
s_fshiyongnianxian = rs_fuzhuang.getString(6);
s_fshengchanriqi = rs_fuzhuang.getString(7);
s_fgoumaichishu= rs_fuzhuang.getString(8);
s_ftuijianzhishu= rs_fuzhuang.getString(9);
s_fyoudian= rs_fuzhuang.getString(10);
%>
<tr>
<td><a href="goods_detail.jsp?ID=<%=s_fuzhuangid%>"><%=s_fuzhuangid%></a></td>
<td height="31"><%=s_fwupinming%></td>
<td><%=s_fyanse%></td>
<td><%=s_fchangjia%></td>
<td><%=s_fcailiao%></td>
<td><%=s_fshiyongnianxian%></td>
<td><%=s_fshengchanriqi%></td>
<td><%=s_fgoumaichishu%></td>
<td><%=s_ftuijianzhishu%></td>
<td><%=s_fyoudian%></td>
</tr>
<% }%>
</table>
<table width="100%" height="21" >
<tr>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<img src="file:///C|/Documents%20and%20Settings/liang/My%20Documents/liangjuyan/yan.png" width="760" height="45"/></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -