VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 1  'vbDataSource
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Cls_user"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Option Explicit
Dim mycnt As Cls_Connect  '連接類

Private Sub Class_Initialize()
  Set mycnt = New Cls_Connect
End Sub

Public Sub OpenUserMessage()
  '打開用戶表
  mycnt.QryName = "select * from UserMessage "
  mycnt.openQry
End Sub

Public Property Get GetUserMessageRs() As Recordset
  Set GetUserMessageRs = mycnt.MQueryRs
End Property

Public Sub OpenUserMessageByUserID(userid As String)
  '打開用戶表
  mycnt.QryName = "select * from UserMessage where userid='" & userid & "'"
  mycnt.openQry
End Sub

Public Sub OpenConnect()
  '打開連接表
  mycnt.QryName = "select * from Connect"
  mycnt.openQry
End Sub

Public Sub OpenConnectByUserID(userid As String)
  '打開連接表
  mycnt.QryName = "select * from Connect where userid='" & userid & "'"
  mycnt.openQry
End Sub

Public Function Query_user(userid As String)
'根據(jù)用戶名稱查詢
  mycnt.PrcName = "QueryUser"
  mycnt.PrcPra = "@pra"
  mycnt.OpenPrc userid
End Function

Public Property Get GetUserByIDRs() As ADODB.Recordset
'將根據(jù)用戶名稱查詢的結(jié)果返回給GetUserRs
  Set GetUserByIDRs = mycnt.MStoreProcRS
End Property
Public Function EditPassWord(myuserid As String, mypassword As String)
''將根據(jù)用戶名稱查詢記錄并根據(jù)mypassword的值寫入數(shù)據(jù)庫
  mycnt.QryName = "select * from usermessage where UserID='" & myuserid & "'"
  mycnt.openQry
  mycnt.MQueryRs.Fields(2) = mypassword
  mycnt.MQueryRs.Update
  mycnt.MQueryRs.Requery
End Function