CAS-数据库维护注册客户端信息

1. 先引入所需依赖，如下：

 implementation "org.apereo.cas:cas-server-support-jdbc-drivers:${project.'cas.version'}"
 implementation "org.apereo.cas:cas-server-support-jpa-service-registry:${project.'cas.version'}"
 implementation "mysql:mysql-connector-java:5.1.46"
 implementation "org.apereo.cas:cas-server-support-jdbc:${project.'cas.version'}"

2.新增cas数据库，接着修改application.yml配置文件，增加如下属性：

cas:
  service-registry:
    jpa:
      user: root
      password: 111
      driver-class: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/cas?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
      dialect: org.hibernate.dialect.MySQL5Dialect
      ddl-auto: update

ddl-auto: update直接写成update，不交给jpa来建表了，建表语句脚本如下：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Registered_Services
-- ----------------------------
DROP TABLE IF EXISTS `Registered_Services`;
CREATE TABLE `Registered_Services` (
  `id` bigint NOT NULL,
  `body` varchar(8000) NOT NULL,
  `evaluation_Order` int NOT NULL,
  `evaluation_Priority` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `service_Id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

SET FOREIGN_KEY_CHECKS = 1;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for service_sequence
-- ----------------------------
DROP TABLE IF EXISTS `service_sequence`;
CREATE TABLE `service_sequence` (
  `next_val` bigint DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of service_sequence
-- ----------------------------
BEGIN;
INSERT INTO `service_sequence` VALUES (1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

3.在表里新增两条注册客户端数据，由于cas服务端会定时拉取注册客户端数据，观察cas服务端日志，会发现如下信息：

说明通过客户端信息注册成功。

这篇好文章是转载于：学新通技术网