整合Junit
1.导入测试对应的starter
2.测试类使用@SpringBootTest修饰
3.使用自动装配的形式添加要测试的对象
@Repository
public class BookDaoImpl implements BookDao {
@Override
public void save() {
System.out.println("BookDao is running...");
}
}
@SpringBootTest
class SpringbootJnuitApplicationTests {
//1.注入要测试的对象
@Autowired
private BookDao bookDao;
@Test
void contextLoads() {
//2.执行要测试的方法
bookDao.save();
}
}
整合MyBatis
1.勾选MyBatis技术,也就是导入MyBatis对应的starter
2.数据库连接相关信息转换成配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?serverTimeZone=UTC
username: root
password: 123
一些小问题:
1.MySQL8.X驱动强制要求设置时区
●修改url, 添加serverTimezone设定
●修改MySQL数据库配置 (略)
2.驱动类过时, 提醒更换为com.mysql.cj.jdbc.Driver
3.如driver-class-name: com.mysql.cj.jdbc.Driver中的mysql.jdbc报红,则将porm.xml文件中的
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<scope>runtime</scope>
删掉
3.数据库SQL映射需要添加@Mapper被容器识别到
@Mapper
@Repository
public interface BookDao {
@Select("select * from book where id = #{id}")
public Book findById(Integer id);
}
整合MyBatis-Plus
1.手工添加MyBatis-Plus对应的starter
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
2.数据层接口使用BaseMapper简化开发
@Mapper
@Repository
public interface BookDao extends BaseMapper<Book> {
}
3.需要使用的第三方技术无法通过勾选确定时,需要手工添加坐标(或者用阿里云的网址新建项目,里面有MyBatis-Plus选项)
整合Druid
1.整合Druid需要导入Druid对应的starter
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.6</version>
</dependency>
2.根据Druid提供的配置方式进行配置
#spring:
# datasource:
# driver-class-name: com.mysql.cj.jdbc.Driver
# url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
# username: root
# password: 123
spring:
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
username: root
password: 123
整合第三方技术通用方式
●导入对应的starter
●根据提供的配置格式, 配置非默认值对应的配置项