Jsp/Servlet

开发平台：

VBScript

delete_form.jsp~3~：源码内容

							<%@ page contentType="text/html; charset=GBK" %>
<%@page import="java.sql.*"%>
<html>
<head>
<title>
delete_form
</title>
</head>
<body >
  <%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
	out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String str = request.getParameter("keywords");
if( str == null)
	str = "";
      else
try{
	conn=DriverManager.getConnection("jdbc:odbc:dsn112");
	stmt=conn.createStatement();
	rs=stmt.executeQuery("DELETE FROM Info WHERE stu_id LIKE '%" + str + "%'");
}
catch(SQLException e){
	System.out.println(e.getMessage());
}
finally{
	stmt.close();
	conn.close();
}
%>
<script language="JavaScript">
        		alert("删除成功");
        		location.href='delete.jsp'
                 </script>
</body>
</html>

						