Mybatis动态SQL

配置文件

<?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="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="lz666."/>
            </dataSource>
        </environment>
    </environments>

    <!--每一个xml都需要单独写一次-->
    <mappers>
        <mapper class="com.li.mapper.BlogMapper"/>
    </mappers>
</configuration>

pojo

package com.li.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;
}

utils工具类

UUID

package com.li.utils;

import java.util.UUID;
//镇压警告，让所有警告波浪线不显示 qaq
@SuppressWarnings("all")

public class IDutils {
    public static String getId() {
        return UUID.randomUUID().toString().replaceAll("-","");
    }
}

MybatisUtils

package com.li.utils;

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 java.io.IOException;
import java.io.InputStream;

public class MybatisUtils {
    public static SqlSessionFactory sqlSessionFactory;
    static {
        //构建 SqlSessionFactory对象
        try {
            String resource = "MybatisConfig.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
    // SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。你可以通过 SqlSession 实例来直接执行已映射的 SQL
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession(true);
    }
}

BlogMapper

package com.li.mapper;

import com.li.pojo.Blog;

import java.util.List;
import java.util.Map;

public interface BlogMapper {

    int AddBlog(Blog blog);

    List<Blog> BlogList(Map map);
}

BlogMapper.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.li.mapper.BlogMapper">
    <!--  给sql添加数据  -->
    <insert id="AddBlog" parameterType="com.li.pojo.Blog">
        insert into blog values(#{id},#{title},#{author},#{createTime},#{views})
    </insert>

    <!--  动态查找记录  -->
    <select id="BlogList" resultType="com.li.pojo.Blog" parameterType="map">
        select * from blog where 1=1
        <if test="title != null">
            AND title like #{title}
        </if>
        <if test="id != null">
            AND id like #{id}
        </if>
    </select>

</mapper>

测试类

package com.li.mapper;

import com.li.pojo.Blog;
import com.li.utils.IDutils;
import com.li.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.Date;
import java.util.HashMap;
import java.util.List;

public class test {
    //添加数据
    @Test
    public void test1(){
        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();
    }

    //动态查找
    @Test
    public void test2(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);
        HashMap map = new HashMap();
        map.put("title","Mybatis");
        //map.put("id","1");
        List<Blog> blogMappers = mapper.BlogList(map);
        for (Blog blogMapper : blogMappers) {
            System.out.println(blogMapper);
        }
        sqlSession.close();
    }
}

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>Mybatis</artifactId>
        <groupId>org.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>Mybatis-04</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>RELEASE</version>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>

            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>
        </resources>
    </build>

</project>

目录结构