📄 course.frm
字号:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form course
Caption = "课程数据录入界面"
ClientHeight = 9390
ClientLeft = 60
ClientTop = 270
ClientWidth = 13020
LinkTopic = "Form3"
Picture = "course.frx":0000
ScaleHeight = 9390
ScaleWidth = 13020
Begin MSAdodcLib.Adodc data
Height = 735
Left = 4800
Top = 6840
Width = 6255
_ExtentX = 11033
_ExtentY = 1296
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = 13500144
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=student"
OLEDBString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=student"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select * from course"
Caption = "选择你所要查看的记录"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "仿宋_GB2312"
Size = 24
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.CommandButton updata
BackColor = &H00FFFFFF&
Caption = "更新"
Height = 375
Left = 10800
Style = 1 'Graphical
TabIndex = 13
Top = 8640
Width = 1095
End
Begin VB.CommandButton motify
BackColor = &H00FFFFFF&
Caption = "修改"
Height = 375
Left = 8640
Style = 1 'Graphical
TabIndex = 12
Top = 8640
Width = 1215
End
Begin VB.CommandButton delete
BackColor = &H00FFFFFF&
Caption = "删除"
Height = 375
Left = 6240
Style = 1 'Graphical
TabIndex = 11
Top = 8640
Width = 1095
End
Begin VB.CommandButton add
BackColor = &H00FFFFFF&
Caption = "添加"
Height = 375
Left = 3720
MaskColor = &H00FFFFFF&
Style = 1 'Graphical
TabIndex = 10
Top = 8640
Width = 1215
End
Begin VB.TextBox score
DataField = "score"
DataSource = "data"
Height = 375
Left = 7800
TabIndex = 4
Top = 4320
Width = 2175
End
Begin VB.TextBox stuName
DataField = "numOfstu"
DataSource = "data"
Height = 375
Left = 7800
TabIndex = 3
Top = 3600
Width = 2895
End
Begin VB.TextBox cOffer
DataField = "course_offer"
DataSource = "data"
Height = 375
Left = 7800
TabIndex = 2
Top = 2880
Width = 2895
End
Begin VB.TextBox cName
DataField = "course_name"
DataSource = "data"
Height = 375
Left = 7800
TabIndex = 1
Top = 2160
Width = 2175
End
Begin VB.TextBox cID
DataField = "course_id"
DataSource = "data"
Height = 375
Left = 7800
TabIndex = 0
Top = 1440
Width = 2175
End
Begin VB.Label label5
BackStyle = 0 'Transparent
Caption = "课程学分"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 4
Left = 4680
TabIndex = 9
Top = 4440
Width = 1455
End
Begin VB.Label label3
BackStyle = 0 'Transparent
Caption = "课程教师"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 3
Left = 4680
TabIndex = 8
Top = 3000
Width = 1455
End
Begin VB.Label label2
BackStyle = 0 'Transparent
Caption = "课程名称"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 2
Left = 4680
TabIndex = 7
Top = 2280
Width = 1455
End
Begin VB.Label lebal1
BackStyle = 0 'Transparent
Caption = "课程编号"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 1
Left = 4680
TabIndex = 6
Top = 1560
Width = 1455
End
Begin VB.Label label4
BackStyle = 0 'Transparent
Caption = "修学者人数"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 0
Left = 4680
TabIndex = 5
Top = 3720
Width = 1695
End
End
Attribute VB_Name = "course"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub add_Click()
On Error Resume Next
delete.Enabled = Not delete.Enabled
modify.Enabled = Not modify.Enable
Update.Enabled = Not Update.Enable
If add.Caption = "添加" Then
add.Caption = "确认"
data.Recordset.AddNew
cID.SetFocus
Else
add.Caption = "添加"
data.Recordset.Update
data.Recordset.MoveLast
End If
End Sub
Private Sub delete_Click()
On Error Resume Next
data.Recordset.delete
data.Recordset.MoveNext
If data.Recordset.EOF Then
dataa.recorset.MoveLast
End If
End Sub
Private Sub motify_Click()
On Error Resume Next
If modift.Caption = "修改" Then
modify.Caption = "确认"
cID.SetFocus
Else
modify.Caption = "修改"
Adodc1.Recordset.Fields("course_name") = cName.Text
Adodc1.Recordset.Fields("course_id") = cID.Text
Adodc1.Recordset.Fields("course_offer") = cOffer.Text
Adodc1.Recordset.Fields("score") = score.Text
Adodc1.Recordset.Fields("numOfstu") = stuName.Text
Adodc1.Recordset.Update
End If
End Sub
Private Sub updata_Click()
main.Show
cID.Text = ""
cName.Text = ""
cOffer.Text = ""
stuName.Text = ""
score.Text = ""
course.Hide
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -