preordain.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+"' and system='"+"1"+"'";
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>
<script language="JavaScript">
function check()
{
  if(document.thistext.relapse.value.length==0)
  {
    alert("请填写回复内容");
	document.thistext.relapse.focus();
	return false;d
  }
}
function see(a)
{
   window.open("../seedd.jsp?action="+a,"body","scrollbars=yes,width=420,height=400")
}
</script>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr> 
    <td height="25" bgcolor="3969A5"></td>
  </tr>
  <tr>
    <td>
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td bgcolor="#FFFFFF">
		  <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
		  <tr bgcolor="#CCCCCC">
		  <td width="100" height="25"><div align="center">定单号</div></td>
		  <td width="150"><div align="center">定单提交时间</div></td>
		  <td width="100"><div align="center">提交人</div></td>
		  <td width="80" colspan="2"><div align="center">定单状态</div></td>
		  <td width="70" colspan="2"><div align="center">操作</div></td>
		  </tr>
		  <%
		  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,dingdanid,buyid,censor_yes,actiontime from dingdan where preordainShop='"+"1"+"' and send='"+"0"+"' order by id desc";
		  ResultSet rs=data.executeQuery(sql);
		  if(!rs.next())
		  {%>
		  <tr bgcolor="#FFFFFF">
          <td height="60" colspan="7"><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 censor_yes=rs.getString("censor_yes");
		  String actiontime=rs.getString("actiontime").substring(0,16);		  
		  %>
		  <tr>
		  <td width="100" height="25"><div align="center"><a href="preordain.jsp?edit=<%=dingdanid%>"><%=dingdanid%></a></div></td>
		  <td width="150"><div align="center"><%=actiontime%></div></td>
		  <td width="100"><div align="center"><a target="_blank" href="user.jsp?id=<%=buyid%>"><%=buyid%></a></div></td>
		  <td width="40"><div align="center"><%if(censor_yes.equals("0")){%><a href="preordain.jsp?through=<%=dingdanid%>"><font color="#FF0000">审核</font></a><%}else{%><font color="#0000FF">已通过</font><%}%></div></td>
		  <td width="40"><div align="center"><a href="send.jsp?id=<%=dingdanid%>&buy=<%=buyid%>"><font color="#FF0000">发货</font></a></div></td>
		  <td width="35"><div align="center"><a href="preordain.jsp?edit=<%=dingdanid%>"><font color="#999999">编辑</font></a></div></td>
		  <td width="35"><div align="center"><a href="preordain.jsp?del=<%=dingdanid%>"><font color="#999999">删除</font></a></div></td>
		  </tr>
		  <%
		  i=1;
		  dingdanid=0;
		  buyid="";
		  censor_yes="";	
		  actiontime="";
		  while(i<pagesize && rs.next())
		  {
		  dingdanid=rs.getInt("dingdanid");
		  buyid=rs.getString("buyid");
		  censor_yes=rs.getString("censor_yes");
		  actiontime=rs.getString("actiontime").substring(0,16);
		  %>
		  <tr>
		  <td width="100" height="25"><div align="center"><a href="preordain.jsp?edit=<%=dingdanid%>"><%=dingdanid%></a></div></td>
		  <td width="150"><div align="center"><%=actiontime%></div></td>
		  <td width="100"><div align="center"><a target="_blank" href="user.jsp?id=<%=buyid%>"><%=buyid%></a></div></td>
		  <td width="40"><div align="center"><%if(censor_yes.equals("0")){%><a href="preordain.jsp?through=<%=dingdanid%>"><font color="#FF0000">审核</font></a><%}else{%><font color="#0000FF">已通过</font><%}%></div></td>
		  <td width="40"><div align="center"><a href="send.jsp?id=<%=dingdanid%>&buy=<%=buyid%>"><font color="#FF0000">发货</font></a></div></td>
		  <td width="35"><div align="center"><a href="preordain.jsp?edit=<%=dingdanid%>"><font color="#999999">编辑</font></a></div></td>
		  <td width="35"><div align="center"><a href="preordain.jsp?del=<%=dingdanid%>"><font color="#999999">删除</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="preordain.jsp?page=<%=intpage-1%>">上一页　</a> 
    <%} else{%>
    <a href="preordain.jsp?page=<%=1%>">最前页</a><a href="preordain.jsp?page=<%=intpage-1%>">　上一页</a> 
    <%}}%>
    <%
if(intpage<allpage)
 {
  if(intpage==allpage)
 {%>
    <a href="preordain.jsp?page=<%=intpage+1%>">下一页</a> 
    <%}else{%>
    <a href="preordain.jsp?page=<%=intpage+1%>">下一页　</a><a href="preordain.jsp?page=<%=allpage%>">最后页</a> 
    <%}}%>
  </div>
