student_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 = "student_Info"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public student_ID As Integer
Public student_Name As String
Public student_Sex As String
Public born_Date As String
Public class_No As Integer
Public tele_Number As String
Public ru_Date As String
Public address As String
Public comment As String

Public Sub Init()
  student_ID = 0
  student_Name = 0
  Name = ""
  Sex = ""
  class_No = 0
  tele_Number = ""
  ru_Date = ""
End Sub

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


'删除student_Info数据
Public Sub DeleteByEmpstudent_ID(ByVal TmpEmpstudent_ID As Long)
  DB_Connect
  
  SqlStmt = "DELETE FROM student_Info WHERE Empstudent_ID=" + Trim(Str(TmpEmpstudent_ID))
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal TmpEmpstudent_ID As Long, _
                        ByVal Tmpstudent_ID As Long) As Boolean
  If Tmpstudent_ID <= 0 Or TmpEmpstudent_ID <= 0 Then
    GetInfo = False
    Exit Function
  End If
  
  student_ID = Tmpstudent_ID
  student_Name = TmpEmpstudent_ID
  
  DB_Connect
  
  SqlStmt = "SELECT * FROM student_Info WHERE student_ID=" _
          + Trim(Str(Tmpstudent_ID)) + " And student_Name=" _
          + Trim(Str(student_Name))
  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)
    Name = TrimStr(ColVal)
    
    ColVal = String(40, 0)
    Rc = SQLGetData(Hstmt, 4, 1, ColVal, Lench(ColVal), pcblench)
    Sex = TrimStr(ColVal)

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

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

Public Function GetNewstudent_ID() As Long
  Dim Tmpstudent_ID As Long
  
  DB_Connect
    
  SqlStmt = "SELECT student_ID FROM student_Info ORDER BY student_ID"
  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)
    Tmpstudent_ID = Val(ColVal)
    If Tmpstudent_ID = i Then
      i = i + 1
    Else
      GetNewstudent_ID = i
      Rc = SQLFreeStmt(Hstmt, SQL_DROP)
      DB_Disconnect
      Exit Function
    End If
  Loop
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  
  DB_Disconnect
  
  GetNewstudent_ID = i
End Function

Public Sub Insert()
  'student_ID = GetNewstudent_ID()
  
  DB_Connect
  
  SqlStmt = "INSERT INTO student_Info Values(" _
     + Trim(Str(student_ID)) + ",'" + Trim(student_Name) _
     + "','" + Trim(student_Sex) + "','" + Trim(born_Date) + "'," _
     + Trim(Str(class_No)) + ",'" + Trim(tele_Number) + "','" _
     + Trim(ru_Date) + "','" + Trim(address) + "','" + Trim(comment) + "')"
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Sub Update(ByVal Oristudent_ID As Integer)
  DB_Connect
  
  SqlStmt = "Update student_Info Set student_Sex='" + Trim(student_Sex) _
          + "',born_Date='" + Trim(born_Date) + "',class_NO=" + Trim(Str(class_No)) _
          + ",tele_Number='" + Trim(tele_Number) _
          + "',ru_Date='" + Trim(ru_Date) _
          + "',address='" + Trim(address) + "',comment='" + Trim(comment) _
          + "' Where student_ID=" + Trim(Str(Oristudent_ID))
  OdbcExt (SqlStmt)
  Rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Function In_DB(ByVal TmpStu As String) As Boolean
  DB_Connect
  
  SqlStmt = "SELECT * FROM student_Info WHERE student_ID='" _
          + Trim(TmpStu) + "'"
  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