com.atlassian.bamboo.utils.db

Class JdbcUtils

java.lang.Object

com.atlassian.bamboo.utils.db.JdbcUtils

public class JdbcUtils
extends Object

Method Summary

Methods

Modifier and Type	Method and Description
static boolean	executeQuietly(Statement statement, String query)
static List<Long>	getListOfLong(Connection connection, String query)
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)

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