users.cls

vb做的数据库 客户管理系统

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Users"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public UserName As String
Public UserPwd As String
Public UserType As Integer
Private Const admin = 1

Public Sub Init()
  UserName = ""
  UserPwd = ""
  UserType = ""
  
End Sub

'删除Users数据
Public Sub Delete(ByVal TmpUser As String)
  ' 不能删除系统管理员用户,TmpUser为要删除的用户名
  If Format(TmpUser, "<") = "admin" Then
    Exit Sub
  End If
  SqlStmt = "DELETE FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub

Public Function GetInfo(ByVal TmpUser As String) As Boolean
'读取指定的记录，TmpUser表示要读取的数据用户名

  UserName = TmpUser
  Dim rs As New ADODB.Recordset
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    GetInfo = False
    Init
    Exit Function
  Else
    UserPwd = Trim(rs.Fields(1))
  End If
  GetInfo = True
  rs.Close
End Function

Public Function In_DB(ByVal TmpUser As String) As Boolean
'判断指定的用户名是否已经在数据库中，TmpUsers表示用户名

  Dim rs As New ADODB.Recordset
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    In_DB = False
  Else
    In_DB = True
  End If
  rs.Close
End Function

Public Sub Insert()
'插入新的用户记录

  SqlStmt = "INSERT INTO Users (UserName,UserPwd) Values('" + Trim(UserName) + _
       "','" + Trim(UserPwd) + "')"
  SQLExt (SqlStmt)
End Sub

Public Sub Update(ByVal TmpUser As String)
'修改指定的用户记录，TmpUser表示要修改的用户名

  SqlStmt = "Update Users Set UserName='" + Trim(UserName) _
          + "',UserPwd='" + Trim(UserPwd) + "'WHERE UserName='" _
          + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub