br.com.sankhya.jape.sql

Class NativeSql

java.lang.Object

br.com.sankhya.jape.sql.NativeSql

public class NativeSql
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
NativeSql(JdbcWrapper conn)
NativeSql(JdbcWrapper conn, java.lang.Class baseClass, java.lang.String resourcePath)
NativeSql(JdbcWrapper jdbc, java.lang.String columns, java.lang.String tables, java.lang.String where, java.lang.Object... params)

Method Summary

Modifier and Type	Method and Description
void	addBatch()
void	addOnlyDateNamedParameter(java.lang.String... names)
void	addParameter(java.util.Collection c)
void	addParameter(java.lang.Object value)
NativeSql	appendSql(java.lang.String s)
java.util.Collection<DynamicVO>	asVOCollection(java.lang.String entityName)
java.util.Collection<DynamicVO>	asVOCollection(java.lang.String entityName, java.lang.String fieldList)
static java.util.Collection	changeToNamedParameters(java.lang.StringBuffer sql, java.lang.String paramPrefix)
void	cleanParameters()
void	doSQLComment(java.lang.String commentKey)
java.sql.ResultSet	executeQuery()
java.sql.ResultSet	executeQuery(java.lang.String sql)
java.sql.ResultSet	executeQuery(java.lang.StringBuffer sql)
java.sql.ResultSet	executeQuery(java.lang.StringBuffer sql, java.util.Collection params)
java.sql.ResultSet	executeQuery(java.lang.String sql, java.util.Collection params)
boolean	executeUpdate()
boolean	executeUpdate(java.lang.String sql)
boolean	executeUpdate(java.lang.StringBuffer sql)
boolean	executeUpdate(java.lang.StringBuffer sql, java.util.Collection params)
boolean	executeUpdate(java.lang.String sql, java.util.Collection params)
void	flushBatchTail()
static java.math.BigDecimal	getBigDecimal(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup)
static java.math.BigDecimal	getBigDecimal(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object param)
static java.math.BigDecimal	getBigDecimal(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object[] params)
static java.lang.Object	getColumnValue(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup) Deprecated.
static java.lang.Object	getColumnValue(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, JdbcWrapper jdbcWrapper) Deprecated.
static java.lang.Object	getColumnValue(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object[] params) Deprecated.
static java.lang.Object	getColumnValue(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object[] params, JdbcWrapper jdbcWrapper) Deprecated.
JdbcWrapper	getConn()
int	getLastUpdateCount()
java.lang.StringBuffer	getSqlBuf()
static java.lang.String	getString(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup)
static java.lang.String	getString(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object param)
static java.lang.String	getString(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object[] params)
static java.lang.StringBuffer	getStringBufferSQLFromResource(java.lang.Class baseClass, java.lang.String resourcePath)
static java.sql.Timestamp	getTimestamp(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup)
static java.sql.Timestamp	getTimestamp(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object param)
static java.sql.Timestamp	getTimestamp(java.lang.String columnName, java.lang.String table, java.lang.String whereOrderGroup, java.lang.Object[] params)
java.lang.Object	getValueParameter(int index)
java.lang.Object	getValueParameter(java.lang.String name)
boolean	isScrollableResult()
void	loadSql(java.lang.Class baseClass, java.lang.String resourcePath)
static java.lang.String	loadSQLFromResource(java.lang.Class baseClass, java.lang.String resourcePath)
void	logNamedParameters()
static java.lang.String	normalizeQuery(java.lang.StringBuffer sql)
static void	releaseResources(java.util.Collection<NativeSql> querys)
static void	releaseResources(NativeSql o)
void	removeSQLBlock(java.lang.String commentKey)
static void	removeSQLBlock(java.lang.StringBuffer sqlBuf, java.lang.String commentKey)
void	removeSQLComment(java.lang.String commentKey)
void	replaceSQLComment(java.lang.String commentKey, java.lang.String toReplace)
void	resetSqlBuf()
void	setBatchUpdateSize(int batchUpdateSize)
void	setFetchSize(int fetchSize)
void	setFillNamedParametersWithNull(boolean value)
void	setIdStatementFromCache(java.lang.String id)
void	setMaxRows(int maxRows)
void	setNamedParameter(java.lang.String name, java.lang.Object value)
void	setParameter(int index, java.lang.Object value)
static void	setParametersStatement(java.sql.PreparedStatement pstm, java.util.Collection finalParametersList)
void	setReuseStatements(boolean b)
void	setScrollableResult(boolean scrollableResult)
java.lang.String	toString()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

