controller缺少bean问题

Question

请教下，通过连接sql数据库，并将内容显示在网页上，比如：

这个是我的目录：

运行启动项是这样的错误：

helloController：

package example.springbootmysql05a;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

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

@Controller
public class helloController {

    @Autowired
    JdbcTemplate jdbcTemplate;
    @ResponseBody
    @RequestMapping("getList")
    public List<Map<String, Object>> getList(){

        return jdbcTemplate.queryForList("Select * from department");
    }
}

application.yml:

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 12345678
    url: jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC  #数据库路径
    schema:
      -classpath:people.sql

数据库中的表格people.sql:

create table people
(
    id int(2) not null,
    name varchar(10) null,
    constraint people_pk
        primary key (id)
)charset = utf8;
insert into people(id,name) values (1,'fe');
insert into people(id,name) values (2,'frg');

单元测试applicationtest：

package com.example.springbootmysql05a;

import org.junit.jupiter.api.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

@RunWith(SpringRunner.class)
@SpringBootTest
class SpringbootMysql05aApplicationTests {
    @Resource
    private DataSource dataSource;

    @Test
    public void teatJdbc() throws SQLException {
        Connection connection=dataSource.getConnection();
        System.out.println(connection.getClass());
        System.out.println(connection);//打印对象
        connection.close();//关闭对象
    }

}