public Emp create(final Emp emp){
final String sql = "insert into Emp (age,name)values(?,?)";
KeyHolder holder = new GeneratedKeyHolder();
jdbc.update(new PreparedStatementCreator() {
@Override
public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
ps.setInt(1, emp.getAge());
ps.setString(2, emp.getName());
return ps;
}
},holder);
int newEmpId= holder.getKey().intValue();
emp.setId(newEmpId);
return emp;
}