java - 在 '?' 附近使用的正确语法

Question

我有一个 Java 代码:

String searchPerson = "select * from persons where surname like ? and name like ?";
//connect to DB
PreparedStatement statement = connect.prepareStatement(searchPerson);
statement.setString(1,"%"+ surname + "%");
statement.setString(2, "%" + name + "%");
ResultSet resultPerson = statement.executeQuery(searchPerson);
//..code

然后我有 SQLException:

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 '?'

Answer 1

您应该执行不带参数的PrepareStatement，如下所示:

statement.executeQuery()

使用 String 参数调用 executeQuery 将按原样执行提供的查询(没有绑定(bind)参数)。