Spring学习笔记——07Spring整合Mybatis

最新推荐文章于 2024-07-25 16:47:20 发布

Jiang锋时刻

最新推荐文章于 2024-07-25 16:47:20 发布

阅读量133

点赞数

分类专栏： Spring 文章标签： mybatis spring mysql java

本文链接：https://blog.csdn.net/bingque6535/article/details/108267702

版权

Spring 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

一. 回顾Mybatis

实体类

@Data
public class User {
    private int id;
    private String name;
    private String pwd;
}

Mapper接口

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

Mapper配置文件

<mapper namespace="com.hjf.mapper.UserMapper">
    <select id="getUserList" resultType="user">
        select * from user
    </select>
</mapper>

Mybaits配置文件

<configuration>

    <typeAliases>
        <package name="com.hjf.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?userSSL=true&amp;
                userUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper class="com.hjf.dao.UserMapper"/>
    </mappers>
</configuration>

测试

@Test
public void test01() throws IOException {
    String resources = "mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resources);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    SqlSession sqlSession = sessionFactory.openSession(true);
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    List<User> userList = mapper.getUserList();
    for (User user : userList) {
        System.out.println(user);
    }
}

注意:
xml文件无法导出, 所以需要在配置文件中加入如下配置:

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

二. 整合Mybatis

1. SqlSessionTemplate

配置文件

<dependencies>
	<!--测试-->
	<dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
   	<!--MySQL-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
   	<!--Mybatis-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.5</version>
    </dependency>
   	<!--Spring框架-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>5.1.9.RELEASE</version>
    </dependency>
    <!--spring操作数据库-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.1.9.RELEASE</version>
    </dependency>
    <!--AOP织入-->
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.13</version>
    </dependency>
	<!--Lombok-->
    <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.12</version>
        <scope>provided</scope>
    </dependency>


</dependencies>

接口

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

mapper配置文件

<mapper namespace="com.hjf.dao.UserMapper">
    <select id="selectUser" resultType="user">
        select * from user
    </select>
</mapper>

Spring配置文件(spring-dao.xml)

<!--第一步: 配置数据源
    数据源: 相当于mybaits中配置文件的关于数据库的属性配置
    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.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/mybatis?userSSL=true&amp;
            userUnicode=true&amp;characterEncoding=UTF-8"/>
    <property name="username" value="root"/>
    <property name="password" value="123456"/>
</bean>


<!--第二步: 创建SqlSessionFactory
	SqlSessionFactory: 注入SqlSessionFactory
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="datasource"/>
    <!--绑定mybatis配置文件-->
    <property name="configLocation" value="classpath:mybatis-config.xml" />

    <!--
        相当于mybaits配置文件中的: 
            <mappers> <mapper class="com.hjf.dao.UserMapper"/> </mappers>
    -->
    <property name="mapperLocations" value="classpath:com/hjf/dao/*.xml" />
</bean>


<!--第三步: 创建SqlSessionTemplate
	SqlSessionTemplate: 就是我们使用的sqlSession
-->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    <!--只能使用构造器注入sqlSessionFactory, 因为它没有set方法-->
    <constructor-arg index="0" ref="sqlSessionFactory"/>
</bean>

Mybatis配置文件

因为spring配置文件中已经配置了数据库的属性和映入了mapper类, 所以可以删掉这部分的配置

<configuration>

    <typeAliases>
        <package name="com.hjf.pojo"/>
    </typeAliases>

<!--    <environments default="development">-->
<!--        <environment id="development">-->
<!--            <transactionManager type="JDBC"/>-->
<!--            <dataSource type="POOLED">-->
<!--                <property name="driver" value="com.mysql.jdbc.Driver"/>-->
<!--                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?userSSL=true&amp;userUnicode=true&amp;characterEncoding=UTF-8"/>-->
<!--                <property name="username" value="root"/>-->
<!--                <property name="password" value="123456"/>-->
<!--            </dataSource>-->
<!--        </environment>-->
<!--    </environments>-->

<!--    <mappers>-->
<!--        <mapper class="com.hjf.dao.UserMapper"/>-->
<!--    </mappers>-->
</configuration>

接口实现, 以实现类的自动创建

如果不创建这个类, 则对象需要在使用时创建, 参考之前Mybaits的测试

// 第四步: 给接口加实现类
public class UserMapperImpl implements UserMapper {
    // 我们所有的操作, 都使用sqlSession来执行, 在原来, 现在都是用sqlSessionTemple
    private SqlSessionTemplate sqlSession;

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

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

加载实现类(applicationContext.xml)

<!--导入Spring配置文件-->
<import resource="spring-dao.xml"/>
<!--第五步: 将自己写的实现类, 注入到Spring中-->
<bean id="userMapper" class="com.hjf.dao.UserMapperImpl">
    <property name="sqlSession" ref="sqlSession"/>
</bean>

测试

@Test
public void test02(){
    ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
    UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
    for (User user: userMapper.selectUser()) {
        System.out.println(user);
    }
}

2. SqlSessionDaoSupport

说明
SqlSessionDaoSupport 是一个抽象的支持类，用来为你提供 SqlSession。调用 getSqlSession() 方法你会得到一个 SqlSessionTemplate，之后可以用于执行 SQL 方法，就像下面这样:

案例

public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper {

    public List<User> selectUser() {
//        SqlSession sqlSession = getSqlSession();
//        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//        List<User> userList = mapper.selectUser();
//        return userList;

        return getSqlSession().getMapper(UserMapper.class).selectUser();
    }
}

说明:
如果用了这个方法, 就不用自己再注入sqlSession了, 可以省略掉spring-dao.xml中的以下配置

<!--SqlSessionTemplate: 就是我们使用的sqlSession-->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
     <!--只能使用构造器注入sqlSessionFactory, 因为它没有set方法-->
     <constructor-arg index="0" ref="sqlSessionFactory"/>
</bean>

Jiang锋时刻

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Spring学习笔记——07Spring整合Mybatis

一. 回顾Mybatis实体类@Datapublic class User { private int id; private String name; private String pwd;}Mapper接口public interface UserMapper { public List<User> getUserList();}Mapper配置文件<mapper namespace="com.hjf.mapper.U
复制链接

扫一扫

专栏目录