public class DAOUtil extends Object implements AutoCloseable
Modifier and Type | Field and Description |
---|---|
static String |
MSG_EXCEPTION_SELECT_ERROR |
Constructor and Description |
---|
DAOUtil(String sql)
Creates a new DAOUtil object.
|
DAOUtil(String sql,
boolean logQueries)
Creates a new DAOUtil object.
|
DAOUtil(String sql,
Integer autoGeneratedKeys)
Creates a new DAOUtil object.
|
DAOUtil(String strSQL,
Integer autoGeneratedKeys,
Plugin plugin)
Creates a new DAOUtil object.
|
DAOUtil(String strSQL,
Integer autoGeneratedKeys,
Plugin plugin,
boolean bLogQueries)
Creates a new DAOUtil object.
|
DAOUtil(String strSQL,
Plugin plugin)
Creates a new DAOUtil object.
|
DAOUtil(String strSQL,
Plugin plugin,
boolean bLogQueries)
Creates a new DAOUtil object.
|
Modifier and Type | Method and Description |
---|---|
void |
close() |
void |
executeQuery()
Executes a query
|
void |
executeUpdate()
Executes the update request and throws an error if the result is not 1
|
void |
free()
Free connection
|
Array |
getArray(int nIndex)
Get an Array value
|
Array |
getArray(String strColumnName)
Get an Array value
|
InputStream |
getAsciiString(int nIndex)
Get an ascii value stream
|
InputStream |
getAsciiString(String strColumnName)
Get an ascii value stream
|
BigDecimal |
getBigDecimal(int nIndex)
Get a BigDecimal value
|
BigDecimal |
getBigDecimal(String strColumnName)
Get a BigDecimal value
|
InputStream |
getBinaryStream(int nIndex)
Gets a binary stream from a resultSet
|
Blob |
getBlob(int nIndex)
Gets a blob from a resultset
|
Blob |
getBlob(String strColumnName)
Gets a blob from a resultset
|
boolean |
getBoolean(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a Boolean
|
boolean |
getBoolean(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a Boolean
|
byte |
getByte(int nIndex)
Gets a byte from a resultset
|
byte |
getByte(String strColumnName)
Gets a byte from a resultset
|
byte[] |
getBytes(int nIndex)
Gets a byte array from a resultset
|
byte[] |
getBytes(String strColumnName)
Gets a byte array from a resultset
|
Reader |
getCharacterStream(int nIndex)
Get a character stream value
|
Reader |
getCharacterStream(String strColumnName)
Get a character stream value
|
Clob |
getClob(int nIndex)
Get a Clob value
|
Clob |
getClob(String strColumnName)
Get a Clob value
|
Date |
getDate(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Date object in the Java programming language.
|
Date |
getDate(int nIndex,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Date object in the Java programming language.
|
Date |
getDate(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Date object in the Java programming language.
|
Date |
getDate(String strColumnName,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Date object in the Java programming language.
|
double |
getDouble(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a double
|
double |
getDouble(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a double
|
float |
getFloat(int nIndex)
Get a float value
|
float |
getFloat(String strColumnName)
Get a float value
|
BigDecimal |
getGeneratedKeyBigDecimal(int nIndex)
Gets the value of the designated column in the current row of this
GeneratedKeys ResultSet object as a BigDecimal
|
byte |
getGeneratedKeyByte(int nIndex)
Gets the value of the designated column in the current row of this
GeneratedKeys ResultSet object as a byte
|
int |
getGeneratedKeyInt(int nIndex)
Gets the value of the designated column in the current row of this
GeneratedKeys ResultSet object as a int
|
long |
getGeneratedKeyLong(int nIndex)
Gets the value of the designated column in the current row of this
GeneratedKeys ResultSet object as a long
|
short |
getGeneratedKeyShort(int nIndex)
Gets the value of the designated column in the current row of this
GeneratedKeys ResultSet object as a short
|
ResultSet |
getGeneratedKeysResultSet()
Get the GeneratedKeys ResultSet
|
int |
getInt(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a int
|
int |
getInt(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a int
|
long |
getLong(int nIndex)
Gets the long value
|
long |
getLong(String strColumnName)
Gets the long value
|
Reader |
getNCharacterStream(int nIndex)
Get a character stream value
|
Reader |
getNCharacterStream(String strColumnName)
Get a character stream value
|
NClob |
getNClob(int nIndex)
Get a NClob value
|
NClob |
getNClob(String strColumnName)
Get a Clob value
|
String |
getNString(int nIndex)
Get a String value
|
String |
getNString(String strColumnName)
Get a Stringvalue
|
Object |
getObject(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a Object
|
<T> T |
getObject(int nIndex,
Class<T> type)
Gets the value of the designated column in the current row of this ResultSet
object as a T
|
Object |
getObject(int nIndex,
Map<String,Class<?>> map)
Gets the value of the designated column in the current row of this ResultSet
object as a Object
|
Object |
getObject(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as an Object
|
<T> T |
getObject(String strColumnName,
Class<T> type)
Gets the value of the designated column in the current row of this ResultSet
object as an Object
|
Object |
getObject(String strColumnName,
Map<String,Class<?>> map)
Gets the value of the designated column in the current row of this ResultSet
object as an Object
|
Ref |
getRef(int nIndex)
Get a Ref value
|
Ref |
getRef(String strColumnName)
Get a Ref value
|
ResultSet |
getResultSet()
Get the ResultSet
|
RowId |
getRowId(int nIndex)
Get a RowId value
|
RowId |
getRowId(String strColumnName)
Get a RowId value
|
short |
getShort(int nIndex)
Get a short value
|
short |
getShort(String strColumnName)
Get a short value
|
SQLXML |
getSQLXML(int nIndex)
Get a SQLXML value
|
SQLXML |
getSQLXML(String strColumnName)
Get a SQLXML value
|
String |
getString(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a string
|
String |
getString(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a string
|
Time |
getTime(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Time object in the Java programming language.
|
Time |
getTime(int nIndex,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Time object in the Java programming language.
|
Time |
getTime(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Time object in the Java programming language.
|
Time |
getTime(String strColumnName,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a java.sql.Time object in the Java programming language.
|
Timestamp |
getTimestamp(int nIndex)
Gets the value of the designated column in the current row of this ResultSet
object as a timestamp
|
Timestamp |
getTimestamp(int nIndex,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a timestamp
|
Timestamp |
getTimestamp(String strColumnName)
Gets the value of the designated column in the current row of this ResultSet
object as a Timestamp
|
Timestamp |
getTimestamp(String strColumnName,
Calendar calendar)
Gets the value of the designated column in the current row of this ResultSet
object as a Timestamp
|
URL |
getURL(int nIndex)
Get a URL value
|
URL |
getURL(String strColumnName)
Get a URL value
|
boolean |
isLast()
Indicates whether the cursor is on the last row of this ResultSet object.
|
boolean |
next()
Moves the cursor down one row from its current position in the ResultSet.
|
boolean |
nextGeneratedKey()
Moves the cursor down one row from its current position in the GeneratedKeys
ResultSet.
|
void |
setArray(int nIndex,
String strTypename,
Object[] elements)
Set an Array value
|
void |
setAsciiStream(int nIndex,
InputStream stream)
Fills the prepared statement with an ascii value stream
|
void |
setAsciiStream(int nIndex,
InputStream stream,
int nLength)
Fills the prepared statement with an ascii value stream
|
void |
setAsciiStream(int nIndex,
InputStream stream,
long lLength)
Fills the prepared statement with an ascii value stream
|
void |
setBigDecimal(int nIndex,
BigDecimal value)
Fills the prepared Statement with a BigDecimal value
|
void |
setBinaryStream(int nIndex,
InputStream iStream)
Fills the prepared statement with a binary value stream
|
void |
setBinaryStream(int nIndex,
InputStream iStream,
int nBlength)
Fills the prepared statement with a binary value stream
|
void |
setBinaryStream(int nIndex,
InputStream iStream,
long nBlength)
Fills the prepared statement with a binary value stream
|
void |
setBlob(int nIndex,
Blob blob)
Fills the prepared statement with a blob value
|
void |
setBlob(int nIndex,
InputStream stream)
Fills the prepared statement with a blob value from a stream
|
void |
setBlob(int nIndex,
InputStream stream,
long nLength)
Fills the prepared statement with a blob value from a stream
|
void |
setBoolean(int nIndex,
boolean bValue)
Fills the prepared statement with a Boolean value
|
void |
setByte(int nIndex,
byte bValue)
Fills the prepared statement with a byte value
|
void |
setBytes(int nIndex,
byte[] tbValue)
Fills the prepared statement with a byte array value
|
void |
setCharacterStream(int nIndex,
Reader stream)
Fills the prepared statement with a character stream
|
void |
setCharacterStream(int nIndex,
Reader stream,
int nLength)
Fills the prepared statement with a character stream
|
void |
setCharacterStream(int nIndex,
Reader stream,
long nLength)
Fills the prepared statement with a character stream
|
void |
setClob(int nIndex,
Clob clob)
Fills the prepared statement with a Clob
|
void |
setClob(int nIndex,
NClob clob)
Fills the prepared statement with a NClob
|
void |
setClob(int nIndex,
Reader stream)
Fills the prepared statement with a Clob stream
|
void |
setClob(int nIndex,
Reader stream,
long nLength)
Fills the prepared statement with a Clob stream
|
void |
setDate(int nIndex,
Date date)
Fills the prepared statement with a date value
|
void |
setDate(int nIndex,
Date date,
Calendar calendar)
Fills the prepared statement with a date value
|
void |
setDouble(int nIndex,
double dValue)
Fills the prepared statement with a double value
|
void |
setDoubleNull(int nIndex)
Sets null value for a "double" column
|
void |
setFloat(int nIndex,
float fValue)
Fills the prepared statement with a float value
|
void |
setInt(int nIndex,
int nValue)
Fills the prepared statement with a int value
|
void |
setIntNull(int nIndex)
Fills the prepared statement with a int null value
|
void |
setLong(int nIndex,
long lValue)
Sets a long value
|
void |
setLongNull(int nIndex)
Sets null value for a "long" column
|
void |
setNCharacterStream(int nIndex,
Reader stream)
Fills the prepared statement with a character stream value
|
void |
setNCharacterStream(int nIndex,
Reader stream,
long nLength)
Fills the prepared statement with a character stream value
|
void |
setNClob(int nIndex,
Reader stream)
Fills the prepared statement with a NClob stream
|
void |
setNClob(int nIndex,
Reader stream,
long nLength)
Fills the prepared statement with a NClob stream
|
void |
setNString(int nIndex,
String strValue)
Fills the prepared statement with a String value
|
void |
setNull(int nIndex,
int nType)
Fills the prepared statement with a null value
|
void |
setNull(int nIndex,
int nType,
String strTypeName)
Fills the prepared statement with a null value
|
void |
setObject(int nIndex,
Object value)
Fills the prepared statement with an object value
|
void |
setObject(int nIndex,
Object value,
int nType)
Fills the prepared statement with an object value
|
void |
setObject(int nIndex,
Object value,
int nType,
int nScaleOrLength)
Fills the prepared statement with an object value
|
void |
setRef(int nIndex,
Ref ref)
Fills the prepared statement with an Ref value
|
void |
setRowId(int nIndex,
RowId rowId)
Fills the prepared statement with a RowId value
|
void |
setShort(int nIndex,
short shortValue)
Fills the prepared statement with a short value
|
void |
setSQLXML(int nIndex,
SQLXML value)
Fills the prepared statement with a SQLXML value
|
void |
setString(int nIndex,
String strValue)
Fills the prepared statement with a string value
|
void |
setTime(int nIndex,
Time time)
Fills the prepared statement with a time value
|
void |
setTime(int nIndex,
Time time,
Calendar calendar)
Fills the prepared statement with a time value
|
void |
setTimestamp(int nIndex,
Timestamp ts)
Fills the prepared statement with a timestamp value
|
void |
setTimestamp(int nIndex,
Timestamp ts,
Calendar calendar)
Fills the prepared statement with a timestamp value
|
void |
setURL(int nIndex,
URL url)
Fills the prepared statement with a URL value
|
public static final String MSG_EXCEPTION_SELECT_ERROR
public DAOUtil(String sql)
sql
- Sql Query for prepared Statementpublic DAOUtil(String sql, boolean logQueries)
sql
- Sql Query for prepared Statementpublic DAOUtil(String strSQL, Plugin plugin)
strSQL
- sql query for prepared Statementplugin
- The plugin using this database accesspublic DAOUtil(String strSQL, Plugin plugin, boolean bLogQueries)
strSQL
- sql query for prepared Statementplugin
- The plugin using this database accesspublic DAOUtil(String sql, Integer autoGeneratedKeys)
sql
- Sql Query for prepared StatementautoGeneratedKeys
- a flag indicating whether auto-generated keys should
be returned; For example one of
Statement.RETURN_GENERATED_KEYS
or
Statement.NO_GENERATED_KEYS
. See
PreparedStatement#prepareStatement(String, int)
public DAOUtil(String strSQL, Integer autoGeneratedKeys, Plugin plugin)
strSQL
- sql query for prepared StatementautoGeneratedKeys
- a flag indicating whether auto-generated keys should
be returned; For example one of
Statement.RETURN_GENERATED_KEYS
or
Statement.NO_GENERATED_KEYS
. See
PreparedStatement#prepareStatement(String, int)
plugin
- The plugin using this database accesspublic DAOUtil(String strSQL, Integer autoGeneratedKeys, Plugin plugin, boolean bLogQueries)
bLogQueries
- strSQL
- sql query for prepared StatementautoGeneratedKeys
- a flag indicating whether auto-generated keys should
be returned; For example one of
Statement.RETURN_GENERATED_KEYS
or
Statement.NO_GENERATED_KEYS
. See
PreparedStatement#prepareStatement(String, int)
plugin
- The plugin using this database accesspublic void executeUpdate()
public void executeQuery()
public final void free()
public boolean isLast()
public void setDate(int nIndex, Date date)
nIndex
- parameter indexdate
- date valuepublic void setDate(int nIndex, Date date, Calendar calendar)
nIndex
- parameter indexdate
- date valuecalendar
- the calendarPreparedStatement.setDate(int, Date, Calendar)
public void setTime(int nIndex, Time time)
nIndex
- parameter indextime
- time valuepublic void setTime(int nIndex, Time time, Calendar calendar)
nIndex
- parameter indextime
- time valuecalendar
- the calendatPreparedStatement.setTime(int, Time, Calendar)
public void setBinaryStream(int nIndex, InputStream iStream, int nBlength)
nIndex
- parameter indexiStream
- the java input stream which contains the binary parameter
valuenBlength
- the number of bytes in the streampublic void setBinaryStream(int nIndex, InputStream iStream, long nBlength)
nIndex
- parameter indexiStream
- the java input stream which contains the binary parameter
valuenBlength
- the number of bytes in the streamPreparedStatement.setBinaryStream(int, InputStream, long)
public void setBinaryStream(int nIndex, InputStream iStream)
nIndex
- parameter indexiStream
- the java input stream which contains the binary parameter
valuePreparedStatement.setBinaryStream(int, InputStream)
public InputStream getBinaryStream(int nIndex)
nIndex
- column indexpublic Blob getBlob(int nIndex)
nIndex
- column indexpublic Blob getBlob(String strColumnName)
strColumnName
- column namepublic void setBlob(int nIndex, InputStream stream)
nIndex
- the indexstream
- the valuePreparedStatement.setBlob(int, InputStream)
public void setBlob(int nIndex, InputStream stream, long nLength)
nIndex
- the indexstream
- the valuenLength
- the number of bytes to readPreparedStatement.setBlob(int, InputStream, long)
public void setBlob(int nIndex, Blob blob)
nIndex
- the indexblob
- the valuePreparedStatement.setBlob(int, InputStream)
public byte[] getBytes(int nIndex)
nIndex
- column indexpublic byte[] getBytes(String strColumnName)
strColumnName
- column namepublic byte getByte(int nIndex)
nIndex
- column indexResultSet.getByte(int)
public byte getByte(String strColumnName)
strColumnName
- column nameResultSet.getByte(int)
public void setInt(int nIndex, int nValue)
nIndex
- parameter index in the prepared statementnValue
- int valuepublic void setBoolean(int nIndex, boolean bValue)
nIndex
- parameter index in the prepared statementbValue
- Boolean valuepublic void setByte(int nIndex, byte bValue)
nIndex
- parameter index in the prepared statementbValue
- byte valuePreparedStatement.setByte(int, byte)
public void setBytes(int nIndex, byte[] tbValue)
nIndex
- parameter index in the prepared statementtbValue
- byte array valuepublic void setString(int nIndex, String strValue)
nIndex
- parameter index in the prepared statementstrValue
- string valuepublic void setTimestamp(int nIndex, Timestamp ts)
nIndex
- parameter index in the prepared statementts
- timestamp valuepublic void setTimestamp(int nIndex, Timestamp ts, Calendar calendar)
nIndex
- parameter index in the prepared statementts
- timestamp valuecalendar
- the calendarPreparedStatement.setTimestamp(int, Timestamp, Calendar)
public void setDouble(int nIndex, double dValue)
nIndex
- parameter index in the prepared statementdValue
- The valuepublic void setDoubleNull(int nIndex)
nIndex
- the indexpublic Date getDate(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public Date getDate(String strColumnName)
strColumnName
- name of the column, ...public Date getDate(int nIndex, Calendar calendar)
nIndex
- the first column is 1, the second is 2, ...calendar
- the calendarResultSet.getDate(int, Calendar)
public Date getDate(String strColumnName, Calendar calendar)
strColumnName
- name of the column, ...calendar
- the calendarResultSet.getDate(String, Calendar)
public Time getTime(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public Time getTime(String strColumnName)
strColumnName
- name of the column, ...public Time getTime(int nIndex, Calendar calendar)
nIndex
- the first column is 1, the second is 2, ...calendar
- the calendarResultSet.getTime(int, Calendar)
public Time getTime(String strColumnName, Calendar calendar)
strColumnName
- name of the column, ...calendar
- the calendarResultSet.getTime(String, Calendar)
public int getInt(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public int getInt(String strColumnName)
strColumnName
- column namepublic boolean getBoolean(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public boolean getBoolean(String strColumnName)
strColumnName
- column namepublic String getString(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public String getString(String strColumnName)
strColumnName
- column namepublic Timestamp getTimestamp(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public Timestamp getTimestamp(String strColumnName)
strColumnName
- column namepublic Timestamp getTimestamp(int nIndex, Calendar calendar)
nIndex
- the first column is 1, the second is 2, ...calendar
- the calendarResultSet.getTimestamp(int, Calendar)
public Timestamp getTimestamp(String strColumnName, Calendar calendar)
strColumnName
- column namecalendar
- the calendarResultSet.getTimestamp(String, Calendar)
public double getDouble(String strColumnName)
strColumnName
- column namepublic double getDouble(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public Object getObject(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public <T> T getObject(int nIndex, Class<T> type)
T
- the return typenIndex
- the first column is 1, the second is 2, ...type
- the typeResultSet.getObject(int, Class)
public Object getObject(int nIndex, Map<String,Class<?>> map)
nIndex
- the first column is 1, the second is 2, ...map
- the type mapResultSet.getObject(int, java.util.Map)
public ResultSet getResultSet()
public ResultSet getGeneratedKeysResultSet()
public Object getObject(String strColumnName)
strColumnName
- column namepublic <T> T getObject(String strColumnName, Class<T> type)
T
- the return typestrColumnName
- column nametype
- the typeResultSet.getObject(String, Class)
public Object getObject(String strColumnName, Map<String,Class<?>> map)
strColumnName
- column namemap
- type mapResultSet.getObject(String, java.util.Map)
public boolean next()
public boolean nextGeneratedKey()
public byte getGeneratedKeyByte(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public short getGeneratedKeyShort(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public int getGeneratedKeyInt(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public long getGeneratedKeyLong(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public BigDecimal getGeneratedKeyBigDecimal(int nIndex)
nIndex
- the first column is 1, the second is 2, ...public void setIntNull(int nIndex)
nIndex
- parameter indexpublic void setLongNull(int nIndex)
nIndex
- the indexpublic void setLong(int nIndex, long lValue)
nIndex
- the indexlValue
- the valuepublic long getLong(int nIndex)
nIndex
- the indexpublic long getLong(String strColumnName)
strColumnName
- the column namepublic void setArray(int nIndex, String strTypename, Object[] elements)
nIndex
- the indexstrTypename
- the type SQL nameelements
- the array valueConnection.createArrayOf(String, Object[])
,
PreparedStatement.setArray(int, Array)
public Array getArray(int nIndex)
nIndex
- the indexResultSet.getArray(int)
public Array getArray(String strColumnName)
strColumnName
- the column nameResultSet.getArray(String)
public void setAsciiStream(int nIndex, InputStream stream)
nIndex
- the indexstream
- the streamPreparedStatement.setAsciiStream(int, InputStream)
public void setAsciiStream(int nIndex, InputStream stream, int nLength)
nIndex
- the indexstream
- the streamnLength
- the number of bytes to readPreparedStatement.setAsciiStream(int, InputStream, int)
public void setAsciiStream(int nIndex, InputStream stream, long lLength)
nIndex
- the indexstream
- the streamlLength
- the number of bytes to readPreparedStatement.setAsciiStream(int, InputStream, long)
public InputStream getAsciiString(int nIndex)
nIndex
- the indexResultSet.getAsciiStream(int)
public InputStream getAsciiString(String strColumnName)
strColumnName
- the column nameResultSet.getAsciiStream(String)
public void setBigDecimal(int nIndex, BigDecimal value)
nIndex
- the indexvalue
- the valuePreparedStatement.setBigDecimal(int, BigDecimal)
public BigDecimal getBigDecimal(int nIndex)
nIndex
- the indexResultSet.getBigDecimal(int)
public BigDecimal getBigDecimal(String strColumnName)
strColumnName
- the column nameResultSet.getBigDecimal(String)
public void setCharacterStream(int nIndex, Reader stream)
nIndex
- the indexstream
- the streamPreparedStatement.setCharacterStream(int, Reader)
public void setCharacterStream(int nIndex, Reader stream, int nLength)
nIndex
- the indexstream
- the streamnLength
- the number of bytes to readPreparedStatement.setCharacterStream(int, Reader, int)
public void setCharacterStream(int nIndex, Reader stream, long nLength)
nIndex
- the indexstream
- the streamnLength
- the number of bytes to readPreparedStatement.setCharacterStream(int, Reader, long)
public Reader getCharacterStream(int nIndex)
nIndex
- the column indexResultSet.getCharacterStream(int)
public Reader getCharacterStream(String strColumnName)
strColumnName
- the column indexResultSet.getCharacterStream(String)
public void setClob(int nIndex, Reader stream)
nIndex
- the indexstream
- the valuePreparedStatement.setClob(int, Reader)
public void setClob(int nIndex, Reader stream, long nLength)
nIndex
- the indexstream
- the valuenLength
- the number of bytes to readPreparedStatement.setClob(int, Reader, long)
public void setClob(int nIndex, Clob clob)
nIndex
- the indexclob
- the valuePreparedStatement.setClob(int, Clob)
public Clob getClob(int nIndex)
nIndex
- the column indexResultSet.getClob(int)
public Clob getClob(String strColumnName)
strColumnName
- the column indexResultSet.getClob(String)
public void setNClob(int nIndex, Reader stream)
nIndex
- the indexstream
- the valuePreparedStatement.setNClob(int, Reader)
public void setNClob(int nIndex, Reader stream, long nLength)
nIndex
- the indexstream
- the valuenLength
- the number of bytes to readPreparedStatement.setNClob(int, Reader, long)
public void setClob(int nIndex, NClob clob)
nIndex
- the indexclob
- the valuePreparedStatement.setNClob(int, NClob)
public NClob getNClob(int nIndex)
nIndex
- the column indexResultSet.getNClob(int)
public NClob getNClob(String strColumnName)
strColumnName
- the column indexResultSet.getClob(String)
public void setFloat(int nIndex, float fValue)
nIndex
- the indexfValue
- the valuePreparedStatement.setFloat(int, float)
public float getFloat(String strColumnName)
strColumnName
- the column nameResultSet.getFloat(String)
public float getFloat(int nIndex)
nIndex
- the column indexResultSet.getFloat(int)
public void setNCharacterStream(int nIndex, Reader stream)
nIndex
- the indexstream
- the streamPreparedStatement.setNCharacterStream(int, Reader)
public void setNCharacterStream(int nIndex, Reader stream, long nLength)
nIndex
- the indexstream
- the streamnLength
- the number of characters to readPreparedStatement.setNCharacterStream(int, Reader, long)
public Reader getNCharacterStream(int nIndex)
nIndex
- the indexResultSet.getNCharacterStream(int)
public Reader getNCharacterStream(String strColumnName)
strColumnName
- the column nameResultSet.getNCharacterStream(String)
public void setNString(int nIndex, String strValue)
nIndex
- the indexstrValue
- the valuePreparedStatement.setNString(int, String)
public String getNString(int nIndex)
nIndex
- the indexResultSet.getNString(int)
public String getNString(String strColumnName)
strColumnName
- the column nameResultSet.getNString(String)
public void setNull(int nIndex, int nType)
nIndex
- the indexnType
- the SQL type code defined in java.sql.TypesPreparedStatement.setNull(int, int)
public void setNull(int nIndex, int nType, String strTypeName)
nIndex
- the indexnType
- the SQL type code defined in java.sql.TypesstrTypeName
- the type namePreparedStatement.setNull(int, int, String)
public void setObject(int nIndex, Object value)
nIndex
- the indexvalue
- the valuePreparedStatement.setObject(int, Object)
public void setObject(int nIndex, Object value, int nType)
nIndex
- the indexvalue
- the valuenType
- the target SQL type (as defined in java.sql.Types)PreparedStatement.setObject(int, Object, int)
public void setObject(int nIndex, Object value, int nType, int nScaleOrLength)
nIndex
- the indexvalue
- the valuenType
- the target SQL type (as defined in java.sql.Types)nScaleOrLength
- the scale or lengthPreparedStatement.setObject(int, Object, int, int)
public Ref getRef(int nIndex)
nIndex
- the indexResultSet.getRef(int)
public Ref getRef(String strColumnName)
strColumnName
- the column nameResultSet.getRef(String)
public void setRef(int nIndex, Ref ref)
nIndex
- the indexref
- the RefPreparedStatement.setRef(int, Ref)
public void setRowId(int nIndex, RowId rowId)
nIndex
- the indexrowId
- the valuePreparedStatement.setRowId(int, RowId)
public RowId getRowId(int nIndex)
nIndex
- the indexResultSet.getRowId(int)
public RowId getRowId(String strColumnName)
strColumnName
- the column nameResultSet.getRowId(String)
public void setShort(int nIndex, short shortValue)
nIndex
- the indexshortValue
- the valuePreparedStatement.setShort(int, short)
public short getShort(String strColumnName)
strColumnName
- the column nameResultSet.getShort(String)
public short getShort(int nIndex)
nIndex
- the column indexResultSet.getShort(int)
public void setSQLXML(int nIndex, SQLXML value)
nIndex
- the indexvalue
- the valuePreparedStatement.setSQLXML(int, SQLXML)
public SQLXML getSQLXML(String strColumnName)
strColumnName
- the column nameResultSet.getSQLXML(String)
public SQLXML getSQLXML(int nIndex)
nIndex
- the column indexResultSet.getSQLXML(int)
public void setURL(int nIndex, URL url)
nIndex
- the indexurl
- the URLPreparedStatement.setURL(int, URL)
public URL getURL(String strColumnName)
strColumnName
- the column nameResultSet.getURL(String)
public URL getURL(int nIndex)
nIndex
- the column indexResultSet.getURL(int)
public void close()
close
in interface AutoCloseable
Copyright © 2020 City of Paris. All rights reserved.