📄 form_db.frm
字号:
VERSION 5.00
Begin VB.Form Form_Db
Caption = "数据库设置"
ClientHeight = 5910
ClientLeft = 1815
ClientTop = 2265
ClientWidth = 8085
ControlBox = 0 'False
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5910
ScaleWidth = 8085
Begin VB.CommandButton Com_Quit
Caption = "取消"
Height = 375
Left = 4560
TabIndex = 9
Top = 5040
Width = 1335
End
Begin VB.CommandButton Com_Connect
Caption = "测试连接"
Height = 375
Left = 2880
TabIndex = 8
Top = 5040
Width = 1335
End
Begin VB.CommandButton Com_OK
Caption = "确定"
Height = 375
Left = 1200
TabIndex = 7
Top = 5040
Width = 1335
End
Begin VB.Frame Frame1
Caption = "设置"
Height = 4095
Left = 720
TabIndex = 0
Top = 480
Width = 6375
Begin VB.TextBox Text_DB
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
IMEMode = 3 'DISABLE
Left = 2160
TabIndex = 10
Top = 3120
Width = 2655
End
Begin VB.TextBox Text_Pass
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
IMEMode = 3 'DISABLE
Left = 2160
PasswordChar = "*"
TabIndex = 3
Top = 2400
Width = 2655
End
Begin VB.TextBox Text_User
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
IMEMode = 3 'DISABLE
Left = 2160
TabIndex = 2
Top = 1440
Width = 2655
End
Begin VB.TextBox Text_Server
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
IMEMode = 3 'DISABLE
Left = 2160
TabIndex = 1
Top = 600
Width = 2655
End
Begin VB.Label Label1
Caption = "数据库名"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 255
Index = 3
Left = 600
TabIndex = 11
Top = 3240
Width = 1095
End
Begin VB.Label Label1
Caption = "口令"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 255
Index = 2
Left = 1080
TabIndex = 6
Top = 2400
Width = 735
End
Begin VB.Label Label1
Caption = "用户名"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 255
Index = 1
Left = 840
TabIndex = 5
Top = 1560
Width = 975
End
Begin VB.Label Label1
Caption = "数据库服务器"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 255
Index = 0
Left = 480
TabIndex = 4
Top = 600
Width = 1575
End
End
End
Attribute VB_Name = "Form_Db"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Com_Connect_Click()
Dim obj As New ADODB.Connection
Dim strCon As String
Dim myVal
On Error GoTo Err
strCon = "driver={SQL Server};server=" & Trim(Text_Server.Text) & _
";uid=" & Trim(Text_User.Text) & _
";pwd=" & Trim(Text_Pass.Text) & _
";database=" & Trim(Text_DB.Text)
obj.Open strCon
myVal = MsgBox("数据库连接成功", vbOKOnly, "数据库设置")
Exit Sub
Err:
myVal = MsgBox("数据库连接失败，错误描述：" & Err.Description, vbOKOnly, "数据库设置")
End Sub
Private Sub Com_OK_Click()
Dim strCon As String
Dim myVa
strCon = Text_Server.Text
If CModule.WriteConfig("DataBase", "server", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
strCon = Text_User.Text
If CModule.WriteConfig("DataBase", "uid", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
strCon = Text_Pass.Text
If CModule.WriteConfig("DataBase", "PWD", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
strCon = Text_DB.Text
If CModule.WriteConfig("DataBase", "Database", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
strVal = MsgBox("数据库设置成功", vbOKOnly, "数据库设置")
Unload Me
End Sub
Private Sub Com_Quit_Click()
Unload Me
End Sub
Private Sub Form_Load()
Dim strCon As String
Dim strVal
If CModule.GetConfig("DataBase", "server", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
Text_Server.Text = strCon
If CModule.GetConfig("DataBase", "uid", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
Text_User.Text = strCon
If CModule.GetConfig("DataBase", "PWD", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
Text_Pass.Text = strCon
If CModule.GetConfig("DataBase", "Database", strCon) = False Then
strVal = MsgBox(strCon, vbOKOnly, "数据库设置")
Exit Sub
End If
Text_DB.Text = strCon
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -