Package org.eclnt.ccee.db.jdbc

Class JDBCSql

java.lang.Object

org.eclnt.ccee.db.jdbc.JDBCSql

All Implemented Interfaces:

ICCEEConstants

public class JDBCSql
extends Object
implements ICCEEConstants

Field Summary

Fields inherited from interface org.eclnt.ccee.ICCEEConstants

AND, ASC, AVG, BETWEEN, BRC, BRO, COUNT, DEFAULT_CONTEXT, DESC, FUNCTIONRESULT, GREATER, GREATEREQUAL, IN, IS, ISNOT, LIKE, LL_DBG, LL_ERR, LL_INF, LL_WAR, LOWER, LOWEREQUAL, MAX, MIN, NULL, OR, ORDERBY, QPFUNCTION_LOWER, QPFUNCTION_UPPER, SUM

Constructor Summary

Constructors

Constructor	Description
JDBCSql()

Method Summary

Modifier and Type	Method	Description
static void	mapResultSetList(String contextName, ResultSet rs, String tableName, List<Map<String,Object>> dms)
static List<Map<String,Object>>	query(String tableName, Object[] colVals, Object[] oderBy)
static List<Map<String,Object>>	query(String contextName, String tableName, Object[] colVals, Object[] orderBy)
static Map<String,Object>	queryOne(String tableName, Object[] colVals, Object[] orderBy)
static Map<String,Object>	queryOne(String contextName, String tableName, Object[] colVals, Object[] orderBy)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

JDBCSql

public JDBCSql()

Method Details

queryOne

public static Map<String,Object> queryOne(String tableName,
 Object[] colVals,
 Object[] orderBy)

queryOne

public static Map<String,Object> queryOne(String contextName,
 String tableName,
 Object[] colVals,
 Object[] orderBy)

query

public static List<Map<String,Object>> query(String tableName,
 Object[] colVals,
 Object[] oderBy)

query

public static List<Map<String,Object>> query(String contextName,
 String tableName,
 Object[] colVals,
 Object[] orderBy)

mapResultSetList

public static void mapResultSetList(String contextName,
 ResultSet rs,
 String tableName,
 List<Map<String,Object>> dms)