?? form1.frm
字號:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form Form1
BackColor = &H00C0C000&
Caption = "Form1"
ClientHeight = 8355
ClientLeft = 60
ClientTop = 345
ClientWidth = 9435
ClipControls = 0 'False
LinkTopic = "Form1"
ScaleHeight = 8355
ScaleWidth = 9435
StartUpPosition = 3 '窗口缺省
Begin VB.TextBox note
Height = 375
Left = 2160
TabIndex = 16
Text = "note"
Top = 3600
Width = 7095
End
Begin VB.CommandButton cmdexit
Caption = "退 出"
Height = 495
Left = 7320
TabIndex = 14
Top = 7560
Width = 1335
End
Begin VB.CommandButton cmddelete
Caption = "刪 除"
Height = 495
Left = 5640
TabIndex = 13
Top = 7560
Width = 1335
End
Begin VB.CommandButton cmdmodify
Caption = "修 改"
Height = 495
Left = 3960
TabIndex = 12
Top = 7560
Width = 1335
End
Begin VB.CommandButton cmdadd
Caption = "添 加"
Height = 495
Left = 2280
TabIndex = 11
Top = 7560
Width = 1335
End
Begin VB.CommandButton Cmdclear
Caption = "清 除"
Height = 495
Left = 600
TabIndex = 10
Top = 7560
Width = 1335
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 3015
Left = 240
TabIndex = 9
Top = 4200
Width = 9000
_ExtentX = 15875
_ExtentY = 5318
_Version = 393216
Rows = 8
Cols = 6
GridColor = 16384
GridColorFixed = 16384
FormatString = "序號|新聞標題|新聞內容|添加者|添加日期|備注"
End
Begin VB.TextBox addtime
Height = 375
Left = 2160
TabIndex = 8
Text = "addtime"
Top = 3120
Width = 7095
End
Begin VB.TextBox adder
Height = 375
Left = 2160
TabIndex = 7
Text = "adder"
Top = 2640
Width = 7095
End
Begin VB.TextBox content
Height = 1095
Left = 2160
TabIndex = 6
Text = "content"
Top = 1440
Width = 7095
End
Begin VB.TextBox title
Height = 375
Left = 2160
TabIndex = 5
Text = "title"
Top = 960
Width = 7095
End
Begin VB.Label Label5
BackColor = &H00C0E0FF&
Caption = "備 注："
BeginProperty Font
Name = "隸書"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 360
TabIndex = 15
Top = 3600
Width = 1575
End
Begin VB.Label Label4
BackColor = &H00C0E0FF&
Caption = "添加日期："
BeginProperty Font
Name = "隸書"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 4
Top = 3120
Width = 1575
End
Begin VB.Label Label3
BackColor = &H00C0E0FF&
Caption = "添加者："
BeginProperty Font
Name = "隸書"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 360
TabIndex = 3
Top = 2640
Width = 1335
End
Begin VB.Label Label2
BackColor = &H00C0E0FF&
Caption = "新聞內容："
BeginProperty Font
Name = "隸書"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 2
Top = 1800
Width = 1575
End
Begin VB.Label Label1
BackColor = &H00C0E0FF&
Caption = "新聞標題："
BeginProperty Font
Name = "隸書"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 1
Top = 960
Width = 1575
End
Begin VB.Label label
BackColor = &H00C0E0FF&
Caption = "宿舍管理系統"
BeginProperty Font
Name = "隸書"
Size = 21.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3000
TabIndex = 0
Top = 240
Width = 2895
End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim SQL As String
Dim newsjl As New ADODB.Recordset ''定義newsjl為數據庫的新聞表中的記錄集對象
Private Sub Clear()
'將文本框中的內容設置為空
title.Text = ""
content.Text = ""
adder.Text = ""
addtime.Text = ""
note.Text = ""
End Sub
Private Sub Cmdclear_Click()
Call Clear
title.SetFocus '鼠標焦點放置在新聞標題處
End Sub
Private Sub Form_Load()
'調用自定義的三個函數
Call Clear
Call MSFG_display
Call Data_Display
End Sub
Private Sub Data_Display()
Dim i As Integer '定義一個變量i，產生序號
SQL = "select * from xinwen"
Set newsjl = cnn.Execute(SQL) '設置記錄集對象實例，執行查詢
MSFlexGrid1.Rows = 1 '清空表
newsjl.MoveFirst '記錄集中的移動方法,指針移動到記錄集的開始
i = 1 '將變量初始化，設置其初始值為1
Do While Not newsjl.EOF '判斷指針是否移動到記錄集的末尾
'逐條顯示新聞的內容
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 0) = i
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 1) = Trim(newsjl("newstitle"))
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 2) = Trim(newsjl("newscontent"))
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 3) = Trim(newsjl("newsadder"))
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 4) = Trim(newsjl("newsaddtime"))
MSFlexGrid1.TextMatrix(MSFlexGrid1.Rows - 1, 5) = Trim(newsjl("newsnote"))
newsjl.MoveNext '記錄集中的移動方法,指針向下移動
i = i + 1
Loop
End Sub
Private Sub MSFG_display()
'分配顯示新聞時每個項目的寬度，并讓其居中
MSFlexGrid1.ColWidth(0) = 500
MSFlexGrid1.ColAlignment(0) = flexAlignCenterCenter
MSFlexGrid1.ColWidth(1) = 2750
MSFlexGrid1.ColAlignment(1) = flexAlignCenterCenter
MSFlexGrid1.ColWidth(2) = 3000
MSFlexGrid1.ColAlignment(2) = flexAlignCenterCenter
MSFlexGrid1.ColWidth(3) = 800
MSFlexGrid1.ColAlignment(3) = flexAlignCenterCenter
MSFlexGrid1.ColWidth(4) = 800
MSFlexGrid1.ColAlignment(4) = flexAlignCenterCenter
MSFlexGrid1.ColWidth(5) = 800
MSFlexGrid1.ColAlignment(5) = flexAlignCenterCenter
MSFlexGrid1.Rows = 1
End Sub
Private Sub MSFlexGrid1_Click()
'點擊每條新聞時，讓其在文本框中顯示相應的內容
title.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 1)
content.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 2)
adder.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 3)
addtime.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 4)
note.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 5)
End Sub
Private Sub MSFlexGrid1_RowColChange()
Call MSFlexGrid1_Click
End Sub
Private Sub cmdadd_Click()
'判斷新聞標題是否為空
If title.Text = "" Then
MsgBox "標題不能為空！", vbOKOnly, "information"
title.SetFocus
Exit Sub
End If
'檢查是否存在該新聞標題
SQL = "select newstitle from xinwen where newstitle='" & title.Text & "'"
Set newsjl = cnn.Execute(SQL) '執行查詢結果
If newsjl.BOF And newsjl.EOF Then '如果不存在此新聞標題，那么執行下面的數據插入：
SQL = "insert into xinwen (newstitle,newscontent,newsadder,newsaddtime,newsnote) values ('" & title.Text & "','" & content.Text & "','" & adder.Text & "','" & addtime.Text & "','" & note.Text & "')"
cnn.Execute (SQL) '對上面的插入操作進行執行
MsgBox "添加成功！", vbOKOnly, "information"
Call Clear
title.SetFocus
Call MSFG_display
Call Data_Display
Else
MsgBox "不允許使用相同的標題，請更換！", vbOKOnly, "information" '存在相同的新聞標題，給出提示
Call Clear
title.SetFocus
Call MSFG_display
Call Data_Display
End If
End Sub
Private Sub cmdmodify_Click()
Dim Msg As String
If title.Text = "" Then
MsgBox "新聞標題不能為空！", vbOKOnly, "information"
title.SetFocus
Exit Sub
Else
'查詢當前新聞標題
SQL = "select newstitle from xinwen where newstitle='" & title.Text & "'"
Set newsjl = cnn.Execute(SQL) '執行當前查詢結果
SQL = "update xinwen set newstitle='" & title.Text & "',newscontent='" & content.Text & "',newsadder='" & adder.Text & "',newsaddtime='" & addtime.Text & "',newsnote='" & note.Text & "' where newstitle='" & title.Text & "'"
cnn.Execute (SQL) '對數據執行更新操作
MsgBox "修改成功！", vbOKOnly, "information"
Call Clear
title.SetFocus
Call MSFG_display
Call Data_Display
End If
End Sub
Private Sub cmddelete_Click()
If title.Text = "" Then
MsgBox "新聞標題不能為空！", vbOKOnly, "information"
title.SetFocus
Exit Sub
End If
SQL = "delete from xinwen where newstitle='" & title.Text & "'"
cnn.Execute (SQL) '執行刪除操作
MsgBox "刪除成功！", vbOKOnly, "information"
Call Clear
Call Data_Display
title.SetFocus
End Sub
Private Sub cmdexit_Click()
If cnn.State <> 0 Then '判斷是否已經使用過Cnn
cnn.Close '關閉數據庫,斷開數據庫的連接
End If
Set cnn = Nothing
End '退出
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -