需求:删除姓名为“花花”,年龄为“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.Iterator;import java.util.List;public class TestS {//1.读取配置文件private ApplicationContext applicationContext =new ClassPathXmlApplicationContext("applicationContext.xml");private EmployeesMapper employeesMapper =applicationContext.getBean("employeesMapper", EmployeesMapper.class);private Employees employees = new Employees();@Testpublic void test6() throws SQLException {Integer delete = employeesMapper.delete(new EntityWrapper<Employees>().eq("last_name", "花花").and().eq("age", 23).and().eq("gender", 0));System.out.println(delete);// List<Employees> list = employeesMapper.selectList(new EntityWrapper<Employees>().gt("id", 0));//查询id>0的数据List<Employees> list = employeesMapper.selectList(new EntityWrapper<Employees>());//查询所有数据list.forEach(list1 -> System.out.println(list1));}}
