edituser.frm

一个用VB写的通信录程序是一个课程设计很实用

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form edituser 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "编辑用户"
   ClientHeight    =   3735
   ClientLeft      =   2535
   ClientTop       =   2805
   ClientWidth     =   6270
   LinkTopic       =   "Form2"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   Picture         =   "edituser.frx":0000
   ScaleHeight     =   3735
   ScaleWidth      =   6270
   Begin MSComctlLib.ListView ListView1 
      Height          =   2295
      Left            =   240
      TabIndex        =   5
      Top             =   1080
      Width           =   5775
      _ExtentX        =   10186
      _ExtentY        =   4048
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      FullRowSelect   =   -1  'True
      HotTracking     =   -1  'True
      _Version        =   393217
      ForeColor       =   -2147483640
      BackColor       =   14737632
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
   Begin VB.CommandButton Command5 
      Caption         =   "关闭"
      Height          =   375
      Left            =   4920
      Picture         =   "edituser.frx":9C09
      Style           =   1  'Graphical
      TabIndex        =   4
      Top             =   360
      Width           =   975
   End
   Begin VB.CommandButton Command4 
      Caption         =   "查找"
      Height          =   375
      Left            =   3720
      Picture         =   "edituser.frx":C469
      Style           =   1  'Graphical
      TabIndex        =   3
      Top             =   360
      Width           =   855
   End
   Begin VB.CommandButton Command3 
      Caption         =   "删除"
      Height          =   375
      Left            =   2640
      Picture         =   "edituser.frx":ECC9
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   360
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "修改"
      Height          =   375
      Left            =   1320
      Picture         =   "edituser.frx":11529
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   360
      Width           =   975
   End
   Begin VB.CommandButton Command1 
      Caption         =   "添加"
      Height          =   375
      Left            =   240
      Picture         =   "edituser.frx":13D89
      Style           =   1  'Graphical
      TabIndex        =   0
      Top             =   360
      Width           =   855
   End
End
Attribute VB_Name = "edituser"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim sql As String
loop1:
madduser.Show (1)
If mSave Then
    sql = "select * from person"
    opendb sql, "2"
    rs.AddNew
    rs("username") = editusername & vbNullString
    rs("name") = editname & vbNullString
    rs("password") = editpassword & vbNullString
    rs("subject") = editsubject & vbNullString
    rs("class") = editclass & vbNullString
    rs("money") = Val(editmoney)
    rs("level") = editlevel & vbNullString
    rs.Update
    closedb
    displaymsg
    mSave = False
    If MsgBox("已成功添加，要继续添加按回车，否则按取消！", 4 + 32, "添加成功") = vbYes Then
        GoTo loop1
    Else
        Exit Sub
    End If
End If
End Sub

Private Sub Command2_Click()
Dim i As Integer
Dim sql As String
Dim bookno As String
i = ListView1.SelectedItem.Index
'得到你所要修改的借书证号
username1 = Replace(Trim(ListView1.SelectedItem.Text), "'", "''")
sql = "select * from person where level='0' and username='" & username1 & "'"
opendb sql, "2"
editusername = rs.Fields("username") & vbNullString '将用户信息存全局变量
editname = rs.Fields("name") & vbNullString
editpassword = rs.Fields("password") & vbNullString
editsubject = rs.Fields("subject") & vbNullString
editclass = rs.Fields("class") & vbNullString
editmoney = rs.Fields("money") & vbNullString
editlevel = rs.Fields("level") & vbNullString
medituser.Show (1)
If mSave Then
    rs("username") = editusername & vbNullString
    rs("name") = editname & vbNullString
    rs("password") = editpassword & vbNullString
    rs("subject") = editsubject & vbNullString
    rs("class") = editclass & vbNullString
    rs("money") = Val(editmoney)
    rs("level") = editlevel & vbNullString
    rs.Update
    closedb
    displaymsg
    MsgBox "修改成功", , "提示"
    mSave = False
Else
    closedb
End If

End Sub

Private Sub Command3_Click()
Dim St As String

St = "确实要删除 " & ListView1.SelectedItem.Text & " " & ListView1.SelectedItem.SubItems(1) & " 吗？"
If MsgBox(St, 4 + 32, "删除") = vbYes Then
    sql = "select * from person where username='" & ListView1.SelectedItem.Text & "' and name='" & ListView1.SelectedItem.SubItems(1) & "'"
    opendb sql, "3"
    If rs.EOF Then
        MsgBox "没有些信息", 64, "提示"
    Else
        rs.Delete 1
    End If
    closedb
    displaymsg
End If
End Sub

Private Sub Command4_Click()
Dim i As Integer
mfinduser.Show (1)
If SearchFlag Then
    sql = "select * from person where level<>'1' and username='" & editusername & "'"
    opendb sql, ""
    If rs.EOF Then
        MsgBox "没有找到匹配记录！", 0 + 48, "查找失败"
        closedb
        Exit Sub
    Else
        ListView1.ListItems.Clear
        For i = 1 To rs.RecordCount
            
            ListView1.ListItems.Add , , rs.Fields("username") & vbNullString
            With ListView1.ListItems(i)
                .SubItems(1) = rs.Fields("name") & vbNullString
                .SubItems(2) = rs.Fields("password") & vbNullString
                .SubItems(3) = rs.Fields("subject") & vbNullString
                .SubItems(4) = rs.Fields("class") & vbNullString
                .SubItems(5) = rs.Fields("money") & vbNullString
                .SubItems(6) = rs.Fields("level") & vbNullString
            End With
            rs.MoveNext
            If rs.EOF Then Exit For
        Next
    End If
    SearchFlag = False

    closedb
End If
End Sub

Private Sub Command5_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dim sql As String
Dim i As Integer
ListView1.View = lvwReport
ListView1.GridLines = True
ListView1.ColumnHeaders.Add , , "借书证号"
ListView1.ColumnHeaders.Add , , "姓名"
ListView1.ColumnHeaders.Add , , "密码"
ListView1.ColumnHeaders.Add , , "系别"
ListView1.ColumnHeaders.Add , , "班级"
ListView1.ColumnHeaders.Add , , "罚金"
ListView1.ColumnHeaders.Add , , "身份"
displaymsg
End Sub
Private Sub displaymsg()
ListView1.ListItems.Clear
sql = "select * from person where level='0'"
opendb sql, ""
If Not rs.EOF Then
    For j = 1 To rs.RecordCount
        ListView1.ListItems.Add , , rs.Fields("username") & vbNullString
        With ListView1.ListItems(j)
            .SubItems(1) = rs.Fields("name") & vbNullString
            .SubItems(2) = rs.Fields("password") & vbNullString
            .SubItems(3) = rs.Fields("subject") & vbNullString
            .SubItems(4) = rs.Fields("class") & vbNullString
            .SubItems(5) = rs.Fields("money") & vbNullString
            .SubItems(6) = rs.Fields("level") & vbNullString
        End With
        rs.MoveNext
        If rs.EOF Then Exit For
    Next
End If
closedb
End Sub

Private Sub ListView1_DblClick()
Command2_Click
End Sub