deleteuser2.jsp

来自「feemanager是思维管理类系统」· JSP 代码 · 共 41 行

JSP
41
字号
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%
  int user_id;
  try
  {
     user_id=Integer.parseInt(request.getParameter("user_id"));     
  }
  catch (Exception e)
  {
  	 user_id=0;
  }
%>
<%
  String sqlString=null;
  if (user_id!=0)
  {
    sqlString="delete from feelist where id="+user_id;
    try
    {
      Connection con;
      Statement sql;
      Class.forName("oracle.jdbc.driver.OracleDriver");      
      con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ywjygl","feemanager","chuyanjun");      
      sql=con.createStatement();
      sql.executeUpdate(sqlString);
      con.close();
    }
    catch (Exception e1)
    {
      out.print("SQL异常");
    }
  }
%>
<head>
	<title>删除纪录</title>
</head>
<body>
	<center>
		删除用户成功!<a href='acceptInsertUserTable.jsp?1'>返回</a>
</body>

⌨️ 快捷键说明

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