user_info.cls

这是个学生信息管理系统

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "user_Info"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'1 user_ID  Varchar 40  用户名
'2 user_PWD Varchar 40  密码
'3 user_Des TinyInt 用户类型（0 - 系统默认用户HrManager和Admin，1 - 人力资源主管用户，2 - 普通系统管理员用户，4 - 普通用户）

Public user_ID As String
Public user_PWD As String
Public user_Des As String


Public Sub Init()
  user_ID = ""
  user_PWD = ""
  user_Des = ""
End Sub

'删除user_Info数据
Public Sub Delete(ByVal TmpUser As String)
 ' If TmpUser = "HrManager" Or TmpUser = "Admin" Then
  '  Exit Sub
 ' End If
  
  DB_Connect
  
  SqlStmt = "DELETE FROM user_Info WHERE user_ID='" _
          + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal TmpUser As String)
  user_ID = TmpUser
  
  DB_Connect
  
  SqlStmt = "SELECT * FROM user_Info WHERE user_ID='" _
          + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetInfo = False
    Exit Function
  Else
    ColVal = String(400, 0)
    Rc = SQLGetData(Hstmt, 2, 1, ColVal, Lench(ColVal), pcblen)
    user_PWD = TrimStr(ColVal)
    
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 3, 1, ColVal, Lench(ColVal), pcblen)
    Emp_Id = Val(ColVal)
    
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 4, 1, ColVal, Lench(ColVal), pcblen)
    user_Des = Val(ColVal)
  End If
    
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  GetInfo = True
  DB_Disconnect
End Function

Public Function In_DB(ByVal TmpUser As String) As Boolean
  DB_Connect
  
  SqlStmt = "SELECT * FROM user_Info WHERE user_ID='" _
          + 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 user_Info Values('" _
     + Trim(user_ID) + "','" + Trim(user_PWD) _
     + "'," + Trim(Str(user_Des)) + ")"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Sub Update(ByVal TmpUser As String)
  DB_Connect
  
  SqlStmt = "Update user_Info Set user_ID='" + Trim(user_ID) _
          + "',user_PWD='" + Trim(user_PWD) _
          + "',user_Des=" + Trim(Str(user_Des)) _
          + ",Emp_Id=" + Trim(Str(Emp_Id)) _
          + " WHERE user_ID='" + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub
Public Function GetPwd(ByVal TmpUser As String) As String
  user_ID = TmpUser
  
  DB_Connect
  
  SqlStmt = "SELECT user_PWD FROM user_Info WHERE user_ID='" _
          + Trim(TmpUser) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    'GetInfo = ""
    Exit Function
  Else
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 1, 1, ColVal, Lench(ColVal), pcblen)
    user_PWD = TrimStr(ColVal)
  End If
    
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  GetPwd = user_PWD
  DB_Disconnect
End Function