com.diasparsoftware.jdbc
Class JdbcUtil

java.lang.Object
  extended bycom.diasparsoftware.jdbc.JdbcUtil

public class JdbcUtil
extends java.lang.Object


Constructor Summary
JdbcUtil()
           
 
Method Summary
static java.sql.ResultSet createFakeResultSet(java.util.Map rowData, org.easymock.MockControl resultSetControl)
           
static java.sql.Date makeDate(int year, int month, int day)
           
static java.sql.Timestamp makeTimestamp(java.util.Date date)
           
static java.sql.Timestamp makeTimestamp(int year, int month, int day)
          Creates a Timestamp object from the specified year, month, day, but at 12 noon local time.
static java.sql.Timestamp makeTimestamp(int year, int month, int day, int hour, int minute, int second, int millisecond)
          A way to make timestamps for normal people — none of this "year minus 1900" and "month minus 1" nonsense.
static java.util.List resultSetAsTable(java.sql.ResultSet resultSet)
          Provide a human-readable view of a JDBC result set.
static void setPreparedStatementParameters(java.sql.PreparedStatement preparedStatement, java.util.List parameters)
           
static java.util.Date toJavaUtilDate(java.sql.Timestamp timestamp)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

JdbcUtil

public JdbcUtil()
Method Detail

resultSetAsTable

public static java.util.List resultSetAsTable(java.sql.ResultSet resultSet)
                                       throws java.sql.SQLException
Provide a human-readable view of a JDBC result set. Here is sample output, showing two rows and the column names.
  [[EMPLOYEE_NUMBER, NAME, PHONE], [019, Joe, 416 555-1212], [092, Sarah, 416 555-1212]] * 

Parameters:
resultSet -
Returns:
A string representation that looks like a List of Lists.
Throws:
java.sql.SQLException

makeTimestamp

public static java.sql.Timestamp makeTimestamp(int year,
                                               int month,
                                               int day)
Creates a Timestamp object from the specified year, month, day, but at 12 noon local time.

Parameters:
year -
month -
day -
Returns:

makeTimestamp

public static java.sql.Timestamp makeTimestamp(java.util.Date date)

makeTimestamp

public static java.sql.Timestamp makeTimestamp(int year,
                                               int month,
                                               int day,
                                               int hour,
                                               int minute,
                                               int second,
                                               int millisecond)
A way to make timestamps for normal people — none of this "year minus 1900" and "month minus 1" nonsense.

Parameters:
year -
month -
day -
hour -
minute -
second -
millisecond -
Returns:

toJavaUtilDate

public static java.util.Date toJavaUtilDate(java.sql.Timestamp timestamp)

setPreparedStatementParameters

public static void setPreparedStatementParameters(java.sql.PreparedStatement preparedStatement,
                                                  java.util.List parameters)
                                           throws java.sql.SQLException
Throws:
java.sql.SQLException

createFakeResultSet

public static java.sql.ResultSet createFakeResultSet(java.util.Map rowData,
                                                     org.easymock.MockControl resultSetControl)

makeDate

public static java.sql.Date makeDate(int year,
                                     int month,
                                     int day)


Copyright © 2003-2004 Diaspar Software Services, Inc.. All Rights Reserved.