---

Compiling and running JDBC programs

---

• The JDBC library
  • Recall:

    A JDBC program (that access the MySQL database) uses methods in the java.sql package (a.k.a the JDBC library)

    ---

  • Fact:

    The JDBC library (i.e., the methods in java.sql.* package must be downloaded and stored somewhere in a user directory You must tell the Java compiler where to find the JDBC library !!!

  ---

  ---

  ---

  ---

• The MySQL JDBC library
  • The MySQL JDBC library is called Connector/J: click here

    ---

  • The MySQL JDBC library is stored in the com.mysql.jdbc.Driver Java package

    ---

  • I have downloaded a copy and stored it in:

    /home/cs377001/lib/mysql-connector-java.jar

  ---

  ---

  ---

  ---

• How to include the MySQL JDBC library in your Java program
  • In order to include the mySQL library in your Java program:

    You must tell the Java compiler where to find the mySQL JDBC library

    ---

    ---

  • Command used to compile your JDBC program in CS377:

    javac -cp ".:/home/cs377001/lib/mysql-connector-java.jar" Prog.java (The mySQL JDBC library is stored in this Java Archive file)

  • Command used to run your JDBC program in CS377:

    java -cp ".:/home/cs377001/lib/mysql-connector-java.jar" Prog (The mySQL JDBC library is stored in this Java Archive file)