详解SpringBoot工程集成全局唯一ID生成器UidGenerator的操作步骤

  
    org.springframework.boot
    spring-boot-starter-web
  
  
    org.springframework.boot
    spring-boot-starter-test
    test
  
  
    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    1.3.2
  
  
  
    mysql
    mysql-connector-java
    runtime
    8.0.12
  
  
  
    com.alibaba
    druid-spring-boot-starter
    1.1.9
  
  
  
    cn.codesheep
    uid-generator
    1.0
  

server.port=9999
spring.datasource.url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/xxx&＃63;useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=xxx
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis.mapper-locatiOns=classpath:mapper/*.xml
mybatis.configuration.map-underscore-to-camel-case=true

DROP TABLE IF EXISTS WORKER_NODE;
CREATE TABLE WORKER_NODE
(
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
HOST_NAME VARCHAR(64) NOT NULL COMMENT 'host name',
PORT VARCHAR(64) NOT NULL COMMENT 'port',
TYPE INT NOT NULL COMMENT 'node type: ACTUAL or CONTAINER',
LAUNCH_DATE DATE NOT NULL COMMENT 'launch date',
MODIFIED TIMESTAMP NOT NULL COMMENT 'modified time',
CREATED TIMESTAMP NOT NULL COMMENT 'created time',
PRIMARY KEY(ID)
)
 COMMENT='DB WorkerID Assigner for UID Generator',ENGINE = INNODB;

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>

 
 
 
 
 
  
 
  
 
 
 
 
  
 
 
 
  
 
 
 
  
 
 
 
  
 
 

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 
 
 
 
 
 
 
 
 
 INSERT INTO WORKER_NODE
 (HOST_NAME,
 PORT,
 TYPE,
 LAUNCH_DATE,
 MODIFIED,
 CREATED)
 VALUES (
 #{hostName},
 #{port},
 #{type},
 #{launchDate},
 NOW(),
 NOW())
 
 
 SELECT
 ID,
 HOST_NAME,
 PORT,
 TYPE,
 LAUNCH_DATE,
 MODIFIED,
 CREATED
 FROM
 WORKER_NODE
 WHERE
 HOST_NAME = #{host} AND PORT = #{port}
 

@Configuration
@ImportResource(locatiOns= { "classpath:uid/cached-uid-spring.xml" })
public class UidConfig {
}

@Service
public class UidGenService {

  @Resource
  private UidGenerator uidGenerator;

  public long getUid() {
    return uidGenerator.getUID();
  }
}

@RestController
public class UidTestController {

  @Autowired
  private UidGenService uidGenService;

  @GetMapping("/testuid")
  public String test() {
    return String.valueOf( uidGenService.getUid() );
  }
}