NativeSql

public NativeSql(JdbcWrapper conn)

NativeSql

public NativeSql(JdbcWrapper conn,
                 java.lang.Class baseClass,
                 java.lang.String resourcePath)
          throws java.lang.Exception

Throws:

java.lang.Exception

NativeSql

public NativeSql(JdbcWrapper jdbc,
                 java.lang.String columns,
                 java.lang.String tables,
                 java.lang.String where,
                 java.lang.Object... params)
          throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

addParameter

public void addParameter(java.lang.Object value)

addParameter

public void addParameter(java.util.Collection c)

logNamedParameters

public void logNamedParameters()

cleanParameters

public void cleanParameters()

addOnlyDateNamedParameter

public void addOnlyDateNamedParameter(java.lang.String... names)

executeQuery

public java.sql.ResultSet executeQuery(java.lang.StringBuffer sql,
                                       java.util.Collection params)
                                throws java.lang.Exception

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.lang.StringBuffer sql)
                                throws java.lang.Exception

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.lang.Exception

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.lang.Exception

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql,
                                       java.util.Collection params)
                                throws java.lang.Exception

Throws:

java.lang.Exception

setFetchSize

public void setFetchSize(int fetchSize)

setMaxRows

public void setMaxRows(int maxRows)

setParametersStatement

public static void setParametersStatement(java.sql.PreparedStatement pstm,
                                          java.util.Collection finalParametersList)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

normalizeQuery

public static java.lang.String normalizeQuery(java.lang.StringBuffer sql)

getLastUpdateCount

public int getLastUpdateCount()

executeUpdate

public boolean executeUpdate(java.lang.String sql)
                      throws java.lang.Exception

Throws:

java.lang.Exception

executeUpdate

public boolean executeUpdate()
                      throws java.lang.Exception

Throws:

java.lang.Exception

addBatch

public void addBatch()
              throws java.lang.Exception

Throws:

java.lang.Exception

flushBatchTail

public void flushBatchTail()
                    throws java.lang.Exception

Throws:

java.lang.Exception

executeUpdate

public boolean executeUpdate(java.lang.StringBuffer sql)
                      throws java.lang.Exception

Throws:

java.lang.Exception

executeUpdate

public boolean executeUpdate(java.lang.StringBuffer sql,
                             java.util.Collection params)
                      throws java.lang.Exception

Throws:

java.lang.Exception

executeUpdate

public boolean executeUpdate(java.lang.String sql,
                             java.util.Collection params)
                      throws java.lang.Exception

Throws:

java.lang.Exception

releaseResources

public static void releaseResources(java.util.Collection<NativeSql> querys)

releaseResources

public static void releaseResources(NativeSql o)

appendSql

public NativeSql appendSql(java.lang.String s)

getSqlBuf

public java.lang.StringBuffer getSqlBuf()

isScrollableResult

public boolean isScrollableResult()

getStringBufferSQLFromResource

public static java.lang.StringBuffer getStringBufferSQLFromResource(java.lang.Class baseClass,
                                                                    java.lang.String resourcePath)
                                                             throws java.lang.Exception

Throws:

java.lang.Exception

loadSQLFromResource

public static java.lang.String loadSQLFromResource(java.lang.Class baseClass,
                                                   java.lang.String resourcePath)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

loadSql

public void loadSql(java.lang.Class baseClass,
                    java.lang.String resourcePath)
             throws java.lang.Exception

Throws:

java.lang.Exception

removeSQLComment

public void removeSQLComment(java.lang.String commentKey)

replaceSQLComment

public void replaceSQLComment(java.lang.String commentKey,
                              java.lang.String toReplace)

doSQLComment

public void doSQLComment(java.lang.String commentKey)

removeSQLBlock

public void removeSQLBlock(java.lang.String commentKey)

removeSQLBlock

public static void removeSQLBlock(java.lang.StringBuffer sqlBuf,
                                  java.lang.String commentKey)

resetSqlBuf

public void resetSqlBuf()

setNamedParameter

public void setNamedParameter(java.lang.String name,
                              java.lang.Object value)

getValueParameter

public java.lang.Object getValueParameter(java.lang.String name)

setParameter

public void setParameter(int index,
                         java.lang.Object value)

getValueParameter

public java.lang.Object getValueParameter(int index)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

