Inherits AutoCloseable.

Public Member Functions
	SQLiteDBConnect ()

	SQLiteDBConnect (String sDriverToLoad, String sUrlToLoad) throws SQLException

void	close ()

void	closeConnection ()

ResultSet	executeQry (String instruction) throws SQLException

void	executeStmt (String instruction) throws SQLException

void	executeStmt (String[] instructionSet) throws SQLException

Connection	getConnection ()

Statement	getStatement ()

final void	init (String sDriverVar, String sUrlVar) throws SQLException

void	setConnection () throws SQLException

void	setStatement () throws SQLException

Public Attributes
Connection	conn = null

int	iTimeout = 30

String	sDriver = ""

Statement	statement = null

String	sUrl = null

Private Member Functions
void	setDriver (String sDriverVar)

void	setUrl (String sUrlVar)

Static Private Attributes
static final Logger	logger = Logger.getLogger(SQLiteDBConnect.class.getName())

Detailed Description

Database connection class & utilities.

Definition at line 35 of file SQLiteDBConnect.java.

Constructor & Destructor Documentation

org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.SQLiteDBConnect ( )

Definition at line 48 of file SQLiteDBConnect.java.

org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.SQLiteDBConnect	(	String	sDriverToLoad,
		String	sUrlToLoad
	)		throws SQLException

Definition at line 59 of file SQLiteDBConnect.java.

References org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.init().

Member Function Documentation

void org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.close ( )

Definition at line 134 of file SQLiteDBConnect.java.

References org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.closeConnection().

void org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.closeConnection ( )

Definition at line 124 of file SQLiteDBConnect.java.

Referenced by org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.close().

ResultSet org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.executeQry ( String instruction ) throws SQLException

Definition at line 120 of file SQLiteDBConnect.java.

Referenced by org.sleuthkit.autopsy.modules.plaso.PlasoIngestModule.createPlasoArtifacts().

void org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.executeStmt ( String instruction ) throws SQLException

Definition at line 103 of file SQLiteDBConnect.java.

Referenced by org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.executeStmt().

void org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.executeStmt ( String[] instructionSet ) throws SQLException

processes an array of instructions e.g. a set of SQL command strings passed from a file

NB you should ensure you either handle empty lines in files by either removing them or parsing them out since they will generate spurious SQLExceptions when they are encountered during the iteration....

Definition at line 114 of file SQLiteDBConnect.java.

References org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.executeStmt().

Connection org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.getConnection ( )

Definition at line 87 of file SQLiteDBConnect.java.

References org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.conn.

Statement org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.getStatement ( )

Definition at line 99 of file SQLiteDBConnect.java.

References org.sleuthkit.autopsy.coreutils.SQLiteDBConnect.statement.