info.bioinfweb.commons.sql

Class IDGenerator

java.lang.Object

info.bioinfweb.commons.sql.IDGenerator

public class IDGenerator
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
IDGenerator()

Method Summary

Modifier and Type	Method and Description
static int	createID(java.sql.Connection connection, java.lang.String table, java.lang.String column, int min, int max) Returns a random ID which is not contained in the specified column of the specified table by the time this method is called.
static long	createID(java.sql.Connection connection, java.lang.String table, java.lang.String column, long min, long max) Returns a random ID which is not contained in the specified column of the specified table by the time this method is called.
static java.lang.String	createID(java.sql.Connection connection, java.lang.String table, java.lang.String column, java.lang.String chars, int length) Returns a random ID which is not contained in the specified column of the specified table by the time this method is called.
static int	createNextID(java.sql.Connection connection, java.lang.String table, java.lang.String column, boolean higher, int start) Returns the next ID which is not already present in the specified table.
static long	createNextID(java.sql.Connection connection, java.lang.String table, java.lang.String column, boolean higher, long start) Returns the next ID which is not already present in the specified table.
static boolean	idExists(java.sql.Connection connection, java.lang.String table, java.lang.String column, long id) Returns whether an ID already exists is the specified column of the specified table.
static boolean	idExists(java.sql.Connection connection, java.lang.String table, java.lang.String column, java.lang.String id)

Methods inherited from class java.lang.Object

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

Constructor Detail

IDGenerator

public IDGenerator()

Method Detail

idExists

public static boolean idExists(java.sql.Connection connection,
                               java.lang.String table,
                               java.lang.String column,
                               long id)
                        throws java.sql.SQLException

Returns whether an ID already exists is the specified column of the specified table.

Parameters:

connection -

table -

column -

id -

Returns:

Throws:

java.sql.SQLException

idExists

public static boolean idExists(java.sql.Connection connection,
                               java.lang.String table,
                               java.lang.String column,
                               java.lang.String id)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

createID

public static int createID(java.sql.Connection connection,
                           java.lang.String table,
                           java.lang.String column,
                           int min,
                           int max)
                    throws java.sql.SQLException

Returns a random ID which is not contained in the specified column of the specified table by the time this method is called. There are no changes made to the database.

Parameters:

connection -

table -

column -

min -

max -

Returns:

Throws:

java.sql.SQLException

createID

public static long createID(java.sql.Connection connection,
                            java.lang.String table,
                            java.lang.String column,
                            long min,
                            long max)
                     throws java.sql.SQLException

Returns a random ID which is not contained in the specified column of the specified table by the time this method is called. There are no changes made to the database.

Parameters:

connection -

table -

column -

min -

max -

Returns:

Throws:

java.sql.SQLException

createID

public static java.lang.String createID(java.sql.Connection connection,
                                        java.lang.String table,
                                        java.lang.String column,
                                        java.lang.String chars,
                                        int length)
                                 throws java.sql.SQLException

Returns a random ID which is not contained in the specified column of the specified table by the time this method is called. There are no changes made to the database.

Parameters:

connection -

table -

column -

chars -

length -

Returns:

Throws:

java.sql.SQLException

createNextID

public static int createNextID(java.sql.Connection connection,
                               java.lang.String table,
                               java.lang.String column,
                               boolean higher,
                               int start)
                        throws java.sql.SQLException

Returns the next ID which is not already present in the specified table. If the table is empty start is returned. There are no changes made to the database.

Parameters:

connection -

table -

column -

higher - specifies if an ID greater than the greatest or smaller than the smallest value value in the table shall be returned

start - the value to be returned if the table is empty

Returns:

Throws:

java.sql.SQLException

createNextID

public static long createNextID(java.sql.Connection connection,
                                java.lang.String table,
                                java.lang.String column,
                                boolean higher,
                                long start)
                         throws java.sql.SQLException

Returns the next ID which is not already present in the specified table. If the table is empty start is returned. There are no changes made to the database.

Parameters:

connection -

table -

column -

higher - specifies if an ID greater than the greatest or smaller than the smallest value value in the table shall be returned

start - the value to be returned if the table is empty

Returns:

Throws:

java.sql.SQLException