如何为具有多个系列的各种参数的查询进行 iBatis 参数映射？
我需要映射这种通用形式的 sql 语句：
SELECT ...
FROM x, y, z
WHERE ( x.id = #x1# OR x.id = #x2# OR ... )
AND ( y.id = #y1# OR y.id = #y2# OR ... )
AND z.name = #name#;
所以我有两个参数列表和 1 个字符串。我想知道是否可以从 iBatis 动态 SQL 或其他东西中制作一些东西。如果我可以构建自己的 WHERE 子句并给出它。因为不知何故我想使用 iBatis 将结果映射到 Java 对象...
你会怎么做？
I need to map a sql statement of this general form:
SELECT ...
FROM x, y, z
WHERE ( x.id = #x1# OR x.id = #x2# OR ... )
AND ( y.id = #y1# OR y.id = #y2# OR ... )
AND z.name = #name#;
So I have two lists of parameters and 1 string. I am wondering if something can be made from perhaps iBatis dynamic SQL or something. If I just could build my own WHERE clause and give it perhaps. Because somehow I want to use iBatis for mapping the result into Java objects...
How would you do?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您的问题似乎是您在 iBatis （或 myBatis）配置文件中构建查询的方式造成的。
为什么不使用一个
in条件而不是一串or条件。这是一个例子：
Your problem seens to be a result of the way in which you framed the query in your iBatis (or myBatis) configuration file.
Instead of a string of
orconditions why not use oneincondition.Here is an example:
您可以使用
如果是这样：要从中构建查询，您必须同时迭代两个列表，这在 iBatis 中是不可能的。相反，您必须创建一个包含名称和值的类并传递它的列表。然后，您可以使用 iBatis 迭代该（单个）列表，并使用列表中的“当前”项访问名称和值。尝试使用这种方法，我过去已经成功地使用过它。我一回家就会尽力为您找到一些源代码。
编辑：好的，看来您想生成两个具有许多 OR 连接条件的块。在这种情况下，您可以依次使用 2 个
You can use the
<iterate>tag to iterate over your parameter list. I suspect that you have 2 lists, one containing the parameter names, the other containing the parameter value. Is that the case?If so: To build a query from that, you would have to iterate both lists simultaneously, which is not possible in iBatis. Instead, you will have to create a class containing both name and value and pass the list of it. Then you can use iBatis to iterate over that (single) list and access name and value using the "current" item from the list. Try to use this approach, I've used it successfully in the past. I'll try to find some source code for you as soon as I'm home.
EDIT: Ok, it seems you want to generate two blocks that have many OR-joined conditions. In that case you can use 2
<iterate>tags one after the other. Do you need help on how to pass multiple parameters into the query?foreach 元素（仅在 ibatis3 - mybatis 中可用）非常强大，允许您指定集合、声明可在元素体内使用的项目和索引变量。它还允许您指定开始和结束字符串，并添加分隔符以放置在迭代之间。该元素很聪明，因为它不会意外地附加额外的分隔符。
The foreach element (available only in ibatis3 - mybatis) is very powerful, and allows you to specify a collection, declare item and index variables that can be used inside the body of the element. It also allows you to specify opening and closing strings, and add a separator to place in between iterations. The element is smart in that it won’t accidentally append extra separators.