com.jiexplorer.db
Class JIGenericConnection
java.lang.Object
com.jiexplorer.db.JIGenericConnection
public class JIGenericConnection
- extends java.lang.Object
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
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
JIGenericConnection
public JIGenericConnection(java.lang.String conf)
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)