mybatis-plus支持pgsql了
- GlobalConfig 配置 PostgreKeyGenerator
@Configuration
@EnableTransactionManagement
public class DataSourceConfig {
...
@Bean(name = "pgKeyGenerator")
public PostgreKeyGenerator postgreKeyGenerator() {
return new PostgreKeyGenerator();
}
@Bean(name = "dbConfig")
public GlobalConfig.DbConfig dbConfig() {
GlobalConfig.DbConfig dbConfig = new GlobalConfig.DbConfig();
dbConfig.setKeyGenerator(postgreKeyGenerator());
return dbConfig;
}
@Bean(name = "globalConfig")
public GlobalConfig globalConfig() {
GlobalConfig globalConfig = new GlobalConfig();
globalConfig.setDbConfig(dbConfig());
return globalConfig;
}
}
- 实体类添加注解
//配置序列
@KeySequence(value = "pm.ef_asset_temp_seq", clazz = Integer.class)
//表名
@TableName(value = "pm.ef_asset_temp")
public class EfAssetTemp implements Serializable {
private static final long serialVersionUID = -1330502357600191800L;
//注意,type 配置成IdType.INPUT !!!
@TableId(value = "id", type = IdType.INPUT)
private Integer id;
}
OK了