manager.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>
<%}}%>
<%
String id=request.getParameter("id");
if(id!="" && id!=null)
{
String sql="delete from manager where name='"+id+"'";
ResultSet rs=data.executeQuery(sql);

sql="select * from manager where name='"+id+"'";
rs=data.executeQuery(sql);
if(rs.next())
{%>
<script language="JavaScript">
alert("发成异常错误，请重试");
</script>
<%}}%>
<style language="javascript">
<!-- @import url(../images/css.css); -->
</style>
<br><br>
<table width="600" 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="120" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">用户名</font></div></td>
          <td width="40" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">性别</font></div></td>
          <td width="80" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">用户级别</font></div></td>
          <td width="180" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">email</font></div></td>
          <td width="120" 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="600" 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 rate="";
	 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,sex,rate,email,regTime from manager where rate='"+"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="120" height="20"><div align="center"><a href="edit_manager.jsp?name=<%=name%>"><%=name%></a></div></td>
	 <td width="40"><div align="center"><%=rs.getString("sex")%></div></td>
	 <td width="80"><div align="center">
	 <%
	 rate=rs.getString("rate");
	 if(rate.equals("0"))
	 { rate="普通用户"; }
	 %><%=rate%></div></td>
	 <td width="180"><div align="center"><a href="mailto:<%=rs.getString("email")%>"><%=rs.getString("email")%></a></div></td>
	 <td width="120"><div align="center"><%=rs.getString("regTime").substring(0,10)%></div></td>
	 <td width="30"><div align="center"><a href="edit_manager.jsp?name=<%=name%>"><img src="../images/edit.gif" width="18" height="18" border="0"></a></div></td>
	 <td width="30"><div align="center"><a href="manager.jsp?id=<%=name%>"><img src="../images/delete.gif" width="16" height="14" border="0"></a></div></td>
	 </tr>
	 <%
	 i=1;
	 name="";
	 String sex="";
	 rate="";
	 String email="";
	 String regTime="";
	 while(i<pagesize && rs.next())
	 {
	 name=rs.getString("name");
	 sex=rs.getString("sex");
	 rate=rs.getString("rate");
	 email=rs.getString("email");
	 regTime=rs.getString("regTime").substring(0,10);
	 %>
	 <tr bgcolor="#FFFFFF">
	 <td width="120" height="20"><div align="center"><a href="edit_manager.jsp?name=<%=name%>"><%=name%></a></div></td>
	 <td width="40"><div align="center"><%=sex%></div></td>
	 <td width="80"><div align="center">
	 <%
	 if(rate.equals("0"))
	 { rate="普通用户"; }
	 %><%=rate%></div></td>
	 <td width="180"><div align="center"><a href="mailto:<%=email%>"><%=email%></a></div></td>
	 <td width="120"><div align="center"><%=regTime%></div></td>
	 <td width="30"><div align="center"><a href="eidt_manager.jsp?name=<%=name%>"><img src="../images/edit.gif" width="18" height="18" border="0"></a></div></td>
	 <td width="30"><div align="center"><a href="manager.jsp?id=<%=name%>"><img src="../images/delete.gif" width="16" height="14" 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="manager.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="manager.jsp?page=<%=1%>">最前页</a><a href="manager.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="manager.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="manager.jsp?page=<%=intpage+1%>">下一页　</a><a href="manager.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>