23,116
社区成员
发帖
与我相关
我的任务
分享
bool occiCdb::initFlatData ( vector< ST_FLAT_BYXD* > & vFlatData )
{
bool bRet(true);
//获取agent数据
string strSql = "SELECT ECID,MOBILE,SIGNFLAG,ECID2 FROM EDU.FLAT_BYXD"; //-----调用出错
//string strSql = "SELECT '108007800053','13781728972',1,'76659059008261' FROM dual"; //--调用正确
stmt = conn->createStatement(strSql);
ResultSet *rset = stmt->executeQuery();
try{
while (rset->next ())
{
ST_FLAT_BYXD* pFlatData = new ST_FLAT_BYXD();
pFlatData->nEcId = rset->getString(1);
pFlatData->strMobile = rset->getString(2);
pFlatData->nSignFlag = rset->getInt(3);
pFlatData->nEcId2 = rset->getString(4);
vFlatData.push_back( pFlatData );
}
}catch(SQLException ex)
{
//记录操作失败日志
sprintf(c_log,"initFlatData sql:%s\nerror code:%d\nerror message:%s",
strSql.c_str(),
ex.getErrorCode(),
ex.getMessage().c_str());
RecordLog(c_log);
bRet = false;
}
//关闭结果集
stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
if (bRet)
RecordLog("initFlatData success");
return bRet;
}
vector< ST_FLAT_BYXD* > gFlatData;
//连接配置数据库
occiCdb *pConfDb = new occiCdb(99);
//初始化数据
pConfDb->initFlatData( gFlatData );
驱动main函数调用处