Package guru.mikelue.jdut.jdbc.util

Class PreparedStatements

java.lang.Object

guru.mikelue.jdut.jdbc.util.PreparedStatements

public final class PreparedStatements
extends Object

Utility for PreparedStatement.

Method Summary

Modifier and Type	Method	Description
static void	setParameter(PreparedStatement statement, DataRow dataRow, String columnName, int paramIndex)	Sets a parameter over statement by DataRow.
static void	setParameter(PreparedStatement statement, Object data, JDBCType jdbcType, int paramIndex)	Sets a parameter over statement by data.

Methods inherited from class java.lang.Object

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

Method Detail

setParameter

public static void setParameter(PreparedStatement statement,
                                DataRow dataRow,
                                String columnName,
                                int paramIndex)
                         throws SQLException

Sets a parameter over statement by DataRow.

Parameters:

statement - The statement to be set

dataRow - The data row to be used over statement

columnName - The name of column to be set

paramIndex - The index of parameter

Throws:

SQLException - The exception of SQL

See Also:

setParameter(PreparedStatement, Object, JDBCType, int)

setParameter

public static void setParameter(PreparedStatement statement,
                                Object data,
                                JDBCType jdbcType,
                                int paramIndex)
                         throws SQLException

Sets a parameter over statement by data.

1. This method chooses the corresponding setXXX method of PreparedStatement by the type of data.
2. If the type of data cannot be determined, the method of PreparedStatement.setObject(int, Object) would be used.
3. For null value, PreparedStatement.setNull would be used

java.util.Date

The object of Date would use PreparedStatement.setTimestamp(int, java.sql.Timestamp) to set parameter.

Parameters:

statement - The statement to be set

jdbcType - The type of JDBC, currently this parameter is used to determine setXXX for String value

data - The data

paramIndex - The index of parameter

Throws:

SQLException - The exception of SQL