06-SpringBoot集成JdbcTemplate

1、创建SpringBoot项目

 

2、添加依赖

        <!-- jdbcTemplate依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!-- mysql依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

 

3、配置文件

application.properties文件

spring.datasource.url=jdbc:mysql://localhost:3306/test01?characterEncoding=UTF-8&serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

一定要在spring.datasource.url属性值的后面跟上

?characterEncoding=UTF-8&serverTimezone=GMT

不然会报错

解释：这是由于数据库和JDBC所在的系统时差引起，在jdbc连接的url后面加上参数serverTimezone=UTC或者serverTimezone=GMT可解决问题，如果使用gmt+8时区，需要对gmt+8转码，写成CTT或者GMT%2B8。

java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

 

4、建表语句

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

 

5、创建UserService，注入JdbcTemplate，写一个添加方法

@Service
public class UserService {

    @Autowired
    private JdbcTemplate jdbcTemplate;//注入JdbcTemplate

    public String addUser(String name,Integer age){
        jdbcTemplate.update("insert  into user (name,age) values (?,?)",name,age);
        return "success";
    }
}

 

6、创建UserController，写一个添加方法

@RestController
public class UserController {

    @Autowired
    private  UserService userService;

    @RequestMapping(value = "/addUser")
    public String addUser(String name, Integer age){
        return userService.addUser(name,age);
    }
}

 

7、启动项目，访问测试