form2.frm

图书馆管理系统 对图书进行管理

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   720
      Left            =   690
      TabIndex        =   1
      Top             =   1995
      Width           =   2895
   End
   Begin VB.TextBox Text1 
      Height          =   795
      Left            =   375
      TabIndex        =   0
      Text            =   "Text1"
      Top             =   795
      Width           =   3540
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
 Dim rs As New ADODB.Recordset
 rs.Open "select * from book1 where 书籍名称='三'", cnn, adOpenKeyset, adLockOptimistic
 If rs.RecordCount > 0 Then
    rs.Fields("复本数") = Text1.Text
    rs.Update
 Else
    cnn.Execute ("insert into book1 values(2,2,2,66,22,'" + Text1.Text + "',444,4444,444,444")
 End If
 rs.Close
End Sub