Question

jdbctemplate 怎么获取表的主键

Answer 1

[html] view plain copy print?
JSONObject obj = new JSONObject();
obj.put("code", transactionTemplate.execute(new TransactionCallback<Integer>() {
@Override
public Integer doInTransaction(TransactionStatus status) {
Object spt = status.createSavepoint();

try {

final String sql = "insert into article (title, content, source, keyword, intro,"
+ " type, author, recommend, headline,leaveNumber,clickNumber,userid,"
+ "createtime,updatetime,deploytime) values"
+ " (?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?) ";

KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(new Prepared