jdbcTemplate 插入Mysql 并返回主键ID

JDBCTemplate插入MySql返回主键ID

Dao层

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;  

public class jdbcTest{
    //function
    final String sql="...";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbcTemplate.update(new PreparedStatementCreator() {
        @Override
        public PreparedStatement createPreparedStatement(Connection connection) throws SQLException{
            PreparedStatement ps = connection.prepareStatement(sql, PreparedStatement.RETURN_GENERAT            ED_KEYS);
            ps.setString(1, "object1");
            ps.setInt(2, 10);

            return ps;
        }
    }, keyHolder);
    return keyHolder.getKey().intValue();
}