📄 frmcount.frm
字号:
VERSION 5.00
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form frmCount
Caption = "数据统计"
ClientHeight = 1635
ClientLeft = 60
ClientTop = 495
ClientWidth = 7305
Icon = "frmCount.frx":0000
LinkTopic = "Form1"
ScaleHeight = 1635
ScaleWidth = 7305
StartUpPosition = 2 '屏幕中心
Begin TabDlg.SSTab SSTab1
Height = 1695
Left = 0
TabIndex = 0
Top = 0
Width = 7335
_ExtentX = 12938
_ExtentY = 2990
_Version = 393216
TabHeight = 520
ForeColor = 16512
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
TabCaption(0) = "读者统计"
TabPicture(0) = "frmCount.frx":0442
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "Label1"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "Text1"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).ControlCount= 2
TabCaption(1) = "书籍统计"
TabPicture(1) = "frmCount.frx":045E
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "Label2"
Tab(1).Control(1)= "Text2"
Tab(1).ControlCount= 2
TabCaption(2) = "借阅统计"
TabPicture(2) = "frmCount.frx":047A
Tab(2).ControlEnabled= 0 'False
Tab(2).Control(0)= "Label3"
Tab(2).Control(1)= "Text3"
Tab(2).ControlCount= 2
Begin VB.TextBox Text3
Alignment = 2 'Center
BackColor = &H00E0E0E0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = -72360
Locked = -1 'True
TabIndex = 6
Text = "Text3"
Top = 720
Width = 1935
End
Begin VB.TextBox Text2
Alignment = 2 'Center
BackColor = &H00E0E0E0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = -72240
Locked = -1 'True
TabIndex = 5
Text = "Text2"
Top = 720
Width = 1935
End
Begin VB.TextBox Text1
Alignment = 2 'Center
BackColor = &H00E0E0E0&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3000
Locked = -1 'True
TabIndex = 4
Text = "Text1"
Top = 720
Width = 2055
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "共借出书籍： 本"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = -73800
TabIndex = 3
Top = 840
Width = 3675
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "书籍总数： 本"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = -73440
TabIndex = 2
Top = 840
Width = 3420
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "读者总人数： 人"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 1560
TabIndex = 1
Top = 840
Width = 3810
End
End
End
Attribute VB_Name = "frmCount"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub TabStrip1_Click()
End Sub
Private Sub Form_Load()
Dim ADOrs As New Recordset
Dim Rec As Integer
ADOrs.ActiveConnection = ADOcn
ADOrs.CursorLocation = adUseClient
ADOrs.CursorType = adOpenDynamic
'ADOrs.CursorType = adOpenStatic
ADOrs.LockType = adLockOptimistic
ADOrs.Open "Select * From 读者信息 Order By 借书证号"
ADOrs.MoveLast
Rec = ADOrs.RecordCount
Text1.Text = Str(Rec)
ADOrs.Close
ADOrs.Open "Select * From 书籍信息 Order By 书籍编号"
ADOrs.MoveLast
Rec = ADOrs.RecordCount
Text2.Text = Str(Rec)
ADOrs.Close
ADOrs.Open "Select * From 借阅信息 Order By 借书证号"
ADOrs.MoveLast
Rec = ADOrs.RecordCount
Text3.Text = Str(Rec)
ADOrs.Close
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -