如果想用mybaits逆向多个条件一起查询就用

DeptPQuery query = new DeptPQuery();
query.or().andParentIdEqualTo(id).andStateEqualTo(0);

List<DeptP> list = deptPDao.selectByExample(query);

DEBUG - ==>  Preparing: select DEPT_ID, DEPT_NAME, PARENT_ID, is_parent, STATE from dept_p WHERE ( PARENT_ID = ? and STATE = ? ) 
DEBUG - ==> Parameters: 0(String), 0(Integer)

可以实现

如果只是

query.andStateEqualTo(0);

query.andParentIdEqualTo(id).

这样只一个参数，一个STATE = ?