📄 index.jsp~180~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@ page import="liangjuyan.conndb"%>
<%@ page import="liangjuyan.chStr"%>
<%
conndb conn = new conndb();
chStr chStr=new chStr();
String username=(String)session.getAttribute("username");
ResultSet rs_haha = conn.executeQuery("select top 5 id,title ,detail from haha where htype=1");
int s_id = 0;
String s_title="";
String s_detail="";
ResultSet rs_ha= conn.executeQuery("select top 5 id,title ,detail from haha where htype=0");
int id = 0;
String title="";
String detail="";
ResultSet rs_fuzhuang = conn.executeQuery("select * 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 * 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 * 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 * 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="";
ResultSet rs_s = conn.executeQuery("select * from type_detail");
int type_id = 0;
String type_name="";
ResultSet rs_shi= conn.executeQuery("select * from stype_detail");
int stype_id = 0;
String stype_name="";
ResultSet rs_sheng = conn.executeQuery("select * from htype_detail");
int htype_id = 0;
String htype_name="";
ResultSet rs_qi = conn.executeQuery("select * from qtype_detail");
int qtype_id = 0;
String qtype_name="";
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
.style2 {color: #FF3300}
.style7 {color: #000000}
</style>
</head>
<body>
<jsp:include page="daohang.jsp"/><jsp:include page="dz.jsp"/><jsp:include page="zhongjian.jsp"/>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="136" height="453" valign="top"> <jsp:include page="aa.jsp"/></td>
<td width="484" valign="top">
<table width="100%" height="45" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc">
<tr >
<td height="30" colspan="11" background="images/fei.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="8%"><div align="center">价格</div></td>
</tr>
<%
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=2;
rs_fuzhuang.last();
int RecordCount=rs_fuzhuang.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_fuzhuang.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(14);
if (username==null || username==""){%>
<tr> <td height="28"><a href="fuzhuang_detail.jsp?ID=<%=s_fuzhuangid%>"><%=s_fuzhuangid%></a></td>
<td height="28"><%=s_fwupinming%></td>
<td><%=s_fyanse%></td>
<td><%=s_fchangjia %></td>
<td><%=s_fcailiao%></td>
<td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
</tr>
<%}else{%>
<tr> <td height="31" align="top"><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_fprice%></td>
</tr><%}
try{
if(!rs_fuzhuang.next()){break;}
}
catch(Exception e){}
}%>
<tr>
<td height="31" colspan="11" align="top" valign="top">
<table width="100%" >
<tr>
<td height="20" align="right"><span class="style7">当前页数：</span>[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1" class="style7">第一页</a> <a href="index.jsp?Page=<%=Page-1%>" class="style7">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>" class="style7">下一页</a> <a href="index.jsp?Page=<%=maxPage%>"><span class="style7">最后一页</span> </a>
<%}
%> </td>
</tr>
</table></td>
</tr>
</table></td></tr>
<tr><td> <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc">
<tr >
<td height="33" colspan="11" background="images/fei.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>
<%
String str2=(String)request.getParameter("Page2");
if(str2==null){
str2="0";
}
int pagesize2=2;
rs_shipin.last();
int RecordCount2=rs_shipin.getRow();
int maxPage2=0;
maxPage2=(RecordCount2%pagesize2==0)?(RecordCount2/pagesize2):(RecordCount2/pagesize2+1);
int Page2=Integer.parseInt(str2);
if(Page2<1){
Page2=1;}
else{
if(Page2>maxPage2){
Page2=maxPage2;
}
}
rs_shipin.absolute((Page2-1)*pagesize2+1);
for(int i=1;i<=pagesize2;i++){
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(14);
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><%}
try{
if(!rs_shipin.next()){break;}
}
catch(Exception e){}
}%>
<tr>
<td height="31" colspan="11" align="top"><table width="100%" >
<tr>
<td align="right"><span class="style7">当前页数：</span>[<%=Page2%>/<%=maxPage2%>]
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -