动态SQL环境搭建

1 环境搭建

1、1 数据库

 CREATE TABLE blog( 
 id VARCHAR(64) NOT NULL ,
 title VARCHAR(64) NOT NULL, 
 author VARCHAR(64) NOT NULL,
 create_time DATETIME NOT NULL, 
 views INT(30) NOT NULL 
 )ENGINE=INNODB DEFAULT CHARSET=utf8; 

1、2实体类 (这里要导入lombok) 工具类

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

使用UUID生成随机数

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

1、3Mapper接口

public interface blogMapper {
    int addBlog(blog blog);
}

1、4Mapper配置

<?xml version="1.0" encoding="UTF-8" ?>


    
        insert into blog (id,title,author,create_time,views)
        values(#{id},#{title},#{author},#{createTime},#{views})
    

1、5Mybatis配置

<?xml version="1.0" encoding="UTF-8" ?>


    
        
        
    
    
        
    
    
    
        
            
            
                
                
                
                
            
        
    
    
    
        
    

1、6用Java插入数据

package com.Google.mapper;

import com.Google.pojo.blog;
import com.Google.units.IDUtil;
import com.Google.units.sqlSessionFactory;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import javax.swing.*;
import java.util.Date;

public class blogTest {
    @Test
    public void test(){
        SqlSession sqlSession = sqlSessionFactory.getsqlSession();

        blogMapper mapper = sqlSession.getMapper(blogMapper.class);

        blog blog = new blog();
        blog.setId(IDUtil.getID());
        blog.setTitle("Mybatis");
        blog.setAuthor("小落");
        blog.setCreateTime(new Date());
        blog.setViews(9999);

        mapper.addBlog(blog);

        blog.setId(IDUtil.getID());
        blog.setTitle("java");
        mapper.addBlog(blog);

        blog.setId(IDUtil.getID());
        blog.setTitle("Spring");
        mapper.addBlog(blog);

        blog.setId(IDUtil.getID());
        blog.setTitle("微服务");
        mapper.addBlog(blog);
        sqlSession.commit();
        sqlSession.close();
    }
}