setReuseStatements

public void setReuseStatements(boolean b)

setScrollableResult

public void setScrollableResult(boolean scrollableResult)

setFillNamedParametersWithNull

public void setFillNamedParametersWithNull(boolean value)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

changeToNamedParameters

public static java.util.Collection changeToNamedParameters(java.lang.StringBuffer sql,
                                                           java.lang.String paramPrefix)

getConn

public JdbcWrapper getConn()

setBatchUpdateSize

public void setBatchUpdateSize(int batchUpdateSize)

setIdStatementFromCache

public void setIdStatementFromCache(java.lang.String id)

getBigDecimal

public static java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                                 java.lang.String table,
                                                 java.lang.String whereOrderGroup,
                                                 java.lang.Object[] params)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

getBigDecimal

public static java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                                 java.lang.String table,
                                                 java.lang.String whereOrderGroup,
                                                 java.lang.Object param)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

getBigDecimal

public static java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                                 java.lang.String table,
                                                 java.lang.String whereOrderGroup)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

getString

public static java.lang.String getString(java.lang.String columnName,
                                         java.lang.String table,
                                         java.lang.String whereOrderGroup,
                                         java.lang.Object[] params)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getString

public static java.lang.String getString(java.lang.String columnName,
                                         java.lang.String table,
                                         java.lang.String whereOrderGroup,
                                         java.lang.Object param)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getString

public static java.lang.String getString(java.lang.String columnName,
                                         java.lang.String table,
                                         java.lang.String whereOrderGroup)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getTimestamp

public static java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                              java.lang.String table,
                                              java.lang.String whereOrderGroup,
                                              java.lang.Object[] params)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

getTimestamp

public static java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                              java.lang.String table,
                                              java.lang.String whereOrderGroup,
                                              java.lang.Object param)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

getTimestamp

public static java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                              java.lang.String table,
                                              java.lang.String whereOrderGroup)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

getColumnValue

@Deprecated
public static java.lang.Object getColumnValue(java.lang.String columnName,
                                                           java.lang.String table,
                                                           java.lang.String whereOrderGroup,
                                                           JdbcWrapper jdbcWrapper)
                                                    throws java.lang.Exception

Deprecated.

Use: getBigDecimal(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getString(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getTimestamp(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[])

Throws:

java.lang.Exception

getColumnValue

@Deprecated
public static java.lang.Object getColumnValue(java.lang.String columnName,
                                                           java.lang.String table,
                                                           java.lang.String whereOrderGroup,
                                                           java.lang.Object[] params)
                                                    throws java.lang.Exception

Deprecated.

Use: getBigDecimal(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getString(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getTimestamp(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[])

Throws:

java.lang.Exception

getColumnValue

@Deprecated
public static java.lang.Object getColumnValue(java.lang.String columnName,
                                                           java.lang.String table,
                                                           java.lang.String whereOrderGroup)
                                                    throws java.lang.Exception

Deprecated.

Use: getBigDecimal(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getString(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getTimestamp(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[])

Throws:

java.lang.Exception

getColumnValue

@Deprecated
public static java.lang.Object getColumnValue(java.lang.String columnName,
                                                           java.lang.String table,
                                                           java.lang.String whereOrderGroup,
                                                           java.lang.Object[] params,
                                                           JdbcWrapper jdbcWrapper)
                                                    throws java.lang.Exception

Deprecated.

Use: getBigDecimal(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getString(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[]) or getTimestamp(java.lang.String, java.lang.String, java.lang.String, java.lang.Object[])

Throws:

java.lang.Exception

asVOCollection

public java.util.Collection<DynamicVO> asVOCollection(java.lang.String entityName,
                                                      java.lang.String fieldList)
                                               throws java.lang.Exception

Parameters:

entityName - Nome da Entidade para instanciar os VOs

fieldList - Lista de Campos (separados por virgula) para preencher no VO, todos devem estar presentes no SQL.

Returns:

Retorna uma Collection de VOs encontrados pelo SQL, apenas com os campos da lista preenchidos e ligações linkadas

Throws:

java.lang.Exception

asVOCollection

public java.util.Collection<DynamicVO> asVOCollection(java.lang.String entityName)
                                               throws java.lang.Exception

Parameters:

entityName - Nome da Entidade para instanciar os VOs

Returns:

Retorna uma Collection de VOs encontrados pelo SQL, apenas campos persistentes.

Throws:

java.lang.Exception