spring整合mybatis的配置文件-CSDN博客

本文链接：https://blog.csdn.net/EDuGou/article/details/77620725

本文介绍了一个基于Spring框架整合MyBatis的数据库配置案例，包括数据源配置、SQL会话工厂设置及分页插件PageHelper的使用。通过XML配置文件详细展示了如何加载属性文件、设置数据源参数、配置SQL会话工厂以及使用PageHelper实现分页查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

备忘

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!--加载配置文件 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="jdbcUrl" value="${jdbc.url}" />
        <property name="driverClass" value="${jdbc.driverClassName}" />
    </bean>
    <!--sqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!--省略sqlmapconfig.xml-->
        <!--<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>-->
                <property name="mapperLocations" value="classpath*:com/zhmhxy/taotao/dao/*.xml"/>
                <!--另一种写法-->
                <!--<property name="mapperLocations" >-->
            <!--<list>-->
                <!--<value>classpath*:com/zhmhxy/taotao/dao/*.xml</value>-->
            <!--</list>-->
        <!--</property>-->
<property name="plugins">
<!--参考:http://blog.csdn.net/estelle_belle/article/details/46356575-->
            <array>
                <bean class="com.github.pagehelper.PageHelper">
                <!--分页工具,在sql语句发送前根据mysql方言拼接limit-->
                    <property name="properties" >
                        <value>dialect=mysql</value>
                    </property>
                </bean>
            </array>
        </property>
    </bean>
    <!-- 管理mapper接口 -->
    <!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> 
        <property name="mapperInterface" value="com.zhmhxy.taotao.dao.UserMapper"></property> 
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> -->
    <!-- 使用mapper扫描管理所有的代理mapper -->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.zhmhxy.taotao.dao"></property>
    </bean>
</beans>