shangchu.jsp

来自「一个自已编写的用JSP编写的简单的人事管理系统」· JSP 代码 · 共 30 行

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
String str=request.getParameter("id");
Connection conn=null;
Statement stmt=null;
try
{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
   out.println(ce.getMessage());
}
try
{ 
   conn=DriverManager.getConnection("jdbc:odbc:dong");                                                               
   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
   ResultSet.CONCUR_READ_ONLY);
   stmt.executeUpdate("delete from people where id='"+str+"'");
}
catch(SQLException e)
{
   out.println(e.getMessage());
}
stmt.close();
conn.close();
response.sendRedirect("44.jsp");
%>