Spintboot项目如何引入mysql

环境：

        idea2023.1
        jdk1.8
        springboot2.7.6
        mysql5.7.26
        maven3.8.1

1、数据库准备好数据

2、引入依赖(pom.xml)

<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>

3、配置(application.yml)

#mysql
spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/cinema
    username: root
    password: root

4、编写测试类

package com.supreme.supreme_api.controller;


import com.supreme.supreme_api.SupremeApiApplication;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;
import java.util.Map;

@Controller
@RequestMapping("/test")
public class TestController {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    private static final Logger logger = Logger.getLogger(TestController.class);
    @GetMapping("/index")
    @ResponseBody
    public List<Map<String,Object>> test() {
        logger.info("DemoApplication start!!!");

        String sql = "select * from manager";
        List<Map<String,Object>> list = jdbcTemplate.queryForList(sql);
         return list;
    }
}

5、postman测试