java - 如何在Java中更正此查询，以便它访问变量SequenceId并从数据库中获取序列的值

我有一个错误提示“ ORA-00933：SQL命令未正确结束”

 rs = st.executeQuery("select * from msg_new_to_bde t where t.ACTION = 804 and t.seq > ? order by t.seq desc" + sequenceID);

最佳答案

尝试这个：

rs = st.executeQuery("select * from msg_new_to_bde t where t.ACTION = 804 and t.seq > " + sequenceID + " order by t.seq desc");