2.4、update 条件修改

需求: 修改, 把姓名为”卧槽”,年龄为25岁的数据,修改为：
需求: 修改, 姓名为”哈哈哈”,年龄为30岁人的数据修改为：
last_name = “花花”、email = “huahua@qq.com”、gender = 0、age = 23。

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  test5() throws SQLException {
        //修改
        Employees employees = new Employees(null,"花花","huahua@qq.com",0,23);
        Integer updateId = employeesMapper.update(employees, new EntityWrapper<Employees>().
                eq("last_name", "哈哈哈").
                and().eq("age", 25));
        System.out.println(updateId);
        //查询修改后的数据
        //1、条件查询
        List<Object> list = employeesMapper.selectObjs(new EntityWrapper<Employees>().
                eq("last_name", "花花").
                and().
                eq("age", 23));
        //2、分页查询
        List<Employees> employees1 = employeesMapper.selectPage(new Page<Employees>(), new EntityWrapper<Employees>().
                eq("last_name", "花花").
                and().
                eq("age", 23));
        employees1.forEach(employees2 -> System.out.println(employees2));
        //3、id查询
        Employees employees2 = employeesMapper.selectById(updateId);
        System.out.println(employees2.toString());
    }
}