users.cls

这是我们公司的题库管理系统,用VB实现,可以进行试题制作,编辑、试卷制作、试卷生成和试卷打印(A3/和A4)

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 Pwd As String
Public UserType As Integer


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

Public Function ELECT(ByVal TmpID As Integer) As Boolean
  DB_Connect
    
    SqlStmt = "SELECT UserName FROM Users WHERE UserType=" + Trim(Str(TmpID))
    OdbcExt (SqlStmt)
    If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    ELECT = False
  Else
    ELECT = True
  End If
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Function
'删除Users数据
Public Sub Delete(ByVal TmpUser As String)
  If TmpUser = "Admin" Then
    Exit Sub
  End If
  
  DB_Connect
  
  SqlStmt = "DELETE FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal TmpUser As String) As Boolean
  UserName = TmpUser
  DB_Connect
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetInfo = False
    Init
    Exit Function
  Else
    ColVal = String(400, 0)
    rc = SQLGetData(Hstmt, 2, 1, ColVal, Lench(ColVal), pcblen)
    Pwd = TrimStr(ColVal)
    
    ColVal = String(400, 0)
    rc = SQLGetData(Hstmt, 3, 1, ColVal, Lench(ColVal), pcblen)
    UserType = TrimStr(ColVal)
    
  End If
    
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  GetInfo = True
  DB_Disconnect
End Function

Public Function GetPwd(ByVal TmpUser As String) As String
  UserName = TmpUser
  
  DB_Connect
  
  SqlStmt = "SELECT UserPwd FROM Users WHERE UserName='" _
          + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetPwd = ""
    Exit Function
  Else
    ColVal = String(400, 0)
    rc = SQLGetData(Hstmt, 1, 1, ColVal, Lench(ColVal), pcblen)
    GetPwd = TrimStr(ColVal)
  End If
    
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Function

Public Function In_DB(ByVal TmpUser As String) As Boolean
  DB_Connect
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    In_DB = False
  Else
    In_DB = True
    
  End If
  rc = SQLFreeStmt(Hstmt, SQL_DROP)

  DB_Disconnect
End Function

Public Sub Insert()
  DB_Connect
  
  SqlStmt = "INSERT INTO Users Values('" + Trim(UserName) + "','" + Trim(Pwd) + "','" + Trim(Str(UserType)) + "' )"
  OdbcExt (SqlStmt)
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub
Public Sub Update(ByVal TmpUser As String)
  DB_Connect
  
  SqlStmt = "Update Users Set UserName='" + Trim(CurUser.UserName) + "',Pwd='" + Trim(CurUser.Pwd) + "',UserType='" + Trim(CurUser.UserType) + "' WHERE UserName='" + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub