SQL from Java

From SQLZoo
Jump to navigation Jump to search

You can connect to an SQL engine using JDBC. You will need to obtain a JDBC driver from the appropriate database.

  • The example given is based on the MySQL JDBC Connector/J which may be found at MySQL
  • Extract the MySQL Connector/J into a directory C:\thingies. (If you know what you are doing you will put this in your classpath.)
  • The program connects to mysql server running on my computer - the user name and password is valid - you may use it too.
  • More examples at http://progzoo.net/wiki/Read_From_a_Database

You need to compile and execute the java from the command prompt:

javac CIA.java
java -classpath "C:/thingies/mysql-connector-java-2.0.14;." 
/* CIA.java
   From http://sqlzoo.net By Andrew Cumming
import java.sql.*;
public class CIA{
  public static void main(String[] args){
    Connection myCon;
    Statement myStmt;
      // Connect to an instance of mysql with the follow details:
      // machine address: pc236nt.napier.ac.uk
      // database       : gisq
      // user name      : scott
      // password       : tiger
      myCon = DriverManager.getConnection(
      myStmt = myCon.createStatement();
      ResultSet result = myStmt.executeQuery(
         "SELECT * FROM cia WHERE population>200000000");
      while (result.next()){
    catch (Exception sqlEx){

It should respond with the names of four countries.