📄 form7.frm
字号:
VERSION 5.00
Begin VB.Form frmInformation
BackColor = &H00FFC0C0&
Caption = "用户信息管理"
ClientHeight = 3150
ClientLeft = 60
ClientTop = 390
ClientWidth = 4680
LinkTopic = "Form7"
ScaleHeight = 11550
ScaleWidth = 19080
StartUpPosition = 3 '窗口缺省
WindowState = 2 'Maximized
Begin VB.PictureBox Picture1
Height = 9615
Left = 1440
Picture = "Form7.frx":0000
ScaleHeight = 9555
ScaleWidth = 7995
TabIndex = 24
Top = 1200
Width = 8055
End
Begin VB.CommandButton cmdReturn
Caption = "返回"
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 15840
TabIndex = 23
Top = 10080
Width = 1575
End
Begin VB.TextBox txtCheckName
DataSource = "Adodc1"
Height = 495
Left = 13680
TabIndex = 21
Top = 4560
Width = 2895
End
Begin VB.TextBox Text5
Height = 495
Left = 9120
TabIndex = 20
Top = 12120
Width = 2895
End
Begin VB.CommandButton cmdChange
Caption = "修改"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 11760
TabIndex = 17
Top = 2040
Width = 1452
End
Begin VB.TextBox txtSex
DataSource = "Adodc1"
Height = 495
Left = 13680
TabIndex = 15
Top = 8640
Width = 2895
End
Begin VB.CommandButton cmdOK
Caption = "确定"
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 11280
TabIndex = 14
Top = 10080
Width = 1575
End
Begin VB.CommandButton cmdCancel
Caption = "取消"
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 735
Left = 13560
TabIndex = 13
Top = 10080
Width = 1575
End
Begin VB.TextBox txtPassword
DataSource = "Adodc1"
Height = 495
Left = 13680
TabIndex = 11
Top = 7800
Width = 2895
End
Begin VB.TextBox txtUserName
DataSource = "Adodc1"
Height = 495
Left = 13680
TabIndex = 7
Top = 5400
Width = 2895
End
Begin VB.TextBox txtType
DataSource = "Adodc1"
Height = 495
IMEMode = 3 'DISABLE
Left = 13680
PasswordChar = "*"
TabIndex = 6
Top = 6840
Width = 2895
End
Begin VB.TextBox txtID
DataSource = "Adodc1"
Height = 495
IMEMode = 3 'DISABLE
Left = 13680
PasswordChar = "*"
TabIndex = 5
Top = 6120
Width = 2895
End
Begin VB.Frame Frame2
BackColor = &H00FFC0C0&
Caption = "用户信息管理"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 2895
Left = 10560
TabIndex = 0
Top = 1200
Width = 6972
Begin VB.CommandButton cmdCheck
Caption = "查询"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 4200
TabIndex = 18
Top = 840
Width = 1452
End
Begin VB.CommandButton cmdLast
Caption = "最后一条记录"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 5040
TabIndex = 4
Top = 2040
Width = 1692
End
Begin VB.CommandButton cmdNext
Caption = "下一条记录"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 3480
TabIndex = 3
Top = 2040
Width = 1452
End
Begin VB.CommandButton cmdPrevious
Caption = "上一条记录"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 1920
TabIndex = 2
Top = 2040
Width = 1452
End
Begin VB.CommandButton cmdFirst
Caption = "第一条记录"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 492
Left = 360
TabIndex = 1
Top = 2040
Width = 1452
End
End
Begin VB.Label Label7
BackColor = &H00FFC0C0&
Caption = "请输入姓名："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 22
Top = 4680
Width = 2295
End
Begin VB.Label Label5
BackColor = &H00FFC0C0&
Caption = "请输入姓名"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 615
Left = 6360
TabIndex = 19
Top = 12240
Width = 2535
End
Begin VB.Label Label2
BackColor = &H00FFC0C0&
Caption = "性别："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 16
Top = 8640
Width = 2295
End
Begin VB.Label Label6
BackColor = &H00FFC0C0&
Caption = "密码："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 12
Top = 7800
Width = 2295
End
Begin VB.Label Label1
BackColor = &H00FFC0C0&
Caption = "姓名："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 10
Top = 5520
Width = 2295
End
Begin VB.Label Label3
BackColor = &H00FFC0C0&
Caption = "用户类型："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 9
Top = 6960
Width = 2175
End
Begin VB.Label Label4
BackColor = &H00FFC0C0&
Caption = "身份证号："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 11040
TabIndex = 8
Top = 6240
Width = 2175
End
End
Attribute VB_Name = "frmInformation"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdOK_Click()
Rs.Update
Text1.Text = ""
Text4.Text = ""
Text3.Text = ""
Text6.Text = ""
Text2.Text = ""
Text7.Text = ""
cmdCheck.Visible = True
cmdCheck.Enabled = True
cmdChange.Visible = True
cmdChange.Enabled = True
End Sub
Private Sub cmdCancel_Click()
txtUserName.Text = ""
txtID.Text = ""
txtType.Text = ""
txtPassword.Text = ""
txtPassword.Text = ""
cmdCheck.Visible = True
cmdCheck.Enabled = True
cmdChange.Visible = True
txtSex.Enabled = True
End Sub
Private Sub cmdCheck_Click()
cmdChange.Visible = False
cmdChange.Enabled = False
Look
End Sub
Private Sub cmdReturn_Click()
Unload Me
frmAdmainUser.Show
End Sub
Private Sub cmdChange_Click()
cmdCheck.Visible = False
cmdCheck.Enabled = False
Look
MsgBox "请输入修改内容", vbexlamation, "提示"
txtUserName.SetFocus
Rs!用户名 = txtUserName.Text
Rs!身份证号 = txtID.Text
Rs!用户类型 = txtType.Text
Rs!密码 = txtPassword.Text
Rs!性别 = txtSex.Text
End Sub
Private Sub firstCommand_Click()
Rs.MoveFirst
Datashow
End Sub
Private Sub Form_Load()
Call Module1.connection
Dim textsql As String
Dim MsgText As String
Dim Rs As New ADODB.Recordse
End Sub
Private Sub lastCommand_Click()
Rs.MoveLast
Datashow
End Sub
Private Sub nextCommand_Click()
Rs.MoveNext
If Rs.EOF Then
Rs.MoveFirst
End If
Datashow
End Sub
Private Sub previousCommand_Click()
Rs.MovePrevious
If Rs.Recordset.BOF Then
Rs.MoveLast
End If
Datashow
End Sub
Public Sub Datashow()
txtUserName.Text = Rs!用户名
txtID.Text = Rs!身份证号
txtType.Text = Rs!用户类型
txtPassword.Text = Rs!密码
txtSex.Text = Rs!性别
Rs.Update
End Sub
Public Sub Look()
txtCheckName.SetFocus
txtsql = "select * from 用户信息表 where 用户名=" & txtCheckName.Text & ""
Set Rs = ExecuteSQL(txtsql, MsgText)
If Rs.EOF = True Then
MsgBox "不存在该用户，请重新输入！", vbOKOnly + vbExclamation, "提示"
Rs.Close
txtID.SetFocus
txtCheckName.SetFocus
Else
Datashow
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
Rs.Close
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -