本文将从整合JDBC讲起,然后整合mybatis,其中会穿插一些druid的知识。
首先需要引入以下依赖。
一、整合JDBC
<!--引入web的启动器-->
<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>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
配置yml文件:
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
由于数据库驱动为8点几,所以需要引入时区!
在test类中进行测试:
@Autowired
private DataSource dataSource;
@Test
void contextLoads() throws SQLException {
// System.out.println(dataSource.getConnection());
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
String sql = "select * from mybatis.user";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
System.out.println(resultSet.getInt("id"));
System.out.println(resultSet.getString("name"));
}
在此处,数据库如下(作为测试,数据库可以随意建立):