Spring--回忆Mybatis

Spring

01: Spring简介
02: Spring–Spring组成及拓展
03: Spring–IoC理论推导&IoC本质
04: Spring–第一个Spring程序HelloSpring&修改上节案例
05: Spring–IoC创建对象方式
06: Spring–Spring配置
07: Spring–依赖注入(Dependency Injection)
08: Spring–Bean的作用域
09: Spring–自动装配Bean(使用自动装配xml配置)
10: Spring–使用注解实现自动装配(推荐使用)
11: Spring–注解开发
12: Spring–使用JavaConfig实现配置
13: Spring–静态代理再理解&AOP
14: Spring–AOP(通过 Spring API 实现&自定义类来实现Aop&使用注解实现)
15: Spring–回忆Mybatis
16: Spring–整合Mybatis
17: Spring–Spring声明式事务

---

1. 回忆Mybatis

1.1 步骤

• 1.编写实体类
• 2.编写核心配置文件
• 3.编写接口
• 4.编写Mapper.xml
• 5.测试

---

1.1.1 编写实体类

为下面这个表编写实体类

User.java

package com.tian.pojo;

import lombok.Data;

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

---

1.1.2 编写核心配置文件

mabatis-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核心配置文件-->
<configuration>
    <typeAliases>
        <package name="com.tian.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--以下数据都是我自己的数据库的信息,请酌情修改-->
                <!--&amp;表示转义字符,其含义就是&-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url"
                          value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=true"/>
                <property name="username" value="root"/>
                <property name="password" value="317525"/>
            </dataSource>
        </environment>
    </environments>
    <!--    每一个Mapper.xml都需要在Mybatis核心配置文件中注册!-->
    <mappers>
        <!--        可以通过class或是resource配置-->
        <!--        <mapper class="com.tian.mapper.UserMapper"/>-->
        <mapper resource="com/tian/mapper/UserMapper.xml"/>
    </mappers>
</configuration>

---

1.1.3 编写接口

UserMapper.java

package com.tian.mapper;

import com.tian.pojo.User;

import java.util.List;

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

---

1.1.4 编写Mapper.xml

UserMapper.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.tian.mapper.UserMapper">
    <select id="selectUser" resultType="user">
        select *
        from mybatis.user;
    </select>
</mapper>

---

1.1.5 测试

Test.java

    @org.junit.Test
    public void test() throws Exception {
        String resources = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resources);
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
//        设置自动提交事务
        SqlSession sqlSession = factory.openSession(true);


        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = mapper.selectUser();
        for (User user : users) {
            System.out.println(user);
        }
        // 关闭sqlSession
        sqlSession.close()
    }

运行结果:

---

---