我有一个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：

您的SQL语法有误；检查与您的MySQL服务器版本相对应的手册，以在’？’附近使用正确的语法。