?? allmerchantlist.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,com.netshop.*" %>
<jsp:useBean scope="page" id="goods" class="com.netshop.goods" />
<jsp:useBean scope="page" id="user" class="com.netshop.user" />
<jsp:useBean scope="page" id="executeWay" class="com.netshop.executeWay" />
<%
int count=0;
int totalPageCount=0;
int perPageCount=5;
int currentPage=1;
String pageId = request.getParameter("page");
if(pageId!=null)
{
currentPage=Integer.parseInt(pageId);
//out.println(pageId);
}
%>
<html>
<head>
<title>網上商品交易平臺</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<div align=center>
<p align="center"><font size="5">店鋪信息</font></p>
<table width="90%" border=0>
<form name=form1 action=userDelete.jsp method=post>
<input type=hidden name="page" value=<%=currentPage%> >
<input type=hidden name="toURL" value="allMerchantList.jsp" >
<tr bgcolor="#F0F0F0">
<td align="center"><font size="4">店名</font></td>
<td align="center"><font size="4">店主</font></td>
<td align="center"><font size="4">經營項目</font></td>
<td align="center"><font size="4">
操作</font></td>
<td align="center"><font size="4">刪除</font></td>
</tr>
<%
ResultSet rs = user.showAllMerchants("1");
rs.last();//移到末尾
count = rs.getRow();//取得總查詢數
totalPageCount = (count + perPageCount -1)/perPageCount;
if(currentPage > totalPageCount || currentPage<=0)
{
currentPage=1;
}
int currentIndex = (currentPage - 1) * perPageCount +1;
if(count>0)
{
rs.absolute(currentIndex);
String strSql1 = "select name from goodsField where ID = '"+rs.getLong("mainFields")+"'";
ResultSet rs1 = executeWay.exeSqlQuery(strSql1);
rs1.first();
%>
<tr>
<td> <%=rs.getString("shopName")%></td>
<td> <%=rs.getString("shopper")%></td>
<td> <%=rs1.getString("name")%></td>
<td> <a href=merchantModifyForm.jsp?ID=<%=rs.getLong("ID")%>>修改</a></td>
<td align=center><input type=checkbox name=deleteID value=<%=rs.getLong("ID")%>></td>
</tr>
<%
int i=1;
while(rs.next())
{
strSql1 = "select name from goodsField where ID = '"+rs.getLong("mainFields")+"'";
rs1 = executeWay.exeSqlQuery(strSql1);
rs1.first();
%>
<tr>
<td> <%=rs.getString("shopName")%></td>
<td> <%=rs.getString("shopper")%></td>
<td> <%=rs1.getString("name")%></td>
<td> <a href=merchantModifyForm.jsp?ID=<%=rs.getLong("ID")%>>修改</a></td>
<td align=center><input type=checkbox name=deleteID value=<%=rs.getLong("ID")%>></td>
</tr>
<%
i++;
if(i > perPageCount-1) break;
}
}
%>
<tr>
<td colspan=5 align=center><br>
<input type=submit name=delete value=刪除所選店鋪>
</td>
</tr>
</form>
</table>
<br>
<table width="90%" border=0>
<tr align="right" valign="top">
<td colspan="4" align="right">
<%
String firstLink,lastLink,preLink,nextLink;
firstLink="allMerchantList.jsp?page=1";
lastLink="allMerchantList.jsp?page="+totalPageCount;
if(currentPage>1)
{
preLink="allMerchantList.jsp?page="+(currentPage-1);
}
else
{
preLink=firstLink;
}
if(currentPage <= totalPageCount-1)
{
nextLink="allMerchantList.jsp?page="+(currentPage+1);
}
else
{
nextLink=lastLink;
}
%>
<form method="post" action="allMerchantList.jsp">
<p align=center>共<font color="#0000FF"><%= count %></font>條 第<font color="#0000FF"><%= currentPage %></font>頁/共<font color="#0000FF"><%= totalPageCount %></font>頁 | <a href=<%=firstLink%> >首頁 </a> | <a href=<%=preLink%> > 上一頁 </a> | <a href=<%=nextLink%>> 下一頁 </a> | <a href=<%=lastLink%> > 尾頁 </a> | 轉到
<input type="text" name=page size=2> <input type="submit" name=submit value=GO> </p>
</form>
</td>
</tr>
</table>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -