Florian Jenett
58 linhas
1.3 KiB
Plaintext
58 linhas
1.3 KiB
Plaintext
// updated fjenett 20081129
|
|
|
|
import de.bezier.data.sql.*;
|
|
|
|
|
|
PostgreSQL pgsql;
|
|
|
|
|
|
void setup()
|
|
{
|
|
size( 100, 100 );
|
|
|
|
// this example assumes that you are running the
|
|
// postgresql server locally (on "localhost").
|
|
//
|
|
|
|
// replace with your own postgresql-account.
|
|
//
|
|
String user = "fjenett";
|
|
String pass = "fjenett";
|
|
|
|
// name of the database to use
|
|
//
|
|
String database = "test";
|
|
|
|
// connect to database on "localhost"
|
|
//
|
|
pgsql = new PostgreSQL( this, "localhost", database, user, pass );
|
|
|
|
// connected?
|
|
if ( pgsql.connect() )
|
|
{
|
|
// query the number of entries in table "weather"
|
|
pgsql.query( "SELECT COUNT(*) FROM weather" );
|
|
|
|
// results found?
|
|
if ( pgsql.next() )
|
|
{
|
|
// nice, then let's report them back
|
|
println( "number of rows in table weather: " + pgsql.getInt(1) );
|
|
}
|
|
|
|
// now let's query for last 10 entries in "weather"
|
|
pgsql.query( "SELECT * FROM weather LIMIT 10" );
|
|
|
|
// anything found?
|
|
while( pgsql.next() )
|
|
{
|
|
// splendid, here's what we've found ..
|
|
println( pgsql.getString("city") );
|
|
}
|
|
}
|
|
else
|
|
{
|
|
// yay, connection failed !
|
|
}
|
|
}
|