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

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

总结

以上是内存溢出为你收集整理的SQLite内存数据库简单使用范例全部内容，希望文章能够帮你解决SQLite内存数据库简单使用范例所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。