Function main

lib_acl_cpp/samples/sqlite/sqlite.cpp:228–317

};

int main(void)
{
	acl::acl_cpp_init();
	acl::log::stdout_open(true);

	acl::stdin_stream in;
	acl::stdout_stream out;
	acl::string line;

#if	defined(_WIN32) || defined(_WIN64)
	const char* libname = "sqlite3.dll";
#else
	const char* libname = "libsqlite3.so";
#endif

	acl::string path;
	out.format("Enter %s load path: ", libname);
	if (in.gets(line) && !line.empty())
#if     defined(_WIN32) || defined(_WIN64)
		path.format("%s\\%s", line.c_str(), libname);
#else
		path.format("%s/%s", line.c_str(), libname);
#endif
	else
		path = libname;

	out.format("%s path: %s\r\n", libname, path.c_str());
	// ���ö�̬����ص�ȫ·��
	acl::db_handle::set_loadpath(path);

	//acl::string dbfile("�������ݿ�.db");
	acl::string dbfile("./path1/path2/mydb.db");

	// db_sqlite �������������� set_loadpath ֮����Ϊ�� db_sqlite ��
	// ���캯������Ҫ���м��� libsqlite3.so
	acl::db_sqlite db(dbfile, "gbk");

	if (db.open() == false)
	{
		printf("open dbfile: %s error\r\n", dbfile.c_str());
		getchar();
		return 1;
	}

	printf("open dbfile %s ok\r\n", dbfile.c_str());

	if (tbl_create(db) == false)
	{
		printf("create table error\r\n");
		getchar();
		return 1;
	}

	// �������ݿ�����
	db.set_conf("PRAGMA synchronous = off");
	db.set_conf("PRAGMA encoding = \"UTF-8\"");
	acl::string buf;
	if ((db.get_conf("PRAGMA encoding", buf)))