最后一次严打:JSP删除数据库表数据
来源:百度文库 编辑:高校问答 时间:2024/06/01 13:10:26
帮我看看哪里错了,为什么总是不能删除数据
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%
String id;
id=request.getParameter(1);
%>
<%
String sql=null;
sql="delete from typetable3 whereid= '+id+'";
out.print(sql);
try
{
Connection con;
Statement stmt;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//jspdb是odbc数据源的名称
con=DriverManager.getConnection("jdbc:odbc:mydb","","");
stmt=con.createStatement();
stmt.executeUpdate(sql);
con.close();
}
catch(Exception e){
out.println(e.getMessage());
}
response.sendRedirect("dbshow.jsp");
%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%
String id;
id=request.getParameter(1);
%>
<%
String sql=null;
sql="delete from typetable3 whereid= '+id+'";
out.print(sql);
try
{
Connection con;
Statement stmt;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//jspdb是odbc数据源的名称
con=DriverManager.getConnection("jdbc:odbc:mydb","","");
stmt=con.createStatement();
stmt.executeUpdate(sql);
con.close();
}
catch(Exception e){
out.println(e.getMessage());
}
response.sendRedirect("dbshow.jsp");
%>
sql="delete from typetable3 where id='"+id+"'";