Question

jsp删除数据库记录问题

String id = request.getParameter("user");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/student?user=root&password=root");
Statement st = con.createStatement();
String str = "DELETE FROM user WHERE id="+id+"";
st.executeUpdate(str);
运行报错，报的是最后一行的错
str语句输出DELETE FROM user WHERE id=1

Answer 1

你打印一下str,把它贴上来，是你SQL语法的错误。