com.rc.celeritas.query
Class QueryHelper

java.lang.Object
  com.rc.celeritas.query.QueryHelper

public class QueryHelper
extends java.lang.Object

Author:

rchoudhary

Constructor Summary

QueryHelper()

Method Summary

static java.lang.String	buildOrderBy(java.lang.String order_by)
static java.lang.String	buildQuerySQL(java.lang.String table)
static java.lang.String	buildQuerySQLWithPKey(java.lang.String table, java.lang.String pk, java.lang.String pVal)
static java.lang.String	createDeleteSQL(java.lang.String table, java.lang.String pk, java.lang.String pVal)
static java.lang.String	createInsertSQL(java.lang.String table, java.util.ArrayList<Column> columns, java.util.Hashtable rMap)
static java.lang.String	createUpdateSQL(java.lang.String table, java.util.ArrayList<Column> columns, java.util.HashMap rMap, java.lang.String pk, java.lang.String pVal)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryHelper

public QueryHelper()

Method Detail

buildOrderBy

public static java.lang.String buildOrderBy(java.lang.String order_by)

Parameters:

order_by -

Returns:

buildQuerySQL

public static java.lang.String buildQuerySQL(java.lang.String table)

Parameters:

table -

Returns:

createDeleteSQL

public static java.lang.String createDeleteSQL(java.lang.String table,
                                               java.lang.String pk,
                                               java.lang.String pVal)

Parameters:

table -

pk -

pVal -

Returns:

createUpdateSQL

public static java.lang.String createUpdateSQL(java.lang.String table,
                                               java.util.ArrayList<Column> columns,
                                               java.util.HashMap rMap,
                                               java.lang.String pk,
                                               java.lang.String pVal)

Parameters:

table -

columns -

rMap -

pk -

pVal -

Returns:

createInsertSQL

public static java.lang.String createInsertSQL(java.lang.String table,
                                               java.util.ArrayList<Column> columns,
                                               java.util.Hashtable rMap)

Parameters:

table -

columns -

rMap -

Returns:

buildQuerySQLWithPKey

public static java.lang.String buildQuerySQLWithPKey(java.lang.String table,
                                                     java.lang.String pk,
                                                     java.lang.String pVal)

Parameters:

table -

pk -

pVal -

Returns: