java.sql.SQLException: Generated keys not requested.

• 问题场景：使用jdbc访问mysql想要实现主键的返回，出现错误
• 具体堆栈信息：

java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate(), Statement.executeLargeUpdate() or Connection.prepareStatement().
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
    at com.mysql.jdbc.StatementImpl.getGeneratedKeys(StatementImpl.java:1682)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getGeneratedKeys(NewProxyPreparedStatement.java:2570)

• 错误代码

        Connection connection = null;
        java.sql.PreparedStatement preparedStatement = null;
        int id = 0;
        try {
            connection = C3P0Utils.getConnection();
            preparedStatement = connection.prepareStatement(INSERT_SQL);
            preparedStatement.executeUpdate();
            ResultSet generatedKeys = preparedStatement.getGeneratedKeys();
            if (generatedKeys.next()) {
                id = generatedKeys.getInt(1);
            }
        }

• 错误原因：
  获取预编译块的时候未获取带有主键返回策略的预编译块
• 解决方式：
  获取preparedStatement的时候多一个参数Statement.RETURN_GENERATED_KEYS就可以了

preparedStatement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)