editbook.frm

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

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form editbook 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "编辑图书"
   ClientHeight    =   3510
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6390
   LinkTopic       =   "Form2"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Picture         =   "editbook.frx":0000
   ScaleHeight     =   3510
   ScaleWidth      =   6390
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "添加"
      Height          =   375
      Left            =   240
      Picture         =   "editbook.frx":9C09
      Style           =   1  'Graphical
      TabIndex        =   5
      Top             =   360
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "修改"
      Height          =   375
      Left            =   1320
      Picture         =   "editbook.frx":C469
      Style           =   1  'Graphical
      TabIndex        =   4
      Top             =   360
      Width           =   975
   End
   Begin VB.CommandButton Command3 
      Caption         =   "删除"
      Height          =   375
      Left            =   2640
      Picture         =   "editbook.frx":ECC9
      Style           =   1  'Graphical
      TabIndex        =   3
      Top             =   360
      Width           =   855
   End
   Begin VB.CommandButton Command4 
      Caption         =   "查找"
      Height          =   375
      Left            =   3720
      Picture         =   "editbook.frx":11529
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   360
      Width           =   855
   End
   Begin VB.CommandButton Command5 
      Caption         =   "关闭"
      Height          =   375
      Left            =   4920
      Picture         =   "editbook.frx":13D89
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   360
      Width           =   975
   End
   Begin MSComctlLib.ListView ListView1 
      Height          =   2295
      Left            =   240
      TabIndex        =   0
      Top             =   960
      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
End
Attribute VB_Name = "editbook"
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:
maddbook.Show (1)
If mSave Then
    sql = "select * from book"
    opendb sql, "2"
    rs.AddNew
    rs("bookno") = editbookno & vbNullString
    rs("booktitle") = editbooktitle & vbNullString
    rs("price") = Val(editprice) & vbNullString
    rs("sort") = editsort & vbNullString
    rs("press") = editpress & 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
bookno = Replace(Trim(ListView1.SelectedItem.Text), "'", "''")
sql = "select * from book where bookno='" & bookno & "'"
opendb sql, "2"
editbookno = rs.Fields("bookno") & vbNullString
editbooktitle = rs.Fields("booktitle") & vbNullString
editprice = rs.Fields("price") & vbNullString
editsort = rs.Fields("sort") & vbNullString
editpress = rs.Fields("press") & vbNullString
meditbook.Show (1)
If mSave Then
    rs("bookno") = editbookno & vbNullString
    rs("booktitle") = editbooktitle & vbNullString
    rs("price") = Val(editprice)
    rs("sort") = editsort & vbNullString
    rs("press") = editpress & 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 book where bookno='" & ListView1.SelectedItem.Text & "' and booktitle='" & 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
mfindbook.Show (1)
If SearchFlag Then
    sql = "select * from book where bookno='" & editbookno & "'"
    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("bookno") & vbNullString
            With ListView1.ListItems(i)
                .SubItems(1) = rs.Fields("booktitle") & vbNullString
                .SubItems(2) = rs.Fields("booktitle") & vbNullString
                .SubItems(3) = rs.Fields("sort") & vbNullString
                .SubItems(4) = rs.Fields("press") & 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 , , "出版社"
displaymsg
End Sub
Private Sub displaymsg()
ListView1.ListItems.Clear
sql = "select * from book  "
opendb sql, ""
If Not rs.EOF Then
    For j = 1 To rs.RecordCount
        ListView1.ListItems.Add , , rs.Fields("bookno") & vbNullString
        With ListView1.ListItems(j)
            .SubItems(1) = rs.Fields("booktitle") & vbNullString
            .SubItems(2) = rs.Fields("price") & vbNullString
            .SubItems(3) = rs.Fields("sort") & vbNullString
            .SubItems(4) = rs.Fields("press") & 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