在 Jdbc 中执行带有绑定变量的 SQL 查询

我有一个这样的sql查询。

 select "DEPT"."DEPTNO" as "DEPTNO1",
"DEPT"."DNAME" as "DNAME1",
"DEPT"."LOC" as "LOC1",
"EMP"."COMM" as "COMM1",
"EMP"."EMPNO" as "EMPNO1",
"EMP"."ENAME" as "ENAME1",
"EMP"."HIREDATE" as "HIREDATE1",
"EMP"."JOB" as "JOB1",
"EMP"."MGR" as "MGR1",
"EMP"."SAL" as "SAL1"
from "EMP" , "DEPT" where "DEPT"."DEPTNO" in (:DeptNo)

//这是Jdbc代码

Class.forName(DB_DRIVER);
dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
Statement statment = dbConnection.createStatement();
result = statment.execute(query);//query is above sql query

当我在 Oracle sql Developer 中运行上面的查询时效果很好。但是当我使用上面的 jdbc 代码运行它时，它会抛出 Not allvariablesbound 异常。 如何在 JDBC 中运行上述查询

replace :deptno在您的查询中带有 ?。

并使用以下命令代替实例化语句：

PreparedStatement stmt=con.prepareStatement(query);

stmt.setInt(1,deptno); //1 is for the first question mark

where deptno保存您要执行查询的值。

通过PreparedStatement接口，我们可以使用参数化查询，该查询只需编译一次，与Statement接口相比具有性能优势。