public class NativeSql
extends java.lang.Object
| 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) |
| 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() |
public NativeSql(JdbcWrapper conn)
public NativeSql(JdbcWrapper conn, java.lang.Class baseClass, java.lang.String resourcePath) throws java.lang.Exception
java.lang.Exceptionpublic NativeSql(JdbcWrapper jdbc, java.lang.String columns, java.lang.String tables, java.lang.String where, java.lang.Object... params) throws java.lang.Exception
java.lang.Exceptionpublic java.lang.String toString()
toString in class java.lang.Objectpublic void addParameter(java.lang.Object value)
public void addParameter(java.util.Collection c)
public void logNamedParameters()
public void cleanParameters()
public void addOnlyDateNamedParameter(java.lang.String... names)
public java.sql.ResultSet executeQuery(java.lang.StringBuffer sql,
java.util.Collection params)
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.ResultSet executeQuery(java.lang.StringBuffer sql)
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.ResultSet executeQuery(java.lang.String sql)
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.ResultSet executeQuery()
throws java.lang.Exception
java.lang.Exceptionpublic java.sql.ResultSet executeQuery(java.lang.String sql,
java.util.Collection params)
throws java.lang.Exception
java.lang.Exceptionpublic void setFetchSize(int fetchSize)
public void setMaxRows(int maxRows)
public static void setParametersStatement(java.sql.PreparedStatement pstm,
java.util.Collection finalParametersList)
throws java.sql.SQLException
java.sql.SQLExceptionpublic static java.lang.String normalizeQuery(java.lang.StringBuffer sql)
public int getLastUpdateCount()
public boolean executeUpdate(java.lang.String sql)
throws java.lang.Exception
java.lang.Exceptionpublic boolean executeUpdate()
throws java.lang.Exception
java.lang.Exceptionpublic void addBatch()
throws java.lang.Exception
java.lang.Exceptionpublic void flushBatchTail()
throws java.lang.Exception
java.lang.Exceptionpublic boolean executeUpdate(java.lang.StringBuffer sql)
throws java.lang.Exception
java.lang.Exceptionpublic boolean executeUpdate(java.lang.StringBuffer sql,
java.util.Collection params)
throws java.lang.Exception
java.lang.Exceptionpublic boolean executeUpdate(java.lang.String sql,
java.util.Collection params)
throws java.lang.Exception
java.lang.Exceptionpublic static void releaseResources(java.util.Collection<NativeSql> querys)
public static void releaseResources(NativeSql o)
public NativeSql appendSql(java.lang.String s)
public java.lang.StringBuffer getSqlBuf()
public boolean isScrollableResult()
public static java.lang.StringBuffer getStringBufferSQLFromResource(java.lang.Class baseClass,
java.lang.String resourcePath)
throws java.lang.Exception
java.lang.Exceptionpublic static java.lang.String loadSQLFromResource(java.lang.Class baseClass,
java.lang.String resourcePath)
throws java.lang.Exception
java.lang.Exceptionpublic void loadSql(java.lang.Class baseClass,
java.lang.String resourcePath)
throws java.lang.Exception
java.lang.Exceptionpublic void removeSQLComment(java.lang.String commentKey)
public void replaceSQLComment(java.lang.String commentKey,
java.lang.String toReplace)
public void doSQLComment(java.lang.String commentKey)
public void removeSQLBlock(java.lang.String commentKey)
public static void removeSQLBlock(java.lang.StringBuffer sqlBuf,
java.lang.String commentKey)
public void resetSqlBuf()
public void setNamedParameter(java.lang.String name,
java.lang.Object value)
public java.lang.Object getValueParameter(java.lang.String name)
public void setParameter(int index,
java.lang.Object value)
public java.lang.Object getValueParameter(int index)
throws java.lang.Exception
java.lang.Exceptionpublic void setReuseStatements(boolean b)
public void setScrollableResult(boolean scrollableResult)
public void setFillNamedParametersWithNull(boolean value)
throws java.lang.Exception
java.lang.Exceptionpublic static java.util.Collection changeToNamedParameters(java.lang.StringBuffer sql,
java.lang.String paramPrefix)
public JdbcWrapper getConn()
public void setBatchUpdateSize(int batchUpdateSize)
public void setIdStatementFromCache(java.lang.String id)
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
java.lang.Exceptionpublic 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
java.lang.Exceptionpublic static java.math.BigDecimal getBigDecimal(java.lang.String columnName,
java.lang.String table,
java.lang.String whereOrderGroup)
throws java.lang.Exception
java.lang.Exceptionpublic 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
java.lang.Exceptionpublic 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
java.lang.Exceptionpublic static java.lang.String getString(java.lang.String columnName,
java.lang.String table,
java.lang.String whereOrderGroup)
throws java.lang.Exception
java.lang.Exceptionpublic 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
java.lang.Exceptionpublic 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
java.lang.Exceptionpublic static java.sql.Timestamp getTimestamp(java.lang.String columnName,
java.lang.String table,
java.lang.String whereOrderGroup)
throws java.lang.Exception
java.lang.Exception@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
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[])java.lang.Exception@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
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[])java.lang.Exception@Deprecated
public static java.lang.Object getColumnValue(java.lang.String columnName,
java.lang.String table,
java.lang.String whereOrderGroup)
throws java.lang.Exception
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[])java.lang.Exception@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
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[])java.lang.Exceptionpublic java.util.Collection<DynamicVO> asVOCollection(java.lang.String entityName, java.lang.String fieldList) throws java.lang.Exception
entityName - Nome da Entidade para instanciar os VOsfieldList - Lista de Campos (separados por virgula) para preencher no VO, todos devem estar presentes no SQL.java.lang.Exceptionpublic java.util.Collection<DynamicVO> asVOCollection(java.lang.String entityName) throws java.lang.Exception
entityName - Nome da Entidade para instanciar os VOsjava.lang.Exception