MyBatis-2-HelloWorld

MyBatis从0开始学习目录

MyBatis-1-简介
MyBatis-2-HelloWorld
MyBatis-3-全局配置
MyBatis-4-映射文件
MyBatis-5-源码分析
MyBatis-6-#{}和$区别
MyBatis-X-面试题

首先建库mybatis

表

CREATE TABLE tb1_employee(
  id INT(11) PRIMARY KEY AUTO_INCREMENT,
  last_name VARCHAR(255),
  gender CHAR(1),
  email VARCHAR(255)
)

Maven下导包

dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.1</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.37</version>
</dependency>

POJO

package com.wxl.springbootmybatis.bean;

public class Employee {

    private Integer id;
    private String lastName;
    private String email;
    private String gender;

    public Integer getId() {
        return id;
    }

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

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "id=" + id +
                ", lastName='" + lastName + '\'' +
                ", email='" + email + '\'' +
                ", gender='" + gender + '\'' +
                '}';
    }
}

Mybatis.config

?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>
    <!--环境配置，连接的数据库，这里使用的是MySQL-->
    <environments default="deveLopment">
        <environment id="deveLopment">
            <!--指定事务管理的类型，这里简单使用Java的JDBC的提交和回滚设置-->
            <transactionManager type="JDBC"></transactionManager>
            <!--dataSource 指连接源配置，POOLED是JDBC连接对象的数据源连接池的实现-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"></property>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis"></property>
                <property name="username" value="root"></property>
                <property name="password" value="root"></property>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--这是告诉Mybatis区哪找持久化类的映射文件，对于在src下的文件直接写文件名，
            如果在某包下，则要写明路径,如：com/mybatistest/config/User.xml-->
        <mapper resource="EmployeeMapper.xml"></mapper>
    </mappers>
</configuration>

方法一：最原生态mybatis写法，已被取代

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.wxl.mybatis.EmLoyeeMapper">
    <!--
        namespace:名称空间
        id:唯一标识
        resultType:返回值类型
        #{id},从传递过来的参数中取出id值
    -->
    <select id="selectEmp" resultType="com.wxl.springbootmybatis.bean.Employee">
        select id,last_name lastName,email,gender from tb1_employee where id = #{id}
    </select>
</mapper>

MybatisTest

package com.wxl.springbootmybatis.test;


import com.wxl.springbootmybatis.bean.Employee;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;

public class MyBatisTest {

    /*
    *   1.根据xml配置文件(全局配置文件)创建SqlSessionFactory对象
    *       有数据源一些运行环境信息
    *   2.sql映射文件；配置了每一个sql，以及sql的封装规则等
    *   3.将sql映射文件注册在全局配置文件中
    *   4.写代码
    *       1）根据全局配置文件得到SqlSessionFactory
    *       2）使用sqlSession工厂，获取到sqlSession对象使用他来执行增删改查
    *           一个sqlSession就是代表和数据库的一次会话，用完关闭
    *       3）使用sql的唯一标志来告诉MyBatis执行哪个sql，sql都是保存在sql映射文件中
    * */
    @Test
    public void test() throws IOException {
        String resource= "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //2.获取sqlsession实例，能直接执行已经映射的sql语句
        SqlSession openSession = sqlSessionFactory.openSession();

        try {
            Employee employee = openSession.selectOne("com.wxl.mybatis.EmLoyeeMapper.selectEmp", 1);
            System.out.println(employee);
        } finally {
            openSession.close();
        }


    }
}

方法二：接口实现，动态代理

EmployeeMapper.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.wxl.springbootmybatis.dao.EmployeeMapper">
    <!--
        namespace:名称空间;指定接口的全类
        id:唯一标识
        resultType:返回值类型
        #{id},从传递过来的参数中取出id值
           public Employee getEmpById(Integer id);

    -->
    <select id="getEmpById" resultType="com.wxl.springbootmybatis.bean.Employee">
        select id,last_name lastName,email,gender from tb1_employee where id = #{id}
    </select>
</mapper>

MybatisTest

package com.wxl.springbootmybatis.test;


import com.wxl.springbootmybatis.bean.Employee;
import com.wxl.springbootmybatis.dao.EmployeeMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;

/*
*   1.接口式编程
*   原生：         Dao     ====>   DaoImpl
*   mybatis        Mapper  ====>   xxMapper.xml
*
*   2.SqlSession代表和数据库的一次会话，用完必须关闭
*   3.SqlSession和Connection一样都是非线程安全。每次使用都应该获取新的对象。
*   4.mapper没有实现类，但是mybatis会为这个接口生成一个代理对象
*   (将接口和xml绑定)
*    EmployeeMapper empMapper    =   sqlSession.getMapper(EmployeeMapper.class)
*   5.两个重要的配置文件：
*       mybatis的全局配置文件，包含数据库连接池信息，事务管理器信息等...系统运行环境信息
*       sql映射文件，保存了每一个sql语句的映射信息
*               将sql抽取出来
* */
public class MyBatisTest {



    public SqlSessionFactory getSqlSessionFactory() throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        return new SqlSessionFactoryBuilder().build(inputStream);
    }


    @Test
    public void test01() throws IOException {
        //1.获取sqlsessionFactory对象
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();

        //2.获取sqlSession对象
        SqlSession openSession = sqlSessionFactory.openSession();

        try {
            //3.获取接口的实现类对象
            //会为接口自动创建一个代理对象，代理对象会执行增删改查方法
            EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);

            Employee employee = mapper.getEmpById(1);
            System.out.println(employee.getClass());//class com.wxl.springbootmybatis.bean.Employee
            System.out.println(mapper.getClass());//class com.sun.proxy.$Proxy4
            System.out.println(employee);
        } finally {
            openSession.close();
        }
    }
}