4,011
社区成员
发帖
与我相关
我的任务
分享
_bstr_t bstrBody = pMessage->HTMLBody;//此处得到邮件的text/html内容
COleDateTime oleDate = pMessage->Date;
////////////////////////此处将获取的邮件存到access数据库中///////////////////
_variant_t RecordsAffected;
m_pRecordset.CreateInstance("ADODB.Recordset");
CString sqlstr;
CString date=oleDate.Format("%Y-%m-%d %H:%M:%S"); //COleDateTime->CString
sqlstr= "INSERT INTO [邮件] ([owner],[postter],[subject],[body],[date]) VALUES('"+parent+"','"+(LPCTSTR)bstrFrom+"','"+(LPCTSTR)bstrSubject+"','"+(LPCTSTR)bstrBody+"','"+date+"')";//
m_pConnection->Execute(_bstr_t(sqlstr),&RecordsAffected,adCmdText);