示例#1
0
int main()
{
	cout << "Connecting to database..." << endl;
	ActiveRecordManager::GetInstance()->Initialize( "host=localhost;user=root;password=123456;db=test_ar" );
	ActiveRecordManager::GetInstance()->AddTable<Account>();
	ActiveRecordManager::GetInstance()->AddTable<Player>();

	cout << "Updating database schemas..." << endl;
	try
	{
		ActiveRecordManager::GetInstance()->UpdateTableSchemas();
	}
	catch( const Exception & e )
	{
		cout << e.displayText() << endl;
	}
	cout << "Update completed." << endl;

	Account account;
	account.Username = "******";
	account.Password = "******";
	
	account.Save();

	vector<AccountPtr> result;
	Account::FindAll( result, DbField( &Account::Id ) >= 20 && DbField( &Account::Id ) < 25, DbOrderBy<Account>( &Account::Username ), 2 );

	for( vector<AccountPtr>::const_iterator it = result.begin(); it != result.end(); ++it )
	{
		AccountPtr account = *it;
		cout << account->ToString() << endl;
	}

	system( "PAUSE" );
	return 0;
}