2.3、selectList 模糊查询

需求：分页查询tbl_employee表中,性别为”女”,名字中带有”老师” 或者 邮箱中包含”a”

**.or()** 与 **.orNew()** 的区别:

package com.wzy;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.wzy.mapper.EmployeesMapper;
import com.wzy.pojo.Employees;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
public class TestS {
    //1.读取配置文件
    private ApplicationContext applicationContext =
            new ClassPathXmlApplicationContext("applicationContext.xml");
    private EmployeesMapper employeesMapper =
            applicationContext.getBean("employeesMapper", EmployeesMapper.class);
    @Test
    public void  test4() throws SQLException {
        List<Employees> employees = employeesMapper.selectPage(new Page<Employees>(1, 2),
                new EntityWrapper<Employees>().
                        eq("gender", 0).
                        and().//不写and 默认也是and连接
                        like("last_name", "老师").
                        or().
                        //orNew().
                        like("email", "a"));
        employees.forEach(employees1 -> System.out.println(employees1));
    }
}