scores.cls

这是一个国内通用的学生管理系统!包括院系,学生基本信息,照片,成绩,课程等多方面的管理系统

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Scores"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'1 LessonId  Int 课程编号
'2 Student_Id  Int 学生编号
'3 Score Tinyint 考试分数

Public LessonId As Long
Public Student_Id As Long
Public Score As Integer

Public Sub Init()
  LessonId = 0
  Student_Id = 0
  Score = 0
End Sub

'删除Salary数据
Public Sub Delete(ByVal TmpLid As Long, _
                  ByVal TmpSid As Long)
  DB_Connect
  
  SqlStmt = "DELETE FROM Scores WHERE LessonId=" + Trim(TmpLid) _
          + " And Student_Id=" + Trim(TmpSid)
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetScore(ByVal TmpLid As Long, _
                         ByVal TmpSid As Long) As Integer
  DB_Connect
  
  SqlStmt = "SELECT Score FROM Scores WHERE LessonId=" _
          + Trim(TmpLid) + " And Student_Id=" + Trim(TmpSid)
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetScore = 0
    Exit Function
  Else
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 1, 1, ColVal, Lench(ColVal), pcblench)
    GetScore = Val(ColVal)
  End If
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Function

Public Function In_DB(ByVal TmpLid As Long, _
                      ByVal TmpSid As Long) As Boolean
  DB_Connect
  
  SqlStmt = "SELECT Score FROM Scores WHERE LessonId=" _
          + Trim(TmpLid) + " And Student_Id=" + Trim(TmpSid)
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    In_DB = False
  Else
    In_DB = True
  End If
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)

  DB_Disconnect
End Function

Public Sub Insert()
  DB_Connect
  
  SqlStmt = "INSERT INTO Scores Values(" + Trim(LessonId) + "," _
          + Trim(Student_Id) + "," + Trim(Score) + ")"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Sub Update(ByVal TmpLid As Long, _
                  ByVal TmpSid As Long)
  DB_Connect
  
  SqlStmt = "Update Scores Set Score=" + Trim(Score) + " WHERE LessonId=" _
          + Trim(TmpLid) + " And Student_Id=" + Trim(TmpSid)
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub