Mybatis從入門到精通——Mybatis快速使用（3）

一、準備工作

1.maven依賴

<dependencies>
        <!--    mysql驅動    -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.18</version>
        </dependency>

        <!--    junit測試    -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <!--    mybatis    -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>


        <!-- 日志相關依賴 -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.10</version>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.1.2</version>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-core</artifactId>
            <version>1.1.2</version>
        </dependency>
        
    </dependencies>
           

2.實體類

public class Person {

    private Integer id;

    private String name;

    private String sex;

    private String telephone;

    private String address;

    private Integer age;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Person{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", telephone='" + telephone + '\'' +
                ", address='" + address + '\'' +
                ", age=" + age +
                '}';
    }
}
           

3.SQL資源

DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL COMMENT '名字',
  `sex` char(1) NOT NULL DEFAULT '男' COMMENT '性别',
  `telephone` varchar(11) DEFAULT NULL COMMENT '手機号',
  `address` varchar(50) DEFAULT NULL COMMENT '位址',
  `age` tinyint(4) DEFAULT NULL COMMENT '年齡',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1295453 DEFAULT CHARSET=utf8;
 
 
INSERT INTO `person` VALUES ('1', 'xy', '男', '123456', '測試', '18');
INSERT INTO `person` VALUES ('2', 'ceshi', '女', '123456789', '美國', '20');
INSERT INTO `person` VALUES ('3', 'ceshi', '女', '123456789', '美國', '21');
           

二、Mybatis使用步驟

1.建立配置檔案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="lazyLoadTriggerMethods"  value=""/>
            <setting name="logImpl" value="SLF4J"/>
    </settings>

    <!--環境配置，連接配接的資料庫，這裡使用的是MySQL-->
    <environments default="mysql">
        <environment id="mysql">
            <!--指定事務管理的類型，這裡簡單使用Java的JDBC的送出和復原設定-->
            <transactionManager type="JDBC"></transactionManager>
            <!--dataSource 指連接配接源配置，type屬性指使用的資料源工廠實作類，此處使用Mybatis提供的連接配接池-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis_study?serverTimezone=GMT%2B8"></property>
                <property name="username" value="root"></property>
                <property name="password" value="123456"></property>
            </dataSource>
        </environment>
    </environments>

    <!--  映射mapper檔案的路徑-->
    <mappers>
        <mapper resource="mappers/PersonMapper.xml"></mapper>
    </mappers>
    
</configuration>
           

2.建立mapper接口

public interface PersonMapper {

    Person selectById(Integer id);
}
           

3.建立mapper.xml檔案

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.my.mapper.PersonMapper">
    
    <select id="selectById" parameterType="int" resultType="com.my.entity.Person">
        select * from person where id = #{id}
    </select>

</mapper>
           

4.建立測試類

public class MybatisTest {

    private SqlSessionFactory sqlSessionFactory;

    @Before
    public void init() throws IOException {
        String resource = "mybatis-config.xml";
        //1.使用mybatis的工具讀取配置檔案
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        //2.建立sqlSessionFactory
        sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
        inputStream.close();
    }

    @Test
    public void test() {
        //3.擷取sqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //4.擷取mapper接口實作類
        PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
        //5.調用方法
        Person person = personMapper.selectById(1);
        System.out.println(person);
        //6.釋放資源
        sqlSession.close();
    }
}
           

5.目錄結構