📄 addstu.frm
字号:
VERSION 5.00
Begin VB.Form frmXueYuan
BackColor = &H00FFC0C0&
Caption = "新学员登记"
ClientHeight = 5955
ClientLeft = 60
ClientTop = 450
ClientWidth = 6870
LinkTopic = "Form1"
ScaleHeight = 5955
ScaleWidth = 6870
StartUpPosition = 3 '窗口缺省
Begin VB.CommandButton cmdNext
Caption = "下一条"
Height = 375
Left = 5160
TabIndex = 26
Top = 4920
Width = 1095
End
Begin VB.CommandButton cmdPrev
Caption = "上一条"
Height = 375
Left = 3720
TabIndex = 25
Top = 4920
Width = 1095
End
Begin VB.CommandButton cmdSave
Caption = "保存"
Height = 375
Left = 6000
TabIndex = 24
Top = 5400
Width = 855
End
Begin VB.CommandButton cmdDel
Caption = "删除"
Height = 375
Left = 5040
TabIndex = 23
Top = 5400
Width = 855
End
Begin VB.TextBox Text
Height = 270
Index = 8
Left = 1440
TabIndex = 8
Top = 5400
Width = 1455
End
Begin VB.TextBox Text
Height = 3615
Index = 9
Left = 3240
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 11
Top = 1200
Width = 3495
End
Begin VB.CommandButton cmdEdit
Caption = "修改"
Height = 375
Left = 4080
TabIndex = 10
Top = 5400
Width = 855
End
Begin VB.CommandButton cmdAdd
Caption = "增加"
Height = 375
Left = 3120
TabIndex = 9
Top = 5400
Width = 855
End
Begin VB.TextBox Text
Height = 270
Index = 7
Left = 1440
TabIndex = 7
Top = 4800
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 6
Left = 1440
TabIndex = 6
Top = 4230
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 5
Left = 1440
TabIndex = 5
Top = 3660
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 4
Left = 1440
TabIndex = 4
Top = 3105
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 3
Left = 1440
TabIndex = 3
Top = 2535
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 2
Left = 1440
TabIndex = 2
Top = 1965
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 1
Left = 1440
TabIndex = 1
Top = 1410
Width = 1455
End
Begin VB.TextBox Text
Height = 270
Index = 0
Left = 1440
TabIndex = 0
Top = 840
Width = 1455
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "备注："
Height = 255
Left = 3240
TabIndex = 22
Top = 840
Width = 735
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "实交学费："
Height = 255
Index = 8
Left = 360
TabIndex = 21
Top = 5400
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "共计学费："
Height = 255
Index = 7
Left = 360
TabIndex = 20
Top = 4800
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "联系电话："
Height = 255
Index = 6
Left = 360
TabIndex = 19
Top = 4230
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "家庭住址："
Height = 255
Index = 5
Left = 360
TabIndex = 18
Top = 3660
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "结课日期："
Height = 255
Index = 4
Left = 360
TabIndex = 17
Top = 3105
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "开课日期："
Height = 255
Index = 3
Left = 360
TabIndex = 16
Top = 2535
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "所学科目："
Height = 255
Index = 2
Left = 360
TabIndex = 15
Top = 1965
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "学员姓名："
Height = 255
Index = 1
Left = 360
TabIndex = 14
Top = 1410
Width = 975
End
Begin VB.Label Label
BackStyle = 0 'Transparent
Caption = "学员编号："
Height = 255
Index = 0
Left = 360
TabIndex = 13
Top = 840
Width = 975
End
Begin VB.Label lblBiaoTi
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "新 学 员 登 记"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 2400
TabIndex = 12
Top = 240
Width = 2535
End
End
Attribute VB_Name = "frmXueYuan"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim conn As New ADODb.Connection
Dim rs As New ADODb.Recordset
Dim strSql As String
Dim strStatus As String
Private Sub cmdAdd_Click()
strStatus = "增加"
lockInput (True)
For I = 0 To 9
Text(I).Text = ""
Next I
Text(0).SetFocus
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdAdd.Enabled = False
cmdEdit.Enabled = False
cmdDel.Enabled = False
cmdSave.Enabled = True
End Sub
Private Sub cmdEdit_Click()
strStatus = "修改"
lockInput (True)
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdAdd.Enabled = False
cmdEdit.Enabled = False
cmdDel.Enabled = False
cmdSave.Enabled = True
End Sub
Private Sub cmdDel_Click()
If MsgBox("确定要删除姓名为【" & Text(1).Text & "】的记录吗？", vbYesNo, "提示") = vbYes Then
rs.Delete
rs.MovePrevious
If rs.BOF Or rs.EOF Or rs.RecordCount = 0 Then
MsgBox "已经没有记录！"
For I = 0 To 9
Text(I).Text = ""
Next I
lockInput (False)
cmdDel.Enabled = False
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdAdd.Enabled = True
cmdEdit.Enabled = False
cmdDel.Enabled = False
cmdSave.Enabled = False
Exit Sub
Else
cmdDel.Enabled = True
cmdPrev.Enabled = True
cmdNext.Enabled = True
dispInfo
End If
End If
End Sub
Private Sub cmdSave_Click()
If strStatus = "增加" Then
For I = 0 To 8
If Text(I) = "" Then
TiShi = MsgBox(Label(I).Caption & "不能为空！", vbExclamation + vbOKOnly, "警告")
Text(I).SetFocus
Exit Sub
End If
Next I
rs.AddNew
rs.Fields("学员编号") = Text(0).Text
rs.Fields("学员姓名") = Text(1).Text
rs.Fields("所学科目") = Text(2).Text
rs.Fields("开课日期") = Text(3).Text
rs.Fields("结课日期") = Text(4).Text
rs.Fields("家庭住址") = Text(5).Text
rs.Fields("联系电话") = Text(6).Text
rs.Fields("共计学费") = Val(Text(7).Text)
rs.Fields("实交学费") = Val(Text(8).Text)
rs.Fields("备注") = Text(9).Text
rs.Update
cmdAdd.Enabled = True
cmdEdit.Enabled = True
cmdDel.Enabled = True
cmdPrev.Enabled = True
cmdNext.Enabled = True
cmdSave.Enabled = False
lockInput (False)
MsgBox ("添加成功！")
ElseIf strStatus = "修改" Then
rs.Fields("学员编号") = Text(0).Text
rs.Fields("学员姓名") = Text(1).Text
rs.Fields("所学科目") = Text(2).Text
rs.Fields("开课日期") = Text(3).Text
rs.Fields("结课日期") = Text(4).Text
rs.Fields("家庭住址") = Text(5).Text
rs.Fields("联系电话") = Text(6).Text
rs.Fields("共计学费") = Text(7).Text
rs.Fields("实交学费") = Text(8).Text
rs.Fields("备注") = Text(9).Text
rs.Update
cmdAdd.Enabled = True
cmdEdit.Enabled = True
cmdDel.Enabled = True
cmdPrev.Enabled = True
cmdNext.Enabled = True
cmdSave.Enabled = False
lockInput (False)
MsgBox ("修改成功！")
Else
MsgBox "没有修改，不能保存！"
End If
End Sub
Private Sub cmdPrev_Click()
rs.MovePrevious
cmdNext.Enabled = True
If rs.BOF Then
rs.MoveNext
cmdPrev.Enabled = False
Else
dispInfo
End If
End Sub
Private Sub cmdNext_Click()
rs.MoveNext
cmdPrev.Enabled = True
If rs.EOF Then
rs.MovePrevious
cmdNext.Enabled = False
Else
dispInfo
End If
End Sub
Private Sub Form_Load()
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
DBpath = App.Path + "\database\school.mdb"
strSql = "provider=Microsoft.Jet.oledb.4.0;data source=" & DBpath & ";Jet OLEDB:Database Password=" & pwd & ";"
conn.Open strSql
strSql = "Select * from [学员档案]"
rs.Open strSql, conn, adOpenKeyset, adLockPessimistic
If rs.BOF Or rs.EOF Or rs.RecordCount = 0 Then
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdAdd.Enabled = True
cmdEdit.Enabled = False
cmdDel.Enabled = False
cmdSave.Enabled = False
lockInput (False)
MsgBox "没有学员记录！请用填加按钮增加记录！"
Exit Sub
Else
dispInfo
End If
lockInput (False)
End Sub
Private Sub dispInfo()
Text(0).Text = rs.Fields("学员编号")
Text(1).Text = rs.Fields("学员姓名")
Text(2).Text = rs.Fields("所学科目")
Text(3).Text = rs.Fields("开课日期")
Text(4).Text = rs.Fields("结课日期")
Text(5).Text = rs.Fields("家庭住址")
Text(6).Text = rs.Fields("联系电话")
Text(7).Text = rs.Fields("共计学费")
Text(8).Text = rs.Fields("实交学费")
Text(9).Text = rs.Fields("备注")
End Sub
Private Sub Form_Unload(Cancel As Integer)
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
End Sub
Private Sub Text_KeyPress(Index As Integer, KeyAscii As Integer)
If KeyAscii = 13 Then
SendKeys "{TAB}"
End If
End Sub
Private Sub lockInput(yn As Boolean)
For I = 0 To 9
Text(I).Enabled = yn
Next I
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -