votorola.g.sql

Class ArrayX

java.lang.Object

ArrayX

@ThreadSafe
public final class ArrayX
extends Object

Array utilities. Alternatives to PreparedStatement.setArray(). To use setArray(), one must implement a compatible java.sql.Array instance, and this requires documentation or support from the JDBC driver that appears to be missing for PostgreSQL. Hence these alternative utilities for converting between arrays (which we cannot store) and strings (which we can).

Method Summary

Methods

Modifier and Type	Method and Description
static String	intsToString(int[] intArray) Returns the space-delimited concatenation of the specified int array.
static String	stringsToString(String[] stringArray) Returns the space-delimited concatenation of the specified string array.
static int[]	stringToInts(String s) Splits the space-delimited string (s) of integers into an array.
static String[]	stringToStrings(String s) Splits the space-delimited string (s) of strings into an array.

Methods inherited from class java.lang.Object

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

Method Detail

intsToString

public static String intsToString(int[] intArray)

Returns the space-delimited concatenation of the specified int array.

Returns:

space-delimited concatenation of intArray; or null, if the intArray is empty

See Also:

stringToInts(String)

stringToInts

public static int[] stringToInts(String s)

Splits the space-delimited string (s) of integers into an array.

Parameters:

s - space-delimited string of integers, which may be empty or null (in which cases, an empty array is returned)

See Also:

intsToString(int[])

stringsToString

public static String stringsToString(String[] stringArray)

Returns the space-delimited concatenation of the specified string array.

Returns:

space-delimited concatenation of stringArray; or null, if the stringArray is empty

See Also:

stringToStrings(String)

stringToStrings

public static String[] stringToStrings(String s)

Splits the space-delimited string (s) of strings into an array.

Parameters:

s - space-delimited string of strings, which may be empty or null (in which cases, an empty array is returned)

See Also:

stringsToString(String[])