0x00 配置application.properties

mysql默认SSL登录，使用useSSL=false可忽略。
直接连接到数据库member时，jdbc:mysql://127.0.0.1:3306/member?useSSL=false

spring.datasource.url=jdbc:mysql://127.0.0.1:3306?useSSL=false
spring.datasource.username=root
spring.datasource.password=pwd
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

0x01 添加依赖pom.xml

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

0x02 数据库增删改查

    @Autowired
    private JdbcTemplate jdbcTemplate;
    // ...
    List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);