Read From a Database
Revision as of 17:29, 19 June 2009 by Andr3w
|127.0.0.1||the IP address database server;|
|gisq||the name of the database;|
Read the name and population for each country with a population of more than 200000000.
The SQL statement is:
SELECT name, population FROM bbc WHERE population>200000000
You can access columns from the
The columns are
- You use the driver com.mysql.jdbc.Driver - this is available from MySQL
- You can connect to any database that supplies a jdbc or an odbc driver.