目录
小知识:许多放在类前面的注解,比如@Mapper,@Service都是将该类定义成一个Bean,交给spring管理
1.创建普通springboot项目,勾选Mysql 框架
2.在pom包里面导入mybatis-plus的坐标
com.baomidou mybatis-plus-boot-starter 3.4.3
3.把数据层的类继承BaseMapper这个接口

1.勾选这些初始依赖

2.导入MP和druid的依赖
-
-
com.baomidou -
mybatis-plus-boot-starter -
3.4.3 -
-
-
-
com.alibaba -
druid-spring-boot-starter -
1.2.16 -
总结:

支持动态条件拼接
- @Test
- void text1() {
- //条件查询
- String name ="1";
- // QueryWrapper
qw = new QueryWrapper<>(); - //使用lambda表达式不容易出错
-
- //1.创建 LambdaQueryWrapper条件查询对象
- LambdaQueryWrapper
lqw = new LambdaQueryWrapper<>(); - //这是模糊查询
- //第一个参数是拼接后面的条件的前提,就是说满足这个前提才会拼接后面的条件
- //第二个参数就是条件查询的条件,就是WHERE
- lqw.like(name!=null,Book::getName,name);
- bookDao.selectList(lqw);
- }
- public interface BookService {
- Boolean save(Book book);
- Boolean update(Book book);
- Boolean delete(Integer id);
- Book getById(Integer id);
- List
getAll(); -
- IPage
getPage(int currentPage,int pageSize); -
-
-
- }
- @Service
- public class BookServiceImpl implements BookService {
-
- @Autowired
- private BookDao bookDao;
-
- @Override
- public Boolean save(Book book) {
- return bookDao.insert(book)>0;
- }
-
- @Override
- public Boolean update(Book book) {
- return bookDao.updateById(book)>0;
- }
-
- @Override
- public Boolean delete(Integer id) {
- return bookDao.deleteById(id)>0;
- }
-
- @Override
- public Book getById(Integer id) {
- return bookDao.selectById(id);
- }
-
- @Override
- public List
getAll() { -
- return bookDao.selectList(null);
- }
-
- @Override
- public IPage
getPage(int currentPage, int pageSize) { - Page
page = new Page<>(currentPage,pageSize); - bookDao.selectPage(page,null);
- return page;
- }
-
- }
别忘记@Service注解