springboot集成mybatis的两种写法

1. sql写在java类中

	@Mapper
	public interface UserMapper {
	    @Select("select * from user")
	    List<UserEntity> users();
	}

2. sql写在xml

	@Mapper
	public interface UserMapper {
	    List<UserEntity> users();
	}

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="cn.lu.springbootdemo.mapper.UserMapper">
    <select id="users" resultType="cn.lu.springbootdemo.entity.UserEntity">
        select * from user
    </select>
</mapper>

3. 配置
   application.yml
   mysql数据库简单配置，正式环境可用阿里的druid

server:
  port: 8085
  servlet:
    context-path: /demo

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot_demo?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
    username: root
    password: 1234
    driver-class-name: com.mysql.jdbc.Driver

mybatis:
  mapper-locations: classpath*:mapper/*.xml