org.equanda.reporting.driver
Class EquandaPreparedStatement
java.lang.Object
org.equanda.reporting.driver.EquandaPreparedStatement
- All Implemented Interfaces:
- PreparedStatement, Statement
public class EquandaPreparedStatement
- extends Object
- implements PreparedStatement
Implementation of java.sql.PreparedStatement used by jasper reports
- Author:
- NetRom team, Joachim Van der Auwera
Method Summary |
void |
addBatch()
|
void |
addBatch(String s)
|
void |
cancel()
|
void |
clearBatch()
|
void |
clearParameters()
|
void |
clearWarnings()
|
void |
close()
|
boolean |
execute()
|
boolean |
execute(String s)
|
boolean |
execute(String s,
int i)
|
boolean |
execute(String s,
int[] ints)
|
boolean |
execute(String s,
String[] strings)
|
int[] |
executeBatch()
|
ResultSet |
executeQuery()
|
ResultSet |
executeQuery(String q)
|
int |
executeUpdate()
|
int |
executeUpdate(String s)
|
int |
executeUpdate(String s,
int i)
|
int |
executeUpdate(String s,
int[] ints)
|
int |
executeUpdate(String s,
String[] strings)
|
Connection |
getConnection()
|
int |
getFetchDirection()
|
int |
getFetchSize()
|
ResultSet |
getGeneratedKeys()
|
int |
getMaxFieldSize()
|
int |
getMaxRows()
|
ResultSetMetaData |
getMetaData()
|
boolean |
getMoreResults()
|
boolean |
getMoreResults(int i)
|
ParameterMetaData |
getParameterMetaData()
|
int |
getQueryTimeout()
|
ResultSet |
getResultSet()
|
int |
getResultSetConcurrency()
|
int |
getResultSetHoldability()
|
int |
getResultSetType()
|
int |
getUpdateCount()
|
SQLWarning |
getWarnings()
|
void |
setArray(int i,
Array array)
|
void |
setAsciiStream(int i,
InputStream inputStream,
int i1)
|
void |
setBigDecimal(int i,
BigDecimal bigDecimal)
|
void |
setBinaryStream(int i,
InputStream inputStream,
int i1)
|
void |
setBlob(int i,
Blob blob)
|
void |
setBoolean(int i,
boolean b)
|
void |
setByte(int i,
byte b)
|
void |
setBytes(int i,
byte[] bytes)
|
void |
setCharacterStream(int i,
Reader reader,
int i1)
|
void |
setClob(int i,
Clob clob)
|
void |
setCursorName(String s)
|
void |
setDate(int i,
Date date)
|
void |
setDate(int i,
Date date,
Calendar calendar)
|
void |
setDouble(int i,
double v)
|
void |
setEscapeProcessing(boolean b)
|
void |
setFetchDirection(int i)
|
void |
setFetchSize(int i)
|
void |
setFloat(int i,
float v)
|
void |
setInt(int i,
int i1)
|
void |
setLong(int i,
long l)
|
void |
setMaxFieldSize(int i)
|
void |
setMaxRows(int i)
|
void |
setNull(int i,
int i1)
|
void |
setNull(int i,
int i1,
String s)
|
void |
setObject(int i,
Object o)
|
void |
setObject(int i,
Object o,
int i1)
|
void |
setObject(int i,
Object o,
int i1,
int i2)
|
void |
setQueryTimeout(int i)
|
void |
setRef(int i,
Ref ref)
|
void |
setShort(int i,
short i1)
|
void |
setString(int i,
String s)
|
void |
setTime(int i,
Time time)
|
void |
setTime(int i,
Time time,
Calendar calendar)
|
void |
setTimestamp(int i,
Timestamp timestamp)
|
void |
setTimestamp(int i,
Timestamp timestamp,
Calendar calendar)
|
void |
setUnicodeStream(int i,
InputStream inputStream,
int i1)
Deprecated. |
void |
setURL(int i,
URL url)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
EquandaPreparedStatement
public EquandaPreparedStatement(ReporterEJB bean,
String query)
throws SQLException
- Throws:
SQLException
executeQuery
public ResultSet executeQuery()
throws SQLException
- Specified by:
executeQuery
in interface PreparedStatement
- Throws:
SQLException
close
public void close()
throws SQLException
- Specified by:
close
in interface Statement
- Throws:
SQLException
setInt
public void setInt(int i,
int i1)
throws SQLException
- Specified by:
setInt
in interface PreparedStatement
- Throws:
SQLException
setDouble
public void setDouble(int i,
double v)
throws SQLException
- Specified by:
setDouble
in interface PreparedStatement
- Throws:
SQLException
setNull
public void setNull(int i,
int i1)
throws SQLException
- Specified by:
setNull
in interface PreparedStatement
- Throws:
SQLException
setString
public void setString(int i,
String s)
throws SQLException
- Specified by:
setString
in interface PreparedStatement
- Throws:
SQLException
setBoolean
public void setBoolean(int i,
boolean b)
throws SQLException
- Specified by:
setBoolean
in interface PreparedStatement
- Throws:
SQLException
setDate
public void setDate(int i,
Date date)
throws SQLException
- Specified by:
setDate
in interface PreparedStatement
- Throws:
SQLException
setTimestamp
public void setTimestamp(int i,
Timestamp timestamp)
throws SQLException
- Specified by:
setTimestamp
in interface PreparedStatement
- Throws:
SQLException
executeQuery
public ResultSet executeQuery(String q)
throws SQLException
- Specified by:
executeQuery
in interface Statement
- Throws:
SQLException
executeUpdate
public int executeUpdate()
throws SQLException
- Specified by:
executeUpdate
in interface PreparedStatement
- Throws:
SQLException
setNull
public void setNull(int i,
int i1,
String s)
throws SQLException
- Specified by:
setNull
in interface PreparedStatement
- Throws:
SQLException
addBatch
public void addBatch()
throws SQLException
- Specified by:
addBatch
in interface PreparedStatement
- Throws:
SQLException
clearParameters
public void clearParameters()
throws SQLException
- Specified by:
clearParameters
in interface PreparedStatement
- Throws:
SQLException
execute
public boolean execute()
throws SQLException
- Specified by:
execute
in interface PreparedStatement
- Throws:
SQLException
setByte
public void setByte(int i,
byte b)
throws SQLException
- Specified by:
setByte
in interface PreparedStatement
- Throws:
SQLException
setFloat
public void setFloat(int i,
float v)
throws SQLException
- Specified by:
setFloat
in interface PreparedStatement
- Throws:
SQLException
setLong
public void setLong(int i,
long l)
throws SQLException
- Specified by:
setLong
in interface PreparedStatement
- Throws:
SQLException
setShort
public void setShort(int i,
short i1)
throws SQLException
- Specified by:
setShort
in interface PreparedStatement
- Throws:
SQLException
setBytes
public void setBytes(int i,
byte[] bytes)
throws SQLException
- Specified by:
setBytes
in interface PreparedStatement
- Throws:
SQLException
setAsciiStream
public void setAsciiStream(int i,
InputStream inputStream,
int i1)
throws SQLException
- Specified by:
setAsciiStream
in interface PreparedStatement
- Throws:
SQLException
setBinaryStream
public void setBinaryStream(int i,
InputStream inputStream,
int i1)
throws SQLException
- Specified by:
setBinaryStream
in interface PreparedStatement
- Throws:
SQLException
setUnicodeStream
public void setUnicodeStream(int i,
InputStream inputStream,
int i1)
throws SQLException
- Deprecated.
- Specified by:
setUnicodeStream
in interface PreparedStatement
- Throws:
SQLException
setCharacterStream
public void setCharacterStream(int i,
Reader reader,
int i1)
throws SQLException
- Specified by:
setCharacterStream
in interface PreparedStatement
- Throws:
SQLException
setObject
public void setObject(int i,
Object o)
throws SQLException
- Specified by:
setObject
in interface PreparedStatement
- Throws:
SQLException
setObject
public void setObject(int i,
Object o,
int i1)
throws SQLException
- Specified by:
setObject
in interface PreparedStatement
- Throws:
SQLException
setObject
public void setObject(int i,
Object o,
int i1,
int i2)
throws SQLException
- Specified by:
setObject
in interface PreparedStatement
- Throws:
SQLException
setBigDecimal
public void setBigDecimal(int i,
BigDecimal bigDecimal)
throws SQLException
- Specified by:
setBigDecimal
in interface PreparedStatement
- Throws:
SQLException
setURL
public void setURL(int i,
URL url)
throws SQLException
- Specified by:
setURL
in interface PreparedStatement
- Throws:
SQLException
setArray
public void setArray(int i,
Array array)
throws SQLException
- Specified by:
setArray
in interface PreparedStatement
- Throws:
SQLException
setBlob
public void setBlob(int i,
Blob blob)
throws SQLException
- Specified by:
setBlob
in interface PreparedStatement
- Throws:
SQLException
setClob
public void setClob(int i,
Clob clob)
throws SQLException
- Specified by:
setClob
in interface PreparedStatement
- Throws:
SQLException
getParameterMetaData
public ParameterMetaData getParameterMetaData()
throws SQLException
- Specified by:
getParameterMetaData
in interface PreparedStatement
- Throws:
SQLException
setRef
public void setRef(int i,
Ref ref)
throws SQLException
- Specified by:
setRef
in interface PreparedStatement
- Throws:
SQLException
getMetaData
public ResultSetMetaData getMetaData()
throws SQLException
- Specified by:
getMetaData
in interface PreparedStatement
- Throws:
SQLException
setTime
public void setTime(int i,
Time time)
throws SQLException
- Specified by:
setTime
in interface PreparedStatement
- Throws:
SQLException
setDate
public void setDate(int i,
Date date,
Calendar calendar)
throws SQLException
- Specified by:
setDate
in interface PreparedStatement
- Throws:
SQLException
setTime
public void setTime(int i,
Time time,
Calendar calendar)
throws SQLException
- Specified by:
setTime
in interface PreparedStatement
- Throws:
SQLException
setTimestamp
public void setTimestamp(int i,
Timestamp timestamp,
Calendar calendar)
throws SQLException
- Specified by:
setTimestamp
in interface PreparedStatement
- Throws:
SQLException
getFetchDirection
public int getFetchDirection()
throws SQLException
- Specified by:
getFetchDirection
in interface Statement
- Throws:
SQLException
getFetchSize
public int getFetchSize()
throws SQLException
- Specified by:
getFetchSize
in interface Statement
- Throws:
SQLException
getMaxFieldSize
public int getMaxFieldSize()
throws SQLException
- Specified by:
getMaxFieldSize
in interface Statement
- Throws:
SQLException
getMaxRows
public int getMaxRows()
throws SQLException
- Specified by:
getMaxRows
in interface Statement
- Throws:
SQLException
getQueryTimeout
public int getQueryTimeout()
throws SQLException
- Specified by:
getQueryTimeout
in interface Statement
- Throws:
SQLException
getResultSetConcurrency
public int getResultSetConcurrency()
throws SQLException
- Specified by:
getResultSetConcurrency
in interface Statement
- Throws:
SQLException
getResultSetHoldability
public int getResultSetHoldability()
throws SQLException
- Specified by:
getResultSetHoldability
in interface Statement
- Throws:
SQLException
getResultSetType
public int getResultSetType()
throws SQLException
- Specified by:
getResultSetType
in interface Statement
- Throws:
SQLException
getUpdateCount
public int getUpdateCount()
throws SQLException
- Specified by:
getUpdateCount
in interface Statement
- Throws:
SQLException
cancel
public void cancel()
throws SQLException
- Specified by:
cancel
in interface Statement
- Throws:
SQLException
clearBatch
public void clearBatch()
throws SQLException
- Specified by:
clearBatch
in interface Statement
- Throws:
SQLException
clearWarnings
public void clearWarnings()
throws SQLException
- Specified by:
clearWarnings
in interface Statement
- Throws:
SQLException
getMoreResults
public boolean getMoreResults()
throws SQLException
- Specified by:
getMoreResults
in interface Statement
- Throws:
SQLException
executeBatch
public int[] executeBatch()
throws SQLException
- Specified by:
executeBatch
in interface Statement
- Throws:
SQLException
setFetchDirection
public void setFetchDirection(int i)
throws SQLException
- Specified by:
setFetchDirection
in interface Statement
- Throws:
SQLException
setFetchSize
public void setFetchSize(int i)
throws SQLException
- Specified by:
setFetchSize
in interface Statement
- Throws:
SQLException
setMaxFieldSize
public void setMaxFieldSize(int i)
throws SQLException
- Specified by:
setMaxFieldSize
in interface Statement
- Throws:
SQLException
setMaxRows
public void setMaxRows(int i)
throws SQLException
- Specified by:
setMaxRows
in interface Statement
- Throws:
SQLException
setQueryTimeout
public void setQueryTimeout(int i)
throws SQLException
- Specified by:
setQueryTimeout
in interface Statement
- Throws:
SQLException
getMoreResults
public boolean getMoreResults(int i)
throws SQLException
- Specified by:
getMoreResults
in interface Statement
- Throws:
SQLException
setEscapeProcessing
public void setEscapeProcessing(boolean b)
throws SQLException
- Specified by:
setEscapeProcessing
in interface Statement
- Throws:
SQLException
executeUpdate
public int executeUpdate(String s)
throws SQLException
- Specified by:
executeUpdate
in interface Statement
- Throws:
SQLException
addBatch
public void addBatch(String s)
throws SQLException
- Specified by:
addBatch
in interface Statement
- Throws:
SQLException
setCursorName
public void setCursorName(String s)
throws SQLException
- Specified by:
setCursorName
in interface Statement
- Throws:
SQLException
execute
public boolean execute(String s)
throws SQLException
- Specified by:
execute
in interface Statement
- Throws:
SQLException
executeUpdate
public int executeUpdate(String s,
int i)
throws SQLException
- Specified by:
executeUpdate
in interface Statement
- Throws:
SQLException
execute
public boolean execute(String s,
int i)
throws SQLException
- Specified by:
execute
in interface Statement
- Throws:
SQLException
executeUpdate
public int executeUpdate(String s,
int[] ints)
throws SQLException
- Specified by:
executeUpdate
in interface Statement
- Throws:
SQLException
execute
public boolean execute(String s,
int[] ints)
throws SQLException
- Specified by:
execute
in interface Statement
- Throws:
SQLException
getConnection
public Connection getConnection()
throws SQLException
- Specified by:
getConnection
in interface Statement
- Throws:
SQLException
getGeneratedKeys
public ResultSet getGeneratedKeys()
throws SQLException
- Specified by:
getGeneratedKeys
in interface Statement
- Throws:
SQLException
getResultSet
public ResultSet getResultSet()
throws SQLException
- Specified by:
getResultSet
in interface Statement
- Throws:
SQLException
getWarnings
public SQLWarning getWarnings()
throws SQLException
- Specified by:
getWarnings
in interface Statement
- Throws:
SQLException
executeUpdate
public int executeUpdate(String s,
String[] strings)
throws SQLException
- Specified by:
executeUpdate
in interface Statement
- Throws:
SQLException
execute
public boolean execute(String s,
String[] strings)
throws SQLException
- Specified by:
execute
in interface Statement
- Throws:
SQLException
Copyright © 2007-2009. All Rights Reserved.