Java SQL PreparedStatement getPriorID(Connection conn, PreparedStatement stmt)

Description

get Prior ID

License

Apache License

Declaration

private static final int getPriorID(Connection conn, PreparedStatement stmt) throws SQLException 

Method Source Code

//package com.java2s;
/*//ww w  . ja  v  a  2s  . c o  m
 * Copyright 2007 Daniel Spiewak
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); 
 * you may not use this file except in compliance with the License. 
 * You may obtain a copy of the License at
 * 
 *       http://www.apache.org/licenses/LICENSE-2.0 
 * 
 * Unless required by applicable law or agreed to in writing, software 
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

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

public class Main {
    private static int priorID = -1;
    private static String uri = System.getProperty("db.uri.prefix");

    private static final int getPriorID(Connection conn, PreparedStatement stmt) throws SQLException {
        int back = -1;

        if (uri.startsWith("jdbc:hsqldb")) {
            PreparedStatement ident = conn.prepareStatement("CALL IDENTITY()");
            ResultSet res = ident.executeQuery();

            if (res.next()) {
                back = res.getInt(1);
            }

            res.close();
            ident.close();
        } else if (uri.startsWith("jdbc:postgres") || uri.startsWith("jdbc:oracle")) {
            back = priorID;
        } else {
            ResultSet res = stmt.getGeneratedKeys();
            if (res.next()) {
                back = res.getInt(1);
            }
        }

        return back;
    }

    private static final PreparedStatement prepareStatement(Connection conn, String sql) throws SQLException {
        if (uri.startsWith("jdbc:hsqldb") || uri.startsWith("jdbc:postgres")) {
            return conn.prepareStatement(sql);
        }

        return conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
    }
}

Related

1. getLimitedBatchSizePreparedStatement(PreparedStatement pstmt, int maxBatchSize)
2. getNewPreparedStatement(String format)
3. getPreparedStatement(Connection conn, String sql)
4. getPreparedStatement(Connection conn, String sql, List