delete.jsp

jsp做的一个个人网站

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*,java.util.Date,java.text.SimpleDateFormat" %>
<%//out.print("执行到此");
request.setCharacterEncoding("gb2312");
int id=Integer.parseInt(request.getParameter("id2"));


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");

String sql="delete from wenzhang where id="+id;

Statement st=con.createStatement();
st.executeUpdate(sql);
con.close();
out.print("<script language='javascript'>alert('删除成功！');location.href='zhongshuofenyun.jsp';</script>");
%>