C++ builder学习之简单Session 实现

#pragma once
#include<string>
#include<MSAccess.hpp>
using namespace std;

class CMySession
{
public:
 CMySession();
 //数据操作
 TMSQuery* QueryData(string strSQL);
 void ConnectDatabase(TMSConnection* ptmsConnection);
 bool WriteData(string strSQL);
 bool DeleteData(string strSQL);
 //业务逻辑
 bool VerifyUserStatus();//检验用户状态
 bool CreateSession(string strUserName,TMSConnection* ptmsConn);//创建会话
public:
 ~CMySession(void);
private:
 string m_strUserName;
 unsigned int m_uSessionID;
 TMSConnection *m_ptmsConn;

};

 

 

#include "MySession.h"

void CMySession::ConnectDatabase(TMSConnection* ptmsConnection)
{
 m_ptmsConn = ptmsConnection;
 return;

}
//创建会话
bool CMySession::CreateSession(string strUserName,TMSConnection* ptmsConn)
{
        m_strUserName = strUserName;
 ConnectDatabase(ptmsConn);
 string strSQL;
        strSQL = "select * from T_log where user_name = '" + strUserName + "'";

        TMSQuery* ptmsQuery = QueryData(strSQL);
        if(ptmsQuery == NULL)
           return false;
 if(ptmsQuery->RecordCount == 0)
 {
                delete ptmsQuery;
                pt