【Spring第十篇】Spring整合Mybatis

素颜马尾好姑娘i 2023-09-29 10:08 61阅读 0赞

#### 文章目录 ####

*   *   *  1.配置数据源文件：在resources目录下创建db.properties
         *  2.编写mybatis-config.xml文件
         *  3.编写spring-dao.xml配置文件
         *  4.将mybati以及spring整合在一个ApplicationContext.xml

`导包：`

<dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>
    
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.9</version>
        </dependency>
    
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.16</version>
        </dependency>
    
    
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.16</version>
        </dependency>
    
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.8</version>
        </dependency>
    
    
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.7</version>
        </dependency>
    
    </dependencies>

`资源导出问题：`

<build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

#### 1.配置数据源文件：在resources目录下创建db.properties ####

driver=com.mysql.cj.jdbc.Driver
    url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8
    username=root
    password=123456

#### 2.编写mybatis-config.xml文件 ####

用于mybatis的配置文件

<?xml version="1.0" encoding="UTF8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
    
    
        
        <properties resource="db.properties"/>
    
    
        <settings>
            
            <setting name="logImpl" value="STDOUT_LOGGING"/>
    
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
    
    
            
            <setting name="cacheEnabled" value="true"/>
    
    
            <setting name="defaultStatementTimeout" value="3" />
    
        </settings>
    
    
        
        <typeAliases>
            <typeAlias type="com.kk.pojo.User" alias="User"/>
        </typeAliases>
    
    </configuration>

#### 3.编写spring-dao.xml配置文件 ####

用于spring配置文件，并且连接mybatis的配置文件

<?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: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-3.0.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">
    
    
    
        <context:property-placeholder location="classpath:db.properties"/>
    
    
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    
    
    
    
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${password}"/>
        </bean>
    
    
    
    
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
    
    
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            <property name="mapperLocations" value="classpath:com/kk/mapper/*.xml"/>
        </bean>
    
    
    
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            
            <constructor-arg index="0" ref="sqlSessionFactory"/>
        </bean>
    
    
    
    </beans>

#### 4.将mybati以及spring整合在一个ApplicationContext.xml ####

--------------------

实体类 User

@Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class User {
        
    
        private int id;
        private String username;
        private String password;
    
    }

--------------------

`mapper层`

`UserMapper` 接口

public interface UserMapper {
        
    
        public List<User> selectUser();
    
    }

`UserMapper.xml`

<?xml version="1.0" encoding="UTF8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    <mapper namespace="com.kk.mapper.UserMapper">
    
        <select id="selectUser" resultType="User">
            select * from mybatis.user ;
        </select>
    
    
    </mapper>

`接口实现类 UserMapperImpl`

public class UserMapperImpl implements UserMapper{
        
    
        //我们的所有操作，，在原来都使用SqlSession来执行，现在都使用SqlSessionTemple；
        private SqlSessionTemplate sqlSession;
    
    
        //需要将它注入进来
        public void setSqlSession(SqlSessionTemplate sqlSession) {
        
            this.sqlSession = sqlSession;
        }
    
        @Override
        public List<User> selectUser() {
        
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    
            List<User> userList = mapper.selectUser();
    
            return userList;
        }
    }

--------------------

`拓展：使用实现类继承SqlSessionDaoSupport`

UserMapperImpl2

public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper{
        
        @Override
        public List<User> selectUser() {
        
    
            SqlSession sqlSession = getSqlSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<User> userList = mapper.selectUser();
            return userList;
        }
    }

在spring\_dao.xml中加入以下字段

<bean id="userMapper2" class="com.kk.mapper.UserMapperImpl2">
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-lqr3r8Wj-1649854513028)(C:\\Users\\30666\\AppData\\Roaming\\Typora\\typora-user-images\\image-20220310193156529.png)\]][img-lqr3r8Wj-1649854513028_C_Users_30666_AppData_Roaming_Typora_typora-user-images_image-20220310193156529.png]

[img-lqr3r8Wj-1649854513028_C_Users_30666_AppData_Roaming_Typora_typora-user-images_image-20220310193156529.png]: https://img-blog.csdnimg.cn/a5521d3ce2964cf5b460e5ac951bf320.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5LiD5a-75YyX6YeM,size_17,color_FFFFFF,t_70,g_se,x_16