spring整合mybatis

于 2023-04-29 17:36:32 发布
阅读量43 收藏
点赞数
文章标签： mybatis spring java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_61871870/article/details/130440612
版权

spring整合mybatis

导包

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


        <!--        mysql-connector-java-->
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

<!--        spring-webmvc-->
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.1.10.RELEASE</version>
        </dependency>


        <!--        spring-jdbc-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.10.RELEASE</version>
        </dependency>

<!--        aop织入器-->
        <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.4</version>
        </dependency>


        <!--        mybatis-spring整合包-->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.2</version>
        </dependency>


	<dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

<!-- 用于解决配置Maven静态资源过滤问题！-->
<!-- 如果在完成编译后target中没有mapper.xml文件，就加上这个 -->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>


</project>

创建实体类

package com.mybatis.Entity;
//使用了lombok，自动生成getter setter
import lombok.Data;

@Data
public class User {
//字段与数据库字段一一对应
    private int studNum;
    private String studName;
    private String studClass;
}

创建Mapper

Mapper

package com.mybatis.Mapper;

import com.mybatis.Entity.User;

import java.util.List;

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

mapper.xml

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

<!--命名空间指向Mapper接口-->
<mapper namespace="com.mybatis.Mapper.UserMapper">
<!--    id指向Mapper中的方法名 resultMap结果集映射-->
    <select id="getUser" resultMap="user">
        select * from stud_imformation
    </select>
    

    <resultMap id="user" type="com.mybatis.Entity.User">
        <result property="studNum" column="stud_num"></result>
        <result property="studName" column="stud_name"></result>
        <result property="studClass" column="stud_class"></result>
    </resultMap>
</mapper>

mapper实现类

package com.mybatis.Mapper;

import com.mybatis.Entity.User;
import org.mybatis.spring.SqlSessionTemplate;

import java.util.List;

public class UserDaoImp implements UserMapper {
	//私有化sqlSessionTemplate
    //此时的sqlSession已经不需要我们自己管理，而是让spring管理
    private SqlSessionTemplate sqlSession;

    //为了将sqlSession注入到bean，我们要么需要一个构造器，要么需要一个set
    //set
    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }

    public UserDaoImp(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }

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

配置文件

mybatis核心配置文件
为了便于理解bean中的配置，这里的原mybatis配置信息先保留下来。
这里可以修改一些基础配置，如, 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <!--<environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/student?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="com.mybatis.Mapper"/>
    </mappers>-->


<!-- -->
</configuration>

springBean配置

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

<!--    配置数据源，相当于原来mybatis-config中的configuration-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql://localhost:3306/student?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8"></property>
    <property name="username" value="root"></property>
    <property name="password" value="123456"></property>
</bean>

<!--    SqlSessionFactoryBean，代替原mybatis中的SqlSessionFactoryBuilder-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--    配置数据源-->
    <property name="dataSource" ref="dataSource"></property>
<!--    关联mybatis的配置文件,有了bean.xml后，mybatis-config中只需要负责修改mybatis的基础配置即可，如<settings>,<typeAliases> -->
    <property name="configLocation" value="classpath:mybatis-config.xml"></property>
<!--    注册mapper.xml-->
    <property name="mapperLocations" value="classpath:com/mybatis/Mapper/*.xml"></property>
</bean>

<!--    SqlSessionTemplate是用于实现sqlSession的，是spring-mybatis的核心-->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<!--使用构造器注入sqlSessionFactory-->
    <constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
</bean>

<bean id="userMapper" class="com.mybatis.Mapper.UserDaoImp">
<!--    set方法注入bean-->
    <property name="sqlSession" ref="sqlSession"></property>
<!--    构造器注入bean-->
    <constructor-arg index="0" ref="sqlSession"></constructor-arg>
</bean>



</beans>

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"
       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/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd">
        
    <import resource="classpath:beans.xml"></import>

</beans>

测试类

import com.mybatis.Mapper.UserMapper;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test2 {

    @Test
    public void test(){
    //在实际项目中不同的人的编写不同的bean配置文件，将所有bean配置文件都importapplicationContext中
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper mapper = context.getBean("userMapper",UserMapper.class);
        System.out.println(mapper.getUser());
    }
}

方式二

该方法可简化对sqlSession的注入

package com.mybatis.Mapper;

import com.mybatis.Entity.User;
import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import java.util.List;
//继承SqlSessionDaoSupport后，可以直接调用getSession()后就能得到一个sqlSessionTemplate
public class UserMapperImp2 extends SqlSessionDaoSupport implements UserMapper{

    @Override
    public List<User> getUser() {
        SqlSession sqlSession = getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        return mapper.getUser();
    }
}

由于在上述代码中已经得到了SqlSessionTemplate，也就无需再私有化sqlSessionTemplate,也无需再有其构造器

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

<!--    配置数据源，相当于原来mybatis-config中的configuration-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql://localhost:3306/student?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8"></property>
    <property name="username" value="root"></property>
    <property name="password" value="123456"></property>
</bean>

<!--    sqlSessionFactoryBean -> sqlSessionFactory-->
<!--    SqlSessionFactoryBean，代替原mybatis中的SqlSessionFactoryBuilder-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--    配置数据源-->
    <property name="dataSource" ref="dataSource"></property>
<!--    关联mybatis的配置文件,有了bean.xml后，mybatis-config中只需要负责修改mybatis的基础配置即可，如<settings>,<typeAliases> -->
    <property name="configLocation" value="classpath:mybatis-config.xml"></property>
<!--    注册mapper.xml-->
    <property name="mapperLocations" value="classpath:com/mybatis/Mapper/*.xml"></property>
</bean>

<!--    sqlSessionTemplate -> sqlSession-->
<!--    SqlSessionTemplate是用于实现sqlSession的，是spring-mybatis的核心-->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<!--使用构造器注入sqlSessionFactory-->
    <constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
</bean>

<!--&lt;!&ndash;&ndash;&gt;
<bean id="userMapper" class="com.mybatis.Mapper.UserDaoImp">
&lt;!&ndash;    set方法注入bean&ndash;&gt;
    <property name="sqlSession" ref="sqlSession"></property>
&lt;!&ndash;    构造器注入bean&ndash;&gt;
    <constructor-arg index="0" ref="sqlSession"></constructor-arg>
</bean>-->
    <bean id="userMapper" class="com.mybatis.Mapper.UserMapperImp2">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
        <property name="sqlSessionTemplate" ref="sqlSession"></property>
    </bean>



</beans>
wenyihuila
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值