Private Sub Comenter_Click()
If Txtname.Text = "" Then
MsgBox "用户名不能为空!", vbOKOnly + vbInformation, "友情提示"
Txtname.SetFocus
Exit Sub
End If
If Txtpwd.Text = "" Then
MsgBox "密码不能为空!", vbOKCancel + vbInformation, "友情提示"
Txtpwd.SetFocus
Exit Sub
End IfDim strSQL As String
strSQL = "select * from Users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "' "Dim str As New ADODB.Recordset
Dim mydb As DataBases
Set str = New ADODB.Recordset
Set mydb = New DataBases
str.CursorLocation = adUseClient
mydb.OpenConn
str.Open strSQL, mydb.SqlConn, adOpenStatic, adLockReadOnlyWith str
If .State = adStateOpen Then .Close
.Open strSQL
If .EOF Then
Try_times = Try_times + 1
If Try_times >= 3 Then
MsgBox "您已经三次尝试进入本系统,均不成功,系统将自动关闭", vbOKOnly + vbCritical, "警告"
Unload Me
Else
MsgBox "对不起,用户名不存在或密码错误 !", vbOKOnly + vbQuestion, "警告"
Txtname.Text = ""
Txtpwd.Text = ""
End If
Elsei = "select type from users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "'"
j = "select type from users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "'"If i = 1 Then
frmMain.Show '登录进入的另一个界面
Else
frmMingXi.Show
End If
'Unload MeEnd If
End With
mydb.CloseConn
End Sub
If Txtname.Text = "" Then
MsgBox "用户名不能为空!", vbOKOnly + vbInformation, "友情提示"
Txtname.SetFocus
Exit Sub
End If
If Txtpwd.Text = "" Then
MsgBox "密码不能为空!", vbOKCancel + vbInformation, "友情提示"
Txtpwd.SetFocus
Exit Sub
End IfDim strSQL As String
strSQL = "select * from Users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "' "Dim str As New ADODB.Recordset
Dim mydb As DataBases
Set str = New ADODB.Recordset
Set mydb = New DataBases
str.CursorLocation = adUseClient
mydb.OpenConn
str.Open strSQL, mydb.SqlConn, adOpenStatic, adLockReadOnlyWith str
If .State = adStateOpen Then .Close
.Open strSQL
If .EOF Then
Try_times = Try_times + 1
If Try_times >= 3 Then
MsgBox "您已经三次尝试进入本系统,均不成功,系统将自动关闭", vbOKOnly + vbCritical, "警告"
Unload Me
Else
MsgBox "对不起,用户名不存在或密码错误 !", vbOKOnly + vbQuestion, "警告"
Txtname.Text = ""
Txtpwd.Text = ""
End If
Elsei = "select type from users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "'"
j = "select type from users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "'"If i = 1 Then
frmMain.Show '登录进入的另一个界面
Else
frmMingXi.Show
End If
'Unload MeEnd If
End With
mydb.CloseConn
End Sub
解决方案 »
- [加分贴]关于对外部程序ListView中某一项进行双击的问题。来者有分,送完止为。
- 请教一个数字排列的问题
- 关于asp网页的分页技术的疑惑!
- VB的安装程序制作完成后,出现了‘430’错误
- 一个提过很多次,但未能很好解决的老问题。请大虾们赐教!!!!!分不够可以加
- Internet Transfer 控件使用的一个疑问:"超时的问题"
- 急急急!!! 正在用VB编程,突然断电,再次打开后控件文件(*.ctl)不能加载.
- vb怎么模拟波动的传播过程?
- 动态添加控件的问题
- 通过popup menu打开模态窗体,然后再想在新窗体中popup menu 就不行了,不知道是什么原因。
- 新人提问!!关于datagrid 导入excel后的问题?急
- 关于FileCopy的一个细节问题,请指教,谢谢!
i是执行结果
你怎么i直接等于sql语句了学习的话,要知道自己每步该干什么,可以一步步跟踪,学习程序!
这里应该改掉。
Dim rs As New ADODB.Recordset
rs.Open "select type from users where [user]='" & Trim$(Txtname.Text) & "' and [password]='" & Trim$(Txtpwd.Text) & "'"
, mydb.SqlConn, adOpenStatic, adLockReadOnly
if rs.filed("type") <>'' then
打开记录,如果结果不为空,这时候TYPE字段已经有了,没必要再运行一个SQL.
红色部分改成:
If str.filed("type") = 1 Then
frmMain.Show '登录进入的另一个界面
Else
frmMingXi.Show
End If
'Unload Me