vip_through.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<br><br>
<table width="360" height="30" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
  <tr> 
    <td><table width="100%" height="30" border="0" cellpadding="0" cellspacing="1">
        <tr> 
          <td width="150" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">用户名</font></div></td>
          <td width="150" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">申请时间</font></div></td>
          <td width="30" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">通过</font></div></td>
          <td width="30" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">拒绝</font></div></td>
        </tr>
      </table></td>
  </tr>
</table>
<table width="360" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="0">
<%
int pagesize=15;
int allcount;
int allpage;
int intpage;
int i;
String strpage=request.getParameter("page");
if(strpage==null)
{
intpage=1;
}
else{
intpage=Integer.parseInt(strpage);
if(intpage<1) intpage=1;
}
String sql="select id,name,actiontime from vip where repel='"+"0"+"' order by id desc";
ResultSet rs=data.executeQuery(sql);
int all=0;
while(rs.next())
{ all++; }
allcount=all;
allpage=(allcount+pagesize-1)/pagesize;
if(intpage>allpage) intpage=allpage;
if(allpage>0)
{
rs.absolute((intpage-1)*pagesize+1);
String name=rs.getString("name");
%>
<tr bgcolor="#FFFFFF">
   <td width="150" height="20"><div align="center"><%=name%></div></td>
   <td width="150"><div align="center"><%=rs.getString("actiontime").substring(0,16)%></div></td>
   <td width="30"><div align="center"><a href="okvip.jsp?name=<%=name%>"><img src="../images/yesvip.GIF" width="16" height="16" border="0"></a></div></td>
   <td width="30"><div align="center"><a href="repelvip.jsp?name=<%=name%>"><img src="../images/novip.GIF" width="16" height="16" border="0"></a></div></td>
</tr>
<%
i=1;
name="";
String actiontime="";
while(i<pagesize && rs.next())
{
name=rs.getString("name");
actiontime=rs.getString("actiontime").substring(0,16);
%>
<tr bgcolor="#FFFFFF">
  <td width="150" height="20"><div align="center"><%=name%></div></td>
  <td width="150"><div align="center"><%=actiontime%></div></td>
  <td width="30"><div align="center"><a href="okvip.jsp?name=<%=name%>"><img src="../images/yesvip.GIF" width="16" height="16" border="0"></a></div></td>
  <td width="30"><div align="center"><a href="repelvip.jsp?name=<%=name%>"><img src="../images/novip.GIF" width="16" height="16" border="0"></a></div></td>
</tr>
<%
i++;
}}%>
      </table></td>
  </tr>
</table>
<form action="" method="post">
<div align="center">当前<font color="#FF0000"><%=intpage%></font>/<font color="#FF0000"><%=allpage%></font>页，每页<font color="#FF0000"><%=pagesize%></font>条
<%if(intpage>1)
 {
if(intpage==1)
 {%>
  <a href="vip_through.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="vip_through.jsp?page=<%=1%>">最前页</a><a href="vip_through.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="vip_through.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="vip_through.jsp?page=<%=intpage+1%>">下一页　</a><a href="vip_through.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>