SpringBoot集成MyBatis

在pom.xml中添加依赖：

<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">
  <modelVersion>4.0.0</modelVersion>
  <groupId>cn.et</groupId>
  <artifactId>SpringBoot_MyBatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <!-- 继承自springboot的依赖 -->
  	<parent>
	    <groupId>org.springframework.boot</groupId>
	    <artifactId>spring-boot-starter-parent</artifactId>
	    <version>1.5.9.RELEASE</version>
	</parent>
	<dependencies>
		<!-- 
			springboot每一个框架的集成都是starter
			spring-boot-starter-web 加载javaee 内嵌tomcat
		 -->
	    <dependency>
	        <groupId>org.springframework.boot</groupId>
	        <artifactId>spring-boot-starter-web</artifactId>
	    </dependency>
	      <!-- 加载mybatis依赖 -->
	    <dependency>
		  <groupId>org.mybatis.spring.boot</groupId>
		  <artifactId>mybatis-spring-boot-starter</artifactId>
		  <version>1.3.1</version>
		</dependency>
		  <!-- 如果需要jsp 添加该依赖  -->
	    <dependency>
	    	<groupId>org.apache.tomcat.embed</groupId>
	    	<artifactId>tomcat-embed-jasper</artifactId>
	    </dependency>
	     <!-- 
	    	数据库启动自动化
	    	连接数据的starter
	     -->
	    <dependency> 
		    <groupId> org.springframework.boot </groupId> 
		    <artifactId> spring-boot-starter-data-jpa </artifactId> 
		</dependency> 
		
		<!-- mysql驱动包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		
		<!-- 加载druid的依赖 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.5</version>
		</dependency>
	</dependencies>
</project>

在application.properties中增加配置：

#配置数据库四要素
spring.datasource.url=jdbc:mysql://localhost/desk
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#指定数据源
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat,config
spring.jpa.show-sql=true
#端口
server.port=80
#项目上下文
server.context-path=/sbm 
spring.devtools.restart.enabled=true

启动类

package cn.et;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class SpringBootTest {
	
	public static void main(String[] args) {
		SpringApplication.run(SpringBootTest.class, args);
	}
}

controller控制层

package cn.et.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import cn.et.Dept;
import cn.et.dao.SpringBootMapper;

@RestController
public class SpringBootController {
	@Autowired
	SpringBootMapper mapper;
	
	@RequestMapping("/queryDept")
	public List<Dept> query() {
		return mapper.queryDept();
	}
}

Dao层,一个@Mapper注解就搞定了

package cn.et.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import cn.et.Dept;

@Mapper
public interface SpringBootMapper {
	
	@Select("select * from dept")
	public List<Dept> queryDept();
	
}