happyCode(3) JdbcTemplate 访问 MySQL 8.0

test.sql

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `version` int(11) DEFAULT NULL COMMENT '版本',
  PRIMARY KEY (`id`)
);
insert into `test`(content) value("测试");

pom.xml

<dependency>
	  <groupId>org.springframework.boot</groupId>
	  <artifactId>spring-boot-starter-jdbc</artifactId>
	</dependency>
    <!-- MySQL驱动 -->
  	<dependency>
	  <groupId>mysql</groupId>
	  <artifactId>mysql-connector-java</artifactId>
	  <version>8.0.11</version><!--$NO-MVN-MAN-VER$-->
	</dependency>

application.yml

spring:
  http:
    encoding:
      force: true
      charset: UTF-8
  datasource:
      url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=GMT%2B8&amp&useSSL=false&allowPublicKeyRetrieval=true
      username: root
      password: 123456
      driver-class-name: com.mysql.cj.jdbc.Driver

TestController.java

package com.oo.test.controller;

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

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;

@Controller
public class TestController {
	@Autowired//自动装配
	JdbcTemplate jdbcTemplate;
	@RequestMapping("/selectTest")
	@ResponseBody
	public List<Map<String,Object>> queryTest() {
		/*
		String sql = "insert into test(content) values(?)";
		jdbcTemplate.update(sql,"测试");
		sql = "update test set content=? where id=?";
		jdbcTemplate.update(sql, "测试", 1);
		sql = "delete from test where id=?";
		jdbcTemplate.update(sql,1);
		*/
		return jdbcTemplate.queryForList("select * from test");
	}
}