本文介绍了选择id = array(Oracle JDBC)的位置的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我目前正在尝试将Oracle(A VARCHAR2)中的ID与输入的ID数组进行比较.
I'm currently working with trying to compare an ID in Oracle(A VARCHAR2) with an array of IDs I have as input.
这就是我想要做的:
Select user, city where id = :arrayOfIds在带JDBC的Postgres中,我将使用:
In Postgres with JDBC I would use:
Select user, city where id = any(:arrayOfIds)Oracle中是否有等效功能?我该怎么做?
Is there an equivelent function in Oracle or how do I do this?
提前感谢亲爱的堆栈溢出!
Thanks in advance dear Stack Overflow!
推荐答案您应使用:
Select user, city where id in (:arrayOfIds)在代码中,您需要使用ID将字符串转换为字符串:
and in you code, you need to trasform your array in string with ids:
arrayOfIds[0] --> 1 arrayOfIds[1] --> 3 arrayOfIds[2] --> 5... 在
1, 3, 5, ...,您可以使用:
Array array = conn.createArrayOf("arrayOfIds", new Object[]{"1", "2","3"}); pstmt.setArray(1, array);如何将arraylist用作准备好的语句参数
更多推荐
选择id = array(Oracle JDBC)的位置
发布评论