mybaits Condition使用

来源：互联网发布：u盘提示格式化数据恢复编辑：程序博客网时间：2024/05/17 22:33

String keyArray[] = keywords.trim().split(",|，");            for (int i = 0; i < keyArray.length; i++) {                Criteria criteria = condition.or();                criteria                    .andEqualTo("deleted", 0)                    .andEqualTo("state", InformationState.STATE_PUBLHISHED)                    .andLike("keywords", "%"+keyArray[i]+"%");                                Criteria criteria2 = condition.or();                criteria2.andEqualTo("deleted", 0)                    .andEqualTo("state", InformationState.STATE_PUBLHISHED)                    .andLike("title", "%"+keyArray[i]+"%");            }

得到类似：

WHERE DELETED = ? AND STATE = ? AND ( KEYWORDS LIKE '%aaa%' or TITLE  '%aaa%' ) OR ( KEYWORDS LIKE '%bbb%' or TITLE  '%bbb%' );

真实日志打印：

WHERE ( DELETED = ? and STATE = ? and KEYWORDS like ? ) or ( DELETED = ? and STATE = ? and TITLE like ? ) or ( DELETED = ? and STATE = ? and KEYWORDS like ? ) or ( DELETED = ? and STATE = ? and TITLE like ? )

0 0