result_info.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 = "result_Info"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public exam_No As String
Public student_ID As Integer
Public student_Name As String
Public class_No As Integer
Public course_Name As String
Public result As Long


Public Sub Init()
  exam_No = ""
  student_ID = 0
  student_Name = ""
  class_No = 0
  course_Name = ""
  result = 0

End Sub

'删除result_Info数据
Public Sub Delete(ByVal TmpEmpexam_No As Integer)
  DB_Connect
  
  SqlStmt = "DELETE FROM result_Info WHERE student_ID=" + Trim(Str(TmpEmpexam_No))
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

'删除result_Info数据
Public Sub DeleteByEmpexam_No(ByVal TmpEmpexam_No As Long)
  DB_Connect
  
  SqlStmt = "DELETE FROM result_Info WHERE Empexam_No=" + Trim(Str(TmpEmpexam_No))
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal TmpEmpexam_No As Long, _
                        ByVal Tmpexam_No As Long) As Boolean
  If Tmpexam_No <= 0 Or TmpEmpexam_No <= 0 Then
    GetInfo = False
    Exit Function
  End If
  
  exam_No = Tmpexam_No
  student_ID = TmpEmpexam_No
  
  DB_Connect
  
  SqlStmt = "SELECT * FROM result_Info WHERE exam_No=" _
          + Trim(Str(Tmpexam_No)) + " And student_ID=" _
          + Trim(Str(student_ID))
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) = SQL_NO_DATA_FOUND Then
    GetInfo = False
    Exit Function
  Else
    ColVal = String(400, 0)
    Rc = SQLGetData(Hstmt, 3, 1, ColVal, Lench(ColVal), pcblench)
    student_Name = TrimStr(ColVal)
    
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 4, 1, ColVal, Lench(ColVal), pcblench)
    class_No = TrimStr(ColVal)

    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 5, 1, ColVal, Lench(ColVal), pcblench)
    course_Name = Val(ColVal)
    
    ColVal = String(400, 0)
    Rc = SQLGetData(Hstmt, 6, 1, ColVal, Lench(ColVal), pcblench)
    result = TrimStr(ColVal)

    ColVal = String(400, 0)
    Rc = SQLGetData(Hstmt, 7, 1, ColVal, Lench(ColVal), pcblench)
    WorkingOrg = TrimStr(ColVal)
  End If
    
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  GetInfo = True
  DB_Disconnect
End Function

Public Function GetNewexam_No() As Long
  Dim Tmpexam_No As Long
  
  DB_Connect
    
  SqlStmt = "SELECT exam_No FROM result_Info ORDER BY exam_No"
  OdbcExt (SqlStmt)
  i = 1
  Do While SQLFetch(Hstmt) <> SQL_NO_DATA_FOUND
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 1, 1, ColVal, Len(ColVal), pcblen)
    Tmpexam_No = Val(ColVal)
    If Tmpexam_No = i Then
      i = i + 1
    Else
      GetNewexam_No = i
      Rc = SQLFreeStmt(Hstmt, SQL_DROP)
      DB_Disconnect
      Exit Function
    End If
  Loop
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
  
  GetNewexam_No = i
End Function

Public Sub Insert()
  'exam_No = GetNewexam_No()
  
  DB_Connect
  
  SqlStmt = "INSERT INTO result_Info Values('" _
     + Trim(exam_No) + "'," + Trim(Str(student_ID)) _
     + ",'" + Trim(student_Name) + "'," + Trim(Str(class_No)) + ",'" _
     + Trim(course_Name) + "'," + Trim(Str(result)) + ")"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Sub Update(ByVal OriEmpexam_No As String)
  DB_Connect
  
  SqlStmt = "Update result_Info Set student_Name='" + Trim(student_Name) _
          + "',class_No=" + Trim(Str(class_No)) + ",course_Name='" + Trim(course_Name) _
          + "',result='" + Trim(result) _
          + "',student_ID=" + Trim(Str(OriEmpexam_No)) _
          + "  WHERE exam_No=" + Trim(Str(Oriexam_No))
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub