spring-boot mysql8+mybatis+druid

pom.xml添加依赖

        <!--Mysql8+Mybatis+Druid-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.12</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

application.yml配置：

spring:
  datasource:
    #一定要设置时区 serverTimezone=UTC
    url: jdbc:mysql://IP:端口/数据库?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
    username: 用户名
    password: 密码
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    filters: stat
    druid:
      initial-size: 3
      min-idle: 1
      max-active: 5
      test-on-borrow: true
      stat-view-servlet:
        allow: true
#Mybatis
mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml        

user.java

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/**
 * 这里使用了lombok如果没下插件的话就取消掉这些注解 添加对应get,set方法
 */

@NoArgsConstructor
@AllArgsConstructor
@Data
@Builder
public class User implements Serializable {
    private static final long serialVersionUID = -7047644056790812191L;

    /**
     * 用户帐号
     */
    private String userId;

    /**
     * 用户密码
     */
    private String userPassword;

    /**
     * 用户名称
     */
    private String userName;
}

UserController.java

import java.util.Map;

import org.apache.commons.collections4.MapUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.whz.cloud.disk.business.service.UserService;
import com.whz.cloud.disk.entity.User;

import lombok.extern.slf4j.Slf4j;

@Controller
@RequestMapping("/user")
@Slf4j
public class UserController {
    @Autowired
    private UserService userService;


    /**
     * 用户注册
     *
     * @param parame  userId 用户名  userName用户姓名 userPassword用户密码
     */
    @RequestMapping(value = "/regUser")
    @ResponseBody
    public void regUser(@RequestParam Map<String, String> parame) {
        String userId = MapUtils.getString(parame, "userId");
        String userName = MapUtils.getString(parame, "userName");
        String userPassword = MapUtils.getString(parame, "userPassword");
        //这里是用的lombok插件
        User user = new User().builder().userId(userId).userName(userName).userPassword(userPassword).build();
        //用户注册
        int rows = userService.regUser(user);
    }
}

UserService.java

package com.whz.cloud.disk.business.service;

import com.whz.cloud.disk.business.dao.UserDao;
import com.whz.cloud.disk.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService {
    @Autowired
    private UserDao userDao;

    public int regUser(User user) {
        return userDao.regUser(user);
    }
}

UserDao.java

import com.whz.cloud.disk.entity.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserDao {
    /**
     * 用户注册
     * @param user 用户账户信息
     * @return 1成功 0失败
     */
    int regUser(User user);
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.whz.cloud.disk.business.dao.UserDao" >

    <!--用户注册-->
    <insert id="regUser" parameterType="com.whz.cloud.disk.entity.User" >
        INSERT INTO USER_ACCOUNT (USER_ID,USER_PASSWORD,USER_NAME) VALUES (#{userId},#{userPassword},#{userName})
    </insert>
</mapper>

数据表结构:

CREATE TABLE `USER_ACCOUNT` (
  `USER_ID` varchar(18) NOT NULL,
  `USER_PASSWORD` varchar(18) DEFAULT NULL,
  `USER_NAME` varchar(18) DEFAULT NULL,
  PRIMARY KEY (`USER_ID`)
)