Read From a Database

From Progzoo

Connection parameters
valuedescription
127.0.0.1 the IP address database server;
gisq the name of the database;
scott user name;
tiger the password;

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 bbc table. The columns are name region area population and gdp.

  • 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.


[Font] [Default] [Show] [Resize] [History] [Profile]