spring mvc 插入一条数据 返回该数据的主键编号

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

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;


    public int addrole(final Object[] params){
        
        KeyHolder keyHolder = new GeneratedKeyHolder();
        final String sql = "insert into role (rolename,status) values (?,1)";
        
        this.jdbcTemplate.update(new PreparedStatementCreator(){
            public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
                PreparedStatement ps = connection.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
                for(int i = 0; i < params.length; i++) {
                    ps.setString(i + 1, params[i].toString());
                }
                return ps;
            }
        }, keyHolder);
        return keyHolder.getKey().intValue();
    }