SpringBoot Mybatis结合

1. 搭建SpringBoot+MyBatis环境

2. 编写实体类

3. 编写SQL定义文件

4. 编写Mapper映射器接口

5. 在启动类前追加@MapperScan标记

6. 在application.properties追加mybatis.mapper-locations定义

pom.xml 中引入jar包

<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.xdl</groupId>
  <artifactId>boot_02</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
<parent>
 <groupId>org.springframework.boot</groupId>
 <artifactId>spring-boot-starter-parent</artifactId>
 <version>1.4.7.RELEASE</version>
</parent>

<properties>
<java.version>1.8</java.version>
</properties>

<dependencies>

<!-- 启用ioc、组件扫描、自 动配置 -->
<dependency>
<groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter</artifactId>
</dependency>

<dependency>
<groupId>junit</groupId>
  <artifactId>junit</artifactId>
</dependency>

<!-- 包含tomcat连接池、jdbcTemplate -->
<dependency>
<groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
 <groupId>commons-dbcp</groupId>
 <artifactId>commons-dbcp</artifactId>
</dependency>

<dependency>
 <groupId>com.oracle</groupId>
 <artifactId>ojdbc6</artifactId>
 <version>11.2.0.3</version>
</dependency>

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

</dependencies>
  

</project>

2.编写实体类

import java.io.Serializable;
import java.sql.Date;


public class Emp implements Serializable{

private int empno;
private String ename;
private int mgr;
private String job;
private Date hiredate;
private Double comm;
private Double sal;
private int deptno;
public int getEmpno() {
return empno;
}
public void setEmpno(int empno) {
this.empno = empno;
}
public String getEname() {
return ename;
}
public void setEname(String ename) {
this.ename = ename;
}
public int getMgr() {
return mgr;
}
public void setMgr(int mgr) {
this.mgr = mgr;
}
public String getJob() {
return job;
}
public void setJob(String job) {
this.job = job;
}
public Date getHiredate() {
return hiredate;
}
public void setHiredate(Date hiredate) {
this.hiredate = hiredate;
}
public Double getComm() {
return comm;
}
public void setComm(Double comm) {
this.comm = comm;
}
public Double getSal() {
return sal;
}
public void setSal(Double sal) {
this.sal = sal;
}
public int getDeptno() {
return deptno;
}
public void setDeptno(int deptno) {
this.deptno = deptno;
}


}

3.编写sql文件

<?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.xdl.mapper.EmpDao">

    <select id="findAll" resultType="cn.xdl.entity.Emp">
        select * from emp
    </select>

</mapper>

4.编写Mapper映射器接口

import java.util.List;

import cn.xdl.entity.Emp;

public interface EmpDao {

    public List<Emp> findAll();

}

5.启动类

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;


//@SpringBootApplication
@Configuration
@ComponentScan
@EnableAutoConfiguration
//@EnableConfigurationProperties
@MapperScan(basePackages={"cn.xdl.mapper"})//扫描Mapper映射器接口生成对象
public class MyBootApplication {

}

6.配置文件

spring.datasource.username=scott
spring.datasource.password=tiger
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.driverClassName=oracle.jdbc.OracleDriver

#mybatis
mybatis.mapper-locations=classpath:sql/*.xml