springBoot项目整合mybatis

一、添加依赖

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-parent</artifactId>
        <version>2.1.2.RELEASE</version>
    </parent>
    <dependencies>
        <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>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- druid连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.8</version>
        </dependency>
        <!-- 热部署 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
    </dependencies>
    <!-- 编译xml文件 -->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

二、创建Demo项目

@RestController
public class DeptController {

    @Autowired
    private DeptService deptService;

    @GetMapping("/getDept")
    public List<Dept> getDeptInfo(){
        return deptService.getDeptInfo();
    }
}

public interface DeptService {
    List<Dept> getDeptInfo();
}

@Service
public class DeptServiceImpl implements DeptService {

    @Autowired
    private DeptMapper deptMapper;

    @Override
    public List<Dept> getDeptInfo() {
        return deptMapper.getDeptInfo();
    }
}

@Mapper
public interface DeptMapper {
    List<Dept> getDeptInfo();
}

<mapper namespace="com.tedu.server.dao.DeptMapper">
    <select id="getDeptInfo" resultType="com.tedu.server.pojo.Dept">
        select * from dept
    </select>
</mapper>

三、添加配置文件

配置文件

spring:
  datasource:
    username: root
    password: root
    url:  jdbc:mysql://localhost:3306/mybatis
    driver‐class‐name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
mybatis:
  #mapper文件的映射
  mapper-locations: classpath:com/tedu/server/dao/mapper/*.xml
  #开启驼峰映射
  configuration:
    map-underscore-to-camel-case: true

其中数据库的用户名、密码、url可以先在idea中尝试一下，是否能连通

选择DataSource—>mysql

出现上图连接成功的字样，则表示连接没问题。（第一次连接时，会没有测试连接的按钮，需要在选择左侧红框，添加mysql的驱动）
driver‐class‐name驱动类的值，则可以在添加的驱动依赖包中进行查看

整个文件的目录结构如下：

启动类

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

启动main方法。
demo访问路径localhost:8080/getDept