How do I create a database connection?

Lennart Jorelid

The database connection is created in 3 steps:

  1. Find a proper database URL (see FAQ on JDBC URL)
  2. Load the database driver
  3. Ask the Java DriverManager class to open a connection to your database

In java code, the steps are realized in code as follows:

  1. Create a properly formatted JDBR URL for your database. (See FAQ on JDBC URL for more information). A JDBC URL has the form jdbc:someSubProtocol://myDatabaseServer/theDatabaseName
  2.   try {
         Class.forName("my.database.driver");
         }
         catch(Exception ex)
         {
            System.err.println("Could not load database driver: " + ex);
         }
         
  3.     Connection conn = DriverManager.getConnection("a.JDBC.URL", "databaseLogin", "databasePassword");
        
0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact