Method exec_sql

lib_acl_cpp/src/db/db_sqlite.cpp:821–859

}

bool db_sqlite::exec_sql(const char* sql, db_rows* result /* = NULL */)
{
	// ���뽫�ϴεIJ�ѯ���ɾ��
	free_result();

	if (sql == NULL || *sql == 0) {
		logger_error("invalid params");
		return false;
	} else if (db_ == NULL) {
		logger_error("db not open yet!");
		return false;
	}

	char** results = NULL, *err;
	int    nrow, ncolumn;

	// ִ�� sqlite �IJ�ѯ����
	int   ret = __sqlite3_get_table(db_, sql, &results, &nrow, &ncolumn, &err);
	if (ret != SQLITE_OK) {
		logger_error("sqlites_get_table(%s) error(%s)",
			sql, __sqlite3_errmsg(db_));
		__sqlite3_free_table(results);
		return false;
	}

	if (nrow > 0) {
		if (result != NULL) {
			sqlite_rows_save(results, nrow, ncolumn, *result);
		} else {
			result_ = NEW db_rows();
			sqlite_rows_save(results, nrow, ncolumn, *result_);
		}
	} else if (results) {
		result_ = NULL;
		__sqlite3_free_table(results);
	}

	return true;
}

int db_sqlite::affect_count(void) const
{