springboot整合mybatis+mysql
springboot集成mybatis主要需要注意的地方是加入maven依赖和配置文件中加入对mapper文件的引入。工程结构未变化,还是control、service、dao层。
Maven依赖
<!--mysql数据库连接-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<!--mybatis引入-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
SpringBoot配置文件application.yml
mybatis:
type-aliases-package: com.shushan.erp.entity
mapper-locations: classpath:mapper/*.xml
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/localpoidemo?useUnicode=true&characterEncoding=UTF-8
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
浏览器访问:http://localhost:8080/userHandle/findUserListByCode/1001
注:以上讲解详细springboot整合mybatis+mysql实列源码可以从下面地址下载:
https://github.com/shushan452/localRepository