Package org.tmatesoft.sqljet.core.internal.lang

Class SqlJetPreparedStatement

java.lang.Object

org.tmatesoft.sqljet.core.internal.lang.SqlJetPreparedStatement

public class SqlJetPreparedStatement
extends Object

Author:

TMate Software Ltd., Dmitry Stadnik (dtrace@seznam.cz)

Constructor Summary

Constructors

Constructor	Description
SqlJetPreparedStatement(SqlJetDb db, String sql)

Method Summary

Modifier and Type	Method	Description
void	clearBindings()
void	close()
byte[]	getBlobAsArray(int columnIndex)
InputStream	getBlobAsStream(int columnIndex)
int	getColumnsCount()
SqlJetValueType	getColumnType(int columnIndex)
double	getFloat(int columnIndex)
long	getInteger(int columnIndex)
int	getParametersCount()
String	getText(int columnIndex)
boolean	isNull(int columnIndex)
void	reset()
void	setBlob(int paramIndex, byte[] value)
void	setBlob(String paramName, byte[] value)
void	setFloat(int paramIndex, double value)
void	setFloat(String paramName, double value)
void	setInteger(int paramIndex, long value)
void	setInteger(String paramName, long value)
void	setNull(int paramIndex)
void	setNull(String paramName)
void	setText(int paramIndex, String value)
void	setText(String paramName, String value)
boolean	step()	Executes the statement or advances to the next row of the query results.

Methods inherited from class java.lang.Object

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

Constructor Details

SqlJetPreparedStatement

public SqlJetPreparedStatement(SqlJetDb db,
 String sql)

Method Details

close

public void close()
           throws SqlJetException

Throws:

SqlJetException

getParametersCount

public int getParametersCount()
                       throws SqlJetException

Throws:

SqlJetException

setInteger

public void setInteger(int paramIndex,
 long value)
                throws SqlJetException

Throws:

SqlJetException

setFloat

public void setFloat(int paramIndex,
 double value)
              throws SqlJetException

Throws:

SqlJetException

setText

public void setText(int paramIndex,
 String value)
             throws SqlJetException

Throws:

SqlJetException

setBlob

public void setBlob(int paramIndex,
 byte[] value)
             throws SqlJetException

Throws:

SqlJetException

setNull

public void setNull(int paramIndex)
             throws SqlJetException

Throws:

SqlJetException

setInteger

public void setInteger(String paramName,
 long value)
                throws SqlJetException

Throws:

SqlJetException

setFloat

public void setFloat(String paramName,
 double value)
              throws SqlJetException

Throws:

SqlJetException

setText

public void setText(String paramName,
 String value)
             throws SqlJetException

Throws:

SqlJetException

setBlob

public void setBlob(String paramName,
 byte[] value)
             throws SqlJetException

Throws:

SqlJetException

setNull

public void setNull(String paramName)
             throws SqlJetException

Throws:

SqlJetException

clearBindings

public void clearBindings()
                   throws SqlJetException

Throws:

SqlJetException

step

public boolean step()
             throws SqlJetException

Executes the statement or advances to the next row of the query results.

Throws:

SqlJetException

getColumnsCount

public int getColumnsCount()
                    throws SqlJetException

Throws:

SqlJetException

getColumnType

public SqlJetValueType getColumnType(int columnIndex)
                              throws SqlJetException

Throws:

SqlJetException

getInteger

public long getInteger(int columnIndex)
                throws SqlJetException

Throws:

SqlJetException

getFloat

public double getFloat(int columnIndex)
                throws SqlJetException

Throws:

SqlJetException

getText

public String getText(int columnIndex)
               throws SqlJetException

Throws:

SqlJetException

getBlobAsArray

public byte[] getBlobAsArray(int columnIndex)
                      throws SqlJetException

Throws:

SqlJetException

getBlobAsStream

public InputStream getBlobAsStream(int columnIndex)
                            throws SqlJetException

Throws:

SqlJetException

isNull

public boolean isNull(int columnIndex)
               throws SqlJetException

Throws:

SqlJetException

reset

public void reset()
           throws SqlJetException

Throws:

SqlJetException