<dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
 <groupId>org.mybatis.spring.boot</groupId>
 <artifactId>mybatis-spring-boot-starter</artifactId>
 <version>2.1.1</version>
</dependency>

#dateSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
# mybatis
# 下劃線轉(zhuǎn)駝峰開(kāi)啟
mybatis.configuration.map-underscore-to-camel-case=true
# mapper掃描位置
mybatis.mapper-locations=classpath:mapper/*.xml

CREATE TABLE USER_INFO
(
 user_id DECIMAL(10) PRIMARY KEY NOT NULL,
 user_name VARCHAR(20) DEFAULT "" NOT NULL
);
CREATE UNIQUE INDEX USER_INFO_user_id_uindex ON USER_INFO (user_id);
ALTER TABLE USER_INFO COMMENT = '用戶基本信息表';

INSERT INTO test.user_info (user_id, user_name) VALUES (1, '特朗普');
INSERT INTO test.user_info (user_id, user_name) VALUES (2, '唐納德');

package com.example;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.dao")
public class DemoApplication {
 public static void main(String[] args) {
  SpringApplication.run(DemoApplication.class, args);
 }
}

package com.example.controller;
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.ResponseBody;
import com.example.service.IUserService;
@Controller
@RequestMapping("user")
public class UserController {
 @Autowired
 private IUserService userService;
 @RequestMapping("/queryUser")
 @ResponseBody
 void queryUser() {
  this.userService.queryUser();
 }
}

package com.example.service;

public interface IUserService {
 void queryUser();
}

package com.example.service;

import com.example.dao.UserDao;
import com.example.entity.UserEntity;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service("userService")
public class UserServiceIml implements IUserService {

 @Resource
 private UserDao userDao;

 @Override
 public void queryUser() {
  List<UserEntity> userList = this.userDao.queryUser();
  System.out.println("================");
  System.out.println(userList);
  System.out.println("================");
 }
}

package com.example.dao;
import com.example.entity.UserEntity;
import java.util.List;
public interface UserDao {
 List<UserEntity> queryUser();
}

package com.example.entity;
public class UserEntity {
 private long userId;
 private String userName;

 public long getUserId() {
  return userId;
 }

 public void setUserId(long userId) {
  this.userId = userId;
 }

 public String getUserName() {
  return userName;
 }
 public void setUserName(String userName) {
  this.userName = userName;
 }
 
 @Override
 public String toString() {
  return "UserEntity{" +
    "userId=" + userId +
    ", userName='" + userName + '\'' +
    '}';
 }
}

//http.authorizeRequests().antMatchers("/user/addUser").hasRole("AAA") 
http.authorizeRequests().antMatchers("/user/**").hasRole("AAA")