Spring boot连接MYSQL–详细（小白向）

本文参考了：【https://blog.csdn.net/zeng_ll/article/details/87715305?ops_request_misc=%25257B%252522request%25255Fid%252522%25253A%252522160807774219724847186389%252522%25252C%252522scm%252522%25253A%25252220140713.130102334…%252522%25257D&request_id=160807774219724847186389&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_alltop_click~default-1-87715305.first_rank_v2_pc_rank_v29&utm_term=springboot%E8%BF%9E%E6%8E%A5%E6%95%B0%E6%8D%AE%E5%BA%93】

1、新建项目

新建项目主要要注意导入依赖

2、运行

直接运行通常会报错

我们需要在配置文件中加入必要的配置

3、这里使用application.yml添加数据库相关配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/php?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8
    username: root
    password: dyj  #数据库名、用户名和密码改为自己的
    driver-class-name: com.mysql.cj.jdbc.Driver

4、加了配置文件运行还是会报错，我们还需要写一个controller类

向TestController.java添加如下代码

package com.msc.controller;//记得改包路径


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

@RestController
public class TestController {
    @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( );
            if(entries != null) {
                Iterator<Map.Entry<String, Object>> iterator = entries.iterator( );
                while(iterator.hasNext( )) {
                    Map.Entry<String, Object> entry =(Map.Entry<String, Object>) iterator.next( );
                    Object key = entry.getKey( );
                    Object value = entry.getValue();
                    System.out.println(key+":"+value);
                }
            }
        }
        return list;
    }
}

5、然后！！在pom.xml中加入

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>

不然会报如下错误

6、最后运行

这样就成功启动服务器了

在地址栏输入

http://localhost:8080/getUsers
http://localhost:端口号+路径