com.revolsys.jdbc

Class JdbcUtils

java.lang.Object

com.revolsys.jdbc.JdbcUtils

public final class JdbcUtils
extends Object

Method Summary

Methods

Modifier and Type	Method and Description
static void	addColumnNames(StringBuilder sql, RecordDefinition recordDefinition, String tablePrefix)
static void	addColumnNames(StringBuilder sql, RecordDefinition recordDefinition, String tablePrefix, List<String> fieldNames, boolean hasColumns)
static void	addFieldName(StringBuilder sql, String tablePrefix, FieldDefinition attribute)
static void	addOrderBy(StringBuilder sql, Map<String,Boolean> orderBy)
static void	appendWhere(StringBuilder sql, Query query)
static String	cleanObjectName(String objectName)
static void	close(ResultSet resultSet)
static void	close(Statement statement)
static void	close(Statement statement, ResultSet resultSet)
static void	commit(Connection connection)
static String	createSelectSql(RecordDefinition recordDefinition, String tablePrefix, String fromClause, boolean lockResults, List<String> fieldNames, Query query, Map<String,Boolean> orderBy)
static void	delete(Connection connection, String tableName, String idColumn, Object id)
static int	executeUpdate(Connection connection, String sql, Object... parameters)
static int	executeUpdate(DataSource dataSource, String sql, Object... parameters)
static int	executeUpdate(JdbcRecordStore recordStore, String sql, Object... parameters)
static Connection	getConnection(DataSource dataSource)
static String	getDeleteSql(Query query)
static org.springframework.dao.DataAccessException	getException(DataSource dataSource, Connection connection, String task, String sql, SQLException e)
static String	getProductName(DataSource dataSource)
static String	getQualifiedTableName(String typePath)
static String	getSchemaName(String typePath)
static String	getSelectSql(Query query)
static String	getTableName(String typePath)
static void	lockTable(Connection connection, String tableName)
static void	lockTable(RecordStore recordStore, String typePath)
static Map<String,Object>	readMap(ResultSet rs)
static void	release(Connection connection, DataSource dataSource)
static Date	selectDate(Connection connection, String sql, Object... parameters)
static Date	selectDate(DataSource dataSource, Connection connection, String sql, Object... parameters)
static Date	selectDate(DataSource dataSource, String sql, Object... parameters)
static int	selectInt(Connection connection, String sql, Object... parameters)
static int	selectInt(DataSource dataSource, Connection connection, String sql, Object... parameters)
static int	selectInt(DataSource dataSource, String sql, Object... parameters)
static int	selectInt(JdbcRecordStore recordStore, String sql, Object... parameters)
static <T> List<T>	selectList(Connection connection, String sql, int columnIndex, Object... parameters)
static long	selectLong(Connection connection, String sql, Object... parameters)
static long	selectLong(DataSource dataSource, Connection connection, String sql, Object... parameters)
static long	selectLong(DataSource dataSource, String sql, Object... parameters)
static long	selectLong(JdbcRecordStore recordStore, String sql, Object... parameters)
static Map<String,Object>	selectMap(Connection connection, String sql, Object... parameters)
static Map<String,Object>	selectMap(DataSource dataSource, String sql, Object... parameters)
static Map<String,Object>	selectMap(JdbcRecordStore recordStore, String sql, Object... parameters)
static String	selectString(Connection connection, String sql, Object... parameters)
static String	selectString(DataSource dataSource, Connection connection, String sql, Object... parameters)
static String	selectString(DataSource dataSource, String sql, Object... parameters)
static String	selectString(JdbcRecordStore recordStore, String sql, Object... parameters)
static void	setParameters(PreparedStatement statement, Object... parameters)
static void	setPreparedStatementParameters(PreparedStatement statement, Query query)
static int	setValue(PreparedStatement statement, int index, Object value)

Methods inherited from class java.lang.Object

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

Method Detail

addColumnNames

public static void addColumnNames(StringBuilder sql,
                  RecordDefinition recordDefinition,
                  String tablePrefix)

addColumnNames

public static void addColumnNames(StringBuilder sql,
                  RecordDefinition recordDefinition,
                  String tablePrefix,
                  List<String> fieldNames,
                  boolean hasColumns)

addFieldName

public static void addFieldName(StringBuilder sql,
                String tablePrefix,
                FieldDefinition attribute)

addOrderBy

public static void addOrderBy(StringBuilder sql,
              Map<String,Boolean> orderBy)

appendWhere

public static void appendWhere(StringBuilder sql,
               Query query)

