程序包 com.gdxsoft.sqlProfiler

类 RawTraceReader

java.lang.Object

com.gdxsoft.sqlProfiler.RawTraceReader

public class RawTraceReader
extends Object

构造器概要

构造器

构造器	说明
RawTraceReader(com.gdxsoft.easyweb.datasource.DataConnection con)

方法概要

修饰符和类型	方法	说明
void	close()	关闭连接和ResultSet
void	closeTrace(com.gdxsoft.easyweb.datasource.DataConnection con)	sp_trace_setstatus state = 2
void	createFileTrace()	无法直接跟踪数据了，只能通过sql读取日志文件
void	createTrace()	创建跟踪，live模式，通过resultSet不断读取返回数据
com.gdxsoft.easyweb.datasource.DataConnection	getConn()
ResultSet	getReader()
int	getTraceId()
boolean	isTraceIsActive()
ProfilerEvent	next()	不断读取 sp_trace_getdata返回的resultSet（纵向表），根据columnid获取整体数据 通过线程ProfilerThread不断调用此方法
void	pauseTrace(com.gdxsoft.easyweb.datasource.DataConnection con)	sp_trace_setstatus state = 0
void	setConn(com.gdxsoft.easyweb.datasource.DataConnection m_Conn)
void	setEvent(int eventId, int... columns)
void	setFilter(int columnId, int logicalOperator, int comparisonOperator, Long value)
void	setFilter(int columnId, int logicalOperator, int comparisonOperator, String value)
void	setIntFilter(Integer value, SqlServerProfiler.IntFilterCondition condition, int column)
void	setStringFilter(String value, SqlServerProfiler.StringFilterCondition condition, int column)
void	startTrace()	sp_trace_setstatus state = 1

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

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

构造器详细资料

RawTraceReader

public RawTraceReader(com.gdxsoft.easyweb.datasource.DataConnection con)

方法详细资料

next

public ProfilerEvent next()
                   throws SQLException

不断读取 sp_trace_getdata返回的resultSet（纵向表），根据columnid获取整体数据
通过线程ProfilerThread不断调用此方法

返回:

抛出:

SQLException

close

public void close()

关闭连接和ResultSet

抛出:

SQLException

setEvent

public void setEvent(int eventId,
                     int... columns)

setFilter

public void setFilter(int columnId,
                      int logicalOperator,
                      int comparisonOperator,
                      Long value)
               throws Exception

抛出:

Exception

setFilter

public void setFilter(int columnId,
                      int logicalOperator,
                      int comparisonOperator,
                      String value)

createFileTrace

public void createFileTrace()
                     throws Exception

无法直接跟踪数据了，只能通过sql读取日志文件

抛出:

Exception

createTrace

public void createTrace()
                 throws Exception

创建跟踪，live模式，通过resultSet不断读取返回数据

抛出:

Exception

closeTrace

public void closeTrace(com.gdxsoft.easyweb.datasource.DataConnection con)

sp_trace_setstatus state = 2

参数:

con -

pauseTrace

public void pauseTrace(com.gdxsoft.easyweb.datasource.DataConnection con)

sp_trace_setstatus state = 0

参数:

con -

startTrace

public void startTrace()
                throws SQLException

sp_trace_setstatus state = 1

抛出:

SQLException

setIntFilter

public void setIntFilter(Integer value,
                         SqlServerProfiler.IntFilterCondition condition,
                         int column)
                  throws Exception

抛出:

Exception

setStringFilter

public void setStringFilter(String value,
                            SqlServerProfiler.StringFilterCondition condition,
                            int column)

isTraceIsActive

public boolean isTraceIsActive()

getTraceId

public int getTraceId()

getReader

public ResultSet getReader()

返回:

the m_Reader

getConn

public com.gdxsoft.easyweb.datasource.DataConnection getConn()

返回:

the m_Conn

setConn

public void setConn(com.gdxsoft.easyweb.datasource.DataConnection m_Conn)

参数:

m_Conn - the m_Conn to set