c/c++ 操纵sqlite

#include "stdafx.h"

#include <stdlib.h>
#include <string>
#include <iostream>
#include "sqlite3.h"
#pragma comment(lib,"sqlite3.lib")

using namespace std;

bool sqlitedbcreate(char* name)
{
	sqlite3* conn;
	if(SQLITE_OK != sqlite3_open(name,&conn))
	{
		cout<<"创建数据库失败:"<<name<<endl;
		return false;
	}
	if(SQLITE_OK != sqlite3_close(conn))
	{
		cout<<"关闭连接失败:"<<endl;
		return false;
	}
	return true;
}

bool sqlitetablecreate(char* dbname,char* tablename)
{
	sqlite3* conn;
	char* errormsg;
	if(SQLITE_OK != sqlite3_open(dbname,&conn))
	{
		cout<<"打开数据库失败:"<<dbname<<endl;
		return false;
	}
	string sqlsentence = "create table ";
	sqlsentence += tablename;
	sqlsentence += " ([id] int, [name] char(20))";
	if(SQLITE_OK != sqlite3_exec(conn,sqlsentence.c_str(),0,0,&errormsg))
	{
		cout<<"创建表失败:"<<tablename<<endl<<"错误:"<<errormsg<<endl;
		return false;
	}

	if(SQLITE_OK != sqlite3_close(conn))
	{
		cout<<"关闭连接失败:"<<endl;
		return false;
	}
	return true;

}

bool sqlitetableexec(char* dbname,char* insert)
{
	sqlite3* conn;
	char* errormsg;
	if(SQLITE_OK != sqlite3_open(dbname,&conn))
	{
		cout<<"打开数据库失败:"<<dbname<<endl;
		return false;
	}

	if(SQLITE_OK != sqlite3_exec(conn,insert,0,0,&errormsg))
	{
		cout<<"执行语句失败:"<<insert<<endl<<"错误:"<<errormsg<<endl;
		return false;
	}

	if(SQLITE_OK != sqlite3_close(conn))
	{
		cout<<"关闭连接失败:"<<endl;
		return false;
	}
	return true;
}

int sqlitecallback(void* data,int colcount,char** colvalues,char** colnames) 
{
	for(int i = 0; i<colcount; i++)
	{
		cout<<colvalues[i]<<"\t";
	}
	cout<<endl;
	return 0;
}


bool sqliteselect(char* dbname,char* select)
{
	sqlite3* conn;
	char* errormsg;
	if(SQLITE_OK != sqlite3_open(dbname,&conn))
	{
		cout<<"打开数据库失败:"<<dbname<<endl;
		return false;
	}

	if(SQLITE_OK != sqlite3_exec(conn,select,&sqlitecallback,0,&errormsg))
	{
		cout<<"执行语句失败:"<<select<<endl<<"错误:"<<errormsg<<endl;
		return false;
	}

	if(SQLITE_OK != sqlite3_close(conn))
	{
		cout<<"关闭连接失败:"<<endl;
		return false;
	}
	return true;
}

int _tmain(int argc, _TCHAR* argv[])
{
	sqlitedbcreate("student");
	sqlitetablecreate("student","studentname");
	sqlitetableexec("student","insert into studentname([id],[name]) values(1,'liu')");
	sqliteselect("student","select * from studentname");

	system("pause");
	return 0;
}