?? frmuser.frm
字號:
VERSION 5.00
Begin VB.Form frmuser
Caption = "用戶管理"
ClientHeight = 2445
ClientLeft = 60
ClientTop = 345
ClientWidth = 4935
ControlBox = 0 'False
LinkTopic = "Form1"
LockControls = -1 'True
ScaleHeight = 2445
ScaleWidth = 4935
StartUpPosition = 2 'CenterScreen
Begin VB.CommandButton Command8
Caption = "返回"
Height = 375
Left = 3240
TabIndex = 12
Top = 1800
Width = 1335
End
Begin VB.CommandButton Command7
Caption = "取消"
Height = 375
Left = 1680
TabIndex = 11
Top = 1800
Width = 1335
End
Begin VB.CommandButton Command6
Caption = "確定"
Height = 375
Left = 240
TabIndex = 10
Top = 1800
Width = 1215
End
Begin VB.CommandButton Command5
Caption = "修改"
Height = 375
Left = 3240
TabIndex = 9
Top = 1320
Width = 1335
End
Begin VB.CommandButton Command4
Caption = "刪除"
Height = 375
Left = 1680
TabIndex = 8
Top = 1320
Width = 1335
End
Begin VB.CommandButton Command3
Caption = "添加"
Height = 375
Left = 240
TabIndex = 7
Top = 1320
Width = 1215
End
Begin VB.Frame Frame1
Caption = "瀏覽"
Height = 735
Left = 2880
TabIndex = 4
Top = 240
Width = 1695
Begin VB.CommandButton Command2
Caption = ">>"
Height = 375
Left = 840
TabIndex = 6
Top = 240
Width = 615
End
Begin VB.CommandButton Command1
Caption = "<<"
Height = 375
Left = 240
TabIndex = 5
Top = 240
Width = 615
End
End
Begin VB.TextBox Text2
Height = 270
IMEMode = 3 'DISABLE
Left = 1080
PasswordChar = "*"
TabIndex = 3
Top = 720
Width = 1575
End
Begin VB.TextBox Text1
Height = 270
Left = 1080
TabIndex = 2
Top = 345
Width = 1575
End
Begin VB.Label Label2
Caption = "密碼："
Height = 255
Left = 360
TabIndex = 1
Top = 720
Width = 735
End
Begin VB.Label Label1
Caption = "用戶名："
Height = 255
Left = 240
TabIndex = 0
Top = 360
Width = 975
End
End
Attribute VB_Name = "frmuser"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rsmuser As ADODB.Recordset
Private Sub Command1_Click()
Command2.Enabled = True
If rsmuser.RecordCount > 0 Then
rsmuser.MovePrevious
If Not rsmuser.BOF Then
displayuserinfo
Else
Command1.Enabled = False
rsmuser.MoveNext
displayuserinfo
End If
Else
MsgBox "database error!"
End If
End Sub
Private Sub Command2_Click()
Command1.Enabled = True
If rsmuser.RecordCount > 0 Then
rsmuser.MoveNext
If Not rsmuser.EOF Then
displayuserinfo
Else
Command2.Enabled = False
rsmuser.MovePrevious
displayuserinfo
End If
Else
MsgBox "database error!"
End If
End Sub
Private Sub Command3_Click()
Command6.Enabled = True
Command7.Enabled = True
Command1.Enabled = False
Command2.Enabled = False
Command3.Enabled = False
Command4.Enabled = False
Command5.Enabled = False
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
judge = True
End Sub
Private Sub Command4_Click()
Dim bresult As Integer
If rsmuser.RecordCount > 0 Then
bresult = MsgBox("你確實要刪除嗎?", vbOKCancel)
If bresult = vbCancel Then
Exit Sub
Else
rsmuser.Delete adAffectCurrent
rsmuser.Update
rsmuser.Requery
displayuserinfo
End If
Else
MsgBox "The Database is Empty!"
End If
End Sub
Private Sub Command5_Click()
Command6.Enabled = True
Command7.Enabled = True
Command1.Enabled = False
Command2.Enabled = False
Command4.Enabled = False
Command3.Enabled = False
Command5.Enabled = False
Text1.SetFocus
SendKeys "{home}+{end}"
judge = False
End Sub
Private Sub Command6_Click()
If judge = True Then 'add
rsmuser.AddNew
With rsmuser
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
End With
rsmuser.Update
rsmuser.Requery
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Command5.Enabled = True
Command6.Enabled = False
Command7.Enabled = False
Else 'modify
rsmuser.Update
With rsmuser
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
End With
rsmuser.Update
Command1.Enabled = True
Command2.Enabled = True
Command4.Enabled = True
Command3.Enabled = True
Command5.Enabled = True
Command6.Enabled = False
Command7.Enabled = False
End If
End Sub
Private Sub Command7_Click()
If judge = True Then
If rsmuser.RecordCount > 0 Then
rsmuser.MoveFirst
displayuserinfo
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Command5.Enabled = True
Command6.Enabled = False
Command7.Enabled = False
Else
MsgBox "database error!"
End If
Else
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Command5.Enabled = True
Command6.Enabled = False
Command7.Enabled = False
End If
End Sub
Private Sub Command8_Click()
Unload Me
frmmain.Visible = True
End Sub
Private Sub Form_Load()
Set rsmuser = New ADODB.Recordset
rsmuser.Open "select * from userinfo where username not like 'administrator'", cn, adOpenStatic, adLockOptimistic
If rsmuser.RecordCount > 0 Then
rsmuser.MoveFirst '首先移到第一條記錄
displayuserinfo
Else
MsgBox "database error!"
End If
Command6.Enabled = False
Command7.Enabled = False
End Sub
Public Sub displayuserinfo()
If rsmuser.RecordCount > 0 Then
Text1.Text = rsmuser.Fields(0)
Text2.Text = rsmuser.Fields(1)
Else
MsgBox "data error!"
End If
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -