微客导航 » 文章资讯 » mybatis-plus分页查询的实现示例

mybatis-plus分页查询的实现示例

2023-07-17 23:16:04 186

按照官方文档进行的配置：快速开始|mybatis-plus

引入依赖：



com.baomidou
mybatis-plus-boot-starter
3.2.0



mysql
mysql-connector-java
5.1.27



com.alibaba
druid
1.0.29

在application.yml配置

spring:
datasource:
type:com.alibaba.druid.pool.DruidDataSource
driver-class-name:com.mysql.jdbc.Driver
url:jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
username:root
password:123456

在启动类上面添加@MapperScan注解，扫描mapper包

@SpringBootApplication
@MapperScan("com.qiao.demo02.mapper")
publicclassSpringbootDemo02Application{

publicstaticvoidmain(String[]args){
SpringApplication.run(SpringbootDemo02Application.class,args);
}

}

新建User和UserMapper

user类

@Data
publicclassUser{
@TableId
privateIntegeruserId;
privateStringuserName;
privateIntegeruserAge;
privateStringuserEmail;
}

UserMapper接口

publicinterfaceUserMapperextendsBaseMapper{

}

最重要的是继承BaseMapper接口：里面声明了很强大的CRUD方法

publicinterfaceBaseMapperextendsMapper{
intinsert(Tentity);

intdeleteById(Serializableid);

intdeleteByMap(@Param("cm")MapcolumnMap);

intdelete(@Param("ew")Wrapperwrapper);

intdeleteBatchIds(@Param("coll")CollectionidList);

intupdateById(@Param("et")Tentity);

intupdate(@Param("et")Tentity,@Param("ew")WrapperupdateWrapper);

TselectById(Serializableid);

ListselectBatchIds(@Param("coll")CollectionidList);

ListselectByMap(@Param("cm")MapcolumnMap);

TselectOne(@Param("ew")WrapperqueryWrapper);

IntegerselectCount(@Param("ew")WrapperqueryWrapper);

ListselectList(@Param("ew")WrapperqueryWrapper);

List>selectMaps(@Param("ew")WrapperqueryWrapper);

List

mybatis-plus分页查询的实现示例

热门推荐

随机推荐