mybatie数据库分页

sqlserver 分页

 SELECT TOP 2 * FROM [user] --显示两行
 WHERE [user].ID
 NOT IN
 (SELECT TOP(1)  ID FROM [user]) --不要第一行
1
2
3
4

mysql

SELECT * FROM table LIMIT 1,2
1

mapper

List<User> getUserListFy(Map<String,Object>map);
1

    <select id="getUserListFy" parameterType="map" resultType="com.wyl.pojo.User">
          SELECT TOP ${row} * FROM [user]
            WHERE [user].ID
             NOT IN
            (SELECT TOP(${uprow})  ID FROM [user])
     </select>
1
2
3
4
5
6

 @Test
    public void selectfy() {
        //第一步获取sqlsession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //方式1
        UserMapper UserDao = sqlSession.getMapper(UserMapper.class);
        Map<String, Object> map = new HashMap<>();
        map.put("row",1);
        map.put("uprow",1);
        List<User> userListFy = UserDao.getUserListFy(map);

        for (User user : userListFy) {
            System.out.println(user);
        }
        //关闭
        sqlSession.close();
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

1