frmcatinfo.frm

该压缩包包含有很多关于数据库原理与应用的课件以及课程设计

VERSION 5.00
Begin VB.Form frmCatInfo 
   Caption         =   "图书分类信息"
   ClientHeight    =   4725
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   9885
   LinkTopic       =   "Form2"
   MDIChild        =   -1  'True
   ScaleHeight     =   4725
   ScaleWidth      =   9885
   WindowState     =   2  'Maximized
   Begin VB.CommandButton cmdLast 
      BackColor       =   &H00FFFFFF&
      Caption         =   "最后一条"
      Height          =   495
      Left            =   8595
      TabIndex        =   11
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdNext 
      BackColor       =   &H00FFFFFF&
      Caption         =   "下一条"
      Height          =   495
      Left            =   7425
      TabIndex        =   10
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdPrevious 
      BackColor       =   &H00FFFFFF&
      Caption         =   "上一条"
      Height          =   495
      Left            =   6260
      TabIndex        =   9
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdFirst 
      BackColor       =   &H00FFFFFF&
      Caption         =   "第一条"
      Height          =   495
      Left            =   5095
      TabIndex        =   8
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdCancel 
      BackColor       =   &H00FFFFFF&
      Caption         =   "取消"
      Height          =   495
      Left            =   3930
      TabIndex        =   7
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdSave 
      BackColor       =   &H00FFFFFF&
      Caption         =   "保存"
      Height          =   495
      Left            =   2765
      TabIndex        =   6
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdDel 
      BackColor       =   &H00FFFFFF&
      Caption         =   "删除"
      Height          =   495
      Left            =   1600
      TabIndex        =   5
      Top             =   3120
      Width           =   855
   End
   Begin VB.CommandButton cmdAddNew 
      BackColor       =   &H00FFFFFF&
      Caption         =   "添加"
      Height          =   495
      Left            =   435
      TabIndex        =   4
      Top             =   3120
      Width           =   855
   End
   Begin VB.TextBox txtCatName 
      Height          =   375
      Left            =   2880
      TabIndex        =   1
      Text            =   "Text1"
      Top             =   1800
      Width           =   1935
   End
   Begin VB.TextBox txtCatId 
      Height          =   375
      Left            =   2880
      TabIndex        =   0
      Text            =   "Text1"
      Top             =   960
      Width           =   1935
   End
   Begin VB.Label Label2 
      Caption         =   "图书分类名称"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   600
      TabIndex        =   3
      Top             =   1800
      Width           =   1935
   End
   Begin VB.Label Label1 
      Caption         =   "图书分类编号"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   600
      TabIndex        =   2
      Top             =   960
      Width           =   2055
   End
End
Attribute VB_Name = "frmCatInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdAddNew_Click()
On Error Resume Next
Call Clear
Dim i As Integer
Dim max As Integer
max = 0
addnewflag = True
cmdAddNew.Enabled = False

'排列记录
For i = 0 To rsCatInfo.RecordCount
    If max < rsCatInfo(0) Then
        max = rsCatInfo(0)
    End If
    rsCatInfo.MoveNext
Next i
rsCatInfo.MoveFirst

cmdCancel.Enabled = True
cmdDel.Enabled = False
cmdFirst.Enabled = False
cmdLast.Enabled = False
cmdPrevious.Enabled = False
cmdNext.Enabled = False
'添加图书分类
rsCatInfo.AddNew
txtCatId.Text = max + 1
txtCatName.SetFocus
End Sub

Private Sub cmdFirst_Click()
On Error Resume Next
rsCatId.MoveFirst
Call display
End Sub

Private Sub cmdLast_Click()
On Error Resume Next
rsCatInfo.MoveLast
Call display
End Sub

Private Sub cmdNext_Click()
On Error Resume Next
rsCatInfo.MoveNext
If rsCatInfo.EOF Then
    rsCatInfo.MoveLast
    MsgBox "Last record", vbInformation, "Last record"
Else
    Call display
End If
End Sub

Private Sub cmdPrevious_Click()
On Error Resume Next
rsCatInfo.MovePrevious
If rsCatInfo.EOF Then
    rsCatInfo.MoveFirst
    MsgBox "First record", vbInformation, "First record"
Else
    Call display
End If
End Sub

Private Sub cmdSave_Click()
On Error Resume Next
If txtCatId.Text = "" Or txtCatName.Text = "" Then
    MsgBox "Improper save!Data entry missing", vbCritical, "Fill up all fields"
    txtCatId.SetFocus
    Exit Sub
End If
Call assign
rsCatInfo.save
MsgBox "Record saved", vbInformation, "Record is saved"

cmdDel.Enabled = True
cmdFirst.Enabled = True
cmdLast.Enabled = True
cmdPrevious.Enabled = True
cmdNext.Enabled = True
cmdAddNew.Enabled = True
cmdCancel.Enabled = False
Exit Sub
End Sub