Springboot各种集成

1.Springboot集成jdbc

1.1 引入Maven依赖-mysql，jdbc

<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
		</dependency>

1.2数据库信息配置

在application.properties文件中配置mysql连接配置文件
###datasource
properties方式

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test
spring.datasource.username = root
spring.datasource.password = root

Yaml 方式
spring:
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url : jdbc:mysql://localhost:3306/spring-boot-demo?useUnicode=true&characterEncoding=utf-8 
    username : root
    password : root

1.3 编写代码测试

Dao层

package cn.itsource.dao;

import cn.itsource.model.Dept;

import java.util.List;

public interface DeptDao {
   

    List<Dept>queryAll();
}

Impl层

package cn.itsource.dao;

import cn.itsource.model.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework