📄 学生信息查询.frm
字号:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form search_student
BorderStyle = 1 'Fixed Single
Caption = "学生信息查询"
ClientHeight = 6810
ClientLeft = 3360
ClientTop = 3120
ClientWidth = 9915
LinkTopic = "Form1"
MaxButton = 0 'False
ScaleHeight = 6810
ScaleWidth = 9915
Begin MSAdodcLib.Adodc Adodc1
Height = 735
Left = 960
Top = 3600
Visible = 0 'False
Width = 2415
_ExtentX = 4260
_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 = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=stu_manage"
OLEDBString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=stu_manage"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = "sa"
Password = "manager"
RecordSource = ""
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.ListBox List1
Columns = 2
Height = 4740
Left = 240
TabIndex = 5
Top = 960
Width = 9375
End
Begin VB.CommandButton Command2
Caption = "查询"
Height = 495
Left = 8400
TabIndex = 4
Top = 240
Width = 1215
End
Begin VB.ComboBox Combo2
Height = 300
Left = 6240
Style = 2 'Dropdown List
TabIndex = 3
Top = 360
Width = 1815
End
Begin VB.CommandButton Command1
Caption = "查询"
Height = 495
Left = 3000
TabIndex = 2
Top = 240
Width = 1215
End
Begin VB.ComboBox Combo1
Height = 300
Left = 1680
Style = 2 'Dropdown List
TabIndex = 1
Top = 360
Width = 1095
End
Begin VB.Label showinfo
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 615
Left = 360
TabIndex = 7
Top = 6000
Width = 9255
End
Begin VB.Label Label2
Caption = "专业"
Height = 255
Left = 5640
TabIndex = 6
Top = 480
Width = 375
End
Begin VB.Line Line1
X1 = 5040
X2 = 5040
Y1 = 240
Y2 = 720
End
Begin VB.Label Label1
Caption = "入学年份"
Height = 255
Left = 840
TabIndex = 0
Top = 480
Width = 855
End
End
Attribute VB_Name = "search_student"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public rs As New ADODB.Recordset
Public adoconn As New ADODB.Connection 'Connection 对象代表了打开与数据源的连接。
'按入学年份查询
Private Sub Command1_Click()
showinfo.Caption = ""
List1.clear
Dim year As String
year = Combo1.Text
If Len(year) = 0 Then
MsgBox "请选择入学年份！"
Combo1.SetFocus
Exit Sub
End If
adoconn.Open
rs.Open "select * from stu where enter_year='" & year & "'", adoconn
If rs.RecordCount = 0 Then
MsgBox "没有" & year & "年入学的学生！"
rs.Close
adoconn.Close
Combo1.SetFocus
Exit Sub
End If
rs.Close
List1.clear
List1.AddItem " 学号 姓名 性别 民族 政治面貌 出生年月 家庭住址 邮政编码 学院 专业 班级"
rs.Open "select no , stu.name as name1, sex ,nation.name as name2, policy.name as name3,birth , addr , post ,college.name as name4, enter_year ,major.name as name5, class from stu ,nation,policy,college,major where stu.nation=nation.id and stu.policy = policy.id and stu.college=college.id and stu.major=major.id and major.college=college.id and enter_year='" & year & "'", adoconn
rs.MoveFirst
Dim i As Integer
For i = 0 To rs.RecordCount - 1
List1.AddItem rs.Fields("no") & Space(2) & rs.Fields("name1") & Space(2) & rs.Fields("sex") & Space(2) & rs.Fields("name2") & Space(2) & rs.Fields("name3") & Space(2) & rs.Fields("birth") & Space(2) & rs.Fields("addr") & Space(2) & rs.Fields("post") & Space(2) & rs.Fields("name4") & Space(2) & rs.Fields("name5") & Space(2) & rs.Fields("class")
rs.MoveNext
Next i
rs.Close
adoconn.Close
End Sub
'按专业查询
Private Sub Command2_Click()
showinfo.Caption = ""
List1.clear
Dim major As String
major = Combo2.Text
If Len(major) = 0 Then
MsgBox "请选择专业！"
Combo2.SetFocus
Exit Sub
End If
adoconn.Open
rs.Open "select * from stu,major where stu.major=major.id and major.name='" & major & "'", adoconn
If rs.RecordCount = 0 Then
MsgBox "没有" & major & "专业的学生！"
rs.Close
adoconn.Close
Combo2.SetFocus
Exit Sub
End If
rs.Close
List1.clear
List1.AddItem " 学号 姓名 性别 民族 政治面貌 出生年月 家庭住址 邮政编码 学院 入学年份 班级"
rs.Open "select no , stu.name as name1, sex ,nation.name as name2, policy.name as name3,birth , addr , post ,college.name as name4, enter_year, class from stu ,nation,policy,college,major where stu.nation=nation.id and stu.policy = policy.id and stu.college=college.id and stu.major=major.id and major.college=college.id and major.name='" & major & "'", adoconn
rs.MoveFirst
Dim i As Integer
For i = 0 To rs.RecordCount - 1
List1.AddItem rs.Fields("no") & Space(2) & rs.Fields("name1") & Space(2) & rs.Fields("sex") & Space(2) & rs.Fields("name2") & Space(2) & rs.Fields("name3") & Space(2) & rs.Fields("birth") & Space(2) & rs.Fields("addr") & Space(2) & rs.Fields("post") & Space(2) & rs.Fields("name4") & Space(2) & rs.Fields("enter_year") & Space(2) & rs.Fields("class")
rs.MoveNext
Next i
rs.Close
adoconn.Close
End Sub
Private Sub Form_Load()
Combo1.AddItem "2000"
Combo1.AddItem "2001"
Combo1.AddItem "2002"
Combo1.AddItem "2003"
Combo1.AddItem "2004"
Combo1.AddItem "2005"
Combo1.AddItem "2006"
Combo1.AddItem "2007"
Combo1.AddItem "2008"
Combo1.AddItem "2009"
Combo1.AddItem "2010"
adoconn.ConnectionString = Adodc1.ConnectionString 'Adodc1为窗体中的ADO控件，并已成功连接数据库
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
adoconn.Open
rs.Open "select * from major", adoconn
If rs.RecordCount = 0 Then
rs.Close
adoconn.Close
Exit Sub
End If
rs.MoveFirst
Dim i As Integer
For i = 0 To rs.RecordCount - 1
Combo2.AddItem rs.Fields("name")
rs.MoveNext
Next i
rs.Close
adoconn.Close
End Sub
Private Sub List1_Click()
showinfo.Caption = List1.Text
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -