SQLite内存数据库简单使用范例

#include <stdio.h>
#include <stdlib.h>
#include<string.h>
#include "sqlite3.h"
#pragma comment(lib,"sqlite3.lib")
#include <windows.h>
#include <iostream>
#include "CodingConv.h"
int main(int argc,char* argv[])
{
	int rc,i,ncols;	
	sqlite3 *db;
	sqlite3_stmt *stmt;
	char *sql;
	const char *tail;
	char* zErrMsg;
	rc=sqlite3_open(":memory:",&db);
	rc=sqlite3_exec(db,"attach 'c:mydatabase.db' as new_Db",&zErrMsg);
	sqlite3_exec(db,"detach 'C:mydatabase.db",&zErrMsg);
	//char temp[256]="c:数据库mydatabase.db";
	//char FileRoot[256];
	//CCodingConv::GB2312_2_UTF8(FileRoot,256,temp,0);
	//
	//rc=sqlite3_open(FileRoot,&db);
    //rc = sqlite3_open("mydatabase.db",&db);
    if(rc!= SQLITE_OK )		
    {		
		printf("failed to open database!n");
		return -1;
	}
	sql="select * from test";

	rc=sqlite3_prepare(db,sql,(int)strlen(sql),&stmt,&tail);
	if(rc!=SQLITE_OK)
	{
		fprintf(stderr,"SQL error:%sn",sqlite3_errmsg(db));
	}

	rc=sqlite3_step(stmt);
	ncols=sqlite3_column_count(stmt);
	while(rc==SQLITE_ROW)
	{
		for(i=0;i<ncols;i++)
		{
			fprintf(stderr,"%s",sqlite3_column_text(stmt,i));
		}
		fprintf(stderr,"n");
		rc=sqlite3_step(stmt);
	}
	sqlite3_finalize(stmt);
	sqlite3_close(db);
	printf("n");
	return 0;
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!