📄 datae.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataE
ClientHeight = 10020
ClientLeft = 1080
ClientTop = 1500
ClientWidth = 8160
_ExtentX = 14393
_ExtentY = 17674
FolderFlags = 3
TypeLibGuid = "{A5DC9AF5-9235-11D1-B067-00DD01144174}"
TypeInfoGuid = "{A5DC9AF6-9235-11D1-B067-00DD01144174}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "conLibrary"
ConnDispId = 1001
SourceOfData = 3
ConnectionSource= $"DataE.dsx":0000
Expanded = -1 'True
QuoteChar = 96
SeparatorChar = 46
EndProperty
NumRecordsets = 10
BeginProperty Recordset1
CommandName = "cmdRegister"
CommDispId = 1002
RsDispId = 1013
CommandText = "select * from usertable where username=?"
ActiveConnectionName= "conLibrary"
CommandType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 9
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "UserID"
Caption = "UserID"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "UserName"
Caption = "UserName"
EndProperty
BeginProperty Field3
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "pwd"
Caption = "pwd"
EndProperty
BeginProperty Field4
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "RealName"
Caption = "RealName"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Age"
Caption = "Age"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Unit"
Caption = "Unit"
EndProperty
BeginProperty Field7
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "RegisterTime"
Caption = "RegisterTime"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "UserType"
Caption = "UserType"
EndProperty
BeginProperty Field9
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "State"
Caption = "State"
EndProperty
NumGroups = 0
ParamCount = 1
BeginProperty P1
RealName = "?"
UserName = "strName"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "cmdAdd"
CommDispId = 1008
RsDispId = -1
CommandText = "insert into usertable (username,pwd,realname,unit,registertime,age,usertype,state) values (?,?,?,?,?,?,?,?)"
ActiveConnectionName= "conLibrary"
CommandType = 1
NumFields = 0
NumGroups = 0
ParamCount = 8
BeginProperty P1
RealName = "?"
UserName = "strUserName"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P2
RealName = "?"
UserName = "strPwd"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P3
RealName = "?"
UserName = "strRealName"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P4
RealName = "?"
UserName = "strUnit"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P5
RealName = "?"
UserName = "dateRT"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 7
HostType = 7
Required = -1 'True
EndProperty
BeginProperty P6
RealName = "?"
UserName = "intAge"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 3
HostType = 2
Required = -1 'True
EndProperty
BeginProperty P7
RealName = "?"
UserName = "intUserType"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 3
HostType = 2
Required = -1 'True
EndProperty
BeginProperty P8
RealName = "?"
UserName = "intState"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 3
HostType = 2
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "cmdUser"
CommDispId = 1015
RsDispId = 1027
CommandText = $"DataE.dsx":00A9
ActiveConnectionName= "conLibrary"
CommandType = 1
Locktype = 3
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "username"
Caption = "username"
EndProperty
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "realname"
Caption = "realname"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "age"
Caption = "age"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "unit"
Caption = "unit"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "usertype"
Caption = "usertype"
EndProperty
BeginProperty Field6
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "state"
Caption = "state"
EndProperty
BeginProperty Field7
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "registertime"
Caption = "registertime"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "cmdFindUser"
CommDispId = 1028
RsDispId = 1088
CommandText = "select username,realname,age,unit,usertype,state,registertime from usertable"
ActiveConnectionName= "conLibrary"
CommandType = 1
Locktype = 3
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "username"
Caption = "username"
EndProperty
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "realname"
Caption = "realname"
EndProperty
BeginProperty Field3
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "age"
Caption = "age"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "unit"
Caption = "unit"
EndProperty
BeginProperty Field5
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "usertype"
Caption = "usertype"
EndProperty
BeginProperty Field6
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "state"
Caption = "state"
EndProperty
BeginProperty Field7
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "registertime"
Caption = "registertime"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset5
CommandName = "cmdStudentAdd"
CommDispId = 1035
RsDispId = -1
CommandText = $"DataE.dsx":0110
ActiveConnectionName= "conLibrary"
CommandType = 1
NumFields = 0
NumGroups = 0
ParamCount = 9
BeginProperty P1
RealName = "?"
UserName = "bookname"
Direction = 1
Precision = 0
Scale = 0
Size = 50
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P2
RealName = "?"
UserName = "bookindex"
Direction = 1
Precision = 0
Scale = 0
Size = 510
DataType = 3
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P3
RealName = "?"
UserName = "author"
Direction = 1
Precision = 0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -