delete1.jsp

jsp做的一个个人网站

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


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

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

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