main.vb

图书馆管理系统,是数据库的课程设计,报告里面包含了需求分析数据字典概念结构设计逻辑结构设计数据库物理设计数据库实施

        Me.book_concern.Text = "出版社"
        Me.book_concern.Width = 121
        '
        'book_addtime
        '
        Me.book_addtime.Text = "进馆时间"
        Me.book_addtime.Width = 119
        '
        'book_amount
        '
        Me.book_amount.Text = "总数量"
        Me.book_amount.Width = 59
        '
        'book_remain
        '
        Me.book_remain.Text = "剩余数量"
        '
        'book_loandegree
        '
        Me.book_loandegree.Text = "借阅次数"
        '
        'GroupBox3
        '
        Me.GroupBox3.Controls.Add(Me.btland)
        Me.GroupBox3.Controls.Add(Me.show_book_loandegree)
        Me.GroupBox3.Controls.Add(Me.show_book_remain)
        Me.GroupBox3.Controls.Add(Me.show_book_amount)
        Me.GroupBox3.Controls.Add(Me.show_book_addtime)
        Me.GroupBox3.Controls.Add(Me.show_book_concern)
        Me.GroupBox3.Controls.Add(Me.show_book_classity)
        Me.GroupBox3.Controls.Add(Me.show_book_author)
        Me.GroupBox3.Controls.Add(Me.show_book_name)
        Me.GroupBox3.Controls.Add(Me.show_book_id)
        Me.GroupBox3.Controls.Add(Me.Label13)
        Me.GroupBox3.Controls.Add(Me.Label12)
        Me.GroupBox3.Controls.Add(Me.Label11)
        Me.GroupBox3.Controls.Add(Me.Label10)
        Me.GroupBox3.Controls.Add(Me.Label9)
        Me.GroupBox3.Controls.Add(Me.Label8)
        Me.GroupBox3.Controls.Add(Me.Label7)
        Me.GroupBox3.Controls.Add(Me.Label6)
        Me.GroupBox3.Controls.Add(Me.Label5)
        Me.GroupBox3.Location = New System.Drawing.Point(7, 132)
        Me.GroupBox3.Name = "GroupBox3"
        Me.GroupBox3.Size = New System.Drawing.Size(200, 195)
        Me.GroupBox3.TabIndex = 215
        Me.GroupBox3.TabStop = False
        Me.GroupBox3.Text = "图书信息"
        '
        'btland
        '
        Me.btland.Location = New System.Drawing.Point(136, 165)
        Me.btland.Name = "btland"
        Me.btland.Size = New System.Drawing.Size(48, 24)
        Me.btland.TabIndex = 7
        Me.btland.Text = "借阅"
        '
        'show_book_loandegree
        '
        Me.show_book_loandegree.Location = New System.Drawing.Point(72, 144)
        Me.show_book_loandegree.Name = "show_book_loandegree"
        Me.show_book_loandegree.Size = New System.Drawing.Size(120, 16)
        Me.show_book_loandegree.TabIndex = 17
        '
        'show_book_remain
        '
        Me.show_book_remain.Location = New System.Drawing.Point(72, 128)
        Me.show_book_remain.Name = "show_book_remain"
        Me.show_book_remain.Size = New System.Drawing.Size(120, 16)
        Me.show_book_remain.TabIndex = 16
        '
        'show_book_amount
        '
        Me.show_book_amount.Location = New System.Drawing.Point(72, 112)
        Me.show_book_amount.Name = "show_book_amount"
        Me.show_book_amount.Size = New System.Drawing.Size(120, 16)
        Me.show_book_amount.TabIndex = 15
        '
        'show_book_addtime
        '
        Me.show_book_addtime.Location = New System.Drawing.Point(72, 96)
        Me.show_book_addtime.Name = "show_book_addtime"
        Me.show_book_addtime.Size = New System.Drawing.Size(120, 16)
        Me.show_book_addtime.TabIndex = 14
        '
        'show_book_concern
        '
        Me.show_book_concern.Location = New System.Drawing.Point(72, 80)
        Me.show_book_concern.Name = "show_book_concern"
        Me.show_book_concern.Size = New System.Drawing.Size(120, 16)
        Me.show_book_concern.TabIndex = 13
        '
        'show_book_classity
        '
        Me.show_book_classity.Location = New System.Drawing.Point(72, 64)
        Me.show_book_classity.Name = "show_book_classity"
        Me.show_book_classity.Size = New System.Drawing.Size(120, 16)
        Me.show_book_classity.TabIndex = 12
        '
        'show_book_author
        '
        Me.show_book_author.Location = New System.Drawing.Point(72, 48)
        Me.show_book_author.Name = "show_book_author"
        Me.show_book_author.Size = New System.Drawing.Size(120, 16)
        Me.show_book_author.TabIndex = 11
        '
        'show_book_name
        '
        Me.show_book_name.Location = New System.Drawing.Point(72, 32)
        Me.show_book_name.Name = "show_book_name"
        Me.show_book_name.Size = New System.Drawing.Size(120, 16)
        Me.show_book_name.TabIndex = 10
        '
        'show_book_id
        '
        Me.show_book_id.Location = New System.Drawing.Point(72, 16)
        Me.show_book_id.Name = "show_book_id"
        Me.show_book_id.Size = New System.Drawing.Size(120, 16)
        Me.show_book_id.TabIndex = 9
        '
        'Label13
        '
        Me.Label13.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label13.Location = New System.Drawing.Point(8, 144)
        Me.Label13.Name = "Label13"
        Me.Label13.Size = New System.Drawing.Size(72, 16)
        Me.Label13.TabIndex = 8
        Me.Label13.Text = "借阅次数："
        Me.Label13.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label12
        '
        Me.Label12.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label12.Location = New System.Drawing.Point(8, 128)
        Me.Label12.Name = "Label12"
        Me.Label12.Size = New System.Drawing.Size(72, 16)
        Me.Label12.TabIndex = 7
        Me.Label12.Text = "剩余数量："
        Me.Label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label11
        '
        Me.Label11.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label11.Location = New System.Drawing.Point(8, 112)
        Me.Label11.Name = "Label11"
        Me.Label11.Size = New System.Drawing.Size(56, 16)
        Me.Label11.TabIndex = 6
        Me.Label11.Text = "总数量："
        Me.Label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label10
        '
        Me.Label10.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label10.Location = New System.Drawing.Point(8, 96)
        Me.Label10.Name = "Label10"
        Me.Label10.Size = New System.Drawing.Size(72, 16)
        Me.Label10.TabIndex = 5
        Me.Label10.Text = "进馆时间："
        Me.Label10.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label9
        '
        Me.Label9.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label9.Location = New System.Drawing.Point(8, 80)
        Me.Label9.Name = "Label9"
        Me.Label9.Size = New System.Drawing.Size(56, 16)
        Me.Label9.TabIndex = 4
        Me.Label9.Text = "出版社："
        Me.Label9.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label8
        '
        Me.Label8.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label8.Location = New System.Drawing.Point(8, 64)
        Me.Label8.Name = "Label8"
        Me.Label8.Size = New System.Drawing.Size(48, 16)
        Me.Label8.TabIndex = 3
        Me.Label8.Text = "分类："
        Me.Label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label7
        '
        Me.Label7.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label7.Location = New System.Drawing.Point(8, 48)
        Me.Label7.Name = "Label7"
        Me.Label7.Size = New System.Drawing.Size(48, 16)
        Me.Label7.TabIndex = 2
        Me.Label7.Text = "作者："
        Me.Label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label6
        '
        Me.Label6.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label6.Location = New System.Drawing.Point(8, 17)
        Me.Label6.Name = "Label6"
        Me.Label6.Size = New System.Drawing.Size(48, 15)
        Me.Label6.TabIndex = 1
        Me.Label6.Text = "编号："
        Me.Label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'Label5
        '
        Me.Label5.ForeColor = System.Drawing.SystemColors.ControlDark
        Me.Label5.Location = New System.Drawing.Point(8, 32)
        Me.Label5.Name = "Label5"
        Me.Label5.Size = New System.Drawing.Size(48, 16)
        Me.Label5.TabIndex = 0
        Me.Label5.Text = "书名："
        Me.Label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'StatusBar1
        '
        Me.StatusBar1.Location = New System.Drawing.Point(0, 673)
        Me.StatusBar1.Name = "StatusBar1"
        Me.StatusBar1.ShowPanels = True
        Me.StatusBar1.Size = New System.Drawing.Size(1014, 24)
        Me.StatusBar1.SizingGrip = False
        Me.StatusBar1.TabIndex = 20
        Me.StatusBar1.Text = "StatusBar1"
        '
        'GroupBox2
        '
        Me.GroupBox2.Controls.Add(Me.search)
        Me.GroupBox2.Controls.Add(Me.list_keyword)
        Me.GroupBox2.Controls.Add(Me.Label3)
        Me.GroupBox2.Controls.Add(Me.Label4)
        Me.GroupBox2.Controls.Add(Me.list_listall)
        Me.GroupBox2.Location = New System.Drawing.Point(535, 4)
        Me.GroupBox2.Name = "GroupBox2"
        Me.GroupBox2.Size = New System.Drawing.Size(344, 40)
        Me.GroupBox2.TabIndex = 195
        Me.GroupBox2.TabStop = False
        Me.GroupBox2.Text = "自定义查询条件"
        '
        'search
        '
        Me.search.Location = New System.Drawing.Point(296, 12)
        Me.search.Name = "search"
        Me.search.Size = New System.Drawing.Size(40, 23)
        Me.search.TabIndex = 5
        Me.search.Text = "查询"
        '
        'list_keyword
        '
        Me.list_keyword.Location = New System.Drawing.Point(208, 13)
        Me.list_keyword.Name = "list_keyword"
        Me.list_keyword.Size = New System.Drawing.Size(80, 21)
        Me.list_keyword.TabIndex = 4
        Me.list_keyword.Text = ""
        '
        'Label3
        '
        Me.Label3.Location = New System.Drawing.Point(8, 13)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(72, 24)
        Me.Label3.TabIndex = 6
        Me.Label3.Text = "列出所有："
        Me.Label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(160, 13)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(48, 24)
        Me.Label4.TabIndex = 8
        Me.Label4.Text = "含有："
        Me.Label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'list_listall
        '
        Me.list_listall.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.list_listall.Items.AddRange(New Object() {"编号", "书名", "分类", "作者", "出版社", "总数量", "剩余数量", "借阅次数"})
        Me.list_listall.Location = New System.Drawing.Point(80, 13)
        Me.list_listall.Name = "list_listall"
        Me.list_listall.Size = New System.Drawing.Size(80, 20)
        Me.list_listall.TabIndex = 3
        '
        'GroupBox1
        '
        Me.GroupBox1.Controls.Add(Me.list_dy)
        Me.GroupBox1.Controls.Add(Me.Label1)
        Me.GroupBox1.Controls.Add(Me.list_condition)
        Me.GroupBox1.Controls.Add(Me.Label2)
        Me.GroupBox1.Location = New System.Drawing.Point(215, 4)
        Me.GroupBox1.Name = "GroupBox1"
        Me.GroupBox1.Size = New System.Drawing.Size(312, 40)
        Me.GroupBox1.TabIndex = 185
        Me.GroupBox1.TabStop = False
        Me.GroupBox1.Text = "查询条件"
        '
        'list_dy
        '
        Me.list_dy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.list_dy.ItemHeight = 12
        Me.list_dy.Items.AddRange(New Object() {"编号", "书名", "分类", "作者", "出版社", "进馆时间", "总数量", "剩余数量", "借阅次数"})
        Me.list_dy.Location = New System.Drawing.Point(80, 13)
        Me.list_dy.MaxDropDownItems = 9