VS2008下使用CppSQLite3访问xgs黑名单表(SQLite数据库)
2014年4月9日17:32:10
代码:
#include <stdlib.h>
#include <stdio.h>
#include "CppSQLite3.h"
#include<iostream>
using namespace std;
int main()
{
printf("hello,world!\n");
CppSQLite3DB db;
db.open("ETCVoidCard.db3");
CppSQLite3Query query = db.execQuery("select * from ETCVOIDCARD");
//while(!query.eof())
if(!query.eof())
{
cout<<"CARDNETWORK:"<<query.getIntField("CARDNETWORK")<<" CARDID:"<<query.getStringField("CARDID")<<endl;
cout<<"CARDSTATUS:"<<query.getIntField("CARDSTATUS")<<" CARDTYPE:"<<query.getIntField("CARDTYPE")<<endl;
cout<<"VALIDFLAG:"<<query.getIntField("VALIDFLAG")<<" INTIME:"<<query.getStringField("INTIME")<<endl;
cout<<"CANCELTIME:"<<query.getStringField("CANCELTIME")<<" BANTYPE:"<<query.getIntField("BANTYPE")<<endl;
cout<<"LOCKCARD:"<<query.getIntField("LOCKCARD")<<" CONTACTINFO:"<<query.getStringField("CONTACTINFO")<<endl;
cout<<"SCOMMENT:"<<query.getStringField("SCOMMENT")<<" VERSION:"<<query.getIntField("VERSION")<<endl;
cout<<"SPARE1:"<<query.getIntField("SPARE1")<<" SPARE2:"<<query.getIntField("SPARE2")<<endl;
cout<<"SPARE3:"<<query.getStringField("SPARE3")<<endl;
query.nextRow();
}
query.finalize();
db.close();
system("pause");
return 0;
}