Constructor and Description |
---|
QueryUtil() |
Modifier and Type | Method and Description |
---|---|
static void |
checkSQLRestriction(DatasourceConnection dc,
SQL sql)
check if there is a sql restriction
|
static QueryColumnImpl |
duplicate2QueryColumnImpl(QueryImpl targetQuery,
QueryColumn col,
boolean deepCopy) |
static boolean |
execute(PageContext pc,
PreparedStatement ps) |
static boolean |
execute(PageContext pc,
Statement stat,
boolean createGeneratedKeys,
SQL sql) |
static String |
getColumnName(ResultSetMetaData meta,
int column) |
static Collection.Key[] |
getColumnNames(Query qry)
return column names as Key from a query
|
static Object |
getObject(ResultSet rs,
int columnIndex,
Class type) |
static Object |
getObject(ResultSet rs,
String columnLabel,
Class type) |
static Object |
getValue(QueryColumn column,
int row)
Deprecated.
use instead QueryColumn.get(int,Object)
|
static void |
removeRows(Query query,
int index,
int count) |
static long |
sizeOf(QueryColumn column) |
static DumpData |
toDumpData(Query query,
PageContext pageContext,
int maxlevel,
DumpProperties dp) |
static String[] |
toStringArray(Collection.Key[] keys) |
public QueryUtil()
public static long sizeOf(QueryColumn column)
public static Collection.Key[] getColumnNames(Query qry)
qry
- public static String[] toStringArray(Collection.Key[] keys)
public static void checkSQLRestriction(DatasourceConnection dc, SQL sql) throws PageException
dc
- sql
- PageException
public static DumpData toDumpData(Query query, PageContext pageContext, int maxlevel, DumpProperties dp)
public static void removeRows(Query query, int index, int count) throws PageException
PageException
public static boolean execute(PageContext pc, Statement stat, boolean createGeneratedKeys, SQL sql) throws SQLException
SQLException
public static boolean execute(PageContext pc, PreparedStatement ps) throws SQLException
SQLException
public static String getColumnName(ResultSetMetaData meta, int column) throws SQLException
SQLException
public static Object getObject(ResultSet rs, int columnIndex, Class type) throws SQLException
SQLException
public static Object getObject(ResultSet rs, String columnLabel, Class type) throws SQLException
SQLException
public static Object getValue(QueryColumn column, int row)
column
- row
- public static QueryColumnImpl duplicate2QueryColumnImpl(QueryImpl targetQuery, QueryColumn col, boolean deepCopy)
Copyright © 2015 Lucee