SQLiteDBConnect.java

Go to the documentation of this file.

/*
 *
 * Autopsy Forensic Browser
 *
 * Copyright 2012-2019 Basis Technology Corp.
 *
 * Copyright 2012 42six Solutions.
 * Contact: aebadirad <at> 42six <dot> com
 * Project Contact/Architect: carrier <at> sleuthkit <dot> org
 *
 * 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.
 */
package org.sleuthkit.autopsy.coreutils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;

public class SQLiteDBConnect implements AutoCloseable {

    private static final Logger logger = Logger.getLogger(SQLiteDBConnect.class.getName());
    private static final int STMT_EXEC_TIMEOUT_SECS = 30;

    public SQLiteDBConnect(String driver, String url) throws SQLException {
        sDriver = driver;
        sUrl = url;
        try {
            Class.forName(sDriver);
        } catch (ClassNotFoundException ex) {
            throw new SQLException(ex);
        }
        conn = DriverManager.getConnection(sUrl);
        statement = conn.createStatement();
        statement.setQueryTimeout(STMT_EXEC_TIMEOUT_SECS);
    }

    public void executeStmt(String sqlStatement) throws SQLException {
        statement.executeUpdate(sqlStatement);
    }

    public void executeStmt(String[] sqlStatements) throws SQLException {
        for (String stmt : sqlStatements) {
            executeStmt(stmt);
        }
    }

    public ResultSet executeQry(String sqlStatement) throws SQLException {
        return statement.executeQuery(sqlStatement);
    }

    public void closeConnection() {
        if (conn == null) {
            return;
        }
        try {
            conn.close();
        } catch (SQLException ex) {
            logger.log(Level.WARNING, "Unable to close connection to SQLite DB at " + sUrl, ex);
        }
    }

    @Override
    public void close() {
        closeConnection();
    }

    /*
     * Partially constructs a utility object for doing basic operations on a
     * SQLite database. The object is not in a usable state. Further
     * initialization is required. See methods below.
     *
     * @deprecated Do not use.
     */
    @Deprecated
    public SQLiteDBConnect() {
    }

    @Deprecated
    public final void init(String driver, String url) throws SQLException {
        sDriver = driver;
        sUrl = url;
        closeConnection();
        setConnection();
        setStatement();
    }

    @Deprecated
    public void setConnection() throws SQLException {
        if (sDriver == null || sDriver.isEmpty() || sUrl == null || sUrl.isEmpty()) {
            throw new SQLException("Driver and or databse URl not initialized");
        }
        closeConnection();
        try {
            Class.forName(sDriver);
        } catch (ClassNotFoundException ex) {
            throw new SQLException(ex);
        }
        conn = DriverManager.getConnection(sUrl);
    }

    @Deprecated
    public Connection getConnection() {
        return conn;
    }

    @Deprecated
    public void setStatement() throws SQLException {
        if (conn == null) {
            setConnection();
        }
        statement = conn.createStatement();
        statement.setQueryTimeout(iTimeout);
    }

    @Deprecated
    public Statement getStatement() {
        return statement;
    }

    /*
     * The lack of encapsulation of these fields is an error. Access to them
     * outside of instances of this class is deprecated.
     *
     * @deprecated Do not access.
     */
    public String sDriver = "";
    public String sUrl = null;
    public int iTimeout = STMT_EXEC_TIMEOUT_SECS;
    public Connection conn = null;
    public Statement statement = null;

}