public class SQLTool
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
class |
SQLTool.Metrics
LogSQL metrics
|
class |
SQLTool.TopSQL |
Constructor and Description |
---|
SQLTool() |
Modifier and Type | Method and Description |
---|---|
static void |
clearStatistics() |
static double |
getAvgTime()
Average of SQL times in milliseconds
|
static long |
getCountTotal()
Requests counter
|
static SQLTool.Metrics |
getMetrics()
Get the SQL metrics for the period
|
static java.lang.String |
getString(java.sql.ResultSet rs,
int type,
int index)
Get a String in a result
|
static int |
getTopSize() |
static java.util.Vector<SQLTool.TopSQL> |
getTopSQL()
Get the top SQL long requests
|
static double |
getTotalTime()
Total of SQL times in milliseconds
|
static void |
insertTopSQL(int index,
java.lang.String date,
java.lang.String sql,
long ms,
java.lang.String logId) |
static void |
setTopSize(int size) |
static void |
statistics(java.lang.String sql,
long begin,
java.lang.String login)
SQL statistics
|
static void |
statistics(java.lang.String sql,
java.util.Vector<ObjectField> host,
long begin,
java.lang.String login)
Manage SQL statistics (time average, long requests...)
|
public static java.lang.String getString(java.sql.ResultSet rs, int type, int index)
public static void setTopSize(int size)
public static int getTopSize()
public static java.util.Vector<SQLTool.TopSQL> getTopSQL()
public static long getCountTotal()
public static double getAvgTime()
public static double getTotalTime()
public static SQLTool.Metrics getMetrics()
public static void statistics(java.lang.String sql, long begin, java.lang.String login)
sql
- Querybegin
- Start time (ms)public static void statistics(java.lang.String sql, java.util.Vector<ObjectField> host, long begin, java.lang.String login)
sql
- Queryhost
- Host values to tracebegin
- Start time (ms)public static void insertTopSQL(int index, java.lang.String date, java.lang.String sql, long ms, java.lang.String logId)
public static void clearStatistics()
Copyright (c)2006-2014 Simplicite Software. All Rights Reserved.