【Mybatis】

什么是"Mybatis"
MyBatis 是一款优秀的持久层框架。
MyBatis 避免了几乎所有的 JDBC 代码手动设置参数以及手动获取结果集的操作。
Mybatis 将基本的 JDBC 常用接口封装，对外提供操作即可

开发示例

• 导入jar包

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

• 创建一个工具类

public class Teacher {
    private Integer id;
    private Integer num;
    private String name;
    private String gender;

    public int getId() {
        return id;
    }

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

    public int getNum() {
        return num;
    }

    public void setNum(Integer num) {
        this.num = num;
    }

    public String getName() {
        return name;
    }

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

    public String getGender() {
        return gender;
    }

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

• 编写mapper映射文件(编写SQL)

<?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">
<!--
    sql映射文件  主要写sql实现
-->

<!--
useGeneratedKeys="true" 返回自增主题
-->
<mapper namespace="com.ffyc.mybatispro.dao.TeacherDao">


    <update id="updateTeacher" parameterType="teacher">
        update teacher
        <trim prefix="set" suffixOverrides=",">
            <if test="num!=null">
                num = #{num},
            </if>
            <if test="name!=name">
                name = #{name},
            </if>
            <if test="gender!=null">
                gender = #{gender}
            </if>
        </trim>

        where id = #{id}
    </update>

    <delete id="deleteTeacher">
        delete from teacher where id in
        <foreach collection="array" item="id" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>

    <!--
      trim 当条件判断有成立时,可以自定义前缀关键字和后缀关键字
      prefix="where"
      prefixOverrides=and|or" 覆盖指定的关键字
    -->
    <select id="teachers" resultType="com.ffyc.mybatispro.modle.Teacher">
        select * from teacher
        <trim prefix="where" prefixOverrides="and|or">
        <choose>
            <when test="name!=null">
                name = #{name}
            </when>
            <otherwise>
                name = '李老师'
            </otherwise>
        </choose>
        </trim>
    </select>
    <select id="findTeacher" resultType="com.ffyc.mybatispro.modle.Teacher">
        select
        <foreach collection="list" item="col" separator=",">
        ${col}
        </foreach>
        from teacher
    </select>
</mapper>

• 编写全局配置文件(主要是配置数据源信息)

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

<!--mybatis核心全局配置文件-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <!--为类配置别名-->
    <typeAliases>
        <package name="com.ffyc.mybatispro.modle"/>
    </typeAliases>
    <!--配置数据库链接相关信息-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <!--type="POOLED"使用数据库链接池功能-->
            <dataSource type="POOLED">
                <!--数据库连接配置-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/ssmdb?serverTimezone=Asia/Shanghai" />
                <property name="username" value="root" />
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>

    <!--注册映射文件-->
    <mappers>
        <mapper resource="mappers/AdminMapper.xml"></mapper>
        <mapper resource="mappers/StudentMapper.xml"></mapper>
        <mapper resource="mappers/MajorMapper.xml"></mapper>
        <mapper resource="mappers/TeacherMapper.xml"></mapper>
    </mappers>
</configuration>

• 编写dao类

public interface TeacherDao {

    List<Teacher> teachers(Teacher teacher);

    void updateTeacher(Teacher teacher);

    void deleteTeacher(Integer[] integers);

    List<Teacher> findTeacher(List<String> columns);
}

• 测试类

package com.ffyc.mybatispro.test;

import com.ffyc.mybatispro.dao.TeacherDao;
import com.ffyc.mybatispro.modle.Teacher;
import com.ffyc.mybatispro.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.ArrayList;
import java.util.List;

public class TestTeacher {
    @Test
    public void test1(){
        SqlSession sqlSession = MyBatisUtil.getSQLSession();
        TeacherDao teacherDao = sqlSession.getMapper(TeacherDao.class);
        Teacher teacher = new Teacher();
        //teacher.setNum(1000);
        teacher.setName("张老师");

        List<Teacher> teachers = teacherDao.teachers(teacher);
        sqlSession.close();
    }
    @Test
    public void test2(){
        SqlSession sqlSession = MyBatisUtil.getSQLSession();
        TeacherDao teacherDao = sqlSession.getMapper(TeacherDao.class);
        Teacher teacher = new Teacher();
        teacher.setId(1);
        teacher.setNum(1004);
        teacher.setName("陈老师");
        teacherDao.updateTeacher(teacher);

        sqlSession.commit();
        sqlSession.close();
    }
    @Test
    public void test3(){
        SqlSession sqlSession = MyBatisUtil.getSQLSession();
        TeacherDao teacherDao = sqlSession.getMapper(TeacherDao.class);

        teacherDao.deleteTeacher(new Integer[]{1,2,3});

        sqlSession.commit();
        sqlSession.close();
    }
    @Test
    public void test4(){
        SqlSession sqlSession = MyBatisUtil.getSQLSession();
        TeacherDao teacherDao = sqlSession.getMapper(TeacherDao.class);

       List<String> list = new ArrayList<String>();
       list.add("num");
       list.add("name");
       list.add("gender");
       teacherDao.findTeacher(list);

        sqlSession.commit();
        sqlSession.close();
    }
}

**

#{}和${}的区别

**

<!--
       #{}  是占位符,是采用预编译方式向sql中传值,可以防止sqL注入，如果我们往sqL中传值,使用#{}
       ${}  是将内容直接拼接到sql语句中,一般不用于向sql中传值,一般用于向sql动态传递列名

       区别:
          底层实现不同
          #{} 采用预编译方式 防止sql注入更加安全
          ${} 采用字符串拼接,直接将值拼接到sql中
    -->