module1.bas

来自「本学生信息管理系统包括学籍信息管理、班级信息管理、课程信息管理、成绩信息管理四大」· BAS 代码 · 共 85 行

Attribute VB_Name = "Module1"
Public fMainForm As frmMain
Public UserName As String
Public usertype As String '


Sub Main()
    Dim fLogin As New frmLogin
    fLogin.Show vbModal
    If Not fLogin.OK Then
        'Login Failed so exit app
        End
    End If
    Unload fLogin

If (usertype = "管理员") Then
    Set fMainForm = New frmMain
    fMainForm.Show
Else
    'Set fuserform = New frmmainuser
    'fuserform.Show
    Set fMainForm = New frmMain
    fMainForm.addcinfoMenu.Enabled = False
    fMainForm.addcourseMenu.Enabled = False
    fMainForm.addresultMenu.Enabled = False
    fMainForm.addsinfoMenu.Enabled = False
    fMainForm.adduserMenu.Enabled = False
    fMainForm.modifycinfoMenu.Enabled = False
    fMainForm.modifycourseMenu.Enabled = False
    fMainForm.modifypwdMenu.Enabled = False
    fMainForm.modifyresultMenu.Enabled = False
    fMainForm.modifysinfo_Menu.Enabled = False
    fMainForm.gradecourseMenu.Enabled = False
    fMainForm.Show
End If
End Sub
Public Function ConnectString() _
   As String
'returns a DB ConnectString
'   ConnectString = "FileDSN=studentinfo.dsn;UID=sa;PWD="
    ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=student.mdb;Persist Security Info=False"
End Function
Public Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
'executes SQL and returns Recordset
   Dim cnn As ADODB.Connection
   Dim rst As ADODB.Recordset
   Dim sTokens() As String
   
   On Error GoTo ExecuteSQL_Error
   
   sTokens = Split(SQL)
   Set cnn = New ADODB.Connection
   cnn.Open ConnectString
   If InStr("INSERT,DELETE,UPDATE", UCase$(sTokens(0))) Then
      cnn.Execute SQL
      MsgString = sTokens(0) & " query successful"
   Else
      Set rst = New ADODB.Recordset
      rst.Open Trim$(SQL), cnn, adOpenKeyset, adLockOptimistic
      'rst.MoveLast     'get RecordCount
      Set ExecuteSQL = rst
      MsgString = "查询到" & rst.RecordCount & " 条记录 "
   End If
'    Set rst = New ADODB.Recordset
'    rst.Open

ExecuteSQL_Exit:
   Set rst = Nothing
   Set cnn = Nothing
   Exit Function
   
ExecuteSQL_Error:
   MsgString = "查询错误: " & Err.Description
   Resume ExecuteSQL_Exit
End Function

Public Function Testtxt(txt As String) As Boolean
    If Trim(txt) = "" Then
        Testtxt = False
    Else
        Testtxt = True
    End If
End Function