我的查詢是 "SELECT mbr,ime,prz FROM radnik WHERE mbr IN (SELECT DISTINCT sef FROM radnik)"，它在 SQLDeveloper 中完成了這項作業。但是，當我在 Eclipse 中運行它時，出現錯誤“SQL 命令未正確結束”。即使從查詢中洗掉分號后，問題仍然存在。這是代碼：
public class Upit2_Sefovi {
public static void main(String[] args) {
try (Connection connection = ConnectionUtil_Basic.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(generateQuery());
ResultSet resultSet = preparedStatement.executeQuery()) {
while (resultSet.next()) {
int mbr = resultSet.getInt(1);
String ime = resultSet.getString(2);
String prezime = resultSet.getString(3);
int brRadnika=ExecuteFun.getRadnici(mbr);
System.out.printf("%-4d %-8s %-8s %-4d\n", mbr, ime, prezime,brRadnika);
}
}catch(SQLException e) {
e.printStackTrace();
}
}
private static String generateQuery() {
String query = "select mbr,ime,prz"
" from radnik"
"where mbr in (select distinct sef from radnik)";
return query;
}
}
這是堆疊跟蹤：
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
at upit2.Upit2_Sefovi.main(Upit2_Sefovi.java:16)
uj5u.com熱心網友回復：
您需要在 radnik 和 where 之間留一個空格。
String query = "select mbr,ime,prz"
" from radnik"
" where mbr in (select distinct sef from radnik)";
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/383185.html
下一篇：資料庫類-表存在嗎？