cleanObjectName

public static String cleanObjectName(String objectName)

close

public static void close(ResultSet resultSet)

close

public static void close(Statement statement)

close

public static void close(Statement statement,
         ResultSet resultSet)

commit

public static void commit(Connection connection)

createSelectSql

public static String createSelectSql(RecordDefinition recordDefinition,
                     String tablePrefix,
                     String fromClause,
                     boolean lockResults,
                     List<String> fieldNames,
                     Query query,
                     Map<String,Boolean> orderBy)

delete

public static void delete(Connection connection,
          String tableName,
          String idColumn,
          Object id)

executeUpdate

public static int executeUpdate(Connection connection,
                String sql,
                Object... parameters)
                         throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(DataSource dataSource,
                String sql,
                Object... parameters)

executeUpdate

public static int executeUpdate(JdbcRecordStore recordStore,
                String sql,
                Object... parameters)

getConnection

public static Connection getConnection(DataSource dataSource)

getDeleteSql

public static String getDeleteSql(Query query)

getException

public static org.springframework.dao.DataAccessException getException(DataSource dataSource,
                                                       Connection connection,
                                                       String task,
                                                       String sql,
                                                       SQLException e)

getProductName

public static String getProductName(DataSource dataSource)

getQualifiedTableName

public static String getQualifiedTableName(String typePath)

getSchemaName

public static String getSchemaName(String typePath)

getSelectSql

public static String getSelectSql(Query query)

getTableName

public static String getTableName(String typePath)

lockTable

public static void lockTable(Connection connection,
             String tableName)
                      throws SQLException

Throws:

SQLException

lockTable

public static void lockTable(RecordStore recordStore,
             String typePath)

readMap

public static Map<String,Object> readMap(ResultSet rs)
                                  throws SQLException

Throws:

SQLException

release

public static void release(Connection connection,
           DataSource dataSource)

selectDate

public static Date selectDate(Connection connection,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectDate

public static Date selectDate(DataSource dataSource,
              Connection connection,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectDate

public static Date selectDate(DataSource dataSource,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectInt

public static int selectInt(Connection connection,
            String sql,
            Object... parameters)

selectInt

public static int selectInt(DataSource dataSource,
            Connection connection,
            String sql,
            Object... parameters)

selectInt

public static int selectInt(DataSource dataSource,
            String sql,
            Object... parameters)

selectInt

public static int selectInt(JdbcRecordStore recordStore,
            String sql,
            Object... parameters)

selectList

public static <T> List<T> selectList(Connection connection,
                     String sql,
                     int columnIndex,
                     Object... parameters)
                          throws SQLException

Throws:

SQLException

selectLong

public static long selectLong(Connection connection,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectLong

public static long selectLong(DataSource dataSource,
              Connection connection,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectLong

public static long selectLong(DataSource dataSource,
              String sql,
              Object... parameters)
                       throws SQLException

Throws:

SQLException

selectLong

public static long selectLong(JdbcRecordStore recordStore,
              String sql,
              Object... parameters)

selectMap

public static Map<String,Object> selectMap(Connection connection,
                           String sql,
                           Object... parameters)
                                    throws SQLException

Throws:

SQLException

selectMap

public static Map<String,Object> selectMap(DataSource dataSource,
                           String sql,
                           Object... parameters)
                                    throws SQLException

Throws:

SQLException

selectMap

public static Map<String,Object> selectMap(JdbcRecordStore recordStore,
                           String sql,
                           Object... parameters)

selectString

public static String selectString(Connection connection,
                  String sql,
                  Object... parameters)
                           throws SQLException

Throws:

SQLException

selectString

public static String selectString(DataSource dataSource,
                  Connection connection,
                  String sql,
                  Object... parameters)
                           throws SQLException

Throws:

SQLException

selectString

public static String selectString(DataSource dataSource,
                  String sql,
                  Object... parameters)
                           throws SQLException

Throws:

SQLException

selectString

public static String selectString(JdbcRecordStore recordStore,
                  String sql,
                  Object... parameters)
                           throws SQLException

Throws:

SQLException

setParameters

public static void setParameters(PreparedStatement statement,
                 Object... parameters)
                          throws SQLException

Throws:

SQLException

setPreparedStatementParameters

public static void setPreparedStatementParameters(PreparedStatement statement,
                                  Query query)

setValue

public static int setValue(PreparedStatement statement,
           int index,
           Object value)
                    throws SQLException

Throws:

SQLException