import de.bezier.data.sql.*;

// Based on example 1:
// created 2005-05-10 by fjenett
// updated fjenett 20081129


MySQL msql;


void setup()
{
    size( 100, 100 );
	
    String user     = "mat259";
    String pass     = "V1sual1zat1on";
	
    // name of the database to use
    String database = "spl_years";
    // if needed add additional parameters like this:
    // bildwelt?useUnicode=true&characterEncoding=UTF-8
	
    // connect to database of server tango
    //
    msql = new MySQL( this, "tango.mat.ucsb.edu", database, user, pass );
    
    if ( msql.connect() )
    {
        msql.query( "SELECT COUNT(*) FROM transactions2010" );
        msql.next();
        println( "number of transactions: " + msql.getInt(1) );
        // You should get -->  10347528

    }
    else
    {
         println( "Conection Failed!! ");
    }
}

void draw()
{
    
}