java oauth2.0单点登录_Oauth2.0 实现SSO单点登陆

简介

首先声明本文章是在不要乱摸基础上进行部分修改，思路和核心代码未做调整，写本片文章主要是为了加深自己的单点登陆的印象，巩固自己小小的知识面，所以将实现的过程记录下来。话不多说，一个字：干

服务架构

image.png

authentication-center 授权服务

oauth2-sso-client-member 用户管理服务

oauth2-sso-client-order 订单服务

数据库

/*

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for oauth_client_details

-- ----------------------------

DROP TABLE IF EXISTS `oauth_client_details`;

CREATE TABLE `oauth_client_details` (

`client_id` varchar(256) CHARACTER SET utf8 NOT NULL,

`resource_ids` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`client_secret` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`scope` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`authorized_grant_types` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`web_server_redirect_uri` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`authorities` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

`access_token_validity` int(11) DEFAULT NULL,

`refresh_token_validity` int(11) DEFAULT NULL,

`additional_information` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,

`autoapprove` varchar(256) CHARACTER SET utf8 DEFAULT NULL,

PRIMARY KEY (`client_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------

-- Records of oauth_client_details

-- ----------------------------

BEGIN;

INSERT INTO `oauth_client_details` VALUES ('OrderManagement', NULL, '$2a$10$8yVwRGY6zB8wv5o0kRgD0ep/HVcvtSZUZsYu/586Egxc1hv3cI9Q6', 'all', 'authorization_code,refresh_token', 'http://localhost:8083/orderSystem/login', NULL, 7200, NULL, NULL, 'true');

INSERT INTO `oauth_client_details` VALUES ('UserManagement', NULL, '$2a$10$ZRmPFVgE6o2aoaK6hv49pOt5BZIKBDLywCaFkuAs6zYmRkpKHgyuO', 'all', 'authorization_code,refresh_token', 'http://localhost:8082/memberSystem/login', NULL, 7200, NULL, NULL, 'true');

COMMIT;

-- ----------------------------

-- Table structure for sys_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_permission`;

CREATE TABLE `sys_permission` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`pid` int(11) DEFAULT '0' COMMENT '父ID',

`type` tinyint(4) NOT NULL COMMENT '资源类型(1：菜单，2：按钮，3：操作)',

`name` varchar(64) CHARACTER SET latin1 NOT NULL COMMENT '资源名称',

`code` varchar(64) CHARACTER SET latin1 NOT NULL COMMENT '资源标识(或者叫权限字符串)',

`uri` varchar(64) CHARACTER SET latin1 DEFAULT NULL COMMENT '资源URI',

`seq` int(11) DEFAULT '1' COMMENT '序号',

`create_user` varchar(64) CHARACTER SET latin1 DEFAULT NULL,

`create_time` datetime DEFAULT NULL,

`update_user` varchar(64) CHARACTER SET latin1 DEFAULT NULL,

`update_time` datetime DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `code` (`code`),

KEY `idx_type` (`type`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------

-- Records of sys_permission

-- ----------------------------

BEGIN;

INSERT INTO `sys_permission` VALUES (1, 0, 3, 'add', 'member:add', '/member/add', 1, 'system', '2019-03-03 18:50:17', 'system', '2019-03-03 18:50:20');

COMMIT;

-- ----------------------------

-- Table structure for sys_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`role_name` varchar(32) NOT NULL COMMENT '角色名称',

`role_code` varchar(32) NOT NULL,

`role_description` varchar(64) DEFAULT NULL COMMENT '角色描述',

`create_user` varchar(64) DEFAULT NULL,

`create_time` datetime DEFAULT CURRENT_TIMESTAMP,

`update_user` varchar(64) DEFAULT NULL,

`update_time` datetime DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------

-- Records of sys_role

-- ----------------------------

BEGIN;

INSERT INTO `sys_role` VALUES (1, '员工', 'normal', '普通员工', 'system', '2019-02-12 11:14:41', NULL, NULL);

INSERT INTO `sys_role` VALUES (2, '部门经理', 'manager', '部门经理', 'system', '2019-02-12 11:15:37', NULL, NULL);

INSERT INTO `sys_role` VALUES (3, '客服', 'kefu', '客服', 'system', '2019-02-12 11:16:27', NULL, NULL);

COMMIT;

-- ----------------------------

-- Table structure for sys_role_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_permission`;

CREATE TABLE `sys_role_permission` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`role_id` int(11) NOT NULL COMMENT '角色ID',

`permission_id` int(11) NOT NULL COMMENT '权限ID',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------

-- Records of sys_role_permission

-- ----------------------------

BEGIN;

INSERT INTO `sys_role_permission` VALUES (1, 2, 1);

COMMIT;

-- ----------------------------

-- Table structure for sys_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(64) NOT NULL COMMENT '账号