Foxtable(狐表)用户栏目专家坐堂 → 关于被教程一笔带过的内容


  共有2707人关注过本帖树形打印复制链接

主题:关于被教程一笔带过的内容

帅哥哟,离线,有人找我吗?
ygg8310
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:四尾狐 帖子:989 积分:8833 威望:0 精华:0 注册:2016/4/10 14:33:00
关于被教程一笔带过的内容  发帖心情 Post By:2019/7/26 12:37:00 [只看该作者]

Static UserTable As DataTable '定义一个变量,用于存储用户随机身份ID,以及最后一次活动时间.
Static
ClearTime As Date
If
UserTable Is Nothing Then '创建用于记录登录信息的临时表
    ClearTime = Date.Now()
   
Dim dtb As New DataTableBuilder("UserInfos")
    dtb.AddDef("UserName", Gettype(String), 16)
    dtb.AddDef("UserID",Gettype(String),16)
    dtb.AddDef("ActiveTime",Gettype(Date))
    UserTable = dtb.Build(True)

End
If
If
(Date.Now - ClearTime).TotalMinutes >= 30 Then '清除超过30分钟没有操作的登录信息
    UserTable.DeleteFor("ActiveTime < #" & Date.Now.AddMinutes(-30) & "#")
    ClearTime = Date.Now()
End
If
Dim wb As New weui
'
身份验证
Dim
UserName As String
Dim
Password As String
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
        ElseIf Username =
"
李四" AndAlso Password="999" Then
            Verified  = True
        End If
        If Verified Then
            UserID = Rand.NextString(16)
'
生成随机用户ID
            UserName = EncryptText(UserName,"123","123")
'
将用户名加密.
            Dim dr As DataRow = UserTable.Find("UserName = '" & UserName & "'")
            If  dr IsNot Nothing Then
'
如果是重复登录,删除以前的登录信息
                dr.Delete()
            End If
            dr = UserTable.AddNew()
            dr("UserName") = UserName
            dr("UserID") = UserId
            dr("ActiveTime") = Date.Now
'
记录登录时间
            wb.AppendCookie("username",UserName)
'
将用户名和密码写入cookie
            wb.AppendCookie("userid",UserID)
            wb.InsertHTML("<meta http-equiv='Refresh' c>")
'
直接跳转到首页
            e.WriteString(wb.Build)
'
生成网页
            Return
'
必须的
        End If
    End
If

Else
'其它页面从Cookie提取登录信息进行验证
    UserName = e.Cookies("username"
'
cookie中获取用户名
    UserID = e.Cookies("userid"
'
cookie中获取 随机ID
    Dim dr As DataRow = UserTable.Find("UserName = '" & UserName & "'")
    If dr IsNot Nothing AndAlso dr("UserID") = UserID Then 
'
如果通过验证,更新活动时候,继续访问其它页面.
        dr("ActiveTime") = Date.Now
'
更新活动时间
    Else
'
如果验证失败
        wb.InsertHTML("<meta http-equiv='Refresh' c>")
'
那么直接跳转到登录页面
        e.WriteString(wb.Build)
'
生成网页
        Return
'
必须的
    End
If

End
If
'
开始生成网页
Select
Case e.path
   
Case "logon.htm" '登录页面
        wb.AddPageTitle("","pageheader","销售系统","由湛江辉迅基于Foxtable开发")
        If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password"Then '判断是否是验证失败后的重新登录
            wb.AddTopTips("","toptip1","用户名或密码错误!").msec = 2000 '如果用户通过登录按钮访问,则给用户一个2秒的提示.
       
End If
        wb.AddForm("","form1","logon.htm")
        With wb.AddInputGroup("form1","ipg1")
            .AddInput("username",
"
户名","text")
            .AddInput("password",
"
密码","password")
        End With
        With wb.AddButtonGroup("form1","btg1",True)
            .Add("btn1",
"
登录", "submit")
        End With
    Case "exit.htm"
'
退出登录
        wb.DeleteCookie("username")
'
清除cookie中原来的用户名和密码
        wb.DeleteCookie("password")
        wb.InsertHTML("<meta http-equiv='Refresh' c>")
'
然后直接跳转到登录页面
    Case "", "default.htm"
'
首页
        wb.AddPageTitle("","pageheader","销售系统","由湛江辉迅基于Foxtable开发")
        With wb.AddGrid("","g1")
            .Add("c1",
"
增加订单", "./images/button.png").Attribute = ""
            .Add("c2","
客户管理", "./images/cell.png", "http://www.foxtable.com")
            .Add("c3",
"
销售统计", "./images/toast.png", "http://www.foxtable.com")
            .Add("c4","Dialog", "./images/dialog.png", "http://www.foxtable.com")
            .Add("c5","Progress", "./images/progress.png", "http://www.foxtable.com")
            .Add("c6","Msg", "./images/msg.png", "http://www.foxtable.com")
            .Add("c7","Article", "./images/article.png", "http://www.foxtable.com")
            .Add("c8","ActionSheet", "./images/actionSheet.png", "http://www.foxtable.com")
            .Add("c9","Icons", "./images/icons.png", "http://www.foxtable.com")
            .Add("c10","Panel", "./images/panel.png", "http://www.foxtable.com")
            .Add("c11","Tab", "./images/tab.png", "http://www.foxtable.com")
            .Add("c12",
"
退出", "./images/exit.png", "exit.htm") '退出登录
        End
With

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

  If UserName = "张三" AndAlso Password = "888" Then  '实际使用的时候,请改为从数据库读取用户名和密码进行比较
那么问题来了问题1、从数据库提取用户名和密码该如何修改这段代码?问题2、能否用table内部表代替sql表?又该怎么写?
datatables("用户表").find("username='" & e.PostValues("username") & "'")
 If UserName = "datatables("用户表").find("username='" & e.PostValues("username") & "'")" AndAlso Password = "datatables("用户表").find("password='" & e.PostValues("password") & "'")" Then  '实际使用的时候,请改为从数据库读取用户名和密码进行比较
[此贴子已经被作者于2019/7/26 13:18:22编辑过]

 回到顶部
帅哥哟,离线,有人找我吗?
有点蓝
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110738 积分:563610 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2019/7/26 13:39:00 [只看该作者]

数据库查询参考:http://www.foxtable.com/webhelp/topics/0696.htm

datatables("用户表").find的用法对内部表和外部表都适用,如果要查询后台数据,也可以适用sqlfind:http://www.foxtable.com/webhelp/topics/2911.htm

 回到顶部