使用规则处理复杂条件
· 阅读需 1 分钟
AND/OR 规则进阶
因此规则还可稍微复杂一点
@{and, (age = :age and sex = '1') or (name = :name and id in (:ids)) }
对应的 SQL 为：
(age = ? and sex = '1') or (name = ? and id in (?, ?, ?))
1 篇博文 含有标签「DynamicSQL」
Hello tag description
查看所有标签Hello tag description
查看所有标签因此规则还可稍微复杂一点
@{and, (age = :age and sex = '1') or (name = :name and id in (:ids)) }
对应的 SQL 为：
(age = ? and sex = '1') or (name = ? and id in (?, ?, ?))