Question

【急~】jsp以下sql查询语句为什么会报错？

org.apache.jasper.JasperException: Exception in JSP: /orderBook.jsp:49
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1

我的jsp文件对应代码：
46 String sql2 = "select price from provide_book where isbn = ?";
47 PreparedStatement stmt2 = conn.prepareStatement(sql2);
48 stmt2.setString(1,isbn);
49 ResultSet rs = stmt2.executeQuery(sql2);

'?'应该代表的是要传进去的参数 为什么这样不行呢？
以下语句可以通过：
String sql = "insert into want_book values(?,?,?,?,?,?,?,?,?,?)";

Answer 1

ResultSet rs = stmt2.executeQuery(sql2);

把里面的sql2去掉；

这种情况下是不需要带参数的

Answer 2

点击韦涵涵,加我一定帮你解决...

祝楼主早日成功!

Answer 3

要把代码都贴出来
46 String sql2 = "select price from provide_book where isbn = ?";
47 PreparedStatement stmt2 = conn.prepareStatement(sql2);
48 stmt2.setString(1,isbn);
49 ResultSet rs = stmt2.executeQuery();
试试