Why use Drivermanager for connection to bank?

Question

I am connecting to the Sqlite database with the following code:

public SQLiteConnection conn() throws SQLException{
        String path = System.getProperty("user.dir");
      try {
       return new SQLiteConnection(path, "DadosPastas.s3db");
    } catch (Exception e) {
        return null;
    }
}

But I have observed several examples as follows:

 import java.sql.*;

 public class SQLiteJDBC {
 public static void main( String args[] ) {
  Connection c = null;

  try {
     Class.forName("org.sqlite.JDBC");
     c = DriverManager.getConnection("jdbc:sqlite:test.db");
  } catch ( Exception e ) {
     System.err.println( e.getClass().getName() + ": " + e.getMessage() );
     System.exit(0);
  }
  System.out.println("Opened database successfully");
 }
}

I’ve already researched and I haven’t found the answer to, why use the DriverManager as in the example above.

So why use the DriverManager in that way specifically?

EDIT

Link to the question: Difference between using Sqliteconnection and Java Drivermanager

Answer 1

Between the various interfaces of the package java.sql, referring to JDBC, there is the interface Connection defining methods for executing a query, commit transaction and close connection, among other resources. To work such as Mysql, it is necessary to use concrete classes that implement these package interfaces java.sql.

This set of concrete classes will bridge the gap between the client code that uses the JDBC API and the database. These are the classes that know how to communicate through the proprietary protocol of the database. This set of classes is named after driver.

When in fact you want to open a connection to a database, it is necessary to always use a driver. The class DriverManager is responsible for communicating with all drivers which is left available. For this, the static method is invoked getConnection with a string which indicates which bank you want to connect to. How you asked the question:

c = DriverManager.getConnection("jdbc:sqlite:test.db");

The method has three overloads:

public static Connection getConnection(String url)
public static Connection getConnection(String url, Properties info)
public static Connection getConnection(String url, String user, String password)

References

• Databases and JDBC
• Connection class in Java