📄 untitled-1.jsp~19~
字号:
<%@ 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 10 id,title ,detail from haha ");
int s_id = 0;
String s_title="";
String s_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="";
%>
<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>
<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="760" height="453" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="25%" height="453" valign="top"> <table border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td width="175" height="623">
<table bordercolor="#CCCCCC" bgcolor="#dde8ff" >
<tr>
<td width="181" height="152" valign="top"><table>
<tr>
<td></td>
</tr>
</table>
<table width="100%" height="146" >
<tr>
<td height="30"> <img src="images/xiao.png" width="7" height="7"> 服装</td>
</tr>
<tr>
<td height="108" valign="top">
<table width="100%">
<% int s=1;
while (rs_s.next()) {
type_id=rs_s.getInt(1);
type_name=rs_s.getString(2);
if(s%2!=0){%>
<tr> <td width="46"><a href="detail.jsp?ID=<%=type_id%>"><%=type_name%></a></td><%}%>
<%if(s%2==0) {%> <td width="46"> <a href="detail.jsp?ID=<%=type_id%>"><%=type_name%></a></td></tr><%}%>
<%
s++;}
int count=rs_s.getRow();
if(count%2!=0){%></tr><%}%>
</table>
</td>
</tr></table>
<tr>
<td height="157" valign="top">
<div align="center"><img src="images/xiao.png" width="7" height="7"> 饰品 </div>
<p> 头饰 银饰 耳钉</p>
<p> 项链 脚链 戒指 </p></td>
</tr>
<tr>
<td height="147" valign="top"><div align="center">
<p><img src="images/xiao.png" width="7" height="7"> 生活用品</p>
<p> 脸盆 家具 洁具</p>
<p> 化妆品 厨具 玩具</p>
<p> 调料 配料 罩类 </p>
</div></td>
</tr>
<tr>
<td height="177" valign="top"><div align="center">
<p><img src="images/xiao.png" width="7" height="7"> 其他</p>
<p> 电子产品 通讯用品 </p>
<p> 交通用品 生活用品</p>
<p> 自动用品 电玩</p>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="578" 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=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><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_fuzhuang.next()){break;}
}
catch(Exception e){}
}%>
<tr>
<td height="31" colspan="11"><table width="100%" >
<tr>
<td 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>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
<tr>
<td height="33" colspan="11" background="images/zuihou.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;}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -