📄 untitled-6.jsp~3~
字号:
<%@ 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 = conn.executeQuery("select * from fuzhuang where tebietuijian=1 ");
int s_id=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="";
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<jsp:include page="daohang.jsp"/><jsp:include page="zhongjian.jsp"/>
<div align="center"><table align="center">
<tr><td width="130"><jsp:include page="aa.jsp"/></td><td width="441">
<table width="441" height="206">
<tr>
<td width="433" height="159" valign="top">
<table width="433">
<tr>
<%
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=2;
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);
int s=1;
for(int i=1;i<=pagesize;i++){
s_id=rs.getInt(1);
s_fwupinming = rs.getString(2);
s_fprice= rs.getString(14);
s_ftupian= rs.getString(11);
if(s%3!=0){
%>
<td width="211" valign="top"><table width="96%" border="1" bordercolor="#FFCC99">
<tr>
<td width="35%" height="138" valign="top"><div align="center">
<table width="189" align="left" >
<tr>
<td width="103" height="133"><div align="center"><img src="images/<%=s_ftupian%>" width="100" height="100"></div></td>
<td width="74" valign="top"><table width="100%" height="128">
<tr>
<td><div align="center"><%=s_fwupinming%></div></td>
</tr>
<tr>
<td><div align="center">原价：<%=s_fprice%></div></td>
</tr>
<tr>
<td><div align="center">特价：<%=s_fprice%></div></td>
</tr>
</table></td>
</tr>
</table>
</div>
</td>
</tr>
</table></td><%}%>
<% if(s%3==0){%><td width="210" valign="top"><table width="95%" border="1" bordercolor="#FFCC99">
<tr>
<td width="35%" height="138" valign="top"><div align="center">
<table width="194" align="left" >
<tr>
<td width="103" height="133"><div align="center"><img src="images/<%=s_ftupian%>" width="100" height="100"></div></td>
<td width="79" valign="top"><table width="100%" height="128">
<tr>
<td><div align="center"><%=s_fwupinming%></div></td>
</tr>
<tr>
<td><div align="center">原价：<%=s_fprice%></div></td>
</tr>
<tr>
<td><div align="center">特价：<%=s_fprice%></div></td>
</tr>
</table></td>
</tr>
</table>
</div>
</td>
</tr>
</table></td></tr><%}
s++; } %>
</table></td>
</tr>
<tr>
<td height="39" valign="top"><table width="100%" >
<tr>
<td height="38" align="right"><span class="style7">当前页数：</span>[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="Untitled-6.jsp?Page=1" class="style7">第一页</a> <a href="Untitled-6.jsp?Page=<%=Page-1%>" class="style7">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="Untitled-6.jsp?Page=<%=Page+1%>" class="style7">下一页</a> <a href="Untitled-6.jsp?Page=<%=maxPage%>"><span class="style7">最后一页</span> </a>
<%}
%> </td>
</tr>
</table></td>
</tr>
</table></td></tr></table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -