1. pom.xml
<!-- 分页插件 start-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
<version>1.2.3</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
<!-- 分页插件 end-->
2. application.yml
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
3. ShopMapper.xml 配置
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.youhu.vegetable.mapper.ShopMapper">
<resultMap id="BaseResultMap" type="com.youhu.vegetable.model.Shop">
<id column="shop_id" property="shopId" jdbcType="INTEGER"/>
<result column="shop_name" property="shopName" jdbcType="VARCHAR"/>
<result column=" user_id" property="userId" jdbcType="INTEGER"/>
<result column="contact number" property="contactNumber" jdbcType="VARCHAR"/>
<result column="shop_type" property="shopType" jdbcType="INTEGER"/>
<result column="longitude" property="longitude" jdbcType="VARCHAR"/>
<result column="latitude" property="latitude" jdbcType="VARCHAR"/>
<result column="address" property="address" jdbcType="VARCHAR"/>
<result column="add_time" property="addTime" jdbcType="VARCHAR"/>
<result column="is_delete" property="isDelete" jdbcType="INTEGER"/>
</resultMap>
<select id="getShopAll" resultMap="BaseResultMap">
select * from shop;
</select>
</mapper>
4. dao 层
@Repository
public interface ShopMapper extends BaseMapper<Shop> {
ArrayList<Shop> getShopAll();
}
5. service 层
public interface ShopService {
BaseResult getShopAll(Integer pageNum, Integer pageSize);
}
6. serviceImpl 层
@Service
public class ShopServiceImpl implements IShopService {
@Autowired
private ShopMapper shopMapper;
@Override
public BaseResult getShopAll(Integer pageNum, Integer pageSize) {
PageHelper.startPage(pageNum, pageSize); // 这里是开启分页
ArrayList<Shop> list = shopMapper.getShopAll();
PageInfo<Shop> pageInfo = new PageInfo<Shop>(list);
List<Shop> shopList = pageInfo.getList();
return BaseResult.success(shopList);
}
}
7. 效果图