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