mybatis分页插件使用

╰+哭是因爲堅強的太久メ 2022-05-13 13:22 287阅读 0赞

**一、添加pom.xml依赖：**

<dependencies>
    	<dependency>
    		<groupId>com.github.pagehelper</groupId>
    		<artifactId>pagehelper</artifactId>
    		<version>4.1.3</version>
    	</dependency>
    </dependencies>

--------------------

**二、添加mybatis-config.xml插件配置：**

<plugins>
    	
    	<plugin interceptor="com.github.pagehelper.PageHelper">
    		       
    		<property name="dialect" value="MariaDB" />
    		
    		
    		
    		<property name="offsetAsPageNum" value="true" />
    		
    		
    		<property name="rowBoundsWithCount" value="true" />
    		
    		
    		<property name="pageSizeZero" value="true" />
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		<property name="supportMethodsArguments" value="false" />
    		
    		<property name="returnPageInfo" value="none" />
    	</plugin>
    </plugins>

--------------------

**三、UserMapper.xml中的SQL语句写法：**

<select id="selectByPrimaryKeyList" parameterType="java.lang.String" resultMap="BaseResultMap">
        select * from t_user where user_id = #{userId,jdbcType=VARCHAR}  
      </select>

--------------------

四、UserMapper.java类写法：

package com.seesun.mapper;
    
    import java.util.List;
    import com.seesun.bean.UserBean;
    
    public interface UserMapper { 
    
    	List<UserBean> selectByPrimaryKeyList(String id);
    
    }

--------------------

五、测试类：

package com.seesun.judge;
    
    
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    
    import com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    import com.seesun.mapper.UserMapper;
    import com.seesun.bean.UserBean;
    
    @RunWith(org.springframework.test.context.junit4.SpringJUnit4ClassRunner.class)
    @ContextConfiguration({ "/META-INF/spring/*.xml"}) //加载配置文件
    public class TestDemo { 
    	
    	private Logger loggger = LoggerFactory.getLogger(TestDemo.class);
    
    	@Autowired
    	private UserMapper userMapper;
    	
        @Test
        public void testUserInfo() { 
        	try { 
        		String id = "YaU4MWqvuGINMcs2FXD";
        		PageInfo<UserBean> page = queryList(1, 5, id);
        		System.out.println("总条目数：" + page.getTotal());
        		for (UserBean entity : page.getList()) { 
        			loggger.info(entity.getUserAccount());
        		}
    		} catch (Exception e) { 
    			loggger.error(e.getMessage());
    		} 
        }
        
        public PageInfo<UserBean> queryList(Integer pangNum, Integer pageSize, String id){ 
        	return PageHelper.startPage(pangNum, pageSize).doSelectPageInfo(() -> userMapper.selectByPrimaryKeyList(id));
        }
        
    }

注：以上内容仅提供参考和交流，请勿用于商业用途，如有侵权联系本人删除！

--------------------

## 持续更新中… ##

如有对思路不清晰或有更好的解决思路，欢迎与本人交流，QQ群：273557553，个人微信：  
你遇到的问题是小编创作灵感的来源！

--------------------