Criterion是最基本,最底层的Where条件,用于字段级的筛选
-
Criteria
public Employee getEmp(String empName) {
EmployeeExample example = new EmployeeExample();
example.or().andEmpNameEqualTo(empName);
List<Employee> list = employeeMapper.selectByExample(example);
return list.size() > 0 ? list.get(0) : null;
}
运行SQL:
==> Preparing: select emp_id, emp_name, gender, email, d_id from tbl_emp WHERE ( emp_name = ? )
==> Parameters: f4f3510008(String)
<== Columns: emp_id, emp_name, gender, email, d_id
<== Row: 70010, f4f3510008, M, f4f3510008@kerryprops.com, 1
<== Total: 1