VB评语管理系统vb+access源代码+可执行程序+论文+开题报告+

3．2 界面设计与代码设计
1. 登陆界面设计:

think58好，好think58 [资料来源：www.THINK58.com]

[资料来源：http://www.THINK58.com]

登陆界面代码设计:
Private Sub Command1_Click()
Dim sql As String
Dim rs_login As New ADODB.Recordset
If Trim(txtuser.Text) = "" Then '判断输入的用户名是否为空
MsgBox "没有这个用户", vbOKOnly + vbExclamation, ""
txtuser.SetFocus
Else
sql = "select * from 系统管理 where 用户名='" & txtuser.Text & "'"
rs_login.Open sql, conn, adOpenKeyset, adLockPessimistic
If rs_login.EOF = True Then
MsgBox "没有这个用户", vbOKOnly + vbExclamation, ""
txtuser.SetFocus
Else '检验密码是否正确
If Trim(rs_login.Fields(1)) = Trim(txtpwd.Text) Then
userID = txtuser.Text
rs_login.Close
Unload Me
mainform.Show
Else
MsgBox "密码不正确", vbOKOnly + vbExclamation, ""
txtpwd.SetFocus
End If
End If
End If
cnt = cnt + 1
If cnt = 3 Then
Unload Me
End If
Exit Sub

think58

[来源：http://think58.com]

End Sub think58.com

[资料来源：http://www.THINK58.com]

Private Sub Command2_Click()
Unload Me
End Sub

本文来自think58

[来源：http://think58.com]

[资料来源：http://THINK58.com]

Private Sub Form_Load()
Dim connectionstring As String
connectionstring = "provider=Microsoft.Jet.oledb.4.0;" & _
"data source=pingyu.mdb"
conn.Open connectionstring
cnt = 0
End Sub think58.com [资料来源：http://THINK58.com]

think58.com

[资料来源：http://www.THINK58.com]

[资料来源：THINK58.com]

[资料来源：www.THINK58.com]

2. 添加学生界面设计:
[资料来源：THINK58.com]

添加学生代码设计:
Private Sub Command1_Click()
Dim sql As String
If Trim(Text1.Text) = "" Then
MsgBox "学生姓名不能为空", vbOKOnly + vbExclamation, ""
Text1.SetFocus
Exit Sub
End If
If Trim(Text2.Text) = "" Then
MsgBox "学号不能为空", vbOKOnly + vbExclamation, ""
Text2.SetFocus
Exit Sub
End If
If Trim(Text3.Text) = "" Then
MsgBox "班级不能为空", vbOKOnly + vbExclamation, ""
Text3.SetFocus
Exit Sub
End If
sql = "select * from 学生管理"
rs.CursorLocation = adUseClient
rs.Open sql, conn, adOpenKeyset, adLockPessimistic
While (rs.EOF = False)
If Trim(rs.Fields(0)) = Trim(Text2.Text) Then
MsgBox "学号不能重复！", vbOKOnly + vbExclamation, ""
Text1.SetFocus
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""

Exit Sub
Else
rs.MoveNext
End If
Wend
rs.AddNew
rs.Fields(0) = Text2.Text
rs.Fields(1) = Text1.Text
rs.Fields(2) = Text3.Text
rs.Update
rs.Close
MsgBox "添加用户成功", vbOKOnly + vbExclamation, ""
Unload Me
End Sub

think58

[资料来源：http://think58.com]

[资料来源：www.THINK58.com]

Private Sub Command2_Click()
Unload Me
End Sub

think58 [资料来源：www.THINK58.com]