main.c

利用C语言实现的人工智能系统

/*
*	SQLITE3_RESET
*/

#include <stdio.h>
#include "sqlite3.h"

int main(int argc, char **argv)
{
	sqlite3 *dbo;
	sqlite3_stmt *stmt;
	const char *object_id;
	int return_code;
	int i=0;
	char *sql;
	
	return_code = sqlite3_open_v2("../data/aab048a5ae57435f88d0409ccf85e59d.db", &dbo, SQLITE_OPEN_READONLY, NULL);
	
	sql = "SELECT * FROM Objects ORDER BY ID ASC;";
	return_code = sqlite3_prepare_v2(dbo, sql, strlen(sql), &stmt, NULL);
	
	return_code = sqlite3_step(stmt);
	while(return_code == SQLITE_ROW) 
	{
        	object_id = (const char *)sqlite3_column_text(stmt, 0);
		printf("%s\n", object_id);
		
		return_code = sqlite3_step(stmt);
	}
	
	printf("\t%d (SQLITE_DONE=101)\n", return_code);
	
	for (i=0; i<3; i++)
	{
		sqlite3_reset(stmt);
		
		return_code = sqlite3_step(stmt);
		while(return_code == SQLITE_ROW) 
		{
			object_id = (const char *)sqlite3_column_text(stmt, 0);
			printf("\t%s\n", object_id);
			
			return_code = sqlite3_step(stmt);
			printf("\t%d\n", return_code);
		}
	}
	return_code = sqlite3_finalize(stmt);
	return_code = sqlite3_close(dbo);
	
	return 0;
}