com.jiexplorer.db
Class JIGenericConnection

java.lang.Object
  extended by com.jiexplorer.db.JIGenericConnection

public class JIGenericConnection
extends java.lang.Object


Field Summary
static java.lang.String JDBC_LOGIN
           
static java.lang.String JDBC_PASSWORD
           
static java.lang.String JDBC_PROVIDER
           
static java.lang.String JDBC_URL
           
static java.lang.String OTHER
           
static java.lang.String SQL_COMMIT
           
static java.lang.String SQL_DELETE_CATAGORYIMAGE
           
static java.lang.String SQL_DELETE_IMAGE_KEYWORD
           
static java.lang.String SQL_DELETE_IMAGE_TABLE
           
static java.lang.String SQL_DELETE_KEYBRIDGE
           
static java.lang.String SQL_DELETE_KEYWORD
           
static java.lang.String SQL_DELETE_OPEN_WITH
           
static java.lang.String SQL_INSERT_CATAGORY
           
static java.lang.String SQL_INSERT_CATAGORYCHILD
           
static java.lang.String SQL_INSERT_IMAGE
           
static java.lang.String SQL_INSERT_IMAGE_TABLE
           
static java.lang.String SQL_INSERT_KEYBRIDGE
           
static java.lang.String SQL_INSERT_KEYWORD
           
static java.lang.String SQL_INSERT_OPEN_WITH
           
static java.lang.String SQL_INSERT_ROOT_CATAGORY
           
static java.lang.String SQL_INSERT_THUMTABLEID
           
static java.lang.String SQL_SELECT_ALL_KEYWORDS
           
static java.lang.String SQL_SELECT_CATAGORY
           
static java.lang.String SQL_SELECT_CATAGORYID
           
static java.lang.String SQL_SELECT_DISK_OBJECT
           
static java.lang.String SQL_SELECT_IMAGE_ID
           
static java.lang.String SQL_SELECT_IMAGE_TABLE
           
static java.lang.String SQL_SELECT_OPEN_WITH
           
static java.lang.String SQL_SELECT_THUMTABLEID
           
static java.lang.String SQL_UPDATE_OPEN_WITH
           
 
Constructor Summary
JIGenericConnection(java.lang.String conf)
           
 
Method Summary
 void close()
           
 void createPrepStatements()
           
static void defaultRecovery()
           
 java.sql.Connection getConnection()
           
 java.sql.PreparedStatement getPrepInsertImageTable()
           
 java.sql.PreparedStatement getPrepInsertThumb()
           
 java.sql.PreparedStatement getPrepInsertThumbTableID()
           
 java.sql.PreparedStatement getPrepSelectCat()
           
 java.sql.PreparedStatement getPrepSelectCatID()
           
 java.sql.PreparedStatement getPrepSelectDiskObject()
           
 java.sql.PreparedStatement getPrepSelectImageID()
           
 java.sql.PreparedStatement getPrepSelectImageTable()
           
 java.sql.PreparedStatement getPrepSelectThumbTableID()
           
 java.lang.String getSqlCreateImageTable(java.lang.String tableUID)
           
 java.lang.String getSqlDropImageTable(java.lang.String tableUID)
           
 void init(java.lang.String conf)
           
 boolean makeTables()
           
 java.io.ByteArrayInputStream properties(java.lang.String config)
           
 void setConnection(java.sql.Connection conn)
           
 boolean validate()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

OTHER

public static final java.lang.String OTHER
See Also:
Constant Field Values

JDBC_URL

public static final java.lang.String JDBC_URL
See Also:
Constant Field Values

JDBC_PROVIDER

public static final java.lang.String JDBC_PROVIDER
See Also:
Constant Field Values

JDBC_LOGIN

public static final java.lang.String JDBC_LOGIN
See Also:
Constant Field Values

JDBC_PASSWORD

public static final java.lang.String JDBC_PASSWORD
See Also:
Constant Field Values

SQL_COMMIT

public static final java.lang.String SQL_COMMIT
See Also:
Constant Field Values

SQL_INSERT_ROOT_CATAGORY

public static final java.lang.String SQL_INSERT_ROOT_CATAGORY

SQL_INSERT_CATAGORY

public static final java.lang.String SQL_INSERT_CATAGORY

SQL_INSERT_CATAGORYCHILD

public static final java.lang.String SQL_INSERT_CATAGORYCHILD

SQL_SELECT_CATAGORYID

public static final java.lang.String SQL_SELECT_CATAGORYID

