void CStoredMessage::ClearMessage()
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("drop table messages");
conn.Execute(szCmdText);
szCmdText.Format("create table messages(id autoincrement, message Memo)");
conn.Execute(szCmdText);
conn.Close();
}
void CStoredAccount::ClearAccount()
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("drop table accounts");
conn.Execute(szCmdText);
szCmdText.Format("create table accounts(id autoincrement, uid varchar(50), pwd varchar(50))");
conn.Execute(szCmdText);
conn.Close();
}
void CStoredMessage::AddMessage(CString strMessage)
{
if (!strMessage.IsEmpty())
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("insert into messages(message) values('%s')", strMessage);
conn.Execute(szCmdText);
conn.Close();
}
}
void CStoredAccount::AddAccount(CString strUserName, CString pwd)
{
if (!strUserName.IsEmpty())
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("insert into accounts(uid, pwd) values('%s', '%s')", strUserName, pwd);
conn.Execute(szCmdText);
conn.Close();
}
}
