📄 form6.frm

📁 用VB+Access做的图书管理系统! 通过简单的算法可以做出图书的录入和录出!
💻 FRM
📖 第 1 页 / 共 2 页
字号:
上一页 12
      Begin VB.TextBox Text17 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   180
         Left            =   120
         TabIndex        =   13
         Text            =   "学科分类"
         Top             =   1320
         Width           =   1095
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   255
         Index           =   1
         Left            =   120
         TabIndex        =   12
         Text            =   "论文编号"
         Top             =   360
         Width           =   1095
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   180
         Index           =   3
         Left            =   120
         TabIndex        =   11
         Text            =   "论文作者"
         Top             =   3720
         Width           =   1215
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   180
         Index           =   4
         Left            =   120
         TabIndex        =   10
         Text            =   "论文字数"
         Top             =   3240
         Width           =   1215
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   255
         Index           =   5
         Left            =   120
         TabIndex        =   9
         Text            =   "刊物发行范围"
         Top             =   2760
         Width           =   1215
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   255
         Index           =   6
         Left            =   120
         TabIndex        =   8
         Text            =   "刊物主办单位"
         Top             =   2280
         Width           =   1215
      End
      Begin VB.TextBox Text16 
         Alignment       =   2  'Center
         BackColor       =   &H0080C0FF&
         BorderStyle     =   0  'None
         Height          =   255
         Index           =   8
         Left            =   120
         TabIndex        =   7
         Text            =   "发表刊物"
         Top             =   1800
         Width           =   1095
      End
   End
   Begin VB.TextBox Text2 
      Height          =   4695
      Left            =   240
      TabIndex        =   5
      Top             =   1680
      Width           =   1695
   End
   Begin VB.CommandButton Command1 
      Caption         =   "添加"
      Height          =   495
      Left            =   240
      TabIndex        =   3
      Top             =   1080
      Width           =   735
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H0080C0FF&
      Caption         =   "作者姓名"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   6495
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   2175
      Begin VB.CommandButton Command2 
         Caption         =   "删除"
         Height          =   495
         Left            =   1200
         TabIndex        =   4
         Top             =   1080
         Width           =   735
      End
      Begin VB.TextBox Text1 
         Height          =   375
         Left            =   240
         TabIndex        =   1
         Top             =   600
         Width           =   1695
      End
      Begin VB.Label Label1 
         BackColor       =   &H0080C0FF&
         Caption         =   "请输入作者姓名"
         Height          =   255
         Left            =   360
         TabIndex        =   2
         Top             =   360
         Width           =   1455
      End
   End
   Begin VB.Label Label4 
      Alignment       =   2  'Center
      BackColor       =   &H0080C0FF&
      Caption         =   "备注"
      Height          =   255
      Left            =   2400
      TabIndex        =   35
      Top             =   6000
      Width           =   855
   End
   Begin VB.Label Label3 
      Alignment       =   2  'Center
      BackColor       =   &H0080C0FF&
      Caption         =   "获奖情况"
      Height          =   255
      Left            =   2400
      TabIndex        =   34
      Top             =   5400
      Width           =   975
   End
   Begin VB.Label Label2 
      Caption         =   "Label2"
      Height          =   495
      Left            =   720
      TabIndex        =   33
      Top             =   1080
      Width           =   1215
   End
End
Attribute VB_Name = "Form6"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Text2.Text = Text1.Text
End Sub
Private Sub Command10_Click()
Unload Form6
Load Form3
Form3.Show
End Sub
Private Sub Command2_Click()
Text2.Text = ""
End Sub
Private Sub Command3_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False

Adodc1.Recordset.MoveFirst
shuchu
Adodc2.Recordset.MoveFirst
Text2.Text = Adodc2.Recordset.Fields("人员名称")
End Sub
Private Sub Command5_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False

Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
MsgBox "已经是最后了"
Adodc1.Recordset.MoveLast
End If
shuchu
Adodc2.Recordset.MoveNext
If Adodc2.Recordset.EOF Then
Adodc2.Recordset.MoveLast
End If
Text2.Text = Adodc2.Recordset.Fields("人员名称")
End Sub
Private Sub Command6_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False

Adodc1.Recordset.MoveLast
shuchu
Adodc2.Recordset.MoveLast
Text2.Text = Adodc2.Recordset.Fields("人员名称")
End Sub
Private Sub Command7_Click()
Command1.Enabled = True
Command2.Enabled = True
Command8.Enabled = False
Text1.Text = Text2.Text
Text2.Text = ""
Text1.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text7.Enabled = True
Text6.Enabled = True
Text8.Enabled = True
Text9.Enabled = True
Text10.Enabled = True
Text11.Enabled = True
Text14.Enabled = True
Command9.Enabled = True
Command7.Enabled = False
End Sub
Private Sub Command8_Click()
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.MoveLast
End If
shuchu
Adodc1.Recordset.Close

