do_delete_orderform.jsp

来自「这个是我自己做的网络购物程序 大家有兴趣的话可以拿去作为参考」· JSP 代码 · 共 47 行

JSP
47
字号
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>



<%
/*


得到数据


*/
String orderno=request.getParameter("orderno");
byte[] get_orderno=orderno.getBytes("ISO-8859-1");
orderno= new String(get_orderno,"GB2312");

%>


 <%  

     Connection con=null;
     Statement sql=null;
   
     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
        catch(ClassNotFoundException e){}
     try { con=DriverManager.getConnection                                     ("jdbc:odbc:bookshop","sa","");

          String SQLstr="delete from orderform where orderno=?";
          PreparedStatement pstmt=con.prepareStatement(SQLstr);
          pstmt.setString(1,orderno);
	if(pstmt.executeUpdate()>0)
          	out.print("删除成功!"+"<br>");
          con.close();
       }
    catch(SQLException e)
       {  }
           
          out.print("<TD >"+ "<a href=delete_orderform.jsp>继续删除</a>"+"</TD>"+"<br>"); 
         out.print("<TD >"+ "<a href=login.jsps>返回主页</a>"+"</TD>"); 
 %>
</BODY>
</HTML>

⌨️ 快捷键说明

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