历时两个月的毕业设计终于做完了,现送部分源代码兼散分!(UP没分)
xks 2003-04-15 07:53:59 历时两个月的毕业设计终于做完了,现送部分源代码兼散分!(UP没分)
总结一些代码,现送给有这方面需要的各位!
写的不好!望指教!
'*********************************************************
'* 名称:类模块DataBaseConnection
'* 功能:连接SQL Server、Access等数据库的模块定义
'*********************************************************
Option Explicit
Public Function MdbConnectString(MdbFile As String, Optional UserName As String, Optional password As String) As String
MdbConnectString = "Provider=MSDASQL.1;Extended Properties=" + """" + "DBQ=" + MdbFile + ";Driver={Microsoft Access Driver (*.mdb)};MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=" + UserName + ";Pwd=" + password + """"
End Function
Public Function XlsConnectString(XlsFile As String) As String
XlsConnectString = "Provider=MSDASQL.1;Extended Properties=" + """" + "DBQ=" + XlsFile + ";Driver={Microsoft Excel Driver (*.xls)};MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3" + """"
End Function
Public Function CsvConnectString() As String
CsvConnectString = "Provider=MSDASQL.1;Extended Properties=" + """" + "Driver={Microsoft Text Driver (*.txt; *.csv)};MaxBufferSize=2048;MaxScanRows=25;PageTimeout=5;SafeTransactions=0;Threads=3;" + """"
End Function
Public Function SqlConnectString(ServerName As String, UserName As String, password As String) As String
SqlConnectString = "Provider=SQLOLEDB.1;User ID=" + UserName + ";Pwd=" + password + ";Data Source=" + ServerName
End Function
模块中定义的连接等公用变量
Public db As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
'*********************************************************
'* 名称:连接服务器窗体
'* 功能:连接SQL Server数据库
'* 控件:三个文本框和两个按钮
'*********************************************************
Private Sub Command1_Click()
On Error Resume Next
Dim DBC As New DataBaseConnection
If db.State = 1 Then
db.Close
End If
db.ConnectionString = DBC.SqlConnectString(Text1.Text, Text2.Text, Text3.Text)
rs.CursorType = adOpenDynamic
rs.CursorLocation = adUseClient
rs.LockType = adLockOptimistic
db.CursorLocation = adUseClient
db.Open
Set cmd.ActiveConnection = db
If Err.Number Then
MsgBox Err.Description, 16 + vbOKOnly, Err.Number
Exit Sub
End If
db.DefaultDatabase = "student1" ’设置要连接数据库名称
If Err.Number Then
MsgBox Err.Description, 16 + vbOKOnly, Err.Number
Exit Sub
End If
d1 = Text1.Text
d2 = Text2.Text
d3 = Text3.Text
Form1.Show
Unload Me
End Sub
'*********************************************************
'* 名称:系统登录窗体
'* 功能:系统登录
'* 控件:两个文本框和两个按钮
'*********************************************************
Private Sub cmdOK_Click()
dim cw as integer
On Error Resume Next
cmd.CommandText = "Select * from user_info where user1 = '" + Text1.Text + "' And password = '" + Text2.Text + "'"
Set rs = cmd.Execute
If Err.Number Then
MsgBox Err.Description, 16 + vbOKOnly, Err.Number
Exit Sub
End If
If rs.RecordCount = 0 Then
cw = cw + 1
If cw >= 3 Then
MsgBox "你可能不是本系统的合法用户!"
End
End If
MsgBox "用户名不正确或密码不对,请重新输入!", 16 + vbOKOnly, "错误"
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
Exit Sub
End If
MDIForm1.Show
Unload Me
End Sub
'*********************************************************
'* 名称:添加管理员用户:
'* 功能:向数据库表中添加记录用以登录系统
'* 控件:三个文本框和两个按钮
'*********************************************************
Private Sub cmdOK_Click()
Set cmd.ActiveConnection = db
If Trim(user(0).Text) = "" Then
MsgBox "请输入用户名", vbOKOnly + vbExclamation, "警告"
Exit Sub
user(0).SetFocus
Else
cmd.CommandText = "select * from user_info"
Set rs = cmd.Execute
While (rs.EOF = False)
If Trim(rs.Fields(0)) = Trim(user(0)) Then
MsgBox "用户名已经存在,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
user(0).Text = ""
password(1).Text = ""
password(2).Text = ""
user(0).SetFocus
Exit Sub
Else
rs.MoveNext
End If
Wend
End If
If Trim(password(1).Text) <> Trim(password(2).Text) Then
MsgBox "两次输入的密码不一致,请检查确认!", vbOKOnly + vbExclamation, "警告"
password(1).Text = ""
password(2).Text = ""
password(1).SetFocus
Else
If password(1).Text = "" Then
MsgBox "密码不能为空,请重新输入", vbOKOnly + vbExclamation, "警告"
password(1).Text = ""
password(2).Text = ""
password(1).SetFocus
Else
r = CStr(user(0).Text)
t = CStr(password(1).Text)
cmd.CommandText = "insert into user_info( user1,password) values(" & "'" & r & " '" & "," & "'" & t & "'" & ");"
Set rs = cmd.Execute
user(0).Text = ""
password(1).Text = ""
password(2).Text = ""
MsgBox "添加用户成功!", vbOKOnly + vbExclamation, "添加用户"
Me.Hide
End If
End If
End Sub