#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