VS2008下使用CppSQLite3访问xgs黑名单表(SQLite数据库)

来源：互联网发布：豆瓣fm mac下载编辑：程序博客网时间：2024/05/22 05:17

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;}

0 0