移动端sql登录求助 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

我想使用数据库来验证用户名和密码，但是却不成功，请老师帮忙看下问题出在那

Dim UserName As String = e.PostValues("username")

Dim Password As String = e.PostValues("password")

Dim UserID As String

If e.Path = "logon.htm" '验证用户名和密码

If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password") Then

Dim Verified As Boolean '用于标记用户是否通过了身份验证

UserName = e.PostValues("username")

Password = e.PostValues("password")

'If UserName = "张三" AndAlso Password = "888" Then '实际使用的时候,请改为从数据库读取用户名和密码进行比较

'Verified = True

End If

Dim cmd As New SQLCommand

cmd.C

cmd.CommandText = "SELECT * Fr om {员工管理} Where [Name] Is Null"

_UserTable = cmd.ExecuteReader(True)

Dim UserName As String = e.Form.Controls("UserName").Value

Dim dr As DataRow

dr = _UserTable.SQLFind("[Name] = '" & UserName & "'")

If dr IsNot Nothing Then

If e.Form.Controls("PassWord").Value = dr("Password") Then

Verified = True

Else

End If

以示例用法为例说明：http://www.foxtable.com/mobilehelp/scr/0138.htm

......

'身份验证

Dim Verified As Boolean '用于标记用户是否通过了身份验证

Dim UserName As String = e.Cookies("username") '从cookie中获取用户名

Dim Password As String = e.Cookies("password") '从cookie中获取用户密码

If e.Path = "logon.htm" '如果是通过登录页面访问,从PostValues即可中提取用户名和密码

If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password") Then

UserName = e.PostValues("username")

Password = e.PostValues("password")

End If

Dim cmd As New SQLCommand

cmd.C

cmd.CommandText = "SELECT * Fr om {员工管理} Where [Name] ='" & UserName & "'"

Dim dt As DataTable = cmd.ExecuteReader()

If dt.DataRows.Count > 0 Then

Dim dr As DataRow

dr = dt.DataRows(0)

If Password = dr("Password") Then

Verified = True

End If

If Verified AndAlso e.Path = "logon.htm" Then '如果用户访问的是登录页,且身份验证成功

wb.AppendCookie("username",UserName) '将用户名和密码写入cookie

wb.AppendCookie("password",Password)

wb.InsertHTML("<meta http-equiv='Refresh' c>") '直接跳转到首页

e.WriteString(wb.Build) '生成网页

Return '必须的

ElseIf Verified = False AndAlso e.Path <> "logon.htm" Then '如果用户身份验证失败,且访问的不是登录页面

wb.InsertHTML("<meta http-equiv='Refresh' c>") '那么直接跳转到登录页面

e.WriteString(wb.Build) '生成网页

Return '必须的

End If

......

Dim UserName As String = e.PostValues("username")
Dim Password As String = e.PostValues("password")
If e.Path = "logon.htm" '验证用户名和密码
    If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password") Then
        Dim Verified As Boolean '用于标记用户是否通过了身份验证
        UserName = e.PostValues("username")
        Password = e.PostValues("password")
        'If UserName = "张三" AndAlso Password = "888" Then '实际使用的时候,请改为从数据库读取用户名和密码进行比较
        'Verified = True
        Dim cmd As New SQLCommand
        cmd.CommandText = "SELECT * From {员工管理} Where [Name] = '" & username & "'"
        _UserTable = cmd.ExecuteReader
        If _UserTable.DataRows.count > 0 Then
            If password = _userTable.DataRows(0)("password") Then
                Verified = True
            End If
        End If
    End If
End If

可以用http://www.foxtable.com/mobilehelp/index.htm?page=0138.htm这个例子为例吗，移动端肯定是要套用数据库的，建议官方出帮助教程就建议用数据库为基础来做，

直接看2楼代码。

错了这个http://www.foxtable.com/mobilehelp/index.htm?page=0154.htm

还是2楼的用法，逻辑完全一样

主题：移动端sql登录求助