already_send.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<%
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+"' and system='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，您不是系统管理员不能进行相应操作");
history.back();
</script>
<%}}%>
<table width="270" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td width="300" height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">管理已发货定单</font></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
		  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
		  <tr>
		  <td width="90" height="20"><div align="center"><font color="#FF0000">定单号</font></div></td>
		  <td width="60"><div align="center"><font color="#FF0000">类型</font></div></td>
		  <td width="80"><div align="center"><font color="#FF0000">提交人</font></div></td>
		  <td width="40"><div align="center"><font color="#FF0000">操作</font></div></td>
		  </tr>
		  <%
		  int pagesize=20;
		  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 * from dingdan where send='"+"1"+"'";
          ResultSet rs=data.executeQuery(sql);
          if(!rs.next())
          {%>
          <tr bgcolor="#FFFFFF">
          <td height="30" colspan="5"><div align="center">尚无已发货定单</div></td>
          </tr>
          <%}
		  rs.last();
		  allcount=rs.getRow();
		  allpage=(allcount+pagesize-1)/pagesize;
		  if(intpage>allpage) intpage=allpage;
		  if(allpage>0)
		  {
		  rs.absolute((intpage-1)*pagesize+1);
		  int dingdanid=rs.getInt("dingdanid");
		  String buyid=rs.getString("buyid").trim();
		  String preordainShop=rs.getString("preordainShop");		  
		  %>
		  <tr>
		  <td width="90" height="20"><div align="center"><a href="already_send.jsp?see=<%=preordainShop%>&did=<%=dingdanid%>"><%=dingdanid%></a></div></td>
		  <td width="60"><div align="center"><%if(preordainShop.equals("0")){%>购买<%}else{%>预定<%}%></div></td>
		  <td width="80"><div align="center"><a target="_blank" href="user.jsp?id=<%=buyid%>"><%=buyid%></a></div></td>
		  <td width="40"><div align="center"><a href="already_send.jsp?see=<%=preordainShop%>&did=<%=dingdanid%>"><font color="#FF0000">查看</font></a></div></td>
		  </tr>
		  <%
		  i=1;
		  dingdanid=0;
		  preordainShop="";
		  buyid="";
		  while(i<pagesize && rs.next())
		  {
		  dingdanid=rs.getInt("dingdanid");
		  buyid=rs.getString("buyid").trim();
		  preordainShop=rs.getString("preordainShop");		  
		  %>
		  <tr>
		  <td width="90" height="20"><div align="center"><a href="already_send.jsp?see=<%=preordainShop%>&did=<%=dingdanid%>"><%=dingdanid%></a></div></td>
		  <td width="60"><div align="center"><%if(preordainShop.equals("0")){%>购买<%}else{%>预定<%}%></div></td>
		  <td width="80"><div align="center"><a target="_blank" href="user.jsp?id=<%=buyid%>"><%=buyid%></a></div></td>
		  <td width="40"><div align="center"><a href="already_send.jsp?see=<%=preordainShop%>&did=<%=dingdanid%>"><font color="#FF0000">查看</font></a></div></td>
		  </tr>
		  <%
		  i++;
		  }}%>
		  </table>
		  </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="25" bgcolor="3969A5"></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="already_send.jsp?page=<%=intpage-1%>">上一页　</a> 
  <%} else{%>
  <a href="already_send.jsp?page=<%=1%>">最前页</a><a href="already_send.jsp?page=<%=intpage-1%>">　上一页</a> 
  <%}}%>
  <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
  <a href="already_send.jsp?page=<%=intpage+1%>">下一页</a> 
  <%}else{%>
  <a href="already_send.jsp?page=<%=intpage+1%>">下一页　</a><a href="already_send.jsp?page=<%=allpage%>">最后页</a> 
  <%}}%>
  </div>
</form>
<%
String see=request.getParameter("see");
if(see!="" && see!=null)
{
String did=request.getParameter("did");
if(see.equals("0"))
{%>
<script language="JavaScript">
window.open("../dingdan.jsp?action=<%=did%>","body","scrollbars=yes,width=420,height=400");
</script>
<%}else{%>
<script language="JavaScript">
window.open("../seedd.jsp?action=<%=did%>","body","scrollbars=yes,width=420,height=400")
</script>
<%}}%>