Example ex = new Example(ExamExaminer.class);
Example.Criteria criteria = ex.createCriteria();
Example.Criteria criteria2 = ex.createCriteria();
if(null!=examinerVO.getNameAndCardNum()&&""!=examinerVO.getNameAndCardNum()){
criteria.andCondition("(examiner_name like '%"+examinerVO.getNameAndCardNum()+"%' or "+"examiner_card_no like '%"+examinerVO.getNameAndCardNum()+"%')") ;
}
Example 一个字段对应多个模糊查询 拼sql 语句
最新推荐文章于 2023-07-31 15:28:03 发布