public class ConnectionManager
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static int |
CUM_TYPE_ARRIVAL |
static int |
CUM_TYPE_DEPARTURE |
static int |
CUM_TYPE_EXIT |
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> |
stageActivityIntervalMap |
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> |
stageServiceIntervalMap |
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> |
stageTotalIntervalMap |
Constructor and Description |
---|
ConnectionManager() |
Modifier and Type | Method and Description |
---|---|
static void |
close() |
static java.sql.ResultSet |
executeSQL(java.lang.String sql) |
static void |
executeStatement(java.lang.String sql) |
static java.sql.Connection |
getConnection() |
static ConnectionManager |
getInstance() |
static void |
initConnectionProperties(java.util.Map<java.lang.String,java.lang.String> conParams) |
static void |
initParametersFromFile() |
static void |
insertActivity(java.lang.String caseID,
java.lang.String stage,
java.lang.String res,
java.lang.Long start,
java.lang.Long complete) |
static void |
insertStage(java.lang.String caseID,
java.lang.String stage,
java.lang.Long queuestart,
java.lang.Long servicestart,
java.lang.Long servicecomplete,
java.lang.String status,
java.lang.String lastStage) |
static void |
main(java.lang.String[] args) |
static int |
selectCumulativeArrivalCount(java.lang.String stageName,
org.joda.time.DateTime timePoint) |
static long |
selectCumulativeCaseTime2(java.lang.String stageName,
org.joda.time.DateTime timePoint) |
static int |
selectCumulativeCount(java.lang.String stageName,
org.joda.time.DateTime timePoint,
int cumulativeType,
java.lang.String exitType,
boolean isLastStage) |
static int |
selectCumulativeDepartureCount(java.lang.String stageName,
org.joda.time.DateTime timePoint) |
static long |
selectCumulativeResTime2(java.lang.String stageName,
org.joda.time.DateTime timePoint) |
public static int CUM_TYPE_ARRIVAL
public static int CUM_TYPE_DEPARTURE
public static int CUM_TYPE_EXIT
public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageActivityIntervalMap
public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageServiceIntervalMap
public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageTotalIntervalMap
public static void main(java.lang.String[] args)
public static ConnectionManager getInstance()
public static void close()
public static void initConnectionProperties(java.util.Map<java.lang.String,java.lang.String> conParams)
public static java.sql.Connection getConnection() throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static void initParametersFromFile()
public static java.sql.ResultSet executeSQL(java.lang.String sql) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static void executeStatement(java.lang.String sql) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static void insertStage(java.lang.String caseID, java.lang.String stage, java.lang.Long queuestart, java.lang.Long servicestart, java.lang.Long servicecomplete, java.lang.String status, java.lang.String lastStage) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static void insertActivity(java.lang.String caseID, java.lang.String stage, java.lang.String res, java.lang.Long start, java.lang.Long complete) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static int selectCumulativeCount(java.lang.String stageName, org.joda.time.DateTime timePoint, int cumulativeType, java.lang.String exitType, boolean isLastStage) throws java.lang.ClassNotFoundException, java.sql.SQLException
java.lang.ClassNotFoundException
java.sql.SQLException
public static int selectCumulativeArrivalCount(java.lang.String stageName, org.joda.time.DateTime timePoint)
stageName
- timePoint
- java.lang.ClassNotFoundException
java.sql.SQLException
public static int selectCumulativeDepartureCount(java.lang.String stageName, org.joda.time.DateTime timePoint)
public static long selectCumulativeCaseTime2(java.lang.String stageName, org.joda.time.DateTime timePoint)
public static long selectCumulativeResTime2(java.lang.String stageName, org.joda.time.DateTime timePoint)