📄 orderdel.jsp

📁 面向对象软件工程案例
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!--   **************************************************************
       **项目名称：网上书店管理端            ************************
       **内容：订单删除                 ************************
       **此页作者：luic                      ************************
       **完成日期：2004/4/26                 ************************
       **修改：   调试通过                   ************************
       **说明： 
       **入口参数： orderID 订单号，itemID 定书项ID
       **************************************************************
-->
<%@ page contentType="text/html; charset=GBK"%> 
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="page.page"%>

<HTML><HEAD><TITLE>网上商店</TITLE>


<STYLE>HTML {
	TEXT-DECORATION: none
}
A:link {
	COLOR: #000000; TEXT-DECORATION: underline
}
A:active {
	COLOR: #000000; TEXT-DECORATION: underline
}
A:visited {
	COLOR: #000000; TEXT-DECORATION: underline
}
A:hover {
	COLOR: rgb(0,147,43); TEXT-DECORATION: underline
}
EM {
	FONT-SIZE: 16pt; FONT-STYLE: normal; FONT-FAMILY: CourierNew
}
A {
	FONT-SIZE: 9pt
}
TD {
	FONT-SIZE: 9pt
}
P {
	FONT-SIZE: 9pt
}
.hh INPUT {
	BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid; BACKGROUND-COLOR: #ffffff
}
</STYLE>

<%
	String admin=(String)session.getAttribute("name");
	if(admin==null||admin==""){
%>
<script>
	   alert("你尚未登录");
</script>
<%
	   response.sendRedirect("login.jsp");
	   }
%>


<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="Microsoft FrontPage 4.0" name=GENERATOR></HEAD>
<BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff 
leftMargin=0 topMargin=0 MARGINHEIGHT="0" MARGINWIDTH="0">
<SCRIPT language=JavaScript>
<!--
function checkss()
{
   if(checkspace(document.searchform.searchkey.value !='请输入关键字'))  {
	document.searchform.searchkey.focus();
	alert("请输入查询关键字！");
	return false;
  }
  if(checkspace(document.searchform.searchkey.value))  {
	document.searchform.searchkey.focus();
	alert("请输入查询关键字！");
	return false;
  }
   document.searchform.submit();
}
function checkspace(checkstr) {
  var str = '';
  for(i = 0; i < checkstr.length; i++) {
    str = str + ' ';
  }
  return (str == checkstr);
}
//-->
</SCRIPT>

<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
  <TBODY>
  <TR>
    <TD><IMG height=63 src="images/guide_0.gif" width=238></TD>
    <TD><IMG height=63 src="images/guide_1.gif" width=538></TD></TR>
    <TD><IMG height=35 src="images/guide_2.gif" width=238></TD>
    <TD background=images/guide_3.gif height=35>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD colSpan=2 height=10><IMG height=13 src="images/space.gif" 
            width=10></TD></TR>
        <TR>
          <TD width="8%">　</TD>
          <TD width="92%"><FONT color=#ffffff>■   
    		订单处理</FONT></TD></TR></TBODY></TABLE></TD></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0 height="524">
  <TBODY>
      <TD vAlign=top width=195 bgColor=#ffffff height=48>
      <TABLE height=48 cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <td width="98%" height="48" bgcolor="#99CC66">
    	<p align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="黑体" size="4">  
		&nbsp;功能列表 </font>
   	</td></TR></TBODY></TABLE></TD>
    <TD vAlign=top width=581 bgColor=#ffffff height=524 rowspan="2" bordercolor="#8EEB32">
      <TABLE cellSpacing=0 cellPadding=0 width="101%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-bottom-width: 1px; padding: 0; border-right-style:solid; border-bottom-style:solid" bordercolor="#99CC66" height="518">
        <TBODY>
               <tr>
          <FORM id=Form1 name=searchform 
                action=dealOrder.jsp method=post>
               <TD bgColor=#bede9e height=25 align=top>
      <DIV align=center>
		<IMG height=16 
      src="images/search.gif" width=64 align=middle> 
      &nbsp;   
        <INPUT onfocus="this.value=''" value=请输入关键字 name=searchkey size="20"> 
		<SELECT   
      id=action name=action size="1"> <OPTION value=1 selected>订单号</OPTION> 
		<option value="2">用户名</option>
		</SELECT> &nbsp; <INPUT id=Submit1 style="BORDER-RIGHT: #333333 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #333333 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #333333 1px solid; COLOR: #333333; LINE-HEIGHT: normal; BORDER-BOTTOM: #333333 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 18px; BACKGROUND-COLOR: #cee7ef; FONT-VARIANT: normal" onclick="return checkss();" type=submit value=立即查询 name=Submit>  
      &nbsp;&nbsp;   
        &nbsp;&nbsp;</DIV></TD></FORM></TR>
               <TD vAlign=top width=581 bgColor=#ffffff height=400>
      <TABLE cellSpacing=4 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR vAlign=top>
          <TD height=389><FONT color=#000000>
            <SCRIPT>
