Class SqlJetPreparedStatement
- java.lang.Object
-
- org.tmatesoft.sqljet.core.internal.lang.SqlJetPreparedStatement
-
public class SqlJetPreparedStatement extends java.lang.Object
- Author:
- TMate Software Ltd., Dmitry Stadnik (dtrace@seznam.cz)
-
-
Constructor Summary
Constructors Constructor Description SqlJetPreparedStatement(SqlJetDb db, java.lang.String sql)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
clearBindings()
void
close()
byte[]
getBlobAsArray(int columnIndex)
java.io.InputStream
getBlobAsStream(int columnIndex)
int
getColumnsCount()
SqlJetValueType
getColumnType(int columnIndex)
double
getFloat(int columnIndex)
long
getInteger(int columnIndex)
int
getParametersCount()
java.lang.String
getText(int columnIndex)
boolean
isNull(int columnIndex)
void
reset()
void
setBlob(int paramIndex, byte[] value)
void
setBlob(java.lang.String paramName, byte[] value)
void
setFloat(int paramIndex, double value)
void
setFloat(java.lang.String paramName, double value)
void
setInteger(int paramIndex, long value)
void
setInteger(java.lang.String paramName, long value)
void
setNull(int paramIndex)
void
setNull(java.lang.String paramName)
void
setText(int paramIndex, java.lang.String value)
void
setText(java.lang.String paramName, java.lang.String value)
boolean
step()
Executes the statement or advances to the next row of the query results.
-
-
-
Constructor Detail
-
SqlJetPreparedStatement
public SqlJetPreparedStatement(SqlJetDb db, java.lang.String sql)
-
-
Method Detail
-
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, java.lang.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(java.lang.String paramName, long value) throws SqlJetException
- Throws:
SqlJetException
-
setFloat
public void setFloat(java.lang.String paramName, double value) throws SqlJetException
- Throws:
SqlJetException
-
setText
public void setText(java.lang.String paramName, java.lang.String value) throws SqlJetException
- Throws:
SqlJetException
-
setBlob
public void setBlob(java.lang.String paramName, byte[] value) throws SqlJetException
- Throws:
SqlJetException
-
setNull
public void setNull(java.lang.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 java.lang.String getText(int columnIndex) throws SqlJetException
- Throws:
SqlJetException
-
getBlobAsArray
public byte[] getBlobAsArray(int columnIndex) throws SqlJetException
- Throws:
SqlJetException
-
getBlobAsStream
public java.io.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
-
-