📄 添加学生基本信息.frm
字号:
VERSION 5.00
Begin VB.Form 添加学生基本信息
Caption = "Form1"
ClientHeight = 6405
ClientLeft = 60
ClientTop = 345
ClientWidth = 7080
LinkTopic = "Form1"
ScaleHeight = 6405
ScaleWidth = 7080
StartUpPosition = 3 '窗口缺省
Begin VB.ComboBox Combo1
Height = 300
Left = 1680
TabIndex = 21
Text = " "
Top = 5040
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "取消"
Height = 495
Left = 3360
TabIndex = 20
Top = 4920
Width = 1215
End
Begin VB.CommandButton Command1
Caption = " 添加"
Height = 495
Left = 3360
TabIndex = 19
Top = 4200
Width = 1095
End
Begin VB.TextBox Text10
Height = 615
Left = 4680
TabIndex = 18
Text = " "
Top = 3120
Width = 1215
End
Begin VB.TextBox Text9
Height = 615
Left = 4680
TabIndex = 17
Text = " "
Top = 2160
Width = 1215
End
Begin VB.TextBox Text8
Height = 615
Left = 4680
TabIndex = 16
Text = " "
Top = 1080
Width = 1215
End
Begin VB.TextBox Text7
Height = 615
Left = 4680
TabIndex = 15
Text = " "
Top = 240
Width = 1215
End
Begin VB.TextBox Text5
Height = 615
Left = 1680
TabIndex = 14
Text = " "
Top = 3840
Width = 1215
End
Begin VB.TextBox Text4
Height = 615
Left = 1680
TabIndex = 13
Text = " "
Top = 2880
Width = 1215
End
Begin VB.TextBox Text3
Height = 615
Left = 1560
TabIndex = 12
Text = " "
Top = 1920
Width = 1215
End
Begin VB.TextBox Text2
Height = 615
Left = 1560
TabIndex = 11
Text = " "
Top = 1080
Width = 1215
End
Begin VB.TextBox Text1
Height = 615
Left = 1560
TabIndex = 10
Text = " "
Top = 240
Width = 1215
End
Begin VB.Label Label10
Caption = "班级编号"
Height = 615
Left = 3120
TabIndex = 9
Top = 3120
Width = 1215
End
Begin VB.Label Label9
Caption = "邮政编码"
Height = 615
Left = 3120
TabIndex = 8
Top = 2040
Width = 1215
End
Begin VB.Label Label8
Caption = "联系电话"
Height = 615
Left = 3120
TabIndex = 7
Top = 1080
Width = 1215
End
Begin VB.Label Label7
Caption = "家庭住址"
Height = 615
Left = 3000
TabIndex = 6
Top = 240
Width = 1215
End
Begin VB.Label Label6
Caption = "政治面貌"
Height = 615
Left = 120
TabIndex = 5
Top = 4800
Width = 1215
End
Begin VB.Label Label5
Caption = "出生日期"
Height = 615
Left = 120
TabIndex = 4
Top = 3720
Width = 1215
End
Begin VB.Label Label4
Caption = "族别"
Height = 615
Left = 120
TabIndex = 3
Top = 2880
Width = 1215
End
Begin VB.Label Label3
Caption = "性别"
Height = 615
Left = 240
TabIndex = 2
Top = 1920
Width = 1215
End
Begin VB.Label Label2
Caption = "姓名"
Height = 615
Left = 120
TabIndex = 1
Top = 1080
Width = 1215
End
Begin VB.Label Label1
Caption = "学号"
Height = 615
Left = 120
TabIndex = 0
Top = 240
Width = 1215
End
End
Attribute VB_Name = "添加学生基本信息"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs21 As New ADODB.Recordset
Private Sub Form_Load()
Combo1.AddItem "团员"
Combo1.AddItem "党员"
Combo1.AddItem "群众"
End Sub
Private Sub Command1_Click()
If rs21.State <> 0 Then rs21.Close
rs21.Open "select * from 学生基本信息表 where 学号='" & Trim(Text1) & "'", cnn, 3, 3
rs21.Find "学号= '" & Trim(Text1) & "'"
If rs21.EOF = False Then
MsgBox "对不起，您要录入的学生已经存在，请行新输入！"
Text1 = ""
Text1.SetFocus
Else
rs21.AddNew
rs21("学号") = Trim(Text1)
rs21("姓名") = Trim(Text2)
rs21("性别") = Trim(Text3)
rs21("族别") = Trim(Text4)
rs21("出生日期") = Trim(Text5)
rs21("政治面貌") = Combo1.Text
rs21("家庭住址") = Trim(Text7)
rs21("联系电话") = Trim(Text8)
rs21("邮政编码") = Trim(Text9)
rs21("班级编号") = Trim(Text10)
rs21.Update
rs21.Requery
MsgBox "信息添加成功"
Text1 = ""
Text2 = ""
Text3 = ""
Text4 = ""
Text5 = ""
Text10 = ""
Text7 = ""
Text8 = ""
Text9 = ""
Combo1.Text = ""
End If
End Sub
Private Sub Label13_Click()
Text1 = ""
Text2 = ""
Text3 = ""
Text4 = ""
Text5 = ""
Text10 = ""
Text7 = ""
Text8 = ""
Text9 = ""
Combo1.Text = ""
End Sub
Private Sub Command2_Click()
Me.Hide
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -