com.atlassian.bamboo.utils.db

Class JdbcUtils

java.lang.Object

com.atlassian.bamboo.utils.db.JdbcUtils

public class JdbcUtils
extends Object

Method Summary

Modifier and Type	Method and Description
static boolean	executeQuietly(Statement statement, String query)
static List<Long>	getListOfLong(Connection connection, String query)
static boolean	isTablePresent(Statement statement, String tableName)
static int	runDeleteQuery(Connection connection, String query, String entityName)
static int	runDeleteQuery(Connection connection, String tableName, String idColumn, Iterable<? extends BambooIdProvider> objects)
static int	runDeleteQuery(PreparedStatement statement, String query, String entityName)
static int	runUpdateQuery(PreparedStatement statement, String query, String entityName)

Methods inherited from class java.lang.Object

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

Method Detail

executeQuietly

public static boolean executeQuietly(Statement statement,
                                     String query)

isTablePresent

public static boolean isTablePresent(@NotNull
                                     Statement statement,
                                     @NotNull
                                     String tableName)

runDeleteQuery

public static int runDeleteQuery(@NotNull
                                 Connection connection,
                                 @NotNull
                                 String query,
                                 @NotNull
                                 String entityName)
                          throws SQLException

Throws:

SQLException

runDeleteQuery

public static int runDeleteQuery(@NotNull
                                 PreparedStatement statement,
                                 @NotNull
                                 String query,
                                 @NotNull
                                 String entityName)
                          throws SQLException

Parameters:

statement - statement to be executed (caller is responsible for closing statement)

query -

entityName -

Returns:

Throws:

SQLException

runUpdateQuery

public static int runUpdateQuery(@NotNull
                                 PreparedStatement statement,
                                 @NotNull
                                 String query,
                                 @NotNull
                                 String entityName)
                          throws SQLException

Parameters:

statement - statement to be executed (caller is responsible for closing statement)

query -

entityName -

Returns:

Throws:

SQLException

getListOfLong

public static List<Long> getListOfLong(@NotNull
                                       Connection connection,
                                       @NotNull
                                       String query)
                                throws SQLException

Throws:

SQLException

runDeleteQuery

public static int runDeleteQuery(@NotNull
                                 Connection connection,
                                 @NotNull
                                 String tableName,
                                 @NotNull
                                 String idColumn,
                                 @NotNull
                                 Iterable<? extends BambooIdProvider> objects)
                          throws SQLException

Throws:

SQLException