function cm(nn){
qus=confirm("确实要删除吗？")
if(qus!=0){
window.location='order1.php?step=del&orderid='+nn;
}
}
</SCRIPT>
            </FONT>
			<div align="center">
            <TABLE cellSpacing=0 cellPadding=0 width="97%" 
border=0>
              <TBODY>
              <TR bgColor=#99cc66>
                <TD width=507 height=44>
<p>&nbsp;&nbsp;
<% 
  String orderID=request.getParameter("orderID");         //定单号
  String itemID=request.getParameter("itemID");           //定书项号
  String sql=new String();

  try
  {
    ////建立数据库连接 
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:bookStore");
    Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); 
    ////删除订单项
    if(orderID==null)  //删除一项
    {
      //获得要删除的项
      sql="SELECT * FROM item WHERE itemID='"+itemID+"'";
      ResultSet rs=stmt.executeQuery(sql);
      //获得相关的订单
      rs.next();
      double delPrice=rs.getDouble("unitPrice")*rs.getInt("bookNum");
      sql="SELECT * FROM myorder WHERE orderID='"+rs.getString("orderID")+"'";
      rs=stmt.executeQuery(sql);
      //更新订单
      rs.next();
      double upPrice=rs.getDouble("totalCost")-delPrice;
      sql="UPDATE myorder SET totalCost='"+upPrice+"'";
      stmt.executeUpdate(sql);    
      //删除单个项
      sql="DELETE FROM item WHERE itemID='";
      sql=sql+itemID+"'";
      stmt.executeUpdate(sql);    
    }
    else  //删除所有项
    {
      sql="DELETE FROM item WHERE orderID='";
      sql=sql+orderID+"'";
      stmt.executeUpdate(sql);
      sql="DELETE FROM myorder WHERE orderID='";
      sql=sql+orderID+"'";
      stmt.executeUpdate(sql);
    }
    stmt.close();
    con.close();
%>
<p>&nbsp;
<font color=red size=5 align=center>订单取消成功!!!!</font>
<p>&nbsp;
<a href=dealOrder.jsp><font size=4 align=center>返回</font></a>
<%    
   }
   catch(Exception e)
   {
      out.println(e.toString());
   }   
     
%>	                  
              </TBODY></TABLE></div>
			<BR>
            <TABLE cellSpacing=0 cellPadding=0 width="98%" align=center 
border=0>
              <TBODY>
              <TR bgColor=#99cc66>
                <TD width="42%" height=12>
                  </TD>
                <TD vAlign=center width="58%" height=12>
                  <DIV align=right><FONT 
              color=#ffffff>
💿 文件大小 9271 K
👤 上传用户 x184372250
📂 所属分类软件设计/软件工程
🏷️ 相关标签

#对象软件 #工程 #案例
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -