22.动态SQL环境搭建

动态SQL

什么是动态SQL：动态sql就是根据不同的条件生成不同的SQL语句

利用动态SQL这一特性可以摆脱拼接语句的情况

动态SQL元素和JSTL或者XML的文本处理器相似在mybatis之前的版本中，有很多元素需要花时间了解。mybatis3大大精简了元素种类，现在只需学原来一半的元素即可。mybatis采用功能强大的基于OGNL的表达式来淘汰其他大部分元素。

if
choose(when,otherwise)
trim(where,set)
foreach

搭建环境

CREATE TABLE `blog`(
`id` VARCHAR(50) NOT NULL COMMENT '博客id',
`title` VARCHAR(100) NOT NULL COMMENT '博客标题',
`author` VARCHAR(30) NOT NULL COMMENT '博客作者',
`create_time` DATETIME NOT NULL COMMENT '创建时间',
`views` INT(30) NOT NULL COMMENT '浏览量'
)ENGINE=INNODB DEFAULT CHARSET=utf8

创建一个基础工程

1. 导包
2. 编写配置文件

<!--sql和实体类中_和驼峰命名可以自动转换-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>


    <mappers>
        <mapper class="faq.dao.BlogMapper"/>
    </mappers>

3. 编写实体类

package faq.pojo;

import lombok.Data;

import java.util.Date;

@Data
public class Blog {
    private String id;
    private String title;
    private String author;
    private Date createTime;
    private int views;
}

4. 编写实体类对应的Mapper接口和mapper.xml文件

package faq.dao;

import faq.pojo.Blog;

public interface BlogMapper {
    //插入数据
    int addBlog(Blog blog);
}

<?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="faq.dao.BlogMapper">
    <insert id="addBlog" parameterType="Blog">
        insert into mybatis.blog (id,title,author,create_time,views)
        values (#{id},#{title},#{author},#{create_time},#{views})
    </insert>
</mapper>

5. 测试

import faq.dao.BlogMapper;
import faq.pojo.Blog;
import faq.utils.IDUtils;
import faq.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.Date;

public class MyTest {
    @Test
    public void addBlogTest() {
        SqlSession sqlSession = MybatisUtils.getsqlSession();
        BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);
        Blog blog = new Blog();
        blog.setId(IDUtils.getId());
        blog.setTitle("Mybatis");
        blog.setAuthor("狂神说");
        blog.setCreateTime(new Date());
        blog.setViews(9999);

        mapper.addBlog(blog);

        blog.setId(IDUtils.getId());
        blog.setTitle("Java");
        mapper.addBlog(blog);

        blog.setId(IDUtils.getId());
        blog.setTitle("Spring");
        mapper.addBlog(blog);

        blog.setId(IDUtils.getId());
        blog.setTitle("微服务");
        mapper.addBlog(blog);

        sqlSession.close();
    }
}