1
<dependency>
2
  <groupId>com.github.pagehelper</groupId>
3
  <artifactId>pagehelper</artifactId>
4
  <version>5.3.2</version>
5
</dependency>

1
<plugins>
2
    <plugin interceptor="com.github.pagehelper.PageInterceptor">
3
      <!--方言：mysql-->
4
        <property name="helperDialect" value="mysql"/>
5
      <!--页码的合理性修正-->
6
        <property name="reasonable" value="true"/>
7
    </plugin>
8
</plugins>

1
public interface MarketGoodsMapper {
2
    List<MarketGoods> selectAll();
3
}

1
<sql id="Base_Column_List">
2
  <!--@mbg.generated-->
3
  id, goods_sn, `name`, category_id, brand_id, gallery, keywords, brief, is_on_sale,
4
  sort_order, pic_url, share_url, is_new, is_hot, unit, counter_price, retail_price,
5
  detail, add_time, update_time, deleted
6
</sql>
7

8
<select id="selectAll" resultMap="BaseResultMap">
9
  select
10
  <include refid="Base_Column_List" />
11
  from market_goods
12
</select>

1
@Test
2
public void test1() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  List<MarketGoods> marketGoods = goodsMapper.selectAll();
6
}

1
@Test
2
public void test2() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  PageHelper.startPage(3, 20);
6
  List<MarketGoods> marketGoods = goodsMapper.selectAll();
7
}

1
@Data
2
public class PageData {
3
  private Integer limit; // 数据量的限制
4
  private List<?> list;  // 数据列表
5
  private Integer page;  // 当前页的页码
6
  private Integer pages; // 总的页码
7
  private Integer total; // 总的数据量
8
}

1
@Test
2
public void test3() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  PageHelper.startPage(3, 20);
6
  List<MarketGoods> marketGoods = goodsMapper.selectAll();
7

8
  PageInfo pageInfo = new PageInfo<>(marketGoods);
9
}

1
@Test
2
public void test5() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  PageHelper.startPage(3, 20);
6
  List<MarketGoods> marketGoods = goodsMapper.selectAll();
7

8
  PageData pageData = PageData.list(marketGoods);
9
}

1
@Test
2
public void test1() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  // 传入null或new MarketGoodsExample();
6
  List<MarketGoods> marketGoods = goodsMapper.selectByExample(null);
7

8
  sqlSession.close();
9
}

1
@Test
2
public void test2() {
3
  SqlSession sqlSession = MyBatisUtil.getSqlSession();
4
  MarketGoodsMapper goodsMapper = sqlSession.getMapper(MarketGoodsMapper.class);
5
  MarketGoodsExample example = new MarketGoodsExample();
6
  // 构造example的成员变量distinct和orderByClause
7
  example.setDistinct(true);
8
  example.setOrderByClause("add_time desc");
9
  List<MarketGoods> marketGoods = goodsMapper.selectByExample(example);
10

11
  sqlSession.close();
12
}

1
public static class Criteria extends GeneratedCriteria {
2

3
  protected Criteria() {
4
    super();
5
  }
6
}
7
protected abstract static class GeneratedCriteria {
8
  protected List<Criterion> criteria;
9

10
  protected GeneratedCriteria() {
11
    super();
12
    criteria = new ArrayList<>();
13
  }
14
}

1
where goods_sn = '1006013' and name like '%羊毛%' and category_id = 1008009

1
// 构造一个Criteria也就是一个List<Criterion>
2
MarketGoodsExample.Criteria criteria = example.createCriteria();
3
// 构造一个Criterion
4
criteria.andGoodsSnEqualTo("1006013");
5
// 构造一个Criterion
6
criteria.andNameLike("%羊毛%");
7
// 构造一个Criterion
8
criteria.andCategoryIdEqualTo(1008009);

1
MarketGoodsExample.Criteria criteria = example.or();

1
example.clear();