?? cls_user.cls
字號:
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
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -