⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 weclomedianzichanpin.jsp~5~

📁 用JSP制作的个人网站
💻 JSP~5~
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@page import="liangjuyan.conndb"%>
<%
  conndb conn = new conndb();
  ResultSet rs = conn.executeQuery("select top 16 qitaid, wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian ,tupian from qita where tebietuijian=1");
  int s_id = 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="";
%>
<script src="JS/check.jsp"></script>
<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" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td height="934" valign="top">
      <jsp:include page="daohang.jsp"/><jsp:include page="dz.jsp"/>
      <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="408" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="72%" height="408" valign="top">
            <table width="100%" height="328"  cellpadding="0" cellspacing="0" border="1" bordercolor="#cccccc">
              <tr>
                <td height="40" background="images/zuihou.png" bgcolor="#ff9966"> </td>
                  
              </tr>
              <tr>
                <td height="286" valign="top"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
                    <tr>

                    </tr>
                    <tr>

                      <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.next()) {
                    s_id=rs.getInt(1);
                     s_qwupinming = rs.getString(2);
                      s_qyanse = rs.getString(3);
                       s_qchangjia = rs.getString(4);
                        s_qcailiao = rs.getString(5);
                         s_qshiyongnianxian = rs.getString(6);
                          s_qshengchanriqi = rs.getString(7);
                          s_qgoumaichishu= rs.getString(8);
                           s_qtuijianzhishu= rs.getString(9);
                            s_qyoudian= rs.getString(10);
                  %>
                    <tr>

                      <td height="31"><a href="goods_detail.jsp?ID=<%=s_id%>"><%=s_qwupinming%></a></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>
                    </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 + -