Skip navigation links

com.sigmadynamics.server.DataServices.DatabaseProvider
Class ValueSetter

java.lang.Object
com.sigmadynamics.server.DataServices.DatabaseProvider.ValueSetter

public class ValueSetter

extends java.lang.Object

This class takes values that have been saved, along with type information, and makes the proper JDBC calls to set argument values into java.sql.Statement objects. This code was put into its own class because the code is used 2 places, inside BatchUpdater and StoredProcedureImpl, and it has methods that need to be overridden by subclasses. For example, the Oracle subclass needs to do some things differently.

Field Summary

protected static java.lang.Object	SQL_BLOB
protected static java.lang.Object	SQL_VARCHAR
static int	TYPE_BYTE_ARRAY
static int	TYPE_DATE
static int	TYPE_DATECALENDAR
static int	TYPE_DOUBLE
static int	TYPE_INPUTSTREAM
static int	TYPE_INTEGER
static int	TYPE_LONG
static int	TYPE_NULL
static int	TYPE_STRING

Constructor Summary

ValueSetter()

Method Summary

protected void	cleanup()
protected void	setValueIntoStatement(java.sql.PreparedStatement stmt, int index, int type, java.lang.Object value) calls the proper JDBC setter for setting values of bound variables in prepared SQL statements

Methods inherited from class java.lang.Object

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

Field Detail

TYPE_NULL

public static final int TYPE_NULL

See Also:

Constant Field Values

TYPE_STRING

public static final int TYPE_STRING

See Also:

Constant Field Values

TYPE_DOUBLE

public static final int TYPE_DOUBLE

See Also:

Constant Field Values

TYPE_LONG

public static final int TYPE_LONG

See Also:

Constant Field Values

TYPE_BYTE_ARRAY

public static final int TYPE_BYTE_ARRAY

See Also:

Constant Field Values

TYPE_INPUTSTREAM

public static final int TYPE_INPUTSTREAM

See Also:

Constant Field Values

TYPE_DATE

public static final int TYPE_DATE

See Also:

Constant Field Values

TYPE_DATECALENDAR

public static final int TYPE_DATECALENDAR

See Also:

Constant Field Values

TYPE_INTEGER

public static final int TYPE_INTEGER

See Also:

Constant Field Values

SQL_VARCHAR

protected static final java.lang.Object SQL_VARCHAR

SQL_BLOB

protected static final java.lang.Object SQL_BLOB

Constructor Detail

ValueSetter

public ValueSetter()

Method Detail

setValueIntoStatement

protected void setValueIntoStatement(java.sql.PreparedStatement stmt,
                                     int index,
                                     int type,
                                     java.lang.Object value)

calls the proper JDBC setter for setting values of bound variables in prepared SQL statements

Parameters:

stmt -

index -

type -

value -

Throws:

java.sql.SQLException

cleanup

protected void cleanup()

Skip navigation links