Read From a Database

From Progzoo
Jump to navigation Jump to search
Connection parameters
valuedescription 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]