插入时间值
时间是datetime类型 采用的sql server
CoInitialize(NULL); //访问comm库
_ConnectionPtr pConn(__uuidof(Connection));//定义对象的同时进行初始化
//智能指针 实际上是一个类 产生一个智能指针对象 //全局接口对象 全局唯一标志符 com接口
pConn->ConnectionString = "Provider=SQLOLEDB.1;Password=123456;Data Source=王莲花;User ID=hisUser;Initial Catalog=hisNurseDB";
pConn->Open("","","",adConnectUnspecified);
_RecordsetPtr pRst(__uuidof(Recordset));
pRst = pConn->Execute("convert(varchar(25),getdate(),120)" , NULL , adCmdText);
strSQL.Format(L"INSERT INTO Information values( convert(varchar(25),getdate(),120) ,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s') " ,
pRst,
lp_id,
lp_pump_type,
lp_bed,
lp_rate,
lp_preset,
lp_sum,
lp_tube_type,
lp_status,
lp_alarm1,
lp_alarm2,
lp_alarm3,
lp_alarm4);
pConn->Execute((_bstr_t)strSQL , NULL , adCmdText);
pConn->Close();
pConn.Release();
CoUninitialize();//卸载/释放comm库
上面的代码不是正确的,我是在想怎么才能把时间值带进去