{"id":3427,"date":"2015-05-14T20:50:39","date_gmt":"2015-05-15T04:50:39","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=3427"},"modified":"2024-05-09T00:29:38","modified_gmt":"2024-05-09T07:29:38","slug":"connecting-to-mysql-using-jdbc-driver","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-jdbc-tutorial\/connecting-to-mysql-using-jdbc-driver\/","title":{"rendered":"Connecting to MySQL Using JDBC Driver"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to connect to the MySQL database using the JDBC Connection object.<\/p>\n\n\n\n

This tutorial picks up where the Setting Up MySQL JDBC Development Environment<\/a> tutorial left off.<\/p>\n\n\n\n

Creating a new project<\/h2>\n\n\n\n

First, launch the IntelliJ IDE.<\/p>\n\n\n\n

Second, create a new project called mysql-jdbc<\/strong>.<\/p>\n\n\n\n

Third, right-click the project name and choose the Open Module Settings<\/strong>.<\/p>\n\n\n\n

Fourth, choose the Libraries<\/strong> under Project Settings <\/strong>and click New Project Library<\/strong>.<\/p>\n\n\n\n

Fifth, select the mysql connector file such as D:\\mysql-drivers\\mysql-connector-j-8.2.0\\mysql-connector-j-8.2.0.jar<\/strong> and click OK.<\/p>\n\n\n\n

Creating a database configuration file<\/h2>\n\n\n\n

First, create a new file called configure.properties<\/code> file in the src<\/code> directory of the project.<\/p>\n\n\n\n

Second, add the following database configuration to the configure.properties<\/code> file:<\/p>\n\n\n

db.url<\/span>=jdbc:mysql:\/\/localhost:3306\/mysqljdbc<\/span>\ndb.username<\/span>=<user><\/span>\ndb.password<\/span>=<password><\/span><\/code><\/span>Code language:<\/span> Properties<\/span> (<\/span>properties<\/span>)<\/span><\/small><\/pre>\n\n\n
In this config.properties<\/code>, we specify three important pieces of information:<\/p>\n\n\n\n
    \n
  • db.url<\/code>: The URL to the MySQL server. In this example, we connect to the local MySQL server and port 3306, database mysqljdbc<\/code>.<\/li>\n\n\n\n
  • db.user<\/code>: The user account that connects to the database.<\/li>\n\n\n\n
  • db.password<\/code>: The password for the user.<\/li>\n<\/ul>\n\n\n\n
    Note that you need to replace the user and password with the one that you use to connect to the MySQL server.<\/p>\n\n\n\n
    Defining a DatabaseConfig class<\/h2>\n\n\n\n
    First, create a new file in the src<\/code> directory called DatabaseConfig.java<\/code>.<\/p>\n\n\n\n
    Second, define the class DatabaseConfig<\/code> in the DatabaseConfig.java<\/code> file:<\/p>\n\n\n
    import<\/span> java.io.IOException;\nimport<\/span> java.io.InputStream;\nimport<\/span> java.util.Properties;\n\npublic<\/span> class<\/span> DatabaseConfig<\/span> <\/span>{\n\n    private<\/span> static<\/span> final<\/span> Properties properties = new<\/span> Properties();\n\n    static<\/span> {\n        try<\/span> (InputStream input = DatabaseConfig.class<\/span>.getClassLoader<\/span>().getResourceAsStream<\/span>(\"config<\/span>.properties<\/span>\")) <\/span>{\n            if<\/span> (input == null<\/span>) {\n                System.out.println(\"Sorry, unable to find config.properties\"<\/span>);\n                System.exit(1<\/span>);\n            }\n\n            \/\/ Load the properties file<\/span>\n            properties.load(input);\n        } catch<\/span> (IOException e) {\n            e.printStackTrace();\n        }\n    }\n\n    public<\/span> static<\/span> String getDbUrl<\/span>()<\/span> <\/span>{\n        return<\/span> properties.getProperty(\"db.url\"<\/span>);\n    }\n\n    public<\/span> static<\/span> String getDbUsername<\/span>()<\/span> <\/span>{\n        return<\/span> properties.getProperty(\"db.username\"<\/span>);\n    }\n\n    public<\/span> static<\/span> String getDbPassword<\/span>()<\/span> <\/span>{\n        return<\/span> properties.getProperty(\"db.password\"<\/span>);\n    }\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    The DatabaseConfig<\/code> class reads the database configuration from the config.properties<\/code> file. <\/p>\n\n\n\n
    The DatabaseConfig<\/code> has three static methods that expose the database configuration:<\/p>\n\n\n\n
      \n
    • getDbUrl()<\/code> – Return the database URL.<\/li>\n\n\n\n
    • getDbUsername()<\/code> – Return the database username<\/li>\n\n\n\n
    • getDbPassword()<\/code> – Return the database password.<\/li>\n<\/ul>\n\n\n\n
      Creating a MySQLConnection class<\/h2>\n\n\n\n
      Create a new file named MySQLConnection.java<\/code> file in the src<\/code> directory and define the MySQLConnection<\/code> class:<\/p>\n\n\n
      import<\/span> java.sql.Connection;\nimport<\/span> java.sql.DriverManager;\nimport<\/span> java.sql.SQLException;\n\n\npublic<\/span> class<\/span> MySQLConnection<\/span> <\/span>{\n    public<\/span> static<\/span> Connection connect<\/span>()<\/span> throws<\/span> SQLException <\/span>{\n\n        try<\/span> {\n            \/\/ Register JDBC driver<\/span>\n            Class.forName(\"com.mysql.cj.jdbc.Driver\"<\/span>);\n\n            \/\/ Get database credentials from DatabaseConfig class<\/span>\n            var<\/span> jdbcUrl = DatabaseConfig.getDbUrl();\n            var<\/span> user = DatabaseConfig.getDbUsername();\n            var<\/span> password = DatabaseConfig.getDbPassword();\n\n            \/\/ Open a connection<\/span>\n            return<\/span> DriverManager.getConnection(jdbcUrl, user, password);\n\n        } catch<\/span> (SQLException | ClassNotFoundException e) {\n            System.err.println(e.getMessage());\n            return<\/span> null<\/span>;\n        }\n    }\n}\n<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
      Creating a Java Program<\/h2>\n\n\n\n
      The following defines the Main<\/code> class that uses the MySQLConnection<\/code> class to connect to the MySQL database:<\/p>\n\n\n
      import<\/span> java.sql.SQLException;\n\npublic<\/span> class<\/span> Main<\/span> <\/span>{\n    public<\/span> static<\/span> void<\/span> main<\/span>(String[] args)<\/span><\/span>{\n        try<\/span> (var<\/span> connection =  MySQLConnection.connect()){\n            System.out.println(\"Connected to the MySQL database.\"<\/span>);\n        } catch<\/span> (SQLException e) {\n            System.err.println(e.getMessage());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
      The program connects to a MySQL database using the MySQLConnection<\/code> class. <\/p>\n\n\n\n
      If the connection is successful, it prints a success message; otherwise, it catches and displays any SQLException<\/code> that might occur during the connection process. <\/p>\n\n\n\n
      Note that we use the try-with-resources to ensure that the Connection<\/code> is closed properly, even if an exception occurs.<\/p>\n\n\n\n
      The output of the program if it successfully connects to the MySQL server:<\/p>\n\n\n
      Connected to the MySQL database.<\/code><\/span><\/pre>\n\n\n
      Summary<\/h2>\n\n\n\n
        \n
      • Use the Connection<\/code> object to connect to the MySQL database.<\/li>\n<\/ul>\n
        \n\t
        \n\t\t
        Was this tutorial helpful? <\/div>\n\t\t
        \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
        \n\t\t
        \n\t\t\t
        <\/div>\n\t\t\t\n\t\t\t