deletewords.jsp

jsp做的一个个人网站

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%request.setCharacterEncoding("gb2312");
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
  Statement st=con.createStatement();
  int id=java.lang.Integer.parseInt(request.getParameter("id"));
  String sql=" delete from leavewords where id="+id;
  st.executeUpdate(sql);
  con.close();
  out.print("<script language='javascript'>alert('删除成功！');location.href='allleavewords.jsp'</script>");
  
  

%>