Package no.ntnu.idatt1002.demo.dao

Class DBConnectionProvider

java.lang.Object
no.ntnu.idatt1002.demo.dao.DBConnectionProvider
public class DBConnectionProvider extends Object
This class provides a connection to the database.

  • Field Details

    • url

      private final String url

    • databaseConnectionProvider

      private static DBConnectionProvider databaseConnectionProvider

    • DB_PATH

      private static String DB_PATH

  • Constructor Details

    • DBConnectionProvider

      public DBConnectionProvider()
      Constructor for the DBConnectionProvider class.

  • Method Details

    • setDbPath

      public static void setDbPath(String dbPath)
      Sets the path to the database. Mainly used for testing purposes.
      Parameters:
      dbPath - the path to the database

    • getConnection

      public Connection getConnection()
      Gets a connection to the database.
      Returns:
      a connection to the database

    • getInstance

      public static DBConnectionProvider getInstance()
      Gets the instance of the DBConnectionProvider.
      Returns:
      the instance of the DBConnectionProvider

    • closeConnection

      public void closeConnection(Connection connection)
      This method closes the connection to the database.
      Parameters:
      connection - the connection to the database

    • closePreparedStatement

      public void closePreparedStatement(PreparedStatement preparedStatement)
      This method closes the PreparedStatement.
      Parameters:
      preparedStatement - the PreparedStatement

    • closeResultSet

      public void closeResultSet(ResultSet resultSet)
      This method closes the ResultSet.
      Parameters:
      resultSet - the ResultSet