Modifier and Type | Method and Description |
---|---|
static String |
CacheHandlerFactory.createId(SQL sql,
String datasource,
String username,
String password) |
Modifier and Type | Class and Description |
---|---|
class |
SQLImpl
represents a SQL Statement with his defined arguments for a prepared statement
|
Modifier and Type | Method and Description |
---|---|
SQL |
SQLImpl.duplicate() |
static SQL |
SQLImpl.duplicate(SQL sql) |
Modifier and Type | Method and Description |
---|---|
static QueryImpl |
HSQLDBHandler.__execute(PageContext pc,
SQL sql,
int maxrows,
int fetchsize,
TimeSpan timeout,
Stopwatch stopwatch,
Set<String> tables,
boolean doSimpleTypes) |
static SQL |
SQLImpl.duplicate(SQL sql) |
Query |
QoQ.execute(PageContext pc,
SQL sql,
int maxrows) |
Query |
HSQLDBHandler.execute(PageContext pc,
SQL sql,
int maxrows,
int fetchsize,
TimeSpan timeout)
executes a query on the queries inside the cld fusion enviroment
|
Query |
QoQ.execute(PageContext pc,
SQL sql,
Selects selects,
int maxrows)
execute a SQL Statement against CFML Scopes
|
Query |
Executer.execute(PageContext pc,
SQL sql,
String prettySQL,
int maxrows) |
Query |
Executer.execute(Vector statements,
PageContext pc,
SQL sql,
int maxrows)
execute a SQL Statement against CFML Scopes
|
PreparedStatement |
DatasourceConnectionImpl.getPreparedStatement(SQL sql,
boolean createGeneratedKeys,
boolean allowCaching) |
PreparedStatement |
DatasourceConnection.getPreparedStatement(SQL sql,
boolean createGeneratedKeys,
boolean allowCaching) |
PreparedStatement |
DatasourceConnectionImpl.getPreparedStatement(SQL sql,
int resultSetType,
int resultSetConcurrency) |
PreparedStatement |
DatasourceConnection.getPreparedStatement(SQL sql,
int resultSetType,
int resultSetConcurrency) |
static boolean |
LikeCompare.like(SQL sql,
String haystack,
String needle) |
static boolean |
LikeCompare.like(SQL sql,
String haystack,
String needle,
String escape) |
Constructor and Description |
---|
HSQLUtil2(SQL sql) |
Modifier and Type | Method and Description |
---|---|
SQL |
QueryEntryImpl.getSQL() |
SQL |
QueryEntry.getSQL() |
Modifier and Type | Method and Description |
---|---|
void |
DebuggerPro.addQuery(Query query,
String datasource,
String name,
SQL sql,
int recordcount,
PageSource src,
int time)
Deprecated.
use instead
addQuery(Query query,String datasource,String name,SQL sql, int recordcount, PageSource src,long time) |
void |
DebuggerImpl.addQuery(Query query,
String datasource,
String name,
SQL sql,
int recordcount,
PageSource src,
int time) |
void |
Debugger.addQuery(Query query,
String datasource,
String name,
SQL sql,
int recordcount,
PageSource src,
int time)
add new query execution time
|
void |
DebuggerPro.addQuery(Query query,
String datasource,
String name,
SQL sql,
int recordcount,
PageSource src,
long time)
add new query execution time
|
void |
DebuggerImpl.addQuery(Query query,
String datasource,
String name,
SQL sql,
int recordcount,
PageSource src,
long time) |
Constructor and Description |
---|
QueryEntryImpl(Query qry,
String datasource,
String name,
SQL sql,
int recordcount,
String src,
long exe)
constructor of the class
|
Constructor and Description |
---|
DatabaseException(SQLException sqle,
SQL sql,
DatasourceConnection dc)
Constructor of the class
|
DatabaseException(String message,
String detail,
SQL sql,
DatasourceConnection dc) |
Modifier and Type | Method and Description |
---|---|
PageException |
ExceptonImpl.createDatabaseException(String message,
SQL sql) |
Query |
CreationImpl.createQuery(DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
int timeout,
String name) |
Query |
CreationImpl.createQuery(DatasourceConnection dc,
SQL sql,
int maxrow,
String name) |
Modifier and Type | Method and Description |
---|---|
PreparedStatement |
ORMDatasourceConnection.getPreparedStatement(SQL sql,
boolean createGeneratedKeys,
boolean allowCaching) |
PreparedStatement |
ORMDatasourceConnection.getPreparedStatement(SQL sql,
int resultSetType,
int resultSetConcurrency) |
Modifier and Type | Method and Description |
---|---|
Object |
QueryCache.get(PageContext pc,
SQL sql,
String datasource,
String username,
String password,
Date cachedafter) |
Query |
QueryCache.getQuery(PageContext pc,
SQL sql,
String datasource,
String username,
String password,
Date cacheAfter)
returns a Query from Query Cache or null if no match found
|
void |
QueryCache.remove(PageContext pc,
SQL sql,
String datasource,
String username,
String password)
removes query from cache
|
void |
QueryCache.set(PageContext pc,
SQL sql,
String datasource,
String username,
String password,
Object value,
Date cacheBefore)
sets a Query to Cache
|
Modifier and Type | Method and Description |
---|---|
static SQL |
QueryParamConverter.convert(String sql,
Argument params) |
static SQL |
QueryParamConverter.convert(String sql,
Array params) |
static SQL |
QueryParamConverter.convert(String sql,
Struct params) |
Modifier and Type | Method and Description |
---|---|
SQL |
QueryImpl.getSql() |
SQL |
Query.getSql() |
Modifier and Type | Method and Description |
---|---|
void |
QueryImpl.setSql(SQL sql) |
Constructor and Description |
---|
QueryImpl(PageContext pc,
DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
TimeSpan timeout,
String name)
constructor of the class, to generate a resultset from a sql query
|
QueryImpl(PageContext pc,
DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
TimeSpan timeout,
String name,
String template) |
QueryImpl(PageContext pc,
DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
TimeSpan timeout,
String name,
String template,
boolean createUpdateData,
boolean allowToCachePreperadeStatement) |
Modifier and Type | Method and Description |
---|---|
SQL |
SimpleQuery.getSql() |
Constructor and Description |
---|
SimpleQuery(PageContext pc,
DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
TimeSpan timeout,
String name,
String template,
TimeZone tz) |
Modifier and Type | Method and Description |
---|---|
SQL |
TOQuery.getSql() |
Modifier and Type | Method and Description |
---|---|
static void |
QueryUtil.checkSQLRestriction(DatasourceConnection dc,
SQL sql)
check if there is a sql restriction
|
static boolean |
QueryUtil.execute(PageContext pc,
Statement stat,
boolean createGeneratedKeys,
SQL sql) |
Modifier and Type | Method and Description |
---|---|
PageException |
Excepton.createDatabaseException(String message,
SQL sql)
create exception "DatabaseException"
|
Query |
Creation.createQuery(DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
int timeout,
String name) |
Query |
Creation.createQuery(DatasourceConnection dc,
SQL sql,
int maxrow,
String name)
Deprecated.
|
Copyright © 2015 Lucee