java mysql executequery_statement.executequery()在mysql中执行select命令时抛出java.sql.sqlsyntaxErrorException...

我有一个使用JDBCAPI从mysql db表中获取记录的方法。

我一直使用的命令是:

"SELECT column_1, column_2, ... FROM table;"

列名称以arraylist的形式提供给方法。正在使用StringBuilder基于列和表名称构造查询。

使用createStation()执行构造的查询时,将引发:

"java.sql.SQLSyntaxErrorException: 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 from $tableName' at line 1"

这是方法的完整代码:

public ObservableList> getTableData(String tableName, List selectedParams, int rowCount) {

try {

StringBuilder query = new StringBuilder("select ");

for (int i = 0; i < selectedParams.size(); i++) {

query.append(selectedParams.get(i)).append(", ");

}

query.append("\b\b from ").append(tableName).append(" limit ").append(rowCount);

System.out.println("query:" + query);

ObservableList> rows;

try (ResultSet rset = st.executeQuery(query.toString())) {

ResultSetMetaData rsmd = rset.getMetaData();

rows = FXCollections.observableArrayList();

while (rset.next()) {

ObservableList row = FXCollections.observableArrayList();

int count = 1;

while (count <= rsmd.getColumnCount()) {

row.add(rset.getString(count));

count++;

}

rows.add(row);

}

}

rows.forEach((row) -> {

System.out.println(row);

});

return rows;

} catch (SQLException ex) {

Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);

}

return null;

}

运行代码时,生成的查询表单打印语句如下所示:

"query:select territory from offices"

我已经直接对数据库和另一个简单的JDBC程序测试了这个查询,它们都运行良好。除了在这个方法中。请帮忙。

----------编辑:忘记粘贴异常消息:-----------

java.sql.SQLSyntaxErrorException: 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 from offices limit 10' at line 1

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)