information.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 = "Information"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'1 ID  Int 编号
'2 Title  Varchar 标题
'3 Signal Varchar 详细信息

Public ID As Long
Public Title As String
Public Signal As String

Public Sub Init()
  ID = 0
  Title = ""
  Signal = ""
End Sub

'删除指定算法信息
Public Sub Delete(ByVal TmpTitle As String)
  DB_Connect
  
  SqlStmt = "DELETE FROM Information WHERE Signal='" _
          + Trim(TmpTitle) + "'"
  OdbcExt (SqlStmt)
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
  DB_Disconnect
End Sub

Public Function GetInfo(ByVal TmpTitle As String) As String
  DB_Connect
  
  SqlStmt = "SELECT * FROM Information WHERE Title='" + Trim(TmpTitle) + "'"
  OdbcExt (SqlStmt)
  If SQLFetch(Hstmt) <> SQL_NO_DATA_FOUND Then
    ColVal = String(400, 0)
    rc = SQLGetData(Hstmt, 3, 1, ColVal, Len(ColVal), pcblen)
      Signal = TrimStr(ColVal)
  Else
    Init
  End If
  rc = SQLFreeStmt(Hstmt, SQL_DROP)

  DB_Disconnect
End Function

Public Function In_DB(ByVal TmpTitle As String) As Boolean
  DB_Connect
  
  SqlStmt = "SELECT * FROM Information WHERE Title='" _
          + Trim(TmpTitle) + "'"
  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 Load_Title()
  Dim i As Integer
  
  Erase t
  ReDim t(0)

  DB_Connect
  
  SqlStmt = "SELECT Title FROM Information ORDER BY Title"
  OdbcExt (SqlStmt)
  i = 0
  ColVal = String(400, 0)
  Do Until SQLFetch(Hstmt) = SQL_NO_DATA_FOUND
    rc = SQLGetData(Hstmt, 1, 1, ColVal, Len(ColVal), pcblen)
    ReDim Preserve t(i + 1)
    t(i) = TrimStr(ColVal)
    i = i + 1
  Loop
  rc = SQLFreeStmt(Hstmt, SQL_DROP)
 
  DB_Disconnect
End Sub