java.lang.Objectorg.objectweb.telosys.common.TelosysObject
org.objectweb.telosys.dal.dao.QueryContext
Field Summary | |
static boolean |
RETURN_GENERATED_KEYS
|
Constructor Summary | |
QueryContext(java.sql.Connection con,
java.lang.String sSql)
|
|
QueryContext(java.sql.Connection con,
java.lang.String sSql,
boolean bReturnGeneratedKeys)
|
Method Summary | |
protected void |
close()
|
protected java.lang.Long |
executeInsertKeyGen()
Executes an INSERT with KEY GENERATION ( Autoincrement Key ) |
protected java.sql.ResultSet |
executeQuery()
|
protected int |
executeUpdate()
|
java.math.BigDecimal |
getResultBigDecimal(int iPosition)
|
java.sql.Blob |
getResultBlob(int iPosition)
|
byte[] |
getResultBlobAsByteArray(int iPosition)
|
boolean |
getResultBoolean(int iPosition)
|
boolean |
getResultBooleanFromInt(int iPosition,
int iTrueValue)
|
boolean |
getResultBooleanFromString(int iPosition,
java.lang.String sTrueValue)
|
java.lang.Boolean |
getResultBooleanObject(int iPosition)
|
byte |
getResultByte(int iPosition)
|
java.lang.Byte |
getResultByteObject(int iPosition)
|
byte[] |
getResultBytes(int iPosition)
|
java.sql.Clob |
getResultClob(int iPosition)
|
java.util.Date |
getResultDate(int iPosition)
|
java.sql.Date |
getResultDateSql(int iPosition)
|
double |
getResultDouble(int iPosition)
|
java.lang.Double |
getResultDoubleObject(int iPosition)
|
float |
getResultFloat(int iPosition)
|
java.lang.Float |
getResultFloatObject(int iPosition)
|
int |
getResultInt(int iPosition)
|
java.lang.Integer |
getResultIntObject(int iPosition)
|
long |
getResultLong(int iPosition)
|
java.lang.Long |
getResultLongObject(int iPosition)
|
short |
getResultShort(int iPosition)
|
java.lang.Short |
getResultShortObject(int iPosition)
|
java.lang.String |
getResultString(int iPosition)
|
java.sql.Time |
getResultTime(int iPosition)
|
java.util.Date |
getResultTimeAsDate(int iPosition)
|
java.sql.Timestamp |
getResultTimestamp(int iPosition)
|
java.util.Date |
getResultTimestampAsDate(int iPosition)
|
protected boolean |
nextResult()
|
void |
setParamBigDecimal(int i,
java.math.BigDecimal value)
|
void |
setParamBlob(int i,
java.sql.Blob param)
|
void |
setParamBlob(int i,
byte[] bytes)
|
void |
setParamBoolean(int i,
boolean bValue)
|
void |
setParamBoolean(int i,
java.lang.Boolean obj)
|
void |
setParamBooleanAsInt(int i,
boolean bValue,
int iTrueValue,
int iFalseValue)
|
void |
setParamBooleanAsString(int i,
boolean bValue,
java.lang.String sTrueValue,
java.lang.String sFalseValue)
|
void |
setParamByte(int i,
byte value)
|
void |
setParamByte(int i,
java.lang.Byte obj)
|
void |
setParamBytes(int i,
byte[] bytes)
|
void |
setParamClob(int i,
java.sql.Clob param)
|
void |
setParamDate(int i,
java.util.Date dateValue)
Converts the given java.util.Date to java.sql.Date and set it as Date parameter |
void |
setParamDouble(int i,
double dValue)
|
void |
setParamDouble(int i,
java.lang.Double obj)
|
void |
setParamFloat(int i,
float fValue)
|
void |
setParamFloat(int i,
java.lang.Float obj)
|
void |
setParamInt(int i,
int iValue)
|
void |
setParamInt(int i,
java.lang.Integer obj)
|
void |
setParamLong(int i,
long value)
|
void |
setParamLong(int i,
java.lang.Long obj)
|
void |
setParamShort(int i,
short value)
|
void |
setParamShort(int i,
java.lang.Short obj)
|
void |
setParamString(int i,
java.lang.String sValue)
|
void |
setParamTime(int i,
java.util.Date dateValue)
Converts the given java.util.Date to java.sql.Time and set it as Time parameter |
void |
setParamTime(int i,
java.sql.Time time)
|
void |
setParamTimestamp(int i,
java.util.Date dateValue)
Converts the given java.util.Date to java.sql.Timestamp and set it as Timestamp parameter |
void |
setParamTimestamp(int i,
java.sql.Timestamp timestamp)
|
Methods inherited from class org.objectweb.telosys.common.TelosysObject |
error, error, error, getFlagTrace, info, setFlagTrace, trace, warn |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final boolean RETURN_GENERATED_KEYS
Constructor Detail |
public QueryContext(java.sql.Connection con, java.lang.String sSql) throws java.sql.SQLException
public QueryContext(java.sql.Connection con, java.lang.String sSql, boolean bReturnGeneratedKeys) throws java.sql.SQLException
Method Detail |
protected int executeUpdate() throws java.sql.SQLException
java.sql.SQLException
protected java.sql.ResultSet executeQuery() throws java.sql.SQLException
java.sql.SQLException
protected java.lang.Long executeInsertKeyGen() throws java.sql.SQLException
java.sql.SQLException
protected void close()
public void setParamInt(int i, int iValue) throws TelosysException
TelosysException
public void setParamInt(int i, java.lang.Integer obj) throws TelosysException
TelosysException
public void setParamByte(int i, byte value) throws TelosysException
TelosysException
public void setParamByte(int i, java.lang.Byte obj) throws TelosysException
TelosysException
public void setParamShort(int i, short value) throws TelosysException
TelosysException
public void setParamShort(int i, java.lang.Short obj) throws TelosysException
TelosysException
public void setParamLong(int i, long value) throws TelosysException
TelosysException
public void setParamLong(int i, java.lang.Long obj) throws TelosysException
TelosysException
public void setParamFloat(int i, float fValue) throws TelosysException
TelosysException
public void setParamFloat(int i, java.lang.Float obj) throws TelosysException
TelosysException
public void setParamDouble(int i, double dValue) throws TelosysException
TelosysException
public void setParamDouble(int i, java.lang.Double obj) throws TelosysException
TelosysException
public void setParamBigDecimal(int i, java.math.BigDecimal value) throws TelosysException
TelosysException
public void setParamString(int i, java.lang.String sValue) throws TelosysException
TelosysException
public void setParamDate(int i, java.util.Date dateValue) throws TelosysException
i
- dateValue
-
TelosysException
public void setParamTimestamp(int i, java.util.Date dateValue) throws TelosysException
i
- dateValue
-
TelosysException
public void setParamTimestamp(int i, java.sql.Timestamp timestamp) throws TelosysException
TelosysException
public void setParamTime(int i, java.util.Date dateValue) throws TelosysException
i
- dateValue
-
TelosysException
public void setParamTime(int i, java.sql.Time time) throws TelosysException
TelosysException
public void setParamBytes(int i, byte[] bytes) throws TelosysException
TelosysException
public void setParamBoolean(int i, boolean bValue) throws TelosysException
TelosysException
public void setParamBoolean(int i, java.lang.Boolean obj) throws TelosysException
TelosysException
public void setParamBooleanAsString(int i, boolean bValue, java.lang.String sTrueValue, java.lang.String sFalseValue) throws TelosysException
TelosysException
public void setParamBooleanAsInt(int i, boolean bValue, int iTrueValue, int iFalseValue) throws TelosysException
TelosysException
public void setParamClob(int i, java.sql.Clob param) throws TelosysException
TelosysException
public void setParamBlob(int i, byte[] bytes) throws TelosysException
TelosysException
public void setParamBlob(int i, java.sql.Blob param) throws TelosysException
TelosysException
public java.lang.String getResultString(int iPosition) throws TelosysException
TelosysException
public int getResultInt(int iPosition) throws TelosysException
TelosysException
public java.lang.Integer getResultIntObject(int iPosition) throws TelosysException
TelosysException
public byte getResultByte(int iPosition) throws TelosysException
TelosysException
public java.lang.Byte getResultByteObject(int iPosition) throws TelosysException
TelosysException
public short getResultShort(int iPosition) throws TelosysException
TelosysException
public java.lang.Short getResultShortObject(int iPosition) throws TelosysException
TelosysException
public long getResultLong(int iPosition) throws TelosysException
TelosysException
public java.lang.Long getResultLongObject(int iPosition) throws TelosysException
TelosysException
public float getResultFloat(int iPosition) throws TelosysException
TelosysException
public java.lang.Float getResultFloatObject(int iPosition) throws TelosysException
TelosysException
public double getResultDouble(int iPosition) throws TelosysException
TelosysException
public java.lang.Double getResultDoubleObject(int iPosition) throws TelosysException
TelosysException
public java.math.BigDecimal getResultBigDecimal(int iPosition) throws TelosysException
TelosysException
public java.util.Date getResultDate(int iPosition) throws TelosysException
TelosysException
public java.sql.Date getResultDateSql(int iPosition) throws TelosysException
TelosysException
public java.sql.Time getResultTime(int iPosition) throws TelosysException
TelosysException
public java.util.Date getResultTimeAsDate(int iPosition) throws TelosysException
TelosysException
public java.sql.Timestamp getResultTimestamp(int iPosition) throws TelosysException
TelosysException
public java.util.Date getResultTimestampAsDate(int iPosition) throws TelosysException
TelosysException
public byte[] getResultBytes(int iPosition) throws TelosysException
TelosysException
public boolean getResultBoolean(int iPosition) throws TelosysException
TelosysException
public java.lang.Boolean getResultBooleanObject(int iPosition) throws TelosysException
TelosysException
public boolean getResultBooleanFromInt(int iPosition, int iTrueValue) throws TelosysException
TelosysException
public boolean getResultBooleanFromString(int iPosition, java.lang.String sTrueValue) throws TelosysException
TelosysException
public java.sql.Clob getResultClob(int iPosition) throws TelosysException
TelosysException
public byte[] getResultBlobAsByteArray(int iPosition) throws TelosysException
TelosysException
public java.sql.Blob getResultBlob(int iPosition) throws TelosysException
TelosysException
protected boolean nextResult() throws TelosysException
TelosysException