使用 usingGeneratedKeyColumns遇到的问题

先记录一下。遇到要使用自动增长的序列时，添加数据可以先查询一下序列号，设置再插入

String s = "select nextval('seq_collection_0') ";
try {
int guid = getNamedParameterJdbcTemplate().queryForInt(s, Collections.EMPTY_MAP);
t.setGuid((long)guid);
Map<String, Object> paramMap = SCollectionRowMapper.putCollectionMap(t);
SimpleJdbcInsert simpleJdbcInsert = new SimpleJdbcInsert(getDataSource()).withTableName("s_collection_0")
.usingColumns("uid","type","remark","phone","parentid","name","luid","longitude","latitude","lasttime","guid",
"cityid","addtime","address");
return simpleJdbcInsert.execute(paramMap);
} catch (Exception e) {
return 0;
}