Spring整合Mybatis

最新推荐文章于 2025-11-03 11:48:09 发布

原创最新推荐文章于 2025-11-03 11:48:09 发布 · 228 阅读

0 ·

CC 4.0 BY-SA版权

SSM 专栏收录该内容

15 篇文章

订阅专栏

本文详细介绍了如何在项目中整合MyBatis与Spring框架，包括导入必要jar包、配置核心文件、创建实体类、编写映射文件、配置数据源、实现DAO接口以及测试查询方法，最后还介绍了如何通过Mapper接口进一步优化整合过程。

步骤：

1.导入jar包

创建好项目后，在web下面创建lib文件夹，用于存放jar包。
1.mybatis的jar包：
在这里插入图片描述

2.数据库驱动jar包

3.数据库连接池DBCPjar包

4.Spring的jar包

5.Mybatis和Spring整合包

2.添加好jar包后右击lib，选择添加为库（Create Library）

3.在src下创建配置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>



<typeAliases>
<!--配置别名-->
    <package name="com.szl.backoffice.model"></package>
</typeAliases>


    <!--加载映射文件-->
    <mappers>
        <mapper resource="com/szl/backoffice/sqlmap/User.xml"></mapper>
    </mappers>

</configuration>

4.在Model中编写一个实体类User

public class User implements Serializable {
    private int id;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    private String username;
    private String sex;

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    private Date birthday;

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    private String address;
    

    public User(String username, String sex, Date birthday, String address) {

        this.username = username;
        this.sex = sex;
        this.birthday = birthday;
        this.address = address;
    }

    public User() {
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", sex='" + sex + '\'' +
                ", birthday=" + birthday +
                ", address='" + address + '\'' +
                '}';
    }
}

5.创建User的映射文件User.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="user">

    <select id="findUserById" parameterType="int" resultType="user">

        SELECT * from user where id=#{id}
    </select>

</mapper>

6.在src下创建spring配置文件applicationContext.xml并配置spring的数据源

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/mvc
		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-3.2.xsd
		http://www.springframework.org/schema/aop
		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    <!-- 1.配置数据库，dbcp数据库连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
			<property name="password" value="123456"/>
			<!-- 最大连接  -->
        <property name="maxActive" value="10"/>
        <!--最大空闲数  -->
        <property name="maxIdle" value="5"/>
    </bean>
   <!-- 2.配置会话工厂, 用于返回一个会话工厂的对象 -->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 数据源，就是上面配置数据库的数据源-->
        <property name="dataSource" ref="dataSource"></property>
        <!-- MyBaits配置文件的路径-->
        <property name="configLocation" value="classpath:SqlMapConfig.xml"></property>
    </bean>
</beans>

7.编写查询方法的接口和实现类（接口略）

package com.szl.backoffice.Dao;

import com.szl.backoffice.model.User;
import org.mybatis.spring.support.SqlSessionDaoSupport;

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
    public User findUserById(int id){
        return this.getSqlSession().selectOne("user.findUserById",id);
    }
}

8.在spring配置文件中配置daobean

 <!--3.配置dao-->
    <bean id="userDao" class="com.szl.backoffice.Dao.UserDaoImpl">
        <property name="sqlSessionFactory" ref="sessionFactory"></property>
    </bean>

9.测试

public class Demo01 {
    @Test
    public void test1(){
        //1.加载spring配置文件
        ApplicationContext context=new ClassPathXmlApplicationContext("applicaitonContext.xml");
    //2.获取dao的bean
    UserDao userDao= (UserDao) context.getBean("userDao");
    //3.调用dao方法
        User user=userDao.findUserById(1);

        System.out.println(user);

    }
}

将上述的DAO换成Mapper接口整合DAO

1.创建Mapper包，将上述DAO包中的UserDao接口复制到mapper包下即可

2.将上述sqlmap包中的User.xml文件复制到mapper包下，将命名空间改为userDao接口即可

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.szl.backoffice.mapper.UserMapper">

    <select id="findUserById" parameterType="int" resultType="user">

        SELECT * from user where id=#{id}
    </select>

</mapper>

3.在sqlMapConfig.xml核心配置文件中加载User.xml映射文件

 <!--加载映射文件-->
    <mappers>
        <!--<mapper resource="com/szl/backoffice/sqlmap/User.xml"></mapper>-->
        
        <!--包配置只适应与mapper代理
        加载映射接口的配置文件
        -->
        <package name="com.szl.backoffice.mapper"></package>
    </mappers>

4.在spring配置文件中配置MapperFactoryBean

 <!--4.由spring创建一个UserMapper对象，使用工厂来创建-->
    <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="sqlSessionFactory" ref="sessionFactory"></property>
        <property name="mapperInterface" value="com.szl.backoffice.mapper.UserMapper"></property>
    </bean>

5.测试

@Test
public void test2(){
    //1.加载spring配置文件
    ApplicationContext context=new ClassPathXmlApplicationContext("applicaitonContext.xml");
    //2.获取userMapper
    UserMapper userMapper = (UserMapper) context.getBean("userMapper");
    //3.调用dao方法
    User user=userMapper.findUserById(10);

    System.out.println(user);

}

第二种方式每个mapper都要配置一个bean对象，比较麻烦，所有有了第三种方法，在spring配置文件中批量配置（其余所有代码都和第二种方式一样）

 <!--3.批量创建mapper的bean对象
    内部会扫描指定包下的mapper，创建接口的代理对象，名字就是类名，首字母小写
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
      <property name="basePackage" value="com.szl.backoffice.mapper"></property>
        <!--value就是上述配置会话工厂的Id-->
        <property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>
    </bean>