spring boot配置mysql

编程知识更新时间:2023-04-05 03:08:47

spring boot通过简单的配置就可以连接mysql，并且可以创建默认的连接池HikariDataSource，下面我们来看一看如何配置mysql

添加maven依赖，代码如下

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

修改application.properties配置文件，添加如下代码

spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

添加测试代码，在启动方法中添加如下代码，用JdbcTemplate操作数据库

@SpringBootApplication
public class SpringBootMysqlApplication {
        public static void main(String[] args) {
        ConfigurableApplicationContext context =
                SpringApplication.run(SpringBootMysqlApplication.class, args);
        JdbcTemplate jdbcTemplate = context.getBean(JdbcTemplate.class);
        List<Map<String, Object>> result =
                jdbcTemplate.queryForList("SELECT * FROM USER");
        System.out.println(result);
         }

}