MySQL 之 TKMapper 复杂sql处理

（1）or连接的条件

# 由于and的优先级高于or,如果想要先执行or就必须把or两边的条件括起来
SELECT id, name, birthday,hobby
FROM student
WHERE (( id= '1002' or birthdy= '2003-06-06') and ( hobby in ( ? )))

Example example = new Example(Student.class);
example.selectProperties("id","name","birthday","hobby");
example.createCriteria().andEqualTo("id","1001")
        .orEqualTo("birthday","2003-06-06");

Example.Criteria criteria = example.createCriteria()
        .andIn("hobby", Lists.newArrayList("篮球"));
example.and(criteria);

（2）Condition自定义条件

Example example = new Example(Student.class);
example.selectProperties("id","name","birthday","hobby");
example.createCriteria().andConditio("( id= '1002' or birthdy= '2003-06-06') and ( hobby in ( ? ))");