Java Utililty Methods SQL Table

void clearTables(Connection conn)
Clear the tables.

Statement stmt = conn.createStatement();
try {
 stmt.execute("delete from id_sequences where name = 'phase'");
 stmt.execute("delete from phase_dependency");
 stmt.execute("delete from phase_criteria");
 stmt.execute("delete from phase_criteria_type_lu");
 stmt.execute("delete from project_phase");
 stmt.execute("delete from phase_type_lu");
...

void clearTables(Connection conn, String[] tables)

Clear the given tables from the database.

Statement stmt = conn.createStatement();
try {
 for (int i = 0; i < tables.length; i++) {
 stmt.executeUpdate("DELETE FROM " + tables[i]);
} finally {
 stmt.close();

void clearTables(Connection connection)
Deleting all data from specified table.

String[] tables = new String[] { "scorecard_question", "scorecard_section", "scorecard_group", "scorecard",
 "scorecard_status_lu", "scorecard_type_lu", "scorecard_question_type_lu", "project_category_lu" };
for (int i = 0; i < tables.length; i++) {
 String query = "DELETE FROM " + tables[i];
 Statement statement = connection.createStatement();
 statement.executeUpdate(query);

boolean columnExist(String table, String column, Connection con)
column Exist

return getColumns(table, con).contains(column.toUpperCase());

Object constructObject(Class theClass, Connection db, int objectId, String tableName, String uniqueField)
Description of the Method

try {
 Class[] paramClass = new Class[] { Class.forName("java.sql.Connection"), int.class,
 Class.forName("java.lang.String"), Class.forName("java.lang.String") };
 Constructor constructor = theClass.getConstructor(paramClass);
 Object[] paramObject = new Object[] { db, new Integer(objectId), tableName, uniqueField };
 return constructor.newInstance(paramObject);
} catch (Exception e) {
 return null;
...

long count(Connection conn, String table)
count

long ret = 0;
try {
 Statement statement = conn.createStatement();
 String sql = String.format("select count(*) from %s;", table);
 ResultSet set = statement.executeQuery(sql);
 if (set.next()) {
 ret = set.getLong(1);
 statement.close();
} catch (SQLException e) {
 e.printStackTrace();
return ret;

int countTables(Connection connection)
count Tables

int count = 0;
ResultSet resultSet = connection.getMetaData().getTables("", null, null, new String[] { "TABLE" });
while (resultSet.next()) {
 count++;
resultSet.close();
return count;

void createBagValuesTables(Connection con)
Create the table 'bagvalues' containing the values of the key field objects contained in a bag and an extra values

String sqlTable = "CREATE TABLE bagvalues (savedbagid integer, value text, extra text)";
String sqlIndex = "CREATE UNIQUE INDEX bagvalues_index1 ON bagvalues " + "(savedbagid, value, extra)";
con.createStatement().execute(sqlTable);
con.createStatement().execute(sqlIndex);

void createFreqTable()
create Freq Table

try {
 Statement stmt = connection.createStatement();
 String sql = "CREATE TABLE IF NOT EXISTS " + FREQ_TABLE + "(" + ID
 + " INTEGER PRIMARY KEY AUTOINCREMENT," + CHROME + " CHAR(10) NOT NULL," + POSITION
 + " CHAR(20) NOT NULL," + A + " CHAR(10)," + T + " CHAR(10)," + C + " CHAR(10)," + G
 + " CHAR(10), " + "UNIQUE (" + CHROME + "," + POSITION + ")" + ");";
 stmt.executeUpdate(sql);
 stmt.close();
...

void createHSQLTables(LineNumberReader reader, Statement statement)
create HSQL Tables

String line;
int idx = 0;
String addPkLine = null;
String createTableLine = null;
StringBuffer stringBuffer = new StringBuffer(1000);
while (null != (line = reader.readLine())) {
 if (line.startsWith("alter table ")) {
 } else {
...