com.gbshape.dbe.utils
Class DBEHelper

java.lang.Object
  com.gbshape.dbe.utils.DBEHelper

public final class DBEHelper

extends java.lang.Object

Constructor Summary

DBEHelper()

Method Summary

static void	appendValue(DBDataBean dataBean, java.lang.StringBuffer where, ColumnBean columnBean, java.lang.String value)
static void	appendValues(DBDataBean dataBean, java.lang.StringBuffer query, ColumnBean columnBean, java.lang.String value)
static java.lang.String	decode(DBDataBean dataBean, java.lang.String string)
static java.util.GregorianCalendar	getCalendar(java.sql.ResultSet rs, java.lang.String column)
static java.sql.Connection	getConnection(DBDataBean dataBean)
static java.lang.String	getConnectionStartURL(DBDataBean dataBean)
static DataTypeBean	getDataTypeBean(DBDataBean dataBean, java.lang.String columnType)
static java.lang.String[]	getDataTypes(DBDataBean dataBean)
static DBDataBean[]	getDBEConfig()
static java.lang.String[]	getDimDataTypes(DBDataBean dataBean)
static java.lang.String	getImplementationVersion(javax.servlet.ServletContext ctx) get Implemetation version
static java.util.HashMap	getImportTasks()
static boolean	isColumnExtra(DBDataBean dataBean)
static boolean	isDBAvailable(java.lang.String dbType)
static java.util.HashMap	parseJSON(java.lang.String data) Create an KeyValue HasMap form a JSON string
static void	setLogs(javax.servlet.http.HttpServletRequest request, java.util.ArrayList messages)
static void	setLogs(javax.servlet.http.HttpServletRequest request, MessageBean message)
static boolean	showDataBases(DBDataBean dataBean)

Methods inherited from class java.lang.Object

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

Constructor Detail

DBEHelper

public DBEHelper()

Method Detail

getConnection

public static java.sql.Connection getConnection(DBDataBean dataBean)
                                         throws java.lang.ClassNotFoundException,
                                                java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

setLogs

public static void setLogs(javax.servlet.http.HttpServletRequest request,
                           MessageBean message)

setLogs

public static void setLogs(javax.servlet.http.HttpServletRequest request,
                           java.util.ArrayList messages)

decode

public static java.lang.String decode(DBDataBean dataBean,
                                      java.lang.String string)

parseJSON

public static java.util.HashMap parseJSON(java.lang.String data)

Create an KeyValue HasMap form a JSON string

Parameters:

data -

Returns:

appendValue

public static void appendValue(DBDataBean dataBean,
                               java.lang.StringBuffer where,
                               ColumnBean columnBean,
                               java.lang.String value)

appendValues

public static void appendValues(DBDataBean dataBean,
                                java.lang.StringBuffer query,
                                ColumnBean columnBean,
                                java.lang.String value)

isDBAvailable

public static boolean isDBAvailable(java.lang.String dbType)

getDataTypes

public static java.lang.String[] getDataTypes(DBDataBean dataBean)

getDimDataTypes

public static java.lang.String[] getDimDataTypes(DBDataBean dataBean)

getConnectionStartURL

public static java.lang.String getConnectionStartURL(DBDataBean dataBean)

isColumnExtra

public static boolean isColumnExtra(DBDataBean dataBean)

showDataBases

public static boolean showDataBases(DBDataBean dataBean)

getCalendar

public static java.util.GregorianCalendar getCalendar(java.sql.ResultSet rs,
                                                      java.lang.String column)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getDataTypeBean

public static DataTypeBean getDataTypeBean(DBDataBean dataBean,
                                           java.lang.String columnType)

getDBEConfig

public static DBDataBean[] getDBEConfig()

getImportTasks

public static java.util.HashMap getImportTasks()

getImplementationVersion

public static java.lang.String getImplementationVersion(javax.servlet.ServletContext ctx)

get Implemetation version

Parameters:

ctx -

Returns: