This method gives back an object of ResultSet which is used to fetch all the records of a relational table. To execute the queries to the database, the executeQuery() method of Statement interface is made use of. The createStatement() is defined as: public Statement createStatement() throws SQLExceptionįor instance, to create a statement object we write: Statement s = c.createStatement() To create a statement, we make use of createStament() method of the Connection interface. The getConnection() method defines 2 varied syntax, they are: public static Connection getConnection(String url)throws SQLException public static Connection getConnection(String url,String name,String password) throws SQLExceptionįor instance, to connect with the MySQL database we write: Connection c = DriverManager.getConnection('jdbc:mysql://localhost:3306/test','root','root') To set up the connection, the getConnection() method of DriverManager class is exploited to connect with the database. The syntax to register a class using forName() method is : public static void forName(String ) throws ClassNotFoundException.įor instance, to load the MySQL driver we write, Class.forName('') The forName() method is exploited to load the driver class and register it. There are 5 basic steps involved to connect any Java application with the database using JDBC. 5 Steps to Connect Java Program with Database Now let us dive into the process of establishing a connection between Java program and database. It handles the direct conversion of JDBC method invocations to vendor-specific database protocols is.Īfter knowing the basic components of Java JDBC and varied kinds of JDBC drivers. It utilizes middleware to convert JDBC calls to vendor-specific calls in whichever way possible. The driver transfers JDBC method invocations into the native function invocations It utilizes client-side libraries to establish a connection with the database.

The JDBC-ODBC bridge driver transfers the JDBC method invocations into the ODBC function invocations. It utilizes an ODBC driver to establish a connection with the database. Software that facilitates java application to relate with the database is known as JDBC Driver. Handles exceptions that arise in the database Seizes the data fetched from the database after the execution of queries

Manages the communications with database serversĪn interface that is used to contact the databaseĪn interface that helps in submitting SQL statements to the database The most familiar and frequently used JDBC components include.

5 Steps to Connect Java Program with Database.

Mysql jdbc url example