程序包 com.gdxsoft.sqlProfiler

类 SqlServerProfiler

java.lang.Object

com.gdxsoft.sqlProfiler.SqlServerProfiler

public class SqlServerProfiler
extends Object

嵌套类概要

嵌套类

修饰符和类型	类	说明
static class	SqlServerProfiler.IntFilterCondition
static class	SqlServerProfiler.StringFilterCondition

字段概要

字段

修饰符和类型	字段	说明
static String	APPNAME
protected boolean	consoleMode
protected List<PerfColumn>	m_columns
protected com.gdxsoft.easyweb.datasource.DataConnection	m_Conn
protected ProfilerEvent	m_EventPaused
protected ConcurrentLinkedQueue<ProfilerEvent>	m_events
protected ProfilerEvent	m_EventStarted
protected ProfilerEvent	m_EventStopped
protected boolean	m_isWindows
protected boolean	m_NeedStop
protected ProfilingStateEnum	m_ProfilingState
protected RawTraceReader	m_Rdr
protected Thread	m_Thr
protected Timer	m_timer
static String	SQL_LOG_NEW

构造器概要

构造器

构造器	说明
SqlServerProfiler()

方法概要

修饰符和类型	方法	说明
void	clearProfilers()
static String	createConnStr(String host, int port, String database)
String	exportRecords()
List<PerfColumn>	getColumns()
protected com.gdxsoft.easyweb.datasource.DataConnection	getConnection()
String	getConnStr()
String	getDatabase()
String	getDdatabase()
protected String	getEventCaption(ProfilerEvent evt)
ConcurrentLinkedQueue<ProfilerEvent>	getEvents()
static SqlServerProfiler	getInstance(int tsId)
static SqlServerProfiler	getInstance(String host, int port, String database, String username, String password)
static Map<Integer,SqlServerProfiler>	getInstances()
static org.slf4j.Logger	getLOGGER()
String	getPassword()
int	getPort()
ProfilingStateEnum	getProfilingState()
RawTraceReader	getRdr()
String	getServer()
Thread	getThr()
Timer	getTimer()
String	getTraceFileName()
org.json.JSONObject	getTraceStatusFromSysTraces()	从 sqlserver数据库的 sys.traces获取状态
int	getTsId()
String	getUsername()
void	init(String server, int port, String database, String username, String password)
boolean	isConsoleMode()
boolean	isInitialized()	是否初始化完毕
boolean	isNeedStop()
boolean	isWindows()
protected void	newEventArrived(ProfilerEvent evt, boolean last)
void	pauseProfiling()	Pause trace
void	recordToDb(ProfilerEvent evt)
static void	removeInstance(int tsId)
void	resumeProfiling()	Resume
void	setConsoleMode(boolean consoleMode)
void	setDatabase(String database)
void	setNeedStop(boolean m_NeedStop)
void	setPassword(String password)
void	setPort(int port)
void	setServer(String server)
void	setTsId(int tsId)
void	setUsername(String username)
void	startProfiling()	Start trace
void	stopProfiling()	Stop trace
static org.json.JSONObject	testConnection(int tsId)	测试连接
static org.json.JSONObject	testConnection(String host, int port, String database, String username, String password)	测试连接
void	truncateRecords()

从类继承的方法 java.lang.Object

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

字段详细资料

SQL_LOG_NEW

public static final String SQL_LOG_NEW

另请参阅:

常量字段值

APPNAME

public static final String APPNAME

另请参阅:

常量字段值

m_ProfilingState

protected ProfilingStateEnum m_ProfilingState

m_Conn

protected com.gdxsoft.easyweb.datasource.DataConnection m_Conn

m_Rdr

protected RawTraceReader m_Rdr

m_NeedStop

protected boolean m_NeedStop

m_timer

protected Timer m_timer

m_events

protected ConcurrentLinkedQueue<ProfilerEvent> m_events

m_columns

protected List<PerfColumn> m_columns

m_Thr

protected Thread m_Thr

m_isWindows

protected boolean m_isWindows

consoleMode

protected boolean consoleMode

m_EventStarted

protected ProfilerEvent m_EventStarted

m_EventStopped

protected ProfilerEvent m_EventStopped

m_EventPaused

protected ProfilerEvent m_EventPaused

构造器详细资料

SqlServerProfiler

public SqlServerProfiler()

方法详细资料

