com.diasparsoftware.jdbc
Class JdbcUtil
java.lang.Object
com.diasparsoftware.jdbc.JdbcUtil
- public class JdbcUtil
- extends java.lang.Object
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 |
JdbcUtil
public JdbcUtil()
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 List
s.
- 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.