form8.frm

图书管理系统原创vb+sql

VERSION 5.00
Begin VB.Form Form8 
   BorderStyle     =   0  'None
   Caption         =   "Form8"
   ClientHeight    =   4485
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   6000
   LinkTopic       =   "Form8"
   Picture         =   "Form8.frx":0000
   ScaleHeight     =   4485
   ScaleWidth      =   6000
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Begin VB.TextBox Text3 
      Alignment       =   1  'Right Justify
      BackColor       =   &H00FFC0C0&
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3000
      TabIndex        =   2
      Top             =   2330
      Width           =   1455
   End
   Begin VB.TextBox Text2 
      Alignment       =   1  'Right Justify
      BackColor       =   &H00FFC0C0&
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3360
      TabIndex        =   1
      Top             =   1720
      Width           =   1095
   End
   Begin VB.TextBox Text1 
      Alignment       =   1  'Right Justify
      BackColor       =   &H00FFC0C0&
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3360
      TabIndex        =   0
      Top             =   1130
      Width           =   1095
   End
   Begin VB.Image Image2 
      Height          =   735
      Left            =   3480
      MouseIcon       =   "Form8.frx":1BE48
      MousePointer    =   99  'Custom
      Top             =   3240
      Width           =   855
   End
   Begin VB.Image Image1 
      Height          =   735
      Left            =   1200
      MouseIcon       =   "Form8.frx":1BF9A
      MousePointer    =   99  'Custom
      Top             =   3240
      Width           =   855
   End
End
Attribute VB_Name = "Form8"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Image1_Click()
If Text1.Text <> "" And Text2.Text <> "" Then
If qy1.State = adStateOpen Then
qy1.Close
End If
If Text1.Text = "" Or Text2.Text = "" Then
MsgBox "数据不可为空,请检查看输入", vbInformation, "输入错误"
Exit Sub
End If
qy1.Open "select * from 系统", cnn, adOpenKeyset, adLockOptimistic, adCmdText
qy1.Fields(0) = Text1.Text
qy1.Fields(1) = Text2.Text
qy1.Update
MsgBox "修改成功"
End If
If Text3.Text <> "" Then
id = Text3.Text
Unload Me
End If
End Sub

Private Sub Image2_Click()
Unload Me
End Sub