ryshanchu.jsp

来自「可在线考试JSP等课程」· JSP 代码 · 共 60 行

JSP
60
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%  
   String Name="";
   String No="";
     if(request.getParameter("Name")!=null && request.getParameter("No")!=null)
   {   
	   No=request.getParameter("No");
       Name=request.getParameter("Name");
	    String SQL="delete from chjb where xh='"+No+"'";
	   Connection conn=null;
	   Statement stmt=null;
	   ResultSet rs=null;
	   try
	   {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   }
      catch(ClassNotFoundException ce) 
	  {    out.println(ce.getMessage());
	  }
	  try{
		   conn=DriverManager.getConnection("jdbc:odbc:test");
		   stmt=conn.createStatement();
		   
	   }
	   catch(SQLException e){
		   System.out.println(e.getMessage());
	   }
          stmt.executeUpdate(SQL);
		  response.sendRedirect("ryxinxi.jsp");
	    }
 %>  
<head><head><BODY background="ryshanchu.jpg">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>人员删除</title>
<style type="text/css">
<!--
.STYLE1 {
	font-family: "宋体";
	font-size: 36px;
	color: #ff3377;
	font-weight: bold;
}
body {	background-color: #339944;}
-->
</style>
</head>
<body>
<center>
  <p class="STYLE1">人员删除</p>
</div>
<form id="form1" name="form1" method="post" action="ryshanchu.jsp">
   学号: <input name="No" type="text" id="No" size="18" >
<p>
  用户名:<input name="Name" type="text" id="Name" size="18" >
<p>
   <input type="submit" name="Submit" value="删除" >
</form>
</center>
</body>
</html>

⌨️ 快捷键说明

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