fr.profi.mzdb.util.sqlite

Class SQLiteQuery

java.lang.Object

fr.profi.mzdb.util.sqlite.SQLiteQuery

public class SQLiteQuery
extends Object

Author:

David Bouyssie

Constructor Summary

Constructors

Constructor and Description
SQLiteQuery(com.almworks.sqlite4java.SQLiteConnection connection, String sqlQuery)
SQLiteQuery(com.almworks.sqlite4java.SQLiteConnection connection, String sqlQuery, boolean cacheStmt)

Method Summary

Modifier and Type	Method and Description
SQLiteQuery	bind(int index, byte[] value)
SQLiteQuery	bind(int index, byte[] value, int offset, int length)
SQLiteQuery	bind(int index, double value)
SQLiteQuery	bind(int index, int value)
SQLiteQuery	bind(int index, long value)
SQLiteQuery	bind(int index, String value)
SQLiteQuery	bindNull(int index)
OutputStream	bindStream(int index)
OutputStream	bindStream(int index, int bufferSize)
SQLiteQuery	bindZeroBlob(int index, int length)
void	dispose()
double[]	extractDoubles(int bufferLength)
float[]	extractFloats(int bufferLength)
int[]	extractInts(int bufferLength)
long[]	extractLongs(int bufferLength)
<T> T	extractRecord(ISQLiteRecordExtraction<T> extractor)
<T> List<T>	extractRecordList(ISQLiteRecordExtraction<T> extractor)
<T> T[]	extractRecords(ISQLiteRecordExtraction<T> extractor, T[] records)
byte[]	extractSingleBlob()
double	extractSingleDouble()
InputStream	extractSingleInputStream()
int	extractSingleInt()
long	extractSingleLong()
String	extractSingleString()
String[]	extractStrings(int bufferLength)
void	forEachRecord(ISQLiteRecordOperation op)
int	getColumnIndex(String colName)
String[]	getColumnNames()
SQLiteRecordIterator	getRecordIterator()
com.almworks.sqlite4java.SQLiteStatement	getStatement()
boolean	isStatementDisposed()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLiteQuery

public SQLiteQuery(com.almworks.sqlite4java.SQLiteConnection connection,
                   String sqlQuery,
                   boolean cacheStmt)
            throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

SQLiteQuery

public SQLiteQuery(com.almworks.sqlite4java.SQLiteConnection connection,
                   String sqlQuery)
            throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

Method Detail

getColumnIndex

public int getColumnIndex(String colName)
                   throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

getColumnNames

public String[] getColumnNames()

getStatement

public com.almworks.sqlite4java.SQLiteStatement getStatement()

dispose

public void dispose()

isStatementDisposed

public boolean isStatementDisposed()

bind

public SQLiteQuery bind(int index,
                        double value)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bind

public SQLiteQuery bind(int index,
                        int value)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bind

public SQLiteQuery bind(int index,
                        long value)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bind

public SQLiteQuery bind(int index,
                        String value)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bind

public SQLiteQuery bind(int index,
                        byte[] value)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bind

public SQLiteQuery bind(int index,
                        byte[] value,
                        int offset,
                        int length)
                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bindZeroBlob

public SQLiteQuery bindZeroBlob(int index,
                                int length)
                         throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bindNull

public SQLiteQuery bindNull(int index)
                     throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bindStream

public OutputStream bindStream(int index)
                        throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

bindStream

public OutputStream bindStream(int index,
                               int bufferSize)
                        throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

getRecordIterator

public SQLiteRecordIterator getRecordIterator()
                                       throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

forEachRecord

public void forEachRecord(ISQLiteRecordOperation op)
                   throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractRecords

public <T> T[] extractRecords(ISQLiteRecordExtraction<T> extractor,
                              T[] records)
                       throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractRecordList

public <T> List<T> extractRecordList(ISQLiteRecordExtraction<T> extractor)
                              throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractRecord

public <T> T extractRecord(ISQLiteRecordExtraction<T> extractor)
                    throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractStrings

public String[] extractStrings(int bufferLength)
                        throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractInts

public int[] extractInts(int bufferLength)
                  throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractLongs

public long[] extractLongs(int bufferLength)
                    throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractFloats

public float[] extractFloats(int bufferLength)
                      throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractDoubles

public double[] extractDoubles(int bufferLength)
                        throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleString

public String extractSingleString()
                           throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleInt

public int extractSingleInt()
                     throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleLong

public long extractSingleLong()
                       throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleDouble

public double extractSingleDouble()
                           throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleBlob

public byte[] extractSingleBlob()
                         throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

extractSingleInputStream

public InputStream extractSingleInputStream()
                                     throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException