📄 deleteform.jsp
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="Login" %>
<jsp:useBean id="login" class="Login" scope="session">
</jsp:useBean>
<BODY bgcolor=white><Font size=3>
<% 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_number1");
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>"+"删除失败");}
%>
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -