deldingdan.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*,java.util.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<jsp:useBean id="equalse" scope="page" class="shop.web.getdate" />
<%
String member=(String)session.getValue("manager");
if(member=="" && member==null)
{%>
<script language="JavaScript">
alert("请登陆后再进入用户管理后台");
history.back();
</script>
<%}else{
String sql="select * from manager where name='"+member+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="JavaScript">
alert("对不起，您的用户名不存在或已被删除");
history.back();
</script>
<%}}%>
<%
String id=request.getParameter("id");
String sql="select * from preordain where dingdanid='"+id+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String actionid=rs.getString("actionid");
String gettime=rs.getString("chktime").substring(0,16);
rs.close();
java.util.Date today=new java.util.Date();
String daytime=today.toLocaleString();
daytime=daytime.substring(0,16);

if(equalse.equalse(daytime,gettime)==true)
{
sql="delete from preordain where dingdanid='"+id+"'";
rs=data.executeQuery(sql);
sql="delete from dingdan where dingdanid='"+id+"'";
rs=data.executeQuery(sql);
response.sendRedirect("manager.jsp");
}
if(equalse.equalse(daytime,gettime)==false){%>
<script language="JavaScript">
alert("对不起，已超出指定时间，您无法取消该定单");
history.back();
</script>
<%}%>