今天做用户登录的时候,智障了……
---------------------------------------------------------------------------------
友情提示:
登录的时候总提示密码错误,
Print IIf(Trim(rs.Fields("password")) = password, "相等", "不相等")
SQL2000 设计数据库的时候,字段中,字符串要设计成可变长度(varchar),
如果设计成char固定长度,那么,如果你的字符串不够长度,数据库会自动用空格补齐。
---------------------------------------------------------------------------------
VB6—>填加窗体—>保存为Login.frm
添加两个标签:
lable1.Caption="用户名:"
lable2.Caption="密码:"
添加两个文本框:
text1命名为txtUser
text2命名为txtPass
Login.frm代码如下:
1 '用户登录代码
2 Public Sub userlogin()
3
4 If txtUser.Text = "" Then
5 MsgBox "用户名不可为空"
6 txtUser.SetFocus
7 Exit Sub
8 End If
9 If txtPass.Text = "" Then
10 MsgBox "密码不可为空"
11 txtPass.SetFocus
12 Exit Sub
13 End If
14
15 username = Trim(txtUser.Text)
16 password = Trim(txtPass.Text)
17
18 Call OpenConn
19
20 sql = "select * from vuinfo where username='" & username & "'"
21 rs.Open sql, conn, 1, 1
22 '判断用户是否存在
23 If rs.EOF Then
24 MsgBox "用户名不存在"
25 txtUser.SetFocus
26 Call CloseConn
27 Exit Sub
28 End If
29 '判断用户密码
30 If rs.Fields("password") <> password Then
31 MsgBox "密码错误"
32 Call CloseConn
33 Exit Sub
34 Else
35 username = rs.Fields("username")
36 password = rs.Fields("password")
37 userPower = rs.Fields("userPower")
38 Call CloseConn
39 infop.Show '显示管理界面
40 Unload Login '卸载登录窗体
41 End If
42 End Sub
2 Public Sub userlogin()
3
4 If txtUser.Text = "" Then
5 MsgBox "用户名不可为空"
6 txtUser.SetFocus
7 Exit Sub
8 End If
9 If txtPass.Text = "" Then
10 MsgBox "密码不可为空"
11 txtPass.SetFocus
12 Exit Sub
13 End If
14
15 username = Trim(txtUser.Text)
16 password = Trim(txtPass.Text)
17
18 Call OpenConn
19
20 sql = "select * from vuinfo where username='" & username & "'"
21 rs.Open sql, conn, 1, 1
22 '判断用户是否存在
23 If rs.EOF Then
24 MsgBox "用户名不存在"
25 txtUser.SetFocus
26 Call CloseConn
27 Exit Sub
28 End If
29 '判断用户密码
30 If rs.Fields("password") <> password Then
31 MsgBox "密码错误"
32 Call CloseConn
33 Exit Sub
34 Else
35 username = rs.Fields("username")
36 password = rs.Fields("password")
37 userPower = rs.Fields("userPower")
38 Call CloseConn
39 infop.Show '显示管理界面
40 Unload Login '卸载登录窗体
41 End If
42 End Sub