</form>
<br><br><br><br>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<%
String edit=request.getParameter("edit");
if(edit!="" && edit!=null)
{%>
<tr bgcolor="3969A5">
<td height="25" colspan="4"><div align="center"><font color="#FFFFFF">商品信息</font></div></td>
</tr>
<tr>
<td height="25" width="150"><div align="center">商品名:</div></td>
<td width="80"><div align="center">数量:</div></td>
<td width="100"><div align="center">期望价格:</div></td>
<td width="70"><div align="center">有效期</div></td>
</tr>
<%
sql="select * from preordain where dingdanid='"+edit+"'";
rs=data.executeQuery(sql);
if(rs.next())
{
String actionid=rs.getString("actionid");
String warename=rs.getString("warename");
int number=rs.getInt("number");
String condition=rs.getString("condition");
int price=rs.getInt("price");
int yx=rs.getInt("yx");
String yxdate=rs.getString("yxdate");
%>
<tr bgcolor="#FFFFFF">
<td width="150" height="25"><div align="center"><a href="javascript:see(<%=edit%>)"><%=warename%></a></div></td>
<td width="80"><div align="center"><%=number%>个/件</div></td>
<td width="100"><div align="center"><%=condition%>:<%=price%>元</div></td>
<td width="70"><div align="center"><%=yx%><%=yxdate%></div></td>
</tr>
<tr bgcolor="3969A5">
<td height="25" colspan="4"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" colspan="4"></td>
</tr>
<tr bgcolor="3969A5">
    <td height="25" colspan="4"><div align="center"><font color="#FFFFFF">定单信息</font></div></td>
</tr>
<tr>
<td colspan="4">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="120" height="20"><div align="right">定单号:</div></td>
<td width="10"></td>
<td width="270"><a href="preordain.jsp?edit=<%=edit%>"><font color="#FF0000"><%=edit%></font></a></td>
</tr>
<tr>
<td height="20"><div align="right">购买人:</div></td>
<td></td>
<td><a target="_blank" href="user.jsp?id=<%=actionid%>"><font color="#FF0000"><%=actionid%></font></a></td>
</tr>
<tr>
<td height="20"><div align="right">定单说明:</div></td>
<td></td>
<td><%
String text="select explain,actiontime from dingdan where dingdanid='"+edit+"'";
ResultSet trs=data.executeQuery(text);
trs.next();
String explain=trs.getString("explain").trim();
String actiontime=trs.getString("actiontime").substring(0,16);
trs.close();
%><%=explain%></td>
</tr>
<tr>
<td height="20"><div align="right">提交时间:</div></td>
<td></td>
<td><%=actiontime%></td>
</tr>
<tr bgcolor="3969A5">
<td height="25" colspan="3"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="4">
<form action="" method="post" name="thistext" onSubmit="return check()">
<input type="hidden" name="rethis" value="">
<input type="hidden" name="id" value="<%=edit%>">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td height="20" colspan="3"></td>
</tr>
<tr bgcolor="3969A5">
          <td height="25" colspan="3"><div align="center"><font color="#FFFFFF">回复定单</font></div></td>
</tr>
<tr>
<td height="15" colspan="3"></td>
</tr>
<tr>
<td width="120" height="20" valign="top"><div align="right">回复定单:</div></td>
<td width="10"></td>
<td width="270"><textarea name="relapse" cols="40" rows="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></textarea></td>
</tr>
<tr>
<td height="10" colspan="3"></td>
</tr>
<tr>
<td height="25" colspan="3"><div align="center"><input type="submit" value="回复" onClick="document.all.rethis.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<input type="reset" value="重写" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
<tr>
<td height="15" colspan="3"></td>
</tr>
<tr bgcolor="3969A5">
<td height="25" colspan="3"></td>
</tr>
</table>
</form>
</td>
</tr>
<%}}%>
</table>
<%
String re=request.getParameter("rethis");
if(re!=null && re.equals("true"))
{
String id=request.getParameter("id");
String setrelapse=request.getParameter("relapse");
setrelapse=new String(setrelapse.getBytes("ISO8859_1"),"GBK");
sql="update dingdan set relapse='"+setrelapse+"' where dingdanid='"+id+"'";
rs=data.executeQuery(sql);
response.sendRedirect("preordain.jsp");
}
%>
<%
String through=request.getParameter("through");
if(through!="" && through!=null)
{
java.util.Date today=new java.util.Date();
String throughtime=today.toLocaleString();
sql="update dingdan set censor_yes='"+"1"+"',throughtime='"+throughtime+"' where dingdanid='"+through+"'";
rs=data.executeQuery(sql);
response.sendRedirect("preordain.jsp");
}
%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
sql="select * from dingdan where dingdanid='"+del+"'";
rs=data.executeQuery(sql);
rs.next();
String censor_yes=rs.getString("censor_yes");
rs.close();
if(censor_yes.equals("1"))
{%>
<script language="JavaScript">
alert("该定单已被审核，不能删除");
</script>
<%}else{
sql="delete from dingdan where dingdanid='"+del+"'";
rs=data.executeQuery(sql);
sql="delete from preordain where dingdanid='"+del+"'";
rs=data.executeQuery(sql);
response.sendRedirect("preordain.jsp");
}}
%>