📄 deleteform.jsp

📁 一个用Jsp+javaBean+sevlet写的购物车

💻 JSP

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>

<jsp:useBean id="login" class="book.Login" scope="session" >
</jsp:useBean>
<html>
<BODY>
<% //如果客户直接进入该页面将被转向登录页面。
   if(session.isNew())
    {response.sendRedirect("userLogin.jsp");
    }
   //如果没有成功登录将被转向登录页面
   String success=login.getSuccess();
         if(success==null)
         {success="";
         }
   if(!(success.equals("ok")))
     {response.sendRedirect("userLogin.jsp");
     }
%>
<% //获取订单号：
   String order_number=request.getParameter("order_number");
          if(order_number==null)
            {order_number="";
            }
     byte b[]=order_number.getBytes("ISO-8859-1");
     order_number=new String(b);
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
       try
      {con=DriverManager.getConnection("jdbc:odbc:shop","","");
       sql=con.createStatement();
       String condition=
              "DELETE  FROM orderform WHERE order_number="+"'"+order_number+"'";
       sql.executeUpdate(condition);  //删除。
       out.print("<BR>"+"订单条款被删除一项");
      }
      catch(SQLException e)
       { out.print("<BR>"+"删除失败");
       }
%>
</BODy>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -