- 在线时间
- 0 小时
- 最后登录
- 2007-9-23
- 注册时间
- 2004-9-10
- 听众数
- 3
- 收听数
- 0
- 能力
- 0 分
- 体力
- 9975 点
- 威望
- 7 点
- 阅读权限
- 150
- 积分
- 4048
- 相册
- 0
- 日志
- 0
- 记录
- 0
- 帖子
- 1893
- 主题
- 823
- 精华
- 2
- 分享
- 0
- 好友
- 0

我的地盘我做主
该用户从未签到
|
(dbg_DB_Data, "DBMS",oSQLDB.Properties("DBMS Name") & " Ver: " & oSQLDB.Properties("DBMS Version")) ; Y5 p% Q A% X4 {1 B" V6 y
dbg_DB_Data = AddRow(dbg_DB_Data, " rovider",oSQLDB.Properties(" rovider Name") & " Ver: " & oSQLDB.Properties(" rovider Version")) 8 s Y2 T5 q2 H$ p
End Sub < >'***********************************************************
) R9 H. H3 e' z( L'* PrintDatabaseInfo + ^% y- { y( ]7 b, s
'*********************************************************** & j* ^( a1 H$ X$ Y0 ?
Private Sub PrintDatabaseInfo(byval DivSetNo)
- k7 w8 Y: j2 A* \5 M dim tbl 4 @8 @$ L' m7 D) y
tbl = MakeTable(dbg_DB_Data) N. m. N. w' S$ M9 y# h
tbl = replace(replace(replace(DivSets(DivSetNo),"#sectname#","DATABASE"),"#title#","DATABASE INFO"),"#data#",tbl) . Y1 N9 ~. i+ h- d, U
Response.Write replace(tbl,"|", vbcrlf)
2 u2 {6 d8 t7 Q5 d0 CEnd Sub </P>< >'***********************************************************
# `: Y% V# ?- q0 ?$ w1 Q'* PrintCollection
2 }& ~% Q! i. f: W3 \'*********************************************************** ( n0 }% v, t7 u0 c$ e1 Y) l
Private Sub PrintCollection(Byval Name, ByVal Collection, ByVal DivSetNo, ByVal ExtraInfo)
' C- I9 o0 a# H9 h8 Q* M. @ Dim vItem, tbl, Temp / { D# y& d: ~- U+ _ k! p) Q
For Each vItem In Collection
! ~+ R/ Q6 Q5 P, G& Y2 Q. ] if isobject(Collection(vItem)) and Name <> "SERVER VARIABLES" and Name <> "QUERYSTRING" and Name <> "FORM" then : w5 \% l3 c0 @ }6 P* v) i9 Z9 I# R
tbl = AddRow(tbl, vItem, "{object}")
, @, S1 x. s0 M: U: @* V) v9 u0 U elseif isnull(Collection(vItem)) then + _& r8 a$ i2 |, h' ]/ ?/ V, A
tbl = AddRow(tbl, vItem, "{null}") ) _" W5 t7 T$ w* ?
elseif isarray(Collection(vItem)) then
2 @9 [0 }& `6 D1 k4 r tbl = AddRow(tbl, vItem, "{array}") . k2 g, z1 n1 s; S5 N
else
9 |, K' Q( q. P o B [; n; Q if dbg_AllVars then
+ n2 k4 A8 H4 _% E5 d* j" F tbl = AddRow(tbl, "<nobr>" & vItem & "</nobr>", server.HTMLEncode(Collection(vItem))) & w. l6 ^ o9 ]! U
elseif (Name = "SERVER VARIABLES" and vItem <> "ALL_HTTP" and vItem <> "ALL_RAW") or Name <> "SERVER VARIABLES" then
, R8 G8 x' H4 k, a2 H# T% k if Collection(vItem) <> "" then , J- O9 l- b7 l" J& d
tbl = AddRow(tbl, vItem, server.HTML* F1 E- e2 v! F
Encode(Collection(vItem))) ' & " {" & TypeName(Collection(vItem)) & "}") 2 u% Q, R; U7 `& T; P3 M
else
% J i2 N- m& W; ^2 w4 j% C. f tbl = AddRow(tbl, vItem, "...")
, p0 u3 w% f, f, O2 Y: A( ` end if ! `% x) g" L; E9 r7 `4 V
end if : V$ w& D( a, y( r; L) t0 S
end if
: ]2 W8 F g0 S- B& Q( G; Q Next
1 |( k# U1 V$ O1 q, T. } U if ExtraInfo <> "" then tbl = tbl & "<TR><TD COLSPAN=2><HR></TR>" & ExtraInfo
! y: d8 F$ ]: |) t3 b" D tbl = MakeTable(tbl) 8 a6 r0 H m+ N% u
if Collection.count <= 0 then DivSetNo =2 " F' |+ O1 C5 l3 m/ y0 T. e y
tbl = replace(replace(DivSets(DivSetNo),"#title#",Name),"#data#",tbl) ' @/ x* L9 g+ E6 \0 z# t
tbl = replace(tbl,"#sectname#",replace(Name," ","")) ) s! s% o1 x" v6 M
Response.Write replace(tbl,"|", vbcrlf)
. h8 C/ D8 T) n8 u( iEnd Sub
8 D3 h5 x2 X% d( C ; s' t, N1 K( M) J7 @
'***********************************************************
4 Q3 o, _9 n; }# S9 v& R6 Q( B'* AddRow
2 q$ y1 Q0 c$ U1 ]: z'***********************************************************
2 s6 p5 t& ~; o. x( [/ zPrivate Function AddRow(byval t, byval var, byval val) - V; f. r: E U' |: ^8 }
t = t & "|<TR valign=top>|<TD>|" & var & "|<TD>= " & val & "|</TR>"
+ t) ^+ N& b. Z# K" V/ d# Y! } AddRow = t 6 I, o6 j' f$ g9 z
End Function </P>< >'*********************************************************** / R! p0 [- H" i( w7 N; x/ F; l( d5 H
'* MakeTable
}9 R# `# s y { t6 i; F9 I- _'*********************************************************** % s& [9 U3 Z, S1 F$ O% K
Private Function MakeTable(byval tdata)
# {6 W2 Q: o& H2 Z9 Y# Q tdata = "|<table border=0 style=""font-size:10pt;font-weight:normal;"">" + tdata + "</Table>|"
' ~7 @6 K2 g$ q+ M' t MakeTable = tdata
6 m! i! t# t* B( w( iEnd Function </P>< >'*********************************************************** + O3 s8 e- P _ c! {. Q
''@SDESCRIPTION: Draws the Debug-panel
9 G2 g9 w- }5 m' [) T'***********************************************************
4 r! s$ a: {; H$ @! f a, w, r+ m% tPublic Sub draw()
. e. ]* C8 ^9 u If dbg_Enabled Then
; V; o' e% X S9 X4 A9 F) Q dbg_FinishTime = Now()
- K1 W' h8 d" ]# o
. D1 n: [' ]+ k5 ~4 @ Dim DivSet, x
8 Q6 I) w N2 d$ m DivSet = split(dbg_Show_default,",") & `* s0 V: E* u* P5 k% G- z
dbg_Show = split(dbg_Show,",") / C! u4 `% T. {7 i+ x4 ?
; m* y0 l8 K, Z; r" I For x = 0 to ubound(dbg_Show) / H( c1 x' ?3 P* z/ R N
divSet(x) = dbg_Show(x)
, K: x" ], Z5 x$ r9 n: r Next * z: l# P$ ?* w% a' S
! t: z( e3 v' _/ h Response.Write "<BR><Table width=100% cellspacing=0 border=0 style=""font-family:arial;font-size:9pt;font-weight:normal;""><TR><TD><DIV style=""background:#005A9E;color:white;padding:4;font-size:12pt;font-weight:bold;"">Debugging-console:</DIV>"
9 c, }$ s2 g4 X$ n! P/ Z' \; T Call PrintSummaryInfo(divSet(0))
+ d; Y' i9 q1 m" j; L% A Call PrintCollection("VARIABLES", dbg_Data,divSet(1),"")
6 F4 b7 d/ @2 n: r, g! F$ Q& g5 F" q Call PrintCollection("QUERYSTRING", Request.QueryString(), divSet(2),"") : x: n8 o& h7 j, S
Call PrintCollection("FORM", Request.Form(),divSet(3),"")
5 ?+ g' r- \8 `4 G) l# z1 J& h Call PrintCookiesInfo(divSet(4))
# o3 f8 d" ]6 Z0 ^* X Call PrintCollection("SESSION", Session.Contents(),divSet(5),AddRow(AddRow(AddRow("","Locale ID",Session.LCID & " (&H" & Hex(Session.LCID) & ")"),"Code Page",Session.CodePage),"Session ID",Session.SessionID))
9 n0 y& K' n v Call PrintCollection("APPLICATION", Application.Contents(),divSet(6),"")
0 P: k+ L3 U, [3 e% x: w& Z Call PrintCollection("SERVER VARIABLES", Request.ServerVariables(),divSet(7),AddRow("","Timeout",Server.ScriptTimeout))
2 n$ t; M; q. I8 \$ o6 m6 G Call PrintDatabaseInfo(divSet(8))
& {: W6 t4 V+ k4 C: N Call PrintCollection("SESSION STATIC OBJECTS", Session.StaticObjects(),divSet(9),"")
1 H3 j$ k$ ?! Z3 f Call PrintCollection("APPLICATION STATIC OBJECTS", Application.StaticObjects(),divSet(10),"")
/ u: q2 N( @& o- W& M! U" N Response.Write "</Table>" u( P" B$ q8 S3 ?
End If
* W5 v( \; b3 z& v1 ?4 qEnd Sub </P>< >'Destructor
2 E, `* Y* r5 T9 [$ mPrivate Sub Class_Terminate()
/ ^" V8 w, z0 _: E; P9 m/ u Set dbg_Data = Nothing
1 A+ O7 b% y: ]# zEnd Sub </P>< >End Class </P>< >%> </P>< >类的说明: </P>< >
. r& h. u7 r1 F6 X# KCLASS debuggingConsole + b, Z- f2 |9 D; `
Version: 1.2 </P>< >-------------------------------------------------------------------------------- </P>< > ublic Properties </P>< > roperty Let Enabled(bNewValue)===[bool] Sets "enabled" to true or false 8 I6 U; L u. N" Q
&n
, t/ l* i: \7 F! tbsp;
# d% L8 E$ ]; n ]9 H oProperty Get Enabled===[bool] Gets the "enabled" value
- L# q5 ]( _: N, P+ Z ) \0 j" M9 E7 _9 M
Property Let Show(bNewValue)===[string] Sets the debugging panel. Where each digit in the string represents a debug information pane in order (11 of them). 1=open, 0=closed + a! r/ D5 y8 @: s4 ~5 f
; S% }4 E9 {! ]3 D' I9 K) n2 ]
Property Get Show===[string] Gets the debugging panel. ' z0 W$ [4 V/ r/ Z4 D
4 ]% N2 Y/ P! z0 R' V3 F: l- W8 Y( B
Property Let AllVars(bNewValue)===[bool] Sets wheather all variables will be displayed or not. true/false </P>< > roperty Get AllVars===[bool] Gets if all variables will be displayed. </P>< >-------------------------------------------------------------------------------- $ [. U' E' R! C8 Y' e
Public Methods </P>< >public sub===Print (label, output)
: q/ Y" g) g7 ^" R Adds a variable to the debug-informations. </P>< >public sub===GrabDatabaseInfo (byval oSQLDB)
6 M+ g) ^- O0 U4 x Adds the Database-connection object to the debug-instance. To display Database-information </P>< >public sub===draw () + V' Q5 y- t0 |& [8 T& U5 W' p
Draws the Debug-panel </P>< >--------------------------------------------------------------------------------
6 |; D. f/ X4 ~1 d. \: d1 |Methods Detail
! y1 A8 u: \% R5 J ( F/ Y3 e. W) v: t( b
public sub===Print (label, output)
% b6 a7 s2 s0 V: i' X5 X$ X+ pParameters:
7 C* G1 J- d! p4 Y, H/ p! d - label [string]: Description of the variable 2 t( I( e- C0 U! ~
- output [variable]: The variable itself 6 ?; Y; @$ M7 Q3 ~. e% Q9 r
# G. @ |1 N9 q& Y2 `0 J: \
public sub===GrabDatabaseInfo (byval oSQLDB) 2 q7 w. l% F; g; O
Parameters: " B9 k2 b8 y- w
- oSQLDB [object]: connection-object</P> |
|