Exception in thread "main" org.postgresql.util.PSQLException: 在 PreparedStatement 上不能使用获取查询字符的查询方法。
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:262)
at com.allinfinance.das.batch.aps.s1001.T1001AproveDay.AproveDay(T1001AproveDay.java:60)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:262)
at com.allinfinance.das.batch.aps.s1001.T1001AproveDay.AproveDay(T1001AproveDay.java:60)
at com.allinfinance.das.batch.aps.s1001.T1001AproveDay.main(T1001AproveDay.java:97)
报此段错误是因为:
PreparedStatement pstmt = conn.prepareStatement(sql.toString());
ResultSet rs = pstmt.executeQuery(sql.toString());
这段
改为:
PreparedStatement pstmt = conn.prepareStatement(sql.toString());
ResultSet rs = pstmt.executeQuery(); //去掉sql.toString()