Adodc2.Recordset.Delete
Adodc2.Recordset.MoveNext
If Adodc2.Recordset.EOF Then
Adodc2.Recordset.MoveLast
End If
Text2.Text = Adodc2.Recordset.Fields("人员名称")
Adodc1.Recordset.Open
End Sub
Private Sub Command9_Click()
Command8.Enabled = True
Command9.Enabled = False
Command7.Enabled = True
Adodc2.Recordset.Fields("论文编号") = Text3.Text
Adodc2.Recordset.Fields("人员名称") = Text2.Text
Adodc2.Recordset.Update
shuru
Adodc1.Recordset.Update
MsgBox "更新成功"
Text1.Text = " "
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False
End Sub
Private Sub Form_Load()
Command9.Enabled = False
Adodc1.Visible = False
Adodc1.ConnectionString = "Provider=Microsoft.jet.OLEDB.3.51;Persist Security Info=False; data source= " & App.Path & "\科技系统档案库.mdb"
Adodc1.RecordSource = "select * from 论文基本信息表 "
Adodc1.Refresh
Adodc1.ConnectionTimeout = 30
Adodc1.Refresh
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False
Command1.Enabled = False
Command2.Enabled = False
Adodc2.Visible = False
Adodc2.ConnectionString = "Provider=Microsoft.jet.OLEDB.3.51;Persist Security Info=False; data source= " & App.Path & "\科技系统档案库.mdb"
Adodc2.RecordSource = "select * from 论文作者信息表 "
Adodc2.Refresh
Adodc2.ConnectionTimeout = 30
Adodc2.Refresh
End Sub
Public Sub shuchu()
Text3.Text = Adodc1.Recordset.Fields("论文编号").Value
Text4.Text = Adodc1.Recordset.Fields("论文名称").Value
Text5.Text = Adodc1.Recordset.Fields("学科分类").Value
Text6.Text = Adodc1.Recordset.Fields("发表刊物").Value
Text7.Text = Adodc1.Recordset.Fields("刊物主办单位").Value
Text8.Text = Adodc1.Recordset.Fields("刊物发行范围").Value
Text9.Text = Adodc1.Recordset.Fields("论文字书").Value
Text10.Text = Adodc1.Recordset.Fields("论文作者").Value
If Adodc1.Recordset.Fields("是否核心期刊").Value = "是" Then
 Option1.Value = True
End If
If Adodc1.Recordset.Fields("是否核心期刊").Value = "否" Then
Option2.Value = True
End If
If Adodc1.Recordset.Fields("是否被SCI记录").Value = "是" Then
Option4.Value = True
End If
If Adodc1.Recordset.Fields("是否被SCI记录").Value = "否" Then
Option3.Value = True
End If
If Adodc1.Recordset.Fields("是否被EI收录").Value = "是" Then
Option6.Value = True
End If
If Adodc1.Recordset.Fields("是否被EI收录").Value = "否" Then
Option5.Value = True
End If
Text14.Text = Adodc1.Recordset.Fields("论文获奖情况").Value
Text11.Text = Adodc1.Recordset.Fields("备注").Value
End Sub

Private Sub Command4_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text7.Enabled = False
Text6.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text14.Enabled = False

Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF Then
MsgBox "已经是最前了"
Adodc1.Recordset.MoveFirst
End If
shuchu
Adodc2.Recordset.MovePrevious
If Adodc2.Recordset.BOF Then
Adodc2.Recordset.MoveFirst
End If
Text2.Text = Adodc2.Recordset.Fields("人员名称")

End Sub


Public Sub shuru()
Adodc1.Recordset.Fields("论文编号").Value = Text3.Text
Adodc1.Recordset.Fields("论文名称").Value = Text4.Text
Adodc1.Recordset.Fields("学科分类").Value = Text5.Text
Adodc1.Recordset.Fields("发表刊物").Value = Text6.Text
Adodc1.Recordset.Fields("刊物主办单位").Value = Text7.Text
Adodc1.Recordset.Fields("刊物发行范围").Value = Text8.Text
Adodc1.Recordset.Fields("论文字书").Value = Text9.Text
Adodc1.Recordset.Fields("论文作者").Value = Text10.Text
If Option1.Value = True Then
Adodc1.Recordset.Fields("是否核心期刊").Value = "是"
End If
If Option2.Value = True Then
Adodc1.Recordset.Fields("是否核心期刊").Value = "否"
End If
If Option4.Value = True Then
Adodc1.Recordset.Fields("是否被SCI记录").Value = "是"
End If
If Option3.Value = True Then
Adodc1.Recordset.Fields("是否被SCI记录").Value = "否"
End If
If Option6.Value = True Then
Adodc1.Recordset.Fields("是否被EI收录").Value = "是"
End If
If Option5.Value = True Then
Adodc1.Recordset.Fields("是否被EI收录").Value = "否"
End If
Adodc1.Recordset.Fields("论文获奖情况").Value = Text14.Text
Adodc1.Recordset.Fields("备注").Value = Text11.Text
End Sub
上一页 12
💿 文件大小 301 K
👤 上传用户 a22aa11a
📂 所属分类教育系统应用
🏷️ 相关标签

#Access #VB #图书管理 #图书
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -