2021-05-19

最新推荐文章于 2024-09-27 00:45:01 发布

柏森49

最新推荐文章于 2024-09-27 00:45:01 发布

阅读量103

点赞数 1

分类专栏：笔记文章标签： java spring

本文链接：https://blog.csdn.net/weixin_44161853/article/details/117031107

版权

笔记专栏收录该内容

3 篇文章 0 订阅

订阅专栏

##MyBatis-Spring的整合
先进行配置的依赖
Spring-Study
org.example
1.0-SNAPSHOT

4.0.0

<artifactId>Spring-mybatis</artifactId>

org.mybatis mybatis 3.5.2 junit junit 4.12

</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.47</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.1.9.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.9.4</version>
</dependency>
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>2.0.4</version>
</dependency>
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.12</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>4.3.11.RELEASE</version>
</dependency>

src/main/resources **/*.properties **/*.xml true src/main/java **/*.properties **/*.xml true

实体类的建立

User.java这块用脚就抠出来了就不写了。
mybatis 映射建、增、删、改、接口方法、创建Mapper.xml文件注意namespace的位置调用,

<select id="selectUser"   resultType="com.lu.pojo.User">
    select *  from user
</select>

接下来就是最重要的一点进行整合，

（1）进行bean.xml配置

<?xml version="1.0" encoding="UTF8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/context
       https://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/aop
       https://www.springframework.org/schema/aop/spring-aop.xsd">

（2）和mybatis数据连接作比较配置数据源


## <!-- 配置数据源-->

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
``

## （3）获取sqlSessionFactory

`<!-- 获取sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
 

## （4） 获取mybatis位置这步可有可无，在mybtis中可以直接设置也可以在bean.xml中进行调用

        <!-- 获取mybatis位置-->
        <property name="configLocation" value="classpath:mybatis.xml"/>
        <property name="mapperLocations" value="classpath*:com/lu/dao/UserMapper.xml"/>
    </bean>
  

## <5>在测试之中进行实现类的创建 在测试时候不用直接的调用sqlsession.getMapper省去这一步奏，可以将增删改查进行封装

    ` public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }

    public List<User> selectUser() {
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        return  mapper.selectUser();`

## <6>实现类的配置

    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>
    <bean id="UserMapper" class="com.lu.dao.UserMapperImpl">
        <property name="sqlSession" ref="sqlSession"></property>
    </bean>

## <7>测试
 ApplicationContext context = new ClassPathXmlApplicationContext("bean.xml");
UserMapper dao = (UserMapper) context.getBean("UserMapper");
        for (User user : dao.selectUser()) {
            System.out.println(user);