org.histpop.ohpr.util
Class DBUtils

java.lang.Object
  org.histpop.ohpr.util.DBUtils

public class DBUtils
extends java.lang.Object

Constructor Summary

DBUtils()

Method Summary

static java.lang.String	commaSeparatedList(java.lang.String[] fields) Create a comma-separated list suitable for SQL GROUP BY or ORDER clauses from a given list of field names
static java.lang.String	createInClause(int[] val) Convert an array of integer values into a comma-separated list as needed for SQL's IN-clause.
static java.lang.String	createInClause(java.lang.String[] val, boolean quoted) Convert an array of string values into a comma-separated list as needed for SQL's IN-clause.
static java.lang.String	createInClause(java.util.Vector val, boolean quoted) Convert a list of string values into a comma-separated list as needed for SQL's IN-clause.
static java.lang.String	createOrderList(java.lang.String[] orderFields, java.lang.String anotherField) Create a SQL ORDER BY list from a given list of field names

Methods inherited from class java.lang.Object

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

Constructor Detail

DBUtils

public DBUtils()

Method Detail

createInClause

public static java.lang.String createInClause(java.util.Vector val,
                                              boolean quoted)

Convert a list of string values into a comma-separated list as needed for SQL's IN-clause.

Parameters:

val - A list of values

Returns:

A comma-separated list of the values, e.g. IN (val1,val2,...)

createInClause

public static java.lang.String createInClause(java.lang.String[] val,
                                              boolean quoted)

Convert an array of string values into a comma-separated list as needed for SQL's IN-clause.

Parameters:

val - An array of values

Returns:

A comma-separated list of the values, e.g. IN (val1,val2,...)

createInClause

public static java.lang.String createInClause(int[] val)

Convert an array of integer values into a comma-separated list as needed for SQL's IN-clause.

Parameters:

val - An array of values

Returns:

A comma-separated list of the values, e.g. IN (val1,val2,...)

createOrderList

public static java.lang.String createOrderList(java.lang.String[] orderFields,
                                               java.lang.String anotherField)

Create a SQL ORDER BY list from a given list of field names

commaSeparatedList

public static java.lang.String commaSeparatedList(java.lang.String[] fields)

Create a comma-separated list suitable for SQL GROUP BY or ORDER clauses from a given list of field names