JDBC MySql绑定变量语法错误在where子句中

如果我理解您的问题，那么您就使用了问题

Statement.executeQuery(String)

PreparedStatement.executeQuery()

// Let us select all the records and display them.ResultSet rs = stmt.executeQuery(sql);   // <-- adding sql here makes it use the        //     Statement version.

你想用

// Let us select all the records and display them.ResultSet rs = stmt.executeQuery();      // <-- use the version from PreparedStatement