数据库只能有一个自增字段的解决方式- Mybatis

废话不多说，直接上代码
 

需要在对应字段加上

@TableField(fill = FieldFill.INSERT)

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import com.chongyejia.supplychain.mapper.FactoryRecommendedMapper;
import jakarta.annotation.Resource;
import org.apache.ibatis.binding.MapperProxy;
import org.apache.ibatis.binding.MapperRegistry;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.defaults.DefaultSqlSession;
import org.apache.ibatis.session.defaults.DefaultSqlSessionFactory;
import org.springframework.context.annotation.Lazy;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;

@Component
public class MyBatisPlusMetaObjectHandler implements MetaObjectHandler {

@Resource
private JdbcTemplate jdbcTemplate;

@Override
public void insertFill(MetaObject metaObject) {
// 如果字段是sort则插入最大值
if (metaObject.hasGetter("sort")) {
TableInfo tableInfo = findTableInfo(metaObject);
String query = "SELECT COALESCE(MAX(sort), 0) FROM "+ tableInfo.getTableName();
Integer maxValue = jdbcTemplate.queryForObject(query, Integer.class);
this.strictInsertFill(metaObject, "sort", Integer.class, maxValue + 1);
}
}

}