org.identityconnectors.databasetable

Class DatabaseTableSQLUtil

java.lang.Object

org.identityconnectors.databasetable.DatabaseTableSQLUtil

public final class DatabaseTableSQLUtil
extends Object

The SQL helper/util class

Since:

1.0

Version:

$Revision 1.0$

Method Summary

Modifier and Type	Method and Description
static Map<String,SQLParam>	getColumnValues(MappingStrategy sms, ResultSet resultSet) Read one row from database result set and convert it to columnValues map.
static String	quoteName(String quoting, String value) Used to escape the table or column name.
static void	setParams(MappingStrategy sms, CallableStatement statement, List<SQLParam> params) This method binds the "?"
static void	setParams(MappingStrategy sms, PreparedStatement statement, List<SQLParam> params) This method binds the "?"

Methods inherited from class java.lang.Object

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

Method Detail

setParams

public static void setParams(MappingStrategy sms,
                             PreparedStatement statement,
                             List<SQLParam> params)
                      throws SQLException

This method binds the "?" markers in SQL statement with the parameters given as values. It concentrates the replacement of all params. GuardedString are handled so the password is never visible.

Parameters:

sms -

statement -

params - a List of the object arguments

Throws:

SQLException - an exception in statement

setParams

public static void setParams(MappingStrategy sms,
                             CallableStatement statement,
                             List<SQLParam> params)
                      throws SQLException

This method binds the "?" markers in SQL statement with the parameters given as values. It concentrates the replacement of all params. GuardedString are handled so the password is never visible.

Parameters:

sms -

statement -

params - a List of the object arguments

Throws:

SQLException - an exception in statement

getColumnValues

public static Map<String,SQLParam> getColumnValues(MappingStrategy sms,
                                                   ResultSet resultSet)
                                            throws SQLException

Read one row from database result set and convert it to columnValues map.

Parameters:

sms - a mapping strategy

resultSet - database data

Returns:

The transformed column values map

Throws:

SQLException

quoteName

public static String quoteName(String quoting,
                               String value)

Used to escape the table or column name.

Parameters:

quoting - the string double, single, back, brackets

value - Value to be quoted

Returns:

the quoted column name