1、创建数据库表(测试用)
CREATE TABLE `t_post_id_2` (
`sequence_id` varchar(24) NOT NULL COMMENT 'Sequence名称',
PRIMARY KEY (`sequence_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
2、配置spring(多表序列)
3、在类中使用(注意要使用Resource指定注入)
@Resource(name="incre1")
private DataFieldMaxValueIncrementer unitIniIncre1;
@Resource(name="incre2")
private DataFieldMaxValueIncrementer unitIniIncre2;
//获取自动生成主键id
@Override
public Map getSequence() {
Map map = new HashMap();
try {
String sequenceStr1 = unitIniIncre1.nextStringValue();
map.put("String", sequenceStr1);
String sequenceStr2 = unitIniIncre2.nextStringValue();
map.put("String2", sequenceStr2);
} catch (DataAccessException e) {
e.printStackTrace();
map.put("succ", "获取失败!");
}
return map;
}
5、成功获取
{"String":"10084","String2":"10004"}