📄 formcoursequery.frm
字号:
VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form frmCourseQuery
BorderStyle = 1 'Fixed Single
Caption = "课程安排"
ClientHeight = 5655
ClientLeft = 45
ClientTop = 435
ClientWidth = 9420
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5655
ScaleWidth = 9420
StartUpPosition = 1 '所有者中心
Begin VB.CommandButton cmdQuit
Caption = "退出"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3960
TabIndex = 18
Top = 2880
Width = 615
End
Begin VB.Data dataAll
Caption = "Data1"
Connect = "Access 2000;"
DatabaseName = "C:\Program Files\StudentMIS\StudentMIS.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 495
Left = 4560
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "CourseTab1"
Top = 5400
Visible = 0 'False
Width = 2055
End
Begin VB.Data dataCourseSe
Caption = "课程浏览"
Connect = "Access 2000;"
DatabaseName = "C:\Program Files\StudentMIS\StudentMIS.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 495
Left = 6840
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "CourseSelect"
Top = 5400
Visible = 0 'False
Width = 2415
End
Begin VB.TextBox txtClassDate
DataField = "ClassDate"
DataSource = "dataCourseSe"
Height = 375
Left = 5520
MaxLength = 10
TabIndex = 16
Text = "Text1"
Top = 1080
Width = 2175
End
Begin VB.TextBox txtClassRoom
DataField = "ClassRoom"
DataSource = "dataCourseSe"
Height = 375
Left = 5520
MaxLength = 20
TabIndex = 14
Text = "Text1"
Top = 1680
Width = 2175
End
Begin VB.CommandButton cmdOK
Caption = "查询"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 2040
TabIndex = 12
Top = 2880
Width = 615
End
Begin VB.TextBox txtCourseID
DataField = "CourseID"
DataSource = "dataCourse"
Height = 375
Left = 2040
MaxLength = 10
TabIndex = 5
Text = "Text1"
Top = 480
Width = 2055
End
Begin VB.TextBox txtCourseName
DataField = "CourseName"
DataSource = "dataCourse"
Height = 375
Left = 5520
MaxLength = 50
TabIndex = 4
Text = "Text1"
Top = 480
Width = 3135
End
Begin VB.TextBox txtTeacher
DataField = "Teacher"
DataSource = "dataCourse"
Height = 375
Left = 2040
MaxLength = 8
TabIndex = 3
Text = "Text1"
Top = 1080
Width = 2055
End
Begin VB.TextBox txtCredit
DataField = "Credit"
DataSource = "dataCourse"
Height = 375
Left = 2040
MaxLength = 4
TabIndex = 2
Text = "Text1"
Top = 1680
Width = 2055
End
Begin VB.TextBox txtPeriod
DataField = "Period"
DataSource = "dataCourse"
Height = 375
Left = 2040
MaxLength = 256
TabIndex = 1
Text = "Text1"
Top = 2280
Width = 2055
End
Begin VB.Data dataCourse
Caption = "课程浏览"
Connect = "Access 2000;"
DatabaseName = "C:\Program Files\StudentMIS\StudentMIS.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 495
Left = 2040
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "Course"
Top = 5400
Visible = 0 'False
Width = 2415
End
Begin VB.TextBox txtDesc
DataField = "Description"
DataSource = "dataCourse"
Height = 855
Left = 5520
MaxLength = 500
TabIndex = 0
Text = "Text1"
Top = 2280
Width = 3255
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "FormCourseQuery.frx":0000
Height = 1815
Left = 1560
OleObjectBlob = "FormCourseQuery.frx":0016
TabIndex = 17
Top = 3480
Width = 6135
End
Begin VB.Label Label9
Caption = "上课学生"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 600
TabIndex = 19
Top = 3360
Width = 855
End
Begin VB.Label Label8
Caption = "上课时间"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4320
TabIndex = 15
Top = 1080
Width = 975
End
Begin VB.Label Label7
Caption = "上课地点"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4320
TabIndex = 13
Top = 1680
Width = 975
End
Begin VB.Label Label1
Caption = "输入课程编号"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 360
TabIndex = 11
Top = 480
Width = 1335
End
Begin VB.Label Label2
Caption = "课程名称"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4320
TabIndex = 10
Top = 480
Width = 855
End
Begin VB.Label Label3
Caption = "学分"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1320
TabIndex = 9
Top = 1680
Width = 495
End
Begin VB.Label Label4
Caption = "学时"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1320
TabIndex = 8
Top = 2280
Width = 495
End
Begin VB.Label Label5
Caption = "任课老师"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 960
TabIndex = 7
Top = 1080
Width = 855
End
Begin VB.Label Label6
Caption = " 说明"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 6
Top = 2280
Width = 615
End
End
Attribute VB_Name = "frmCourseQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdOK_Click()
'strSQL = "SELECT * FROM Student , Class ,Department "
'txtStudentID.Text = " SELECT * FROM Student WHERE StudentID = '" & txtStudent.Text & "'"
strSQL = "SELECT * FROM Course WHERE CourseID ='" & txtCourseID.Text & "'"
dataCourse.RecordSource = strSQL
dataCourseSe.RecordSource = " SELECT * FROM CourseSelect WHERE CourseID = '" & txtCourseID.Text & "'"
dataAll.RecordSource = "SELECT CourseSelect.StudentID, Course.CourseID,Student.Name FROM CourseSelect,Course,Student WHERE CourseSelect.CourseID = '" & txtCourseID.Text & "' AND Course.CourseID = '" & txtCourseID.Text & "' AND Student.StudentID=CourseSelect.StudentID"
'strSQL = "SELECT * FROM Student WHERE
dataCourse.Refresh
dataCourseSe.Refresh
dataAll.Refresh
End Sub
Private Sub cmdQuit_Click()
Unload Me
End Sub
Private Sub Form_Load()
dataCourse.DatabaseName = App.Path & "\StudentMIS.mdb"
dataCourseSe.DatabaseName = App.Path & "\StudentMIS.mdb"
dataAll.DatabaseName = App.Path & "\StudentMIS.mdb"
dataAll.Visible = False
txtCourseID.Text = ""
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -