iBatis中如何实现大于等于SQL语句?
比方说,在我的 sql 语句中我想要执行以下操作:
WHERE numberOfCookies >= 10
How do I do this in iBatis?
Let's say in my sql statement I want to do:
WHERE numberOfCookies >= 10
How do I do this in iBatis?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
因为SQL是用xml编写的,所以不能只使用符号“>”,需要写成:
Update:
>
for more than< code>< 小于
Because the SQL is written in xml, you cannot just use the symbol ">", you need to write it as:
Update:
>
for greater than<
for less than为什么它不起作用?
我唯一能想到的是
>
字符与 XML 的配合不太好。在这种情况下,您可以将整个语句包装在内
Why does it not work?
The only thing I can think of is that the
>
character isn't playing nice with the XML. In which case, you can wrap the entire statement within<![CDATA[ ... ]]>