feedback.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+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<table align="center" width="400" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC">
<tr bgcolor="3969A5">
    <td height="25"><div align="center"><font color="#FFFFFF">定单投诉</font></div></td>
</tr>
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<%
int pagesize=10;
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 feedback<>'"+null+"'";
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");
String preordainShop=rs.getString("preordainShop");
String feedback=rs.getString("feedback");
%>
<tr bgcolor="CCCCCC">
<td height="20" colspan="2"><div align="center">定单号:<a href="feedback.jsp?show=<%=dingdanid%>&tj=<%=preordainShop%>"><font color="#FF0000"><%=dingdanid%></font></a>　　　投诉人:<a target="_blank" href="user.jsp?id=<%=buyid%>"><font color="#FF0000"><%=buyid%></font></a></div></td>
</tr>
<tr>
<td height="20">　<%=feedback%></td>
</tr>
<tr> 
<td height="10" bgcolor="#E7E7E7"></td>
</tr>
<%
i=0;
dingdanid=0;
buyid="";
preordainShop="";
feedback="";
while(i<pagesize && rs.next())
{
dingdanid=rs.getInt("dingdanid");
buyid=rs.getString("buyid").trim();
preordainShop=rs.getString("preordainShop");
feedback=rs.getString("feedback");
%>
<tr bgcolor="#CCCCCC"> 
<td height="20" colspan="2"><div align="center">定单号:<a href="feedback.jsp?show=<%=dingdanid%>&tj=<%=preordainShop%>"><font color="#FF0000"><%=dingdanid%></font></a>　　　投诉人:<a target="_blank" href="user.jsp?id=<%=buyid%>"><font color="#FF0000"><%=buyid%></font></a></div></td>
</tr>
<tr> 
<td height="20">　<%=feedback%></td>
</tr>
<tr> 
<td height="10" bgcolor="#E7E7E7"></td>
</tr>
<%
i++;
}}%>
</table>
</td>
</tr>
<tr bgcolor="3969A5">
<td height="25"></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="feedback.jsp?page=<%=intpage-1%>">上一页　</a> 
    <%} else{%>
    <a href="feedback.jsp?page=<%=1%>">最前页</a><a href="feedback.jsp?page=<%=intpage-1%>">　上一页</a> 
    <%}}%>
    <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
    <a href="feedback.jsp?page=<%=intpage+1%>">下一页</a> 
    <%}else{%>
    <a href="feedback.jsp?page=<%=intpage+1%>">下一页　</a><a href="feedback.jsp?page=<%=allpage%>">最后页</a> 
    <%}}%>
  </div>
</form>
<%
String show=request.getParameter("show");
if(show!="" && show!=null)
{
String tj=request.getParameter("tj");
if(tj.equals("0"))
{%>
<script language="JavaScript">
window.open("../dingdan.jsp?action=<%=show%>","body","scrollbars=yes,width=420,height=400");
</script>
<%}else{%>
<script language="JavaScript">
window.open("../seedd.jsp?action=<%=show%>","body","scrollbars=yes,width=420,height=400")
</script>
<%}}%>