SpringBoot（三） 集成mybatis

1、在pom.xml文件中配置数据库和mybatis的依赖

<!-- mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>

		<!-- 数据库 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
		</dependency>
		<dependency>
			<groupId>oracle</groupId>
			<artifactId>ojdbc</artifactId>
			<version>1.4</version>
		</dependency>

2、在application.properties文件中添加数据库连接配置和mybatis的路径配置

#mysql
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#spring.datasource.url=jdbc:mysql://localhost:3306/boottest?useUnicode=true&characterEncoding=utf-8&useSSL=false
#spring.datasource.username=root
#spring.datasource.password=
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@172.31.1.70:1521:SGY
spring.datasource.username=
spring.datasource.password=

#mybatis.mapper-locaitons=classpath:mapper/*.xml
#mybatis.typeAliasesPackage=com.zw.dao
#指定mybatis所对应的xml文件目录
mybatis.mapper-locations=classpath*:mapper/*Dao.xml
#mybatis.type-aliases-package=com.zw.domain

3、新建文件数据库接口StudentDao.java和StudentDao.xml文件

 3.1 目录结构

  

3.2 新建StudentDao.java接口文件

package com.zw.dao;

import java.util.List;

import com.zw.dto.Student;

public interface StudentDao {

	List<Student> getStudent();

}

3.3 新建StudentDao.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.zw.dao.StudentDao">
	
	<resultMap id="StudentResp" type="com.zw.dto.Student">
		<result column="id" property="id"/>
		<result column="name" property="name"/>
		<result column="score" property="score"/>
	</resultMap>
	
	 <select id="getStudent" resultMap="StudentResp" parameterType="java.util.Map">
		select t.id,t.name,t.score 
		from student t 
	</select>

</mapper>

  3.4 在启动类的头部添加如下的注解，指名dao层的接口位置

@MapperScan("com.zw.dao")

4、启动Service模块的启动类即可。这里后续写的写的接口测试出来的结果如下图