com.sankhya.util

Class JdbcUtils

java.lang.Object

com.sankhya.util.JdbcUtils

public class JdbcUtils
extends java.lang.Object

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	buildConnectionFromProperties(java.util.Properties dbProperties)
static void	closeConnection(java.sql.Connection conn)
static void	closeResultSet(java.sql.ResultSet rset)
static void	closeStatement(java.sql.Statement st)
static void	fillMapFromResultSet(java.util.Map<java.lang.String,java.lang.Object> map, java.sql.ResultSet rset)
static java.lang.String	getClobFieldAsString(java.sql.ResultSet rset, java.lang.String fieldName)
static java.lang.Object	getTypedFieldFromResultSet(java.lang.String fieldName, java.lang.Class<?> valueClass, java.sql.ResultSet rset)
static java.lang.Object	getTypedFieldFromResultSet(java.lang.String fieldName, java.sql.ResultSet rset)

Methods inherited from class java.lang.Object

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

Method Detail

buildConnectionFromProperties

public static java.sql.Connection buildConnectionFromProperties(java.util.Properties dbProperties)
                                                         throws java.lang.Exception

Parameters:

dbProperties - Chaves: br.com.sankhya.database.vendor br.com.sankhya.database.host br.com.sankhya.database.port br.com.sankhya.database.servico br.com.sankhya.database.user br.com.sankhya.database.password

Returns:

Connection

Throws:

java.lang.Exception

closeResultSet

public static void closeResultSet(java.sql.ResultSet rset)

closeStatement

public static void closeStatement(java.sql.Statement st)

closeConnection

public static void closeConnection(java.sql.Connection conn)

fillMapFromResultSet

public static void fillMapFromResultSet(java.util.Map<java.lang.String,java.lang.Object> map,
                                        java.sql.ResultSet rset)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypedFieldFromResultSet

public static java.lang.Object getTypedFieldFromResultSet(java.lang.String fieldName,
                                                          java.sql.ResultSet rset)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypedFieldFromResultSet

public static java.lang.Object getTypedFieldFromResultSet(java.lang.String fieldName,
                                                          java.lang.Class<?> valueClass,
                                                          java.sql.ResultSet rset)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getClobFieldAsString

public static java.lang.String getClobFieldAsString(java.sql.ResultSet rset,
                                                    java.lang.String fieldName)
                                             throws java.lang.Exception

Throws:

java.lang.Exception