我用的mysql文件在附件里...用C++的........
点击浏览该文件
我也把我用的代码贴上来吧!!!!
大家帮我看下......帮我啊!!!!
CSqlBase mySQLBase;/*数据库接连对象*/
mySQLBase.SetHostInfo(HostServerAddr,atoi(MySqlDataBasePorts));
mySQLBase.SetUserInfo(MySqlUserName,NULL);
mySQLBase.Open(MySqlDataBase);
CSqlSet *nSql;
char strSQL[100] = {0};
Elog("CLIENT","erlog.log",0);
sprintf(strSQL,"%s","select * from CLIENT");
Elog(strSQL,"erlog.log",0);
Elog("111111111111CLIENT","erlog.log",0);
nSql = mySQLBase.NewSet();
Elog("222222222222222CLIENT","erlog.log",0);
nSql->Open(strSQL);
Elog("333333333333333CLIENT","erlog.log",0);
while (!nSql->IsEof())/*循环次数是表中的数据数*/
{
Elog("循环次数是表中的数据数","erlog.log",0);
Elog(nSql->Field("CLI_NAME"),"erlog.log",0);
Elog(nSql->Field("CLI_SEX"),"erlog.log",0);
Elog(nSql->Field("CLI_DEP_ID"),"erlog.log",0);
Elog(nSql->Field("CLI_GRO_ID"),"erlog.log",0);
Elog(nSql->Field("CLI_AUTH_ID"),"erlog.log",0);
nSql->MoveNext();
}
nSql->Close();
Elog("ORG_DEPART","erlog.log",0);
sprintf(strSQL,"%s","select * from ORG_DEPART");
nSql = mySQLBase.NewSet();
nSql->Open(strSQL);
while (!nSql->IsEof())/*循环次数是表中的数据数*/
{
Elog(nSql->Field("ORG_DEP_ID"),"erlog.log",0);
Elog(nSql->Field("ORG_DEP_NAME"),"erlog.log",0);
nSql->MoveNext();
}
nSql->Close();
出现的日志结果如下:
[2008-04-04 13:45:38] CLIENT
[2008-04-04 13:45:38] select * from CLIENT
[2008-04-04 13:45:38] 111111111111CLIENT
[2008-04-04 13:45:38] 222222222222222CLIENT
[2008-04-04 13:45:38] 333333333333333CLIENT
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ??
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ???
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 2
[2008-04-04 13:45:38] 2
[2008-04-04 13:45:38] 2
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ??
[2008-04-04 13:45:38] 0
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ??
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ??A?
[2008-04-04 13:45:38] 0
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] ??B?
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 5
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] A??1
[2008-04-04 13:45:38] 0
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 5
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] A??2
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 5
[2008-04-04 13:45:38] 循环次数是表中的数据数
[2008-04-04 13:45:38] B??1
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] 5
[2008-04-04 13:45:38] 5
[2008-04-04 13:45:38] ORG_DEPART
[2008-04-04 13:45:38] 1
[2008-04-04 13:45:38] ??
[2008-04-04 13:45:38] 2
[2008-04-04 13:45:38] ???
[2008-04-04 13:45:38] 3
[2008-04-04 13:45:38] ???
[2008-04-04 13:45:38] 4
[2008-04-04 13:45:38] ???