Private Sub init_ado()                         '初始化cnnrsdata和rsdata
       Dim strcnn
       Set cnnrsdata = New ADODB.Connection
       strcnn = "Provider=Microsoft.jet.oledb.3.51;" & _
       "Data Source='" & App.Path & "\zhuyong.mdb'"
       cnnrsdata.Open strcnn
      Set rsdata = New ADODB.Recordset
      rsdata.CursorType = adOpenKeyset
      rsdata.LockType = adLockOptimistic
End Sub
Private Sub MDIForm_Load()
frmSplash.Show
End Sub
Private Sub mnubookfind_Click()
find.Show
End Sub
Private Sub mnudingpiao_Click()
frmbook.Show
End Sub
Private Sub mnuoutme_Click()
Unload Me
End Sub
Private Sub mnuspace_Click()
init_ado本文来自辣文论文网原文请找QQ752018766
     strQuery = "select * from line where line.book=true"
     rsdata.Open strQuery, cnnrsdata, , , adCmdText
       If rsdata.EOF Then
          MsgBox "数据已清空!"
       Else
           rsdata.MoveFirst
       End If
     
    Dim i As Integer
        For i = 1 To rsdata.RecordCount
            If rsdata!book = True Then
                rsdata!book = False
                rsdata.Update
                rsdata.MoveNext
            End If
         Next i
         rsdata.Close
         strQuery = "select * from customer"
         rsdata.Open strQuery, cnnrsdata, , , adCmdText
             If rsdata.EOF Then
                booksystem.Show
             Else
                   rsdata.MoveFirst
             End If
    Dim j As Integer
       For j = 1 To rsdata.RecordCount
           rsdata.Delete
           rsdata.MoveNext
       Next j
          rsdata.Close
End Sub
Private Sub mnutuipiao_Click()
Frmback.Show
毕业论文http://www.751com.cn
Option Explicit
Private cnnrsdata As New ADODB.Connection
Private rsdata As New ADODB.Recordset
Dim strQuery As String
Dim bookinformation As String
Dim response As Integer
Private Sub init_ado()                         '初始化cnnrsdata和rsdata
    Dim strcnn
    Set cnnrsdata = New ADODB.Connection
    strcnn = "Provider=Microsoft.jet.oledb.3.51;" & _
    "Data Source='" & App.Path & "\zhuyong.mdb'"
    cnnrsdata.Open strcnn
    Set rsdata = New ADODB.Recordset
    rsdata.CursorType = adOpenKeyset