SpringBoot连接MySql数据库

找到一篇很靠谱的帖子先贴出来

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

主要几个步骤

1. 新建项目时添加依赖

   
   image.png
   

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

application.properties中的配置，driverClassName使用com.mysql.jdbc.Driver运行时报错了

#数据库相关配置
spring.datasource.url = jdbc:mysql://127.0.0.1:3306/数据库名?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.username = root
spring.datasource.password = 123
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

可以通过下面的方式测试，可以读取到数据

@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