集成Mybatis
- 在pom.xml中添加MyBatis依赖
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
- application.yml 配置文件
spring:
datasource:
username: jjxd
password: root
url: jdbc:mysql://114.116.16.197:3306/jjxd?useUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
mapper-locations: classpath:mapper/*.xml
3. 相关目录文件
- User.java
- UserDao.java(提供一个接口,用于映射UserMapper.xml,实现访问数据库)
- UserService.java(提供一个Service接口,可不使用这种接口方式)
- UserServiceImpl.java(UserService接口的实现)
- UserMapper.xml(MyBatis数据库脚本执行文件)
- Controller.java文件
- 启动项目,请求localhost:8080/user?id=1,返回结果
Exception
-
Loading class com.mysql.jdbc.Driver. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
解决方式:将application.yml中的driver-class-name: com.mysql.jdbc.Driver
改为driver-class-name: com.mysql.cj.jdbc.Driver
-
运行项目,UserDao始终等于null
解决方式:在UserDao.java中加入@Component注解