找到一篇很靠譜的帖子先貼出來(lái)

https://blog.csdn.net/qq_44127187/article/details/111246064

主要幾個(gè)步驟

1. 新建項(xiàng)目時(shí)添加依賴

   
   
   image.png
   
   

   就是pom.xml里的這兩個(gè)，一定要導(dǎo)入

        <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中的配置，driverClassName使用com.mysql.jdbc.Driver運(yùn)行時(shí)報(bào)錯(cuò)了

#數(shù)據(jù)庫(kù)相關(guān)配置
spring.datasource.url = jdbc:mysql://127.0.0.1:3306/數(shù)據(jù)庫(kù)名?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.username = root
spring.datasource.password = 123
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

可以通過(guò)下面的方式測(cè)試，可以讀取到數(shù)據(jù)

@RestController
public class SQLTestController {


    @Autowired
    private JdbcTemplate jdbcTemplate;

    @RequestMapping("/getUsers")
    public List<Map<String, Object>> getDbType() {
        String sql = "select * from test";
        List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);
        for (Map<String, Object> map : list) {
            Set<Map.Entry<String, Object>> entries = map.entrySet();
            for (Map.Entry<String, Object> entry : entries) {
                Object key = entry.getKey();
                Object value = entry.getValue();
                System.out.println(key + ":" + value);
            }
        }
        return list;
    }
}

?
但是這樣的方式并不算容易，最方便的還是使用Mybatis