---

Making a JDBC network connection to the SQL server

---

• Making the network connection to the MySQL DBMS server
  • Fact:

    After loading the JDBC communication driver software into a Java program, we can now start communicating with the database server (running on some computer) over an Internet connection

    ---

    ---

  • Establishing a network connection to a database server:

    The network connection is established by using: The (class) method getConnection in the DriverManager class

    ---

  • Syntax:

    Connection SQLconnection; SQLconnection = DriverManager.getConnection ( URL, USER, PASSWD ); Parameters: URL = location of the (MySQL) database server USER = userid (e.g., "cs377") PASSWD = password (e.g., "12345")

    Note:

    The DriverManager.getConnection() method will: Make a network TCP connection to the mySQL server at URL as the user USER and password PASSWD

  ---

  ---

  ---

  ---

• Connection parameters for holland.mathcs.emory.edu
  • Use the following parameters when you make a connection to holland.mathcs.emory.edu:

    URL = "jdbc:mysql://holland.mathcs.emory.edu:3306/DatabaseName"         USER = cs377 PASSWD = abc123

  ---

  ---

  ---

  ---

• Summary

  • How to make a network connection to the MySQL server running on holland.mathcs.emory.edu:

    Connection SQLconnection; SQLconnection = DriverManager.getConnection ( "jdbc:mysql://holland.mathcs.emory.edu:3306/companyDB", "cs377", "abc123");

    ---

    ---

  • What is achieved by the DriverManager.getConnection( ... ) call:

    Before the Java program executes the DriverManager.getConnection( ... ) statement: After the Java program executes the DriverManager.getConnection( ... ) statement:

    ---

    ---

    ---

  • Note:

    You only need to connect to the SQL server once for the entire execution of the Java program: After you have made the JDBC connection to the SQL server, you can execute any number of SQL queries.