需求:删除姓名为“花花”,年龄为“23”性别为“女”的数据。

    image.png
    image.png
    image.png

    1. package com.wzy;
    2. import com.baomidou.mybatisplus.mapper.EntityWrapper;
    3. import com.baomidou.mybatisplus.plugins.Page;
    4. import com.wzy.mapper.EmployeesMapper;
    5. import com.wzy.pojo.Employees;
    6. import org.junit.Test;
    7. import org.springframework.context.ApplicationContext;
    8. import org.springframework.context.support.ClassPathXmlApplicationContext;
    9. import javax.sql.DataSource;
    10. import java.sql.Connection;
    11. import java.sql.SQLException;
    12. import java.util.Iterator;
    13. import java.util.List;
    14. public class TestS {
    15. //1.读取配置文件
    16. private ApplicationContext applicationContext =
    17. new ClassPathXmlApplicationContext("applicationContext.xml");
    18. private EmployeesMapper employeesMapper =
    19. applicationContext.getBean("employeesMapper", EmployeesMapper.class);
    20. private Employees employees = new Employees();
    21. @Test
    22. public void test6() throws SQLException {
    23. Integer delete = employeesMapper.delete(new EntityWrapper<Employees>().eq("last_name", "花花").
    24. and().
    25. eq("age", 23).
    26. and().
    27. eq("gender", 0));
    28. System.out.println(delete);
    29. // List<Employees> list = employeesMapper.selectList(new EntityWrapper<Employees>().gt("id", 0));//查询id>0的数据
    30. List<Employees> list = employeesMapper.selectList(new EntityWrapper<Employees>());//查询所有数据
    31. list.forEach(list1 -> System.out.println(list1));
    32. }
    33. }