📄 dataenvironment1.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
ClientHeight = 9870
ClientLeft = 0
ClientTop = 0
ClientWidth = 11235
_ExtentX = 19817
_ExtentY = 17410
FolderFlags = 1
TypeLibGuid = "{900694EE-F1F1-4094-A024-85B1AFB9EF13}"
TypeInfoGuid = "{FD1AC768-38B0-4834-9853-1AD01CC032AD}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "Connection1"
ConnDispId = 1001
SourceOfData = 3
ConnectionSource= "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=学生信息管理系统;Data Source=127.0.0.1"
Expanded = -1 'True
IsSQL = -1 'True
QuoteChar = 34
SeparatorChar = 46
EndProperty
NumRecordsets = 11
BeginProperty Recordset1
CommandName = "CmdStudent"
CommDispId = 1002
RsDispId = 1041
CommandText = "dbo.STUDENT"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 13
BeginProperty Field1
Precision = 0
Size = 6
Scale = 0
Type = 129
Name = "studentNo"
Caption = "studentNo"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 200
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 2
Scale = 0
Type = 129
Name = "sex"
Caption = "sex"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "departNO"
Caption = "departNO"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "classno"
Caption = "classno"
EndProperty
BeginProperty Field6
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "birthday"
Caption = "birthday"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "native"
Caption = "native"
EndProperty
BeginProperty Field8
Precision = 0
Size = 20
Scale = 0
Type = 129
Name = "phone"
Caption = "phone"
EndProperty
BeginProperty Field9
Precision = 0
Size = 100
Scale = 0
Type = 200
Name = "address"
Caption = "address"
EndProperty
BeginProperty Field10
Precision = 0
Size = 8
Scale = 0
Type = 129
Name = "zipcode"
Caption = "zipcode"
EndProperty
BeginProperty Field11
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "email"
Caption = "email"
EndProperty
BeginProperty Field12
Precision = 0
Size = 2147483647
Scale = 0
Type = 205
Name = "photo"
Caption = "photo"
EndProperty
BeginProperty Field13
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "memo"
Caption = "memo"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "dbo_stu_GetAllStudent"
CommDispId = 1003
RsDispId = 1006
CommandText = "dbo.stu_GetAllStudent"
ActiveConnectionName= "Connection1"
CursorType = 1
Locktype = 3
CallSyntax = "{? = CALL dbo.stu_GetAllStudent }"
CommandCursorLocation= 2
IsRSReturning = -1 'True
NumFields = 12
BeginProperty Field1
Precision = 0
Size = 6
Scale = 0
Type = 129
Name = "学号"
Caption = "学号"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 200
Name = "姓名"
Caption = "姓名"
EndProperty
BeginProperty Field3
Precision = 0
Size = 2
Scale = 0
Type = 129
Name = "性别"
Caption = "性别"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "所属院系"
Caption = "所属院系"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "班级"
Caption = "班级"
EndProperty
BeginProperty Field6
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "出生日期"
Caption = "出生日期"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "籍贯"
Caption = "籍贯"
EndProperty
BeginProperty Field8
Precision = 0
Size = 20
Scale = 0
Type = 129
Name = "电话"
Caption = "电话"
EndProperty
BeginProperty Field9
Precision = 0
Size = 100
Scale = 0
Type = 200
Name = "家庭住址"
Caption = "家庭住址"
EndProperty
BeginProperty Field10
Precision = 0
Size = 8
Scale = 0
Type = 129
Name = "邮编"
Caption = "邮编"
EndProperty
BeginProperty Field11
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "电子邮件"
Caption = "电子邮件"
EndProperty
BeginProperty Field12
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "备注"
Caption = "备注"
EndProperty
NumGroups = 0
ParamCount = 1
BeginProperty P1
RealName = "@RETURN_VALUE"
UserName = "RETURN_VALUE"
Direction = 4
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = 0 'False
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "dbo_stu_AddBasicStudentInfo"
CommDispId = 1007
RsDispId = -1
CommandText = "dbo.stu_AddBasicStudentInfo"
ActiveConnectionName= "Connection1"
CallSyntax = "{? = CALL dbo.stu_AddBasicStudentInfo( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }"
NumFields = 0
NumGroups = 0
ParamCount = 13
BeginProperty P1
RealName = "@RETURN_VALUE"
Direction = 4
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = 0 'False
EndProperty
BeginProperty P2
RealName = "@studentNo"
Direction = 1
Precision = 0
Scale = 0
Size = 6
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P3
RealName = "@name"
Direction = 1
Precision = 0
Scale = 0
Size = 20
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P4
RealName = "@sex"
Direction = 1
Precision = 0
Scale = 0
Size = 2
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P5
RealName = "@departName"
Direction = 1
Precision = 0
Scale = 0
Size = 50
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P6
RealName = "@className"
Direction = 1
Precision = 0
Scale = 0
Size = 50
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P7
RealName = "@birthday"
Direction = 1
Precision = 0
Scale = 0
Size = 0
DataType = 135
HostType = 7
Required = -1 'True
EndProperty
BeginProperty P8
RealName = "@native"
Direction = 1
Precision = 0
Scale = 0
Size = 50
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P9
RealName = "@phone"
Direction = 1
Precision = 0
Scale = 0
Size = 20
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P10
RealName = "@address"
Direction = 1
Precision = 0
Scale = 0
Size = 100
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P11
RealName = "@zipCode"
Direction = 1
Precision = 0
Scale = 0
Size = 8
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -