解决MyBatis集成SpringMVC时配置失效问题

Bertha 。 2023-10-08 18:14 31阅读 0赞

## 错误原因 ##

1.  第一种原因：可能是Mybatis配置文件内容写错分别检查：数据源配置、mapper映射扫描配置、SQLSessionFactory配置、SqlSession配置。  
    附上完整配置项目代码：（案例以阿里druid连接池为主）

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            
            <property name="driverClassName" value="${driver}" />
            <property name="url" value="${url}" />
            <property name="username" value="${username}" />
            <property name="password" value="${password}" />
            
            <property name="initialSize" value="${initialSize}" />
            <property name="minIdle" value="${minIdle}" />
            <property name="maxActive" value="${maxActive}" />
            
            <property name="maxWait" value="${maxWait}" />
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
            
            <property name="testWhileIdle" value="true" />
            
            <property name="testOnBorrow" value="true" />
            <property name="testOnReturn" value="false" />
            
            <property name="poolPreparedStatements" value="true" />
            <property name="maxPoolPreparedStatementPerConnectionSize" value="50" />
            
            <property name="defaultAutoCommit" value="true" />
            
            <property name="validationQuery" value="select 1 from dual" />
            <property name="filters" value="wall,stat" />
            <property name="proxyFilters">
                <list>
                    <ref bean="logFilter" />
                    <ref bean="stat-filter" />
                </list>
            </property>
        </bean>
    
        
        <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
            
            <property name="slowSqlMillis" value="50"/>
            <property name="logSlowSql" value="true"/>
        </bean>
        
        <bean id="logFilter" class="com.alibaba.druid.filter.logging.Slf4jLogFilter">
            <property name="dataSourceLogEnabled" value="true" />
            <property name="statementExecutableSqlLogEnable" value="true" />
        </bean>
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource" />
            
            <property name="typeAliasesPackage" value="com.ynu.ssmdemo" />
            
            <property name="mapperLocations" value="classpath:com/ynu/ssmdemo/mybatis/dao/**/*.xml"></property>
        </bean>

1.  第二种原因：MyBatis配置文件没有加载到SpringApplication中  
    修改方法：打开web.xml文件，添加SpringContext初始化监听器
    
        
        <context-param>
            
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:mybatis.xml</param-value>
        </context-param>
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>

> 以上两种方法能够解决大部分问题。

> 感谢各位看官，如果喜欢的话点赞给我多多支持，我会一直出Java全栈开发课程内容，蟹蟹大家~磕头