org.parosproxy.paros.db

Class DbUtils

java.lang.Object

org.parosproxy.paros.db.DbUtils

public class DbUtils
extends Object

Method Summary

Modifier and Type	Method and Description
static void	execute(Connection connection, String sql) Utility function for executing the given sql
static void	executeAndClose(PreparedStatement preparedStatement) Deprecated. (2.8.0) replaced by execute(java.sql.Connection, java.lang.String)
static void	executeUpdate(Connection connection, String sql) Utility function for executing an update sql statement
static void	executeUpdateAndClose(PreparedStatement preparedStatement) Deprecated. (2.8.0) replaced by executeUpdate(java.sql.Connection, java.lang.String)
static int	getColumnSize(Connection connection, String tableName, String columnName) Gets the size of the given column columnName of the table tableName.
static int	getColumnType(Connection connection, String tableName, String columnName) Gets the type of the given column columnName of the table tableName.
static boolean	hasColumn(Connection connection, String tableName, String columnName) Tells whether the table tableName has the column with the given columnName, or not.
static boolean	hasIndex(Connection connection, String tableName, String indexName) Tells whether the table tableName has an index with the given indexName, or not.
static boolean	hasTable(Connection connection, String tableName) Tells whether the table tableName exists in the database, or not.

Methods inherited from class java.lang.Object

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

Method Detail

hasTable

public static boolean hasTable(Connection connection,
                               String tableName)
                        throws SQLException

Tells whether the table tableName exists in the database, or not.

Parameters:

connection - the connection to the database

tableName - the name of the table that will be checked

Returns:

true if the table tableName exists in the database, false otherwise.

Throws:

SQLException - if an error occurred while checking if the table exists

hasColumn

public static boolean hasColumn(Connection connection,
                                String tableName,
                                String columnName)
                         throws SQLException

Tells whether the table tableName has the column with the given columnName, or not.

Parameters:

connection - the connection to the database

tableName - the name of the table that may have the column

columnName - the name of the column that will be checked

Returns:

true if the table tableName has the column columnName, false otherwise.

Throws:

SQLException - if an error occurred while checking if the table has the column

hasIndex

public static boolean hasIndex(Connection connection,
                               String tableName,
                               String indexName)
                        throws SQLException

Tells whether the table tableName has an index with the given indexName, or not.

Parameters:

connection - the connection to the database

tableName - the name of the table that may have the index

indexName - the name of the index that will be checked

Returns:

true if the table tableName has the index indexName, false otherwise.

Throws:

SQLException - if an error occurred while checking if the table has the index

getColumnType

public static int getColumnType(Connection connection,
                                String tableName,
                                String columnName)
                         throws SQLException

Gets the type of the given column columnName of the table tableName.

Parameters:

connection - the connection to the database

tableName - the name of the table that has the column

columnName - the name of the column that will be used to get the type

Returns:

the type of the column, or -1 if the column doesn't exist.

Throws:

SQLException - if an error occurred while checking the type of the column

getColumnSize

public static int getColumnSize(Connection connection,
                                String tableName,
                                String columnName)
                         throws SQLException

Gets the size of the given column columnName of the table tableName.

Parameters:

connection - the connection to the database

tableName - the name of the table that has the column

columnName - the name of the column that will be used to get the size

Returns:

the length of the column, or -1 if the column doesn't exist, or if the type has no size.

Throws:

SQLException - if an error occurred while checking the size of the column

executeAndClose

@Deprecated
public static void executeAndClose(PreparedStatement preparedStatement)
                                        throws SQLException

Deprecated. (2.8.0) replaced by execute(java.sql.Connection, java.lang.String)

Executes and closes the given preparedStatement.

Parameters:

preparedStatement - the statement that will be executed and immediately closed

Throws:

SQLException - if error occurred while executing the given preparedStatement

See Also:

Statement.close(), PreparedStatement.execute()

execute

public static void execute(Connection connection,
                           String sql)
                    throws SQLException

Utility function for executing the given sql

Parameters:

connection - the database connection to use

sql - the sql statement to run

Throws:

SQLException - if error occurred while executing the given sql

Since:

2.8.0

executeUpdateAndClose

@Deprecated
public static void executeUpdateAndClose(PreparedStatement preparedStatement)
                                              throws SQLException

Deprecated. (2.8.0) replaced by executeUpdate(java.sql.Connection, java.lang.String)

Executes (update) and closes the given preparedStatement.

Parameters:

preparedStatement - the statement that will be executed and immediately closed

Throws:

SQLException - if error occurred while executing the given preparedStatement

See Also:

Statement.close(), PreparedStatement.executeUpdate()

executeUpdate

public static void executeUpdate(Connection connection,
                                 String sql)
                          throws SQLException

Utility function for executing an update sql statement

Parameters:

connection - the database connection to use

sql - the sql statement to run

Throws:

SQLException - if error occurred while executing the given sql

Since:

2.8.0