boot_auth_api

说明

建库建表语句，新增机顶盒信息表

CREATE DATABASE IF NOT EXISTS migu_aaa default character set utf8 COLLATE utf8_general_ci;
DROP TABLE IF EXISTS migu_aaa.`stb_info`;
CREATE TABLE migu_aaa.`stb_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `stbID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机顶盒ID',
  `provinceID` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '省份ID',
  `cityCode` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地市代码',
  `mac` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机顶盒MAC地址',
  `loginType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分配牌照方ID',
  `timestamp` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '20120205144102（yyyyMMddHHmmss）',
  `stbtype` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '01：个人;02：集团',
  `eccode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '集团客户编码',
  `groupcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分组编码',
  `detailParam` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '扩展属性,xml格式',
  `updateTime` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unique_index`(`stbID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SF-12_IF-01申请备案许可ID/api/getLoginID
SF-12_IF-02备案许可ID查询/api/querytLoginID

调用协议：http post xml，详情请参考需求及接口文档：咪咕视讯AAA双认证接口开发需求

部署方式同其他spring boot应用
配置文件application.yml说明

server:
  port: 8080 #暴露的端口号
  undertow:
    worker-threads: 32 # 阻塞任务线程池,它的值设置取决于系统线程执行任务的阻塞系数，默认值是IO线程数*8
    io-threads: 4 # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程
    buffer-size: 1024 # 每块buffer的空间大小,越小的空间被利用越充分，不要设置太大
    direct-buffers: true # 是否分配的直接内存(NIO直接分配的堆外内存)
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver #mysql驱动，不需要修改
    password: Guttv@1234ABCxyz! #数据库密码
    url: jdbc:mysql://dev-db-01:3306/migu_aaa?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull #url
    username: root # 数据库用户名
mybatis:
  mapperLocations: classpath:/mapper/**Mapper.xml #mapper文件路径，不需要修改
  typeAliasesPackage: com.guttv.bean #包别名映射，不需要修改
logging:
  config: classpath:logback-spring.xml #指定日志配置文件，一般情况下不需要修改
log: 
  path: /var/guttv/logs #日志目录
  level: debug #日志级别，debug可以打印执行的sql语句