Package com.avoka.core.sql

Class SqlUtils

java.lang.Object

com.avoka.core.sql.SqlUtils

public class SqlUtils
extends Object

Provides SQL utility functions

Constructor Summary

Constructors

Constructor	Description
SqlUtils()

Method Summary

Modifier and Type	Method	Description
static void	close(Connection connection)	Close a connection.
static void	close(ResultSet rs)	Close a result set.
static void	close(Statement statement)	Close a statement.
static String	getValueAsString(ResultSet rs, String column)	Get a column data as String type.

Methods inherited from class java.lang.Object

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

Constructor Details

SqlUtils

public SqlUtils()

Method Details

close

public static void close(Connection connection)

Close a connection.

Parameters:

connection - a connection to be closed

close

public static void close(ResultSet rs)

Close a result set.

Parameters:

rs - result set to be closed

close

public static void close(Statement statement)

Close a statement.

Parameters:

statement - a statement to be closed

getValueAsString

public static String getValueAsString(ResultSet rs,
 String column)

Get a column data as String type.

Parameters:

rs - result set that contains the data

column - column name to get

Returns:

the string representation of the column data