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(); } }