removeInstance

public static void removeInstance(int tsId)

getInstance

public static SqlServerProfiler getInstance(String host,
                                            int port,
                                            String database,
                                            String username,
                                            String password)
                                     throws Exception

参数:

host -

port -

database -

username -

password -

返回:

抛出:

Exception

createConnStr

public static String createConnStr(String host,
                                   int port,
                                   String database)

testConnection

public static org.json.JSONObject testConnection(String host,
                                                 int port,
                                                 String database,
                                                 String username,
                                                 String password)

测试连接

参数:

host -

port -

database -

username -

password -

返回:

testConnection

public static org.json.JSONObject testConnection(int tsId)

测试连接

参数:

tsId -

返回:

抛出:

Exception

getInstance

public static SqlServerProfiler getInstance(int tsId)
                                     throws Exception

参数:

tsId -

返回:

抛出:

Exception

init

public void init(String server,
                 int port,
                 String database,
                 String username,
                 String password)
          throws Exception

抛出:

Exception

startProfiling

public void startProfiling()
                    throws Exception

Start trace

抛出:

SQLException

Exception

pauseProfiling

public void pauseProfiling()

Pause trace

resumeProfiling

public void resumeProfiling()
                     throws Exception

Resume

抛出:

SQLException

Exception

stopProfiling

public void stopProfiling()

Stop trace

getTraceStatusFromSysTraces

public org.json.JSONObject getTraceStatusFromSysTraces()

从 sqlserver数据库的 sys.traces获取状态

返回:

getEventCaption

protected String getEventCaption(ProfilerEvent evt)

exportRecords

public String exportRecords()
                     throws org.json.JSONException,
                            IOException

抛出:

org.json.JSONException

IOException

truncateRecords

public void truncateRecords()
                     throws org.json.JSONException,
                            IOException

抛出:

org.json.JSONException

IOException

recordToDb

public void recordToDb(ProfilerEvent evt)

newEventArrived

protected void newEventArrived(ProfilerEvent evt,
                               boolean last)

getConnection

protected com.gdxsoft.easyweb.datasource.DataConnection getConnection()
                                                               throws Exception

抛出:

Exception

clearProfilers

public void clearProfilers()

getServer

public String getServer()

返回:

the server

setServer

public void setServer(String server)

参数:

server - the server to set

getUsername

public String getUsername()

返回:

the username

setUsername

public void setUsername(String username)

参数:

username - the username to set

getPassword

public String getPassword()

返回:

the password

setPassword

public void setPassword(String password)

参数:

password - the password to set

getDdatabase

public String getDdatabase()

返回:

the database

setDatabase

public void setDatabase(String database)

参数:

database - the database to set

getPort

public int getPort()

返回:

the port

setPort

public void setPort(int port)

参数:

port - the port to set

isInitialized

public boolean isInitialized()

是否初始化完毕

返回:

the initialized

getTsId

public int getTsId()

返回:

the tsId

setTsId

public void setTsId(int tsId)

参数:

tsId - the tsId to set

getLOGGER

public static org.slf4j.Logger getLOGGER()

返回:

the lOGGER

getInstances

public static Map<Integer,SqlServerProfiler> getInstances()

返回:

the instances

getConnStr

public String getConnStr()

返回:

the connStr

getProfilingState

public ProfilingStateEnum getProfilingState()

返回:

the m_ProfilingState

getRdr

public RawTraceReader getRdr()

返回:

the m_Rdr

isNeedStop

public boolean isNeedStop()

返回:

the m_NeedStop

getTimer

public Timer getTimer()

返回:

the m_timer

getEvents

public ConcurrentLinkedQueue<ProfilerEvent> getEvents()

返回:

the m_events

getColumns

public List<PerfColumn> getColumns()

返回:

the m_columns

getThr

public Thread getThr()

返回:

the m_Thr

isWindows

public boolean isWindows()

返回:

the m_isWindows

getDatabase

public String getDatabase()

返回:

the database

setNeedStop

public void setNeedStop(boolean m_NeedStop)

参数:

m_NeedStop - the m_NeedStop to set

getTraceFileName

public String getTraceFileName()

返回:

the traceFileName

isConsoleMode

public boolean isConsoleMode()

返回:

the consoleMode

setConsoleMode

public void setConsoleMode(boolean consoleMode)

参数:

consoleMode - the consoleMode to set