📄 weclomeshipin.jsp~12~
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@page import="liangjuyan.conndb"%>
<%
conndb conn = new conndb();
ResultSet rs_shipin = conn.executeQuery("select top 6 shipinid, wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian ,tupian from shipin where tebietuijian=1");
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="";
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {font-size: 18px}
.style2 {
color: #000000;
font-weight: bold;
font-size: larger;
}
-->
</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%"> 网上展厅
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="18%"> 发布供求信息
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="17%"> 发布求购信息
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="14%"> 在线调查
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"> 流行时尚
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"> 行业资讯
<img src="images/1.png" width="22" height="22"/>
</td>
<td width="13%"> 关于我们
<img src="images/1.png" width="22" height="22"/>
</td>
</tr>
</table>
<table width="100%" height="52" border="0" cellpadding="0" cellspacing="0" background="../../commerce/WebModuleDefault/images/5.png">
<tr>
<td height="52" background="images/li.png">
<form id="form1" name="form1" method="post" action="">
<span class="style1"> 请选择查询条件</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="11">
<tr>
<td width="315" height="5" background="images/san.png"></td>
<td width="280" background="images/w.png"></td>
<td width="148" background="images/ni.png"></td>
</tr>
</table>
<table width="100%" height="484" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="72%" height="484" valign="top">
<table width="100%" height="480" cellpadding="0" cellspacing="0" border="1" bordercolor="#cccccc">
<tr>
<td height="32" background="images/gaihoudafadf.png" bgcolor="#ff9966"> </td>
</tr>
<tr>
<td height="448" valign="top"><table width="100%" >
<tr>
<td width="33%" height="113" valign="top">
<%
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_stupian= rs_shipin.getString(11);
%>
<table width="26%" height="457" border="1" bordercolor="#CCCCCC" bgcolor="#ADC8FF" >
<tr>
<td height="107" valign="top"><img src="images/<%=s_stupian%>"/></td>
</tr>
<tr>
<td height="34">物品名：<%=s_stupian%></td>
</tr>
<tr>
<td height="37">颜色：<%=s_stupian%></td>
</tr>
<tr>
<td height="33">厂家：<%=s_stupian%></td>
</tr>
<tr>
<td height="38">材料：<%=s_stupian%></td>
</tr>
<tr>
<td height="36">使用年限：<%=s_stupian%></td>
</tr>
<tr>
<td height="37">生产日期：<%=s_stupian%></td>
</tr>
<tr>
<td height="37">购买次数：<%=s_stupian%></td>
</tr>
<tr>
<td height="37">购买次数：<%=s_stupian%></td>
</tr>
<tr>
<td height="36">优点：<%=s_stupian%></td>
</tr>
</table></td><%}%>
</tr>
</table>
<table width="100%" height="15" >
<tr>
<td bgcolor="#E7EFFE"> <span class="style2">返回</span></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<img src="file:///C|/Documents%20and%20Settings/liang/My%20Documents/liangjuyan/yan.png" width="759" height="45"/>
</td>
</tr>
</table>
</body>
</html>
<%conn.close();%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -