CREATE

内置实现类缺少mysql因为mysql不支持序列只能通过表模拟序列

H2KeyGenerator

com.yl.mybatisplus.plugin;import

com.baomidou.mybatisplus.core.incrementer.IKeyGenerator;

import

com.yl.mybatisplus.mp.entity.DualSequence;

import

com.yl.mybatisplus.mp.mapper.DualSequenceMapper;

import

org.springframework.beans.factory.annotation.Autowired;

import

org.springframework.stereotype.Component;Component

public

保证查询的是最新的如果更新失败再次获取最新的DualSequence

dualSequence

dualNextMapper.selectById(next.dbid);Long

startValue

dualSequence.getStartValue();int

number

dualNextMapper.updateById(dualSequence);//如果更新失败再次执行查询获取最新的if

(number

executeSql(incrementerName);}//更新后的是最新的起始值作为idreturn

String.valueOf(startValuedualSequence.getStep());}

}其他类

com.yl.mybatisplus.mp.entity;import

lombok.Data;/***

com.yl.mybatisplus.mp.mapper;import

com.baomidou.mybatisplus.core.mapper.BaseMapper;

import

com.yl.mybatisplus.mp.entity.DualSequence;

import

org.apache.ibatis.annotations.Mapper;

import

org.apache.ibatis.annotations.Select;

import

org.apache.ibatis.annotations.Update;/***

临时序列表

com.yl.mybatisplus.mp.controller;import

com.yl.mybatisplus.plugin.MysqlKeyGenerator;

import

org.springframework.beans.factory.annotation.Autowired;

import

org.springframework.web.bind.annotation.GetMapping;

import

org.springframework.web.bind.annotation.RequestMapping;

import

org.springframework.web.bind.annotation.RestController;/***

临时序列**

mysqlKeyGenerator;GetMapping(/nextId)public

String

mysqlKeyGenerator.executeSql(null);}}