利用ADO方式向Oracle 数据库中插入当前日期时间(yyyy-mm-dd hh24:mi:ss)
#include <afx.h>#include <iostream>
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF","adoEOF"),rename("LockTypeEnum","AdoLockTypeEnum"),rename("DataTypeEnum","AdoDataTypeEnum"),\
rename("FieldAttributeEnum","AdoFieldAttributeEnum"),rename("EditModeEnum","AdoEditModeEnum"),rename("RecordStatusEnum","AdoRecordStatusEnum"),rename("ParameterDirectionEnum","AdoParameterDirectionEnum")
using namespace std;
try
{
_variant_t RecordsAffected;
CString sql;
CTime tm = CTime::GetCurrentTime();
CString str=tm.Format("%Y-%m-%d %H-%M-%S");
//cout<<str;//输出tm结构体的时间成员
sql="insert into RECV_TABLE (ID_SENSOR,MESSAGE,DETECT_TIME) values ('S1035','1235698回家中国馆薄瓜瓜',to_date('"+str+"','yyyy-mm-dd hh24:mi:ss'))";
m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
cout<<"数据添加成功!"<<endl;
}
catch(_com_error *e)
{
cout<<e->ErrorMessage()<<endl;
return 0;
}
break;