delete.jsp

来自「这是一个在线考试系统」· JSP 代码 · 共 43 行

JSP

43 行

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%//接收要删除的用户ID号
 long tk_id;
 try
 {
   tk_id=Long.parseLong(request.getParameter("tk_id"));
 }
 catch(Exception e)
 {
   tk_id=0; 
 }
%>
<%//构造追加记录SQL语句
 String sqlString=null;//SQL语句
 if(tk_id!=0)//接收到的参数正确
 {
   sqlString="delete from kaoti where tk_id="+tk_id;
//执行SQL语句
   try 
    { Connection con;
      Statement sql;
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi","sa","");
      sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
      sql.executeUpdate(sqlString);
      out.print("<script>alert('删除成功！');document.location='kaotiji.jsp';</script>");
      con.close();
    }
   catch(SQLException e1) 
    {
      out.print("SQL异常！");
    }
  }
%>
<head>
<title>删除程序</title>
</head>
<body>

</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?

delete.jsp

delete.jsp - 源码说明

⌨️ 快捷键说明