spring-mybatis整合

最新推荐文章于 2024-06-13 23:23:00 发布

啦啦啦不想起床

最新推荐文章于 2024-06-13 23:23:00 发布

阅读量76

点赞数

文章标签： spring

本文链接：https://blog.csdn.net/m0_53996163/article/details/117712604

版权

Spring-Mybatis整合

1.applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    <!--将spring-mybatis配置文件导入-->
    <import resource="spring-mybatis.xml"/>
    <!--接口实现类-->
    <bean id="userMapper" class="com.thy.mapper.UserMapperImpl">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>
    <!--XxxMapperImpl实现类采用setter注入方式-->
    <!--注入userMapper，将sqlSession注入到该实现类中-->
    <!--<bean id="userMapper" class="com.thy.mapper.UserMapperImpl">
        <property name="sqlSession" ref="sqlSession"/>
    </bean>-->
</beans>

2.Spring-Mybatis.xml

<?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"


       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/util https://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!--DataSource:使用spring的数据源来代替Mybatis的配置 c3p0 dbcp druid
        我们这里使用spring提供的jdbc：org.springframework.jdbc.datasource-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>

    <!--sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!--绑定Mybatis-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <property name="mapperLocations" value="classpath:com/thy/mapper/*.xml"/>
    </bean>

    <!--sqlSessionTemplate,接口实现类若继承SqlSessionDaoSupport，可省略不写-->
    <!--<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        &lt;!&ndash;只能使用构造器注入sqlSessionFactory，因为它没有set方法&ndash;&gt;
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>-->

    <!--配置声明式事务-->
    <!--开启事务-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <constructor-arg ref="dataSource" />
    </bean>

    <!--结合aop实现事务的植入-->
    <!--配置事务的类-->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <!--给哪些方法配置事务-->
        <!--配置事务的传播特性:propagation
        1、PROPAGATION_REQUIRED：默认事务类型，如果没有，就新建一个事务；如果有，就加入当前事务。适合绝大多数情况。
        2、PROPAGATION_REQUIRES_NEW：如果没有，就新建一个事务；如果有，就将当前事务挂起。
        3、PROPAGATION_NESTED：如果没有，就新建一个事务；如果有，就在当前事务中嵌套其他事务。
        4、PROPAGATION_SUPPORTS：如果没有，就以非事务方式执行；如果有，就使用当前事务。
        5、PROPAGATION_NOT_SUPPORTED：如果没有，就以非事务方式执行；如果有，就将当前事务挂起。即无论如何不支持事务。
        6、PROPAGATION_NEVER：如果没有，就以非事务方式执行；如果有，就抛出异常。
        7、PROPAGATION_MANDATORY：如果没有，就抛出异常；如果有，就使用当前事务。
        -->
        <tx:attributes>
            <tx:method name="addUser" propagation="REQUIRED"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>

    <!--配置事务切入点-->
    <aop:config>
        <aop:pointcut id="txPointCut" expression="execution(* com.thy.mapper.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
    </aop:config>
</beans>

3.mybatis-config.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>
    <settings>
        <!--标准日志工厂实现-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!--log4j日志工厂实现-->
        <!--<setting name="logImpl" value="LOG4J"/>-->
    </settings>
    <!--别名-->
    <typeAliases>
        <package name="com.thy.pojo"/>
    </typeAliases>
</configuration>

4.XXXmapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.thy.mapper.UserMapper">
    <select id="selectUser" resultType="user">
        select *
        from user;
    </select>
    <insert id="addUser" parameterType="user">
        insert into user (id,username,pwd)
        values (#{id},#{username},#{pwd});
    </insert>
    <delete id="delUser" parameterType="_int">
        delete
        from user
        where id=#{id};
    </delete>
</mapper>

5.Maven配置文件 pom.xml

根据自己需要导入相关jar

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>spring-study</artifactId>
        <groupId>com.thy</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>spring-11-transaction</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <!--导入依赖-->
    <dependencies>
        <!--spring5-->
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.5</version>
        </dependency>

        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23 </version>
        </dependency>

        <!--mybatis-->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>

        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>

        <!--mybatis-spring-->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>

        <!--spring操作连接数据库，spring-jdbc-->
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.6</version>
        </dependency>

        <!--lombok插件-->
        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
        </dependency>

        <!--log4j-->
        <!-- https://mvnrepository.com/artifact/log4j/log4j -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

        <!--spring aop-->
        <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.6</version>
        </dependency>
    </dependencies>
    <!--在build中配置resources。来防止资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
</project>

5.使用步骤

编写实体类
编写核心配置文件
编写接口
编写XXXMapper.xmi
测试

6.XXXMapperImpl类说明

1.情况一

在接口实现类XXXmapperImpl中采用setter注入的方式进行注入，如

import java.util.List;

public class UserMapperImpl implements UserMapper{
    //我们的所有操作都使用sqlSession来执行，现在都使用sqlSessionTemplate
    private SqlSessionTemplate sqlSession;

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

    @Override
    public List<User> selectUser() {
        return sqlSession.getMapper(UserMapper.class).selectUser();
    }
}

applicationContext.xml中如果采用以下方式。

<!--注入userMapper，将sqlSession注入到该实现类中-->
<bean id="userMapper" class="com.thy.mapper.UserMapperImpl">
    <property name="sqlSession" ref="sqlSession"/>
</bean>

在spring-mybatis.xml配置文件中应配置如下。

<!--注入userMapper，将sqlSession注入到该实现类中-->
<bean id="userMapper" class="com.thy.mapper.UserMapperImpl">
    <property name="sqlSession" ref="sqlSession"/>
</bean>

2.情况二

在接口实现类XXXmapperImpl中采用extends SqlSessionDaoSupport，如：

package com.thy.mapper;

import com.thy.pojo.User;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import java.util.List;

public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {
    @Override
    public List<User> selectUser() {
        return getSqlSession().getMapper(UserMapper.class).selectUser();
    }

    @Override
    public void addUser(User user) {
        getSqlSession().getMapper(UserMapper.class).addUser(user);
    }

    @Override
    public void delUser(int id) {
        getSqlSession().getMapper(UserMapper.class).delUser(id);
    }

    @Override
    public List<User> show() {
        User user = new User(6, "小王", "123456");
        UserMapper mapper = getSqlSession().getMapper(UserMapper.class);
        mapper.addUser(user);
        mapper.delUser(5);
        return mapper.selectUser();
    }

}

在spring-mybatis.xml配置文件中应配置可以省略sqlSessionTemplate注入，
applicationContext.xml中如果采用以下方式配置。

<!--注入userMapper，将sqlSession注入到该实现类中-->
<bean id="userMapper" class="com.thy.mapper.UserMapperImpl">
    <property name="sqlSession" ref="sqlSession"/>
</bean>

啦啦啦不想起床

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
spring-mybatis整合

Spring-Mybatis整合1.applicationContext.xml<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springfr
复制链接

扫一扫