springboot如何对本地数据库增删改查_SpringBoot使用JDBC实现增删改查

一、项目分层

二、连接数据库

步骤一、引入连接数据库的相关依赖

org.springframework.boot

spring-boot-starter-jdbc

com.alibaba

druid

1.1.14

mysql

mysql-connector-java

8.0.15

org.projectlombok

lombok

1.18.6

provided

步骤二、配置数据库连接池相关信息

步骤三、初始化数据库连接

@Configuration

@PropertySource(value = "classpath:application.properties")

public class DataSourceConfiguration {

@Bean(destroyMethod = "close", initMethod = "init")

@ConfigurationProperties(prefix = "spring.datasource")

public DataSource druidDataSource() {

DruidDataSource druidDataSource = new DruidDataSource();

return druidDataSource;

}

}