springboot之mybatis使用

springboot之mybatis使用

1. POM导入mysql和mybatis依赖

 <!--mybatis依赖-->
	        <dependency>
	            <groupId>org.mybatis.spring.boot</groupId>
	            <artifactId>mybatis-spring-boot-starter</artifactId>
	            <version>1.3.1</version>
	        </dependency>
	
	        <!--mysql依赖-->
	        <dependency>
	            <groupId>mysql</groupId>
	            <artifactId>mysql-connector-java</artifactId>
	            <version>5.1.6</version>
	        </dependency>
	        <dependency>
	            <groupId>org.springframework.boot</groupId>
	            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

2. 创建对应实体类

3. 创建对应mapper及对应的mapper.xml

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="">
	    <select id="" resultType="">
	
	    </select>
	
</mapper>

3.配置mysql数据库连接及mybatis

	#数据库连接
	  datasource:
	    url: jdbc:mysql://localhost:3306/oauth2?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
	    driverClassName: com.mysql.jdbc.Driver
	    username: root
	    password: root
	  main:
	    allow-bean-definition-overriding: true
	
	
	
	#mybatis
	mybatis:
	  mapper-locations: classpath:mapper/*Mapper.xml
      type-aliases-package: com.test.testoauth2.domain 

结束！！！