SQL_SELECT_CATAGORY

public static final java.lang.String SQL_SELECT_CATAGORY

SQL_DELETE_CATAGORYIMAGE

public static final java.lang.String SQL_DELETE_CATAGORYIMAGE

SQL_DELETE_IMAGE_KEYWORD

public static final java.lang.String SQL_DELETE_IMAGE_KEYWORD

SQL_DELETE_KEYBRIDGE

public static final java.lang.String SQL_DELETE_KEYBRIDGE

SQL_DELETE_KEYWORD

public static final java.lang.String SQL_DELETE_KEYWORD

SQL_INSERT_KEYWORD

public static final java.lang.String SQL_INSERT_KEYWORD

SQL_INSERT_KEYBRIDGE

public static final java.lang.String SQL_INSERT_KEYBRIDGE

SQL_SELECT_ALL_KEYWORDS

public static final java.lang.String SQL_SELECT_ALL_KEYWORDS

SQL_SELECT_IMAGE_ID

public static final java.lang.String SQL_SELECT_IMAGE_ID

SQL_INSERT_IMAGE

public static final java.lang.String SQL_INSERT_IMAGE

SQL_INSERT_IMAGE_TABLE

public static final java.lang.String SQL_INSERT_IMAGE_TABLE

SQL_SELECT_IMAGE_TABLE

public static final java.lang.String SQL_SELECT_IMAGE_TABLE

SQL_DELETE_IMAGE_TABLE

public static final java.lang.String SQL_DELETE_IMAGE_TABLE

SQL_SELECT_DISK_OBJECT

public static final java.lang.String SQL_SELECT_DISK_OBJECT

SQL_INSERT_THUMTABLEID

public static final java.lang.String SQL_INSERT_THUMTABLEID

SQL_SELECT_THUMTABLEID

public static final java.lang.String SQL_SELECT_THUMTABLEID

SQL_SELECT_OPEN_WITH

public static final java.lang.String SQL_SELECT_OPEN_WITH

SQL_INSERT_OPEN_WITH

public static final java.lang.String SQL_INSERT_OPEN_WITH

SQL_UPDATE_OPEN_WITH

public static final java.lang.String SQL_UPDATE_OPEN_WITH

SQL_DELETE_OPEN_WITH

public static final java.lang.String SQL_DELETE_OPEN_WITH
Constructor Detail

JIGenericConnection

public JIGenericConnection(java.lang.String conf)
Method Detail

validate

public boolean validate()

defaultRecovery

public static void defaultRecovery()

createPrepStatements

public final void createPrepStatements()
                                throws java.sql.SQLException
Throws:
java.sql.SQLException

init

public void init(java.lang.String conf)

makeTables

public boolean makeTables()

close

public void close()

getConnection

public final java.sql.Connection getConnection()

getPrepInsertImageTable

public final java.sql.PreparedStatement getPrepInsertImageTable()
Returns:
the prepInsertImageTable

getPrepInsertThumb

public final java.sql.PreparedStatement getPrepInsertThumb()
Returns:
the prepInsertThumb

getPrepInsertThumbTableID

public final java.sql.PreparedStatement getPrepInsertThumbTableID()
Returns:
the prepInsertThumbTable

getPrepSelectCat

public final java.sql.PreparedStatement getPrepSelectCat()
Returns:
the prepSelectCat

getPrepSelectCatID

public final java.sql.PreparedStatement getPrepSelectCatID()
Returns:
the prepSelectCatID

getPrepSelectDiskObject

public final java.sql.PreparedStatement getPrepSelectDiskObject()
Returns:
the prepSelectDiskObject

getPrepSelectImageID

public final java.sql.PreparedStatement getPrepSelectImageID()
Returns:
the prepSelectImageID

getPrepSelectImageTable

public final java.sql.PreparedStatement getPrepSelectImageTable()
Returns:
the prepSelectImageTable

getPrepSelectThumbTableID

public final java.sql.PreparedStatement getPrepSelectThumbTableID()
Returns:
the prepSelectThumbTableID

setConnection

public final void setConnection(java.sql.Connection conn)
Parameters:
conn - the conn to set

getSqlCreateImageTable

public final java.lang.String getSqlCreateImageTable(java.lang.String tableUID)
Returns:
the sql_create_image_table

getSqlDropImageTable

public final java.lang.String getSqlDropImageTable(java.lang.String tableUID)
Returns:
the sql_drop_image_db

properties

public java.io.ByteArrayInputStream properties(java.lang.String config)