Mysatis配置整合PageHelper出现的问题

客官°小女子只卖身不卖艺 2022-04-14 07:17 184阅读 0赞

在进行分页时，在Mybatis的SqlMapConfig.xml可以配置如下：

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
    		PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    		"http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	<plugins>
    		<plugin interceptor="com.github.pagehelper.PageHelper">
    			
    			        
            	<property name="dialect" value="mysql"/>
    		</plugin>
    	</plugins>
    </configuration>

但是在启动的过程中会报如下错误：

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [spring/applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [mybatis/sqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.ClassCastException: com.github.pagehelper.PageHelper cannot be cast to org.apache.ibatis.plugin.Interceptor

此时要修改配置文件：

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        <plugins>
            <plugin interceptor="com.github.pagehelper.PageInterceptor">
                
                
                
            </plugin>
        </plugins>
    </configuration>

此时运行，不会再报错！