📄 frmtest.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{F0D2F211-CCB0-11D0-A316-00AA00688B10}#1.0#0"; "MSDATLST.OCX"
Begin VB.Form frmStudentInfo
Caption = "基本信息"
ClientHeight = 8400
ClientLeft = 60
ClientTop = 450
ClientWidth = 9060
Icon = "frmTest.frx":0000
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 8400
ScaleWidth = 9060
WindowState = 2 'Maximized
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 660
Left = 0
TabIndex = 26
Top = 0
Width = 9060
_ExtentX = 15981
_ExtentY = 1164
ButtonWidth = 1032
ButtonHeight = 1005
AllowCustomize = 0 'False
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 1
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "exit"
Description = "退出"
Object.ToolTipText = "退出"
ImageIndex = 1
EndProperty
EndProperty
End
Begin VB.Frame Frame4
Caption = "班级导师"
Height = 3135
Left = 4440
TabIndex = 24
Top = 4920
Width = 3975
Begin MSDataListLib.DataList dlistTeacher
Height = 2790
Left = 120
TabIndex = 25
Top = 240
Width = 3735
_ExtentX = 6588
_ExtentY = 4921
_Version = 393216
BackColor = -2147483643
ListField = "TEANAME"
BoundColumn = ""
End
End
Begin VB.Frame Frame3
Caption = "选修课程"
Height = 3135
Left = 120
TabIndex = 22
Top = 4920
Width = 4215
Begin MSDataListLib.DataList dlistCourse
Height = 2790
Left = 120
TabIndex = 23
Top = 240
Width = 3975
_ExtentX = 7011
_ExtentY = 4921
_Version = 393216
End
End
Begin VB.Frame Frame2
Caption = "所在单位"
Height = 1335
Left = 120
TabIndex = 13
Top = 3480
Width = 8295
Begin VB.Label lblSpec
Caption = "专业:"
Height = 255
Left = 4680
TabIndex = 21
Top = 840
Width = 3255
End
Begin VB.Label Label13
Caption = "专业:"
Height = 255
Left = 3960
TabIndex = 20
Top = 840
Width = 495
End
Begin VB.Label lblClass
Caption = "班级:"
Height = 255
Left = 1080
TabIndex = 19
Top = 840
Width = 2775
End
Begin VB.Label Label11
Caption = "班级:"
Height = 255
Left = 480
TabIndex = 18
Top = 840
Width = 495
End
Begin VB.Label lblDeptment
Caption = "系:"
Height = 255
Left = 4680
TabIndex = 17
Top = 360
Width = 3255
End
Begin VB.Label Label7
Caption = "系:"
Height = 255
Left = 4080
TabIndex = 16
Top = 360
Width = 495
End
Begin VB.Label lblInstitute
Caption = "学院:"
Height = 255
Left = 1080
TabIndex = 15
Top = 360
Width = 2055
End
Begin VB.Label Label3
Caption = "学院:"
Height = 255
Left = 480
TabIndex = 14
Top = 360
Width = 495
End
End
Begin VB.Frame Frame1
Caption = "基本信息"
Height = 2655
Left = 120
TabIndex = 0
Top = 720
Width = 8295
Begin VB.Label lblOther
Caption = "备注:"
Height = 615
Left = 1080
TabIndex = 12
Top = 1800
Width = 6975
End
Begin VB.Label Label10
Caption = "备注:"
Height = 255
Left = 480
TabIndex = 11
Top = 1800
Width = 495
End
Begin VB.Label lblAdress
Caption = "家庭住址:"
Height = 255
Left = 1080
TabIndex = 10
Top = 1320
Width = 6855
End
Begin VB.Label Label8
Caption = "家庭住址:"
Height = 255
Left = 120
TabIndex = 9
Top = 1320
Width = 855
End
Begin VB.Label lblSex
Caption = "性别:"
Height = 255
Left = 4800
TabIndex = 8
Top = 840
Width = 975
End
Begin VB.Label Label6
Caption = "性别:"
Height = 255
Left = 4080
TabIndex = 7
Top = 840
Width = 495
End
Begin VB.Label lblNO
Caption = "学号:"
Height = 255
Left = 1080
TabIndex = 6
Top = 840
Width = 2295
End
Begin VB.Label Label4
Caption = "学号:"
Height = 255
Left = 480
TabIndex = 5
Top = 840
Width = 495
End
Begin VB.Label lblBirth
Caption = "出生年月:"
Height = 255
Left = 4800
TabIndex = 4
Top = 360
Width = 1935
End
Begin VB.Label Label2
Caption = "出生年月:"
Height = 255
Left = 3720
TabIndex = 3
Top = 360
Width = 975
End
Begin VB.Label lblName
Caption = "姓名:"
Height = 255
Left = 1080
TabIndex = 2
Top = 360
Width = 1575
End
Begin VB.Label Label1
Caption = "姓名:"
Height = 255
Left = 480
TabIndex = 1
Top = 360
Width = 495
End
End
Begin MSComctlLib.ImageList ImageList1
Left = 0
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 32
ImageHeight = 32
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 1
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmTest.frx":0BF2
Key = ""
EndProperty
EndProperty
End
End
Attribute VB_Name = "frmStudentInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rsStudent As New ADODB.Recordset
Dim rsDeptment As New ADODB.Recordset
Dim rsTeacher As New ADODB.Recordset
Dim rsCourse As New ADODB.Recordset
Dim sql As String
Private Sub Form_Load()
' rsStudent.CursorLocation = adUseClient
' rsStudent.CursorType = adOpenStatic
' rsDeptment.CursorLocation = adUseClient
' rsDeptment.CursorType = adOpenStatic
' rsTeacher.CursorLocation = adUseClient
' rsTeacher.CursorType = adOpenStatic
' rsCourse.CursorLocation = adUseClient
' rsCourse.CursorType = adOpenStatic
'向界面添加基本信息
sql = "select * from studentinfo where stuno = '" + UserNO + "'"
cn.exeSQL sql, rsStudent, False
Set lblName.DataSource = rsStudent
lblName.DataField = "stuname"
Set lblBirth.DataSource = rsStudent
lblBirth.DataField = "stubirth"
Set lblSex.DataSource = rsStudent
lblSex.DataField = "stusex"
Set lblOther.DataSource = rsStudent
lblOther.DataField = "stuother"
Set lblAdress.DataSource = rsStudent
lblAdress.DataField = "stuadress"
Set lblNO.DataSource = rsStudent
lblNO.DataField = "stuno"
'向界面添加机构信息
sql = "select * from studentdeptment where stuno = '" + UserNO + "'"
cn.exeSQL sql, rsDeptment, False
Set lblInstitute.DataSource = rsDeptment
lblInstitute.DataField = "insname"
Set lblDeptment.DataSource = rsDeptment
lblDeptment.DataField = "deptname"
Set lblClass.DataSource = rsDeptment
lblClass.DataField = "classname"
Set lblSpec.DataSource = rsDeptment
lblSpec.DataField = "specname"
'向界面添加导师信息
sql = "select * from studentteacher where stuno = '" + UserNO + "'"
cn.exeSQL sql, rsTeacher, False
Set dlistTeacher.RowSource = rsTeacher
dlistTeacher.ListField = "teaname"
'向界面添加课程信息
sql = "select * from studentcourse where stuno = '" + UserNO + "'"
cn.exeSQL sql, rsCourse, False
Set dlistCourse.RowSource = rsCourse
dlistCourse.ListField = "cosname"
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "exit"
Unload Me
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -