一、环境搭建
1、创建项目时勾选上mybatis framework和mysql driver。
2、在resources目录下创建application.yml配置文件。
# application.yml的内容
spring:
datasource:
url: jdbc:mysql:///books?useSSL=false&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
二、测试配置
1、创建Book实体类,这里get/set/toString方式省略(数据库对应的SQL创建表的语句省略了)。
public class Book {
private Integer id;
private String name;
}
2、创建BookDao
接口上面一定要加上@Mapper(org.apache.ibatis.annotations.Mapper的),否则会报错
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import xin.students.domain.Book;
@Mapper
public interface BookDao {
@Select("select * from book where id = #{id};")
public Book find(Integer id);
}
3、编写测试类
@SpringBootTest
class SpringbootMybatisApplicationTests {
@Autowired
BookDao bookDao;
@Test
void contextLoads() {
System.out.println(bookDao.find(1));
}
}
4、测试结果
更换数据库连接池(druid)
1、添加依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
2、使用数据库连接池
spring:
datasource:
url: jdbc:mysql:///books?useSSL=false&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
type: com.alibaba.druid.pool.DruidDataSource