📄 数据库实例2学生信息编辑浏览data2.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Begin VB.Form 实验指导实例2
Caption = "Form2"
ClientHeight = 4305
ClientLeft = 60
ClientTop = 345
ClientWidth = 6540
LinkTopic = "Form2"
ScaleHeight = 4305
ScaleWidth = 6540
StartUpPosition = 3 '窗口缺省
Begin MSComDlg.CommonDialog CommonDialog1
Left = 2520
Top = 3480
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.CommandButton Command2
Caption = "Command2"
Height = 375
Left = 3120
TabIndex = 21
Top = 3720
Width = 1815
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 7
Left = 5040
TabIndex = 20
Top = 3720
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 6
Left = 5040
TabIndex = 19
Top = 3240
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 5
Left = 5040
TabIndex = 18
Top = 2760
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 4
Left = 5040
TabIndex = 17
Top = 2280
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 3
Left = 5040
TabIndex = 16
Top = 1800
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 2
Left = 5040
TabIndex = 15
Top = 1320
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 1
Left = 5040
TabIndex = 14
Top = 840
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "Command1"
Height = 375
Index = 0
Left = 5040
TabIndex = 13
Top = 360
Width = 1215
End
Begin VB.TextBox Text1
DataField = "学号"
DataSource = "Data1"
Height = 375
Left = 1200
TabIndex = 5
Text = "Text1"
Top = 360
Width = 1215
End
Begin VB.TextBox Text2
DataField = "姓名"
DataSource = "Data1"
Height = 375
Left = 1200
TabIndex = 4
Text = "Text2"
Top = 1200
Width = 1215
End
Begin VB.TextBox Text3
DataField = "出生年月"
DataSource = "Data1"
Height = 375
Left = 1200
TabIndex = 3
Text = "Text3"
Top = 2760
Width = 1215
End
Begin VB.TextBox Text4
DataField = "奖学金"
DataSource = "Data1"
Height = 375
Left = 1200
TabIndex = 2
Text = "Text4"
Top = 3600
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "check1"
DataField = "性别"
DataSource = "Data1"
Height = 375
Left = 360
TabIndex = 1
Top = 2040
Width = 2655
End
Begin VB.TextBox Text5
DataField = "简历"
DataSource = "Data1"
Height = 855
Left = 3120
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 0
Top = 360
Width = 1815
End
Begin VB.Data Data1
Caption = "data1"
Connect = "Access"
DatabaseName = "学籍1b.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 345
Left = 3240
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "学生"
Top = 0
Width = 1815
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "label1"
Height = 180
Left = 360
TabIndex = 12
Top = 480
Width = 540
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "label2"
Height = 180
Left = 360
TabIndex = 11
Top = 1320
Width = 540
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "label3"
Height = 180
Left = 360
TabIndex = 10
Top = 2880
Width = 540
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "label4"
Height = 180
Left = 360
TabIndex = 9
Top = 3720
Width = 540
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "label5"
Height = 180
Left = 2520
TabIndex = 8
Top = 360
Width = 540
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "label6"
Height = 180
Left = 2520
TabIndex = 7
Top = 1440
Width = 540
End
Begin VB.OLE OLE1
DataField = "照片"
DataSource = "Data1"
Height = 2175
Left = 3120
TabIndex = 6
Top = 1440
Width = 1815
End
End
Attribute VB_Name = "实验指导实例2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Form_Load()
Dim i As Integer
For i = 0 To 7
Command1(i).Caption = Mid("追加修改删除表首前翻后翻表尾返回", 2 * i + 1, 2)
Next i
Command1(3).Enabled = False
Command1(4).Enabled = False
Caption = "学生表信息编辑浏览"
Label1.Caption = "学号:"
Label2.Caption = "姓名:"
Label3.Caption = "出生年月:"
Label4.Caption = "奖学金:"
Label5.Caption = "简历:"
Label6.Caption = "照片:"
Check1.Caption = "性别(选中表示男,否则为女)"
Data1.Visible = False
CommonDialog1.Filter = "图片（*.bmp）|*.bmp"
Command2.Caption = "插入或调换图片"
End Sub
Private Sub Command1_Click(Index As Integer)
Dim n As Byte
'On Error GoTo errshow
Select Case Index
Case 0
Data1.Recordset.AddNew
Case 1
Data1.Recordset.Update
Case 2
n = MsgBox("是否真的要删除该记录？", vbYesNo, "删除确认")
'VB预定义的许多符号常量，对我们编程很有帮助。如需要消息框中有是、否两个按钮，
'而记不住决定按钮样式的数值，相比之下，可能与其等价的符号常量"vbYesNo"更
'容易想起来。又如，对话时用户按了"确定"，若记不清相应的返回值，VB的符号常量
' "vbYes"就是按"确认"时的返回值。
If n = vbYes Then Data1.Recordset.Delete
Case 3
Data1.Recordset.MoveFirst
Command1(3).Enabled = False
Command1(4).Enabled = False
Command1(5).Enabled = True
Command1(6).Enabled = True
Case 4
If Not Data1.Recordset.BOF Then
Data1.Recordset.MovePrevious
Else
Command1(3).Enabled = False
Command1(4).Enabled = False
End If
Command1(5).Enabled = True
Command1(6).Enabled = True
Case 5
If Not Data1.Recordset.EOF Then
Data1.Recordset.MoveNext
Else
Command1(5).Enabled = False
Command1(6).Enabled = False
End If
Command1(3).Enabled = True
Command1(4).Enabled = True
Case 6
Data1.Recordset.MoveLast
Command1(6).Enabled = False
Command1(5).Enabled = False
Command1(4).Enabled = True
Command1(3).Enabled = True
Case 7
End
End Select
'errshow:
' MsgBox Err.Description
End Sub
Private Sub Command2_Click()
CommonDialog1.ShowOpen
If CommonDialog1.FileName <> "" Then
OLE1.SourceDoc = CommonDialog1.FileName
OLE1.Action = 1
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -