mybatis-spring整合-优快云博客

本文链接：https://blog.youkuaiyun.com/ZMM_Devil/article/details/85459753

本文详细介绍如何在Spring框架中整合MyBatis，包括配置数据源、SqlSessionFactory、SqlSessionTemplate以及DAO组件，并提供具体XML配置代码示例。

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

首先需要放架包:https://pan.baidu.com/s/1YrHXk3UkDPUyty6Uc42jKw

接下来就是配置了,整合的大概就是把mybatis配置文件都放入spring里边,下面是代码

<?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:p="http://www.springframework.org/schema/p"
       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/aop
         http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 配置数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url">
        <value>jdbc:mysql://localhost:3306/smbms?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC&amp;verifyServerCertificate=false&amp;useSSL=false</value>
    </property>
    <property name="username" value="root"/>
    <property name="password" value="2452762053"/>
</bean>
 <!-- 配置SqlSessionFactoryBean -->
    <bean id="sqlSessionFactory"
          class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 引用数据源组件 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 引用MyBatis配置文件中的配置 -->
        <property name="configLocation"
                  value="classpath:mybatis-config.xml"/>
        <!-- 配置SQL映射文件信息 -->
        <property name="mapperLocations">
            <list>
                <value>classpath:com/zhiyi/mapper/SmbmsUserMapper.xml</value>
            </list>
        </property>
    </bean>

    <!-- 配置SqlSessionTemplate -->
    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>
    <!-- 配置DAO组件并注入SqlSessionTemplate实例 -->
    <bean class="com.zhiyi.mapper.UserMapperImpl" id="userMapper">
        <property name="sqlSession" ref="sqlSessionTemplate"/>
    </bean>
</beans>