jdbc插入数据库后获取主键值

package com.wanmei.meishu;

import java.sql.*;

public class OpSqliteDB {

    private String url;
    private Connection connection;
    OpSqliteDB(String url) {
        this.url = url;
    }

    //主要是参数Statement.RETURN_GENERATED_KEYS和方法getGeneratedKeys()的使用
    Integer saveData( String sql){
        try {
            Class.forName("org.sqlite.JDBC");
            if(connection == null) {
                connection = DriverManager.getConnection(url);
            }
            /*
            //显式设置Statement.RETURN_GENERATED_KEYS也可以
            PreparedStatement preparedStatement=connection.prepareStatement("insert into class (name,sid)values(?,?)",Statement.RETURN_GENERATED_KEYS);
            preparedStatement.executeUpdate();
            resultSet=preparedStatement.getGeneratedKeys();
            if(resultSet.next()){
                id=resultSet.getInt(1);
            }
            return id;
            */
            //测试使用的是sqlite，自增主键，这样也能获取到自动生成的主键
            Statement statement = connection.createStatement();
            statement.executeUpdate(sql);
            ResultSet resultSet=statement.getGeneratedKeys();
            if(resultSet.next()){
                return resultSet.getInt(1);
            }
        }catch (SQLException e){
            e.printStackTrace();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }
        return -1;
    }
}

看Statement的源码注释如下

    /**
     * Retrieves any auto-generated keys created as a result of executing this
     * <code>Statement</code> object. If this <code>Statement</code> object did
     * not generate any keys, an empty <code>ResultSet</code>
     * object is returned.
     *
     *<p><B>Note:</B>If the columns which represent the auto-generated keys were not specified,
     * the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
     *
     * @return a <code>ResultSet</code> object containing the auto-generated key(s)
     *         generated by the execution of this <code>Statement</code> object
     * @exception SQLException if a database access error occurs or
     * this method is called on a closed <code>Statement</code>
     * @throws SQLFeatureNotSupportedException  if the JDBC driver does not support this method
     * @since 1.4
     */
    ResultSet getGeneratedKeys() throws SQLException;

意为，如果没有Statement没有生产任何key，则返回空ResultSet