Spring Cloud云架构 - commonservice-sso服务搭建（一）

前面几篇我们已经介绍了Spring Cloud和oauth2的知识点，今天我们要利用Spring Cloud和oauth2进行commonservice-sso服务搭建，本节我们只是搭建commonservice-sso的基础平台，闲话少说，直接将步骤记录下来：

1. 创建maven项目commonservice-sso，其中pom.xml文件配置如下：

<?xml version="1.0" encoding="UTF-8"?>    
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">    
    <modelVersion>4.0.0</modelVersion>    
        
    <parent>    
        <groupId>com.ml.honghu</groupId>    
        <artifactId>commonservice</artifactId>    
        <version>0.0.1-SNAPSHOT</version>    
    </parent>    
    
    <artifactId>commonservice-sso</artifactId>    
    <packaging>jar</packaging>    
    
    <dependencies>    
        <dependency>    
            <groupId>org.springframework.cloud</groupId>    
            <artifactId>spring-cloud-starter-eureka</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.cloud</groupId>    
            <artifactId>spring-cloud-starter-config</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-actuator</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-data-rest</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-web</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-security</artifactId>    
        </dependency>    
    
        <dependency>    
            <groupId>org.springframework.security.oauth</groupId>    
            <artifactId>spring-security-oauth2</artifactId>    
        </dependency>    
    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-test</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.hateoas</groupId>    
            <artifactId>spring-hateoas</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-data-rest</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>com.ml.honghu.common.framework</groupId>    
            <artifactId>common-framework-dao</artifactId>    
            <version>1.0.0-SNAPSHOT</version>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-web</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>org.springframework.boot</groupId>    
            <artifactId>spring-boot-starter-freemarker</artifactId>    
        </dependency>    
        <dependency>    
            <groupId>com.ml.honghu</groupId>    
            <artifactId>component-base</artifactId>    
        </dependency>    
        </dependency>    
    </dependencies>    
    
    <!-- 打包插件，其中repackage、true是专门打spring boot专用包 -->    
    <build>    
        <plugins>    
            <plugin>    
                <groupId>org.springframework.boot</groupId>    
                <artifactId>spring-boot-maven-plugin</artifactId>    
                <executions>    
                    <execution>    
                        <id>1</id>    
                        <goals>    
                            <goal>repackage</goal>    
                        </goals>    
                    </execution>    
                    <execution>    
                        <id>2</id>    
                        <goals>    
                            <goal>build-info</goal>    
                        </goals>    
                    </execution>    
                </executions>    
            </plugin>    
        </plugins>    
    </build>    
</project>    

spring:    
  application:    
    name: commonservice-sso    
  profiles:     
    active: dev,discoveryClient    
  cloud:    
    config:    
      discovery:     
        enabled: true    
        service-id: commonservice-config-server    
eureka:     
  client:    
    service-url:    
      defaultZone: http://honghu:123456@localhost:8761/eureka    
  instance:    
    prefer-ip-address: true    

package com.ml.honghu;    
    
import org.springframework.boot.SpringApplication;    
import org.springframework.boot.autoconfigure.SpringBootApplication;    
import org.springframework.cloud.netflix.eureka.EnableEurekaClient;    
    
@SpringBootApplication    
@EnableEurekaClient    
public class SSOApplication {    
    public static void main(String[] args) {    
        SpringApplication.run(SSOApplication.class, args);    
    }    
}    

/*  
Navicat MySQL Data Transfer  
  
Source Server         : localhost  
Source Server Version : 50621  
Source Host           : localhost:3306  
Source Database       : honghu  
  
Target Server Type    : MYSQL  
Target Server Version : 50621  
File Encoding         : 65001  
  
Date: 2017-10-26 20:12:56  
*/    
    
SET FOREIGN_KEY_CHECKS=0;    
    
-- ----------------------------    
-- Table structure for `oauth_access_token`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_access_token`;    
CREATE TABLE `oauth_access_token` (    
  `token_id` varchar(256) DEFAULT NULL,    
  `token` blob,    
  `authentication_id` varchar(128) NOT NULL,    
  `user_name` varchar(256) DEFAULT NULL,    
  `client_id` varchar(256) DEFAULT NULL,    
  `authentication` blob,    
  `refresh_token` varchar(256) DEFAULT NULL,    
  PRIMARY KEY (`authentication_id`)    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;    
    
    
-- ----------------------------    
-- Table structure for `oauth_approvals`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_approvals`;    
CREATE TABLE `oauth_approvals` (    
  `userId` varchar(256) DEFAULT NULL,    
  `clientId` varchar(256) DEFAULT NULL,    
  `scope` varchar(256) DEFAULT NULL,    
  `status` varchar(10) DEFAULT NULL,    
  `expiresAt` datetime DEFAULT NULL,    
  `lastModifiedAt` datetime DEFAULT NULL    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;    
    
-- ----------------------------    
-- Records of oauth_approvals    
-- ----------------------------    
    
-- ----------------------------    
-- Table structure for `oauth_client_details`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_client_details`;    
CREATE TABLE `oauth_client_details` (    
  `client_id` varchar(128) NOT NULL,    
  `resource_ids` varchar(256) DEFAULT NULL,    
  `client_secret` varchar(256) DEFAULT NULL,    
  `scope` varchar(256) DEFAULT NULL,    
  `authorized_grant_types` varchar(256) DEFAULT NULL,    
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,    
  `authorities` varchar(256) DEFAULT NULL,    
  `access_token_validity` int(11) DEFAULT NULL,    
  `refresh_token_validity` int(11) DEFAULT NULL,    
  `additional_information` varchar(4096) DEFAULT NULL,    
  `autoapprove` varchar(256) DEFAULT NULL,    
  PRIMARY KEY (`client_id`)    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;    
    
    
-- ----------------------------    
-- Table structure for `oauth_client_token`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_client_token`;    
CREATE TABLE `oauth_client_token` (    
  `token_id` varchar(256) DEFAULT NULL,    
  `token` blob,    
  `authentication_id` varchar(128) NOT NULL,    
  `user_name` varchar(256) DEFAULT NULL,    
  `client_id` varchar(256) DEFAULT NULL,    
  PRIMARY KEY (`authentication_id`)    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;    
    
-- ----------------------------    
-- Records of oauth_client_token    
-- ----------------------------    
    
-- ----------------------------    
-- Table structure for `oauth_code`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_code`;    
CREATE TABLE `oauth_code` (    
  `code` varchar(256) DEFAULT NULL,    
  `authentication` blob    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;    
    
-- ----------------------------    
-- Records of oauth_code    
-- ----------------------------    
    
-- ----------------------------    
-- Table structure for `oauth_refresh_token`    
-- ----------------------------    
DROP TABLE IF EXISTS `oauth_refresh_token`;    
CREATE TABLE `oauth_refresh_token` (    
  `token_id` varchar(256) DEFAULT NULL,    
  `token` blob,    
  `authentication` blob    
) ENGINE=InnoDB DEFAULT CHARSET=utf8;