📄 index.jsp~173~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@ page import="liangjuyan.conndb"%>
<%
conndb conn = new conndb();
String username=(String)session.getAttribute("username");
ResultSet rs_haha = conn.executeQuery("select top 10 id,title ,detail from haha ");
int s_id = 0;
String s_title="";
String s_detail="";
ResultSet rs_fuzhuang = conn.executeQuery("select top 2 fuzhuangid, wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian,price 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="";
String s_fprice="";
ResultSet rs_shipin = conn.executeQuery("select top 2 shipinid, wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian,price 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="";
String s_sprice="";
ResultSet rs_shenghuoyongpin = conn.executeQuery("select top 2 shenghuoyongpinid,wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian,price 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="";
String s_hprice="";
ResultSet rs_qita = conn.executeQuery("select top 2 qitaid,wupinming,yanse,changjia,cailiao,shiyongnianxian,shengchanriqi,goumaichishu,tuijianzhishu,youdian,tupian,price 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="";
String s_qprice="";
%>
<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" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="404" valign="top">
<jsp:include page="daohang.jsp"/><jsp:include page="dz.jsp"/><jsp:include page="zhongjian.jsp"/>
<table width="100%" height="453" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="25%" height="453" valign="top">
<table width="192" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr bordercolor="#FF9966">
<td width="192" height="33" valign="midder" background="images/haha.png"> 最新资讯 </td>
</tr>
<%
while (rs_haha.next()) {
s_id=rs_haha.getInt(1);
s_title=rs_haha.getString(2);
%>
<tr>
<td height="39">
<table >
<tr>
<td height="31" valign="midder "><a href="zuixindetail.jsp?ID=<%=s_id%>"><%=s_title%></a></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="418" valign="top">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td height="34" colspan="11" valign="top" background="images/zuihou.png" width="556"> 服装</td>
</tr>
<tr>
<td width="57"><div align="center">编号</div></td>
<td width="51" height="27"><div align="center">物品名</div></td>
<td width="35"><div align="center">颜色</div></td>
<td width="42"><div align="center">厂家</div></td>
<td width="47"><div align="center">材料</div></td>
<td width="53"><div align="center">使用年限</div></td>
<td width="54"><div align="center">生产日期</div></td>
<td width="60"><div align="center">购买次数</div></td>
<td width="54"><div align="center">推荐指数</div></td>
<td width="37"><div align="center">优点</div></td>
<td width="43"><div align="center">价格</div></td>
</tr>
<%
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=10;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);
int Page=Integer.parseInt(str);
if(Page<1){
Page=1;}
else{
if(Page>maxPage){
Page=maxPage;
}
}
rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
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);
s_fprice= rs_fuzhuang.getString(12);
if (username==null || username==""){%>
<tr>
<td><a href="fuzhuang_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>
<td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
</tr>
<%}else{%>
<tr>
<td><a href="fuzhuang_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>
<td><%=s_fprice%></td>
</tr> <%}
try{
if(!rs.next()){break;}
}
catch(Exception e){}
}%>
<tr>
<td height="31" colspan="11"><table width="100%" >
<tr>
<td align="right">当前页数：[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1">第一页</a> <a href="index.jsp?Page=<%=Page-1%>">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>">下一页</a> <a href="index.jsp?Page=<%=maxPage%>">最后一页 </a>
<%}
%>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -