64,654
社区成员
发帖
与我相关
我的任务
分享
void DBClass::OpenDB()
{
/////////////////MYSQL语句/////////////////////
myCon = mysql_init((MYSQL*)0);
if (NULL != mysql_real_connect(myCon, dbip, dbUser, dbPWD, dbname, 63346/*3306*/, NULL, 0))
{
cout<<"连接成功"<<endl;
//system("PAUSE");
}
else
{
cout<<"连接失败"<<endl;
system("PAUSE");
}
//return;
}
void DBClass::InsertDB(string strSQL)
{
////////////////MYSQL语句//////////////////
//strSQL = "insert into db_test(a,b) values('fuc1', 'you1'), ('fuc2', 'you2')";
if (0 == mysql_query(myCon, strSQL.c_str()))
{
cout << "插入成功" << endl;
}
else
{
cout << "插入失败" << endl;
mysql_close(myCon);
system("PAUSE");
//return -1;
}
}
strSQL += " ('" + dm + "', '" + updatetime+ "', " + InstrumentData[0] + ", " + InstrumentData[1] + ", "
+ InstrumentData[2] + ", " + InstrumentData[3] + ", " + InstrumentData[4]+ ", " + InstrumentData[5] + ", "
+ InstrumentData[6] + ", " + InstrumentData[7] + ", " + InstrumentData[8] + ", " + strTimeStamp + ", "
+ InstrumentData[9] + ", " + InstrumentData[10] + ", " + InstrumentData[11] + "," + InstrumentData[12] + ","
+ InstrumentData[13] + "," + InstrumentData[14] + "," + InstrumentData[15] + "," + InstrumentData[16] + ","
+ InstrumentData[17] + ")";
//+ ", " + pDepthMarketDat a.HighestPrice + ", " + pDepthMarketData.LowestPrice + ", " + nTime + ", '" + item.LastWriteTime + "'";
//strSQL += " select '" + dm + "'";
bFirst = false;
++nCount;
if (nCount == 1) // 突然想起这样插入,可能会导致数据丢失,但插一条效率可能会低,
{
/* 计数器,标志位复位 */
bFirst = true;
nCount = 0;
/* 插入数据库 */
dbController->InsertDB(strSQL); // 测试用暂注释这行
/* 重置字符串 */
strSQL = "insert into tstockinfodetail_two(StockID, LastWriteTime, LastPrice, BidPrice1, BidVol1, AskPrice1, AskVol1, Volume, HighestPrice, LowestPrice,OpenPrice, TimeStamp,PreSettlementPrice,UpperLimitPrice,LowerLimitPrice,OpenInterest,PreOpenInterest,SettlementPrice,PreClosePrice,ClosePrice,AveragePrice) values";
}
char dbUser[30] = "root";
char dbPWD[30] = "这里密码就不写出来了"; //"123456";//"root";//"root"; //
char dbip[50]="gz-cdb-9tqf5do7.sql.tencentcdb.com";//"localhost";
char dbname[50]="futures";//"db_websocket";
char tablename[50]="ttesttable";
char *query=NULL;
myCon = mysql_init((MYSQL*)0);
if (NULL != mysql_real_connect(myCon, dbip, dbUser, dbPWD, dbname, 63346/*3306*/, NULL, 0))
{
cout<<"连接成功"<<endl;
//system("PAUSE");
}
else
{
cout<<"连接失败"<<endl;
system("PAUSE");
}