How to connect Database using JDBC?

There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.

Below are the steps:

Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection

Load and register the driver

For registering the driver we load the driver class using the name forName() method. This method loads the class which is mentioned as parameter.

Class.forName(“com.mysql.jdbc.Driver");
// class.forName load the Driver class

Establishing the Connection:

For establishing connection with database static method called getConnection () is activated which is present in DriverManagerClass it has three arguments of string type URL, username and password.

DriverManager.getConnection (“jdbc:mysql://localhost:3306 Employee”,"root","root");

URL contains JDBC (main protocol): MySQL (sub protocol for mySql)://localhost:3306(sub name for mySql(host:prot)/Employee(database) when this method returns an connection object that is

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Employee","root","root");

Creating statement object

For creating statement object a method is called createStatement() which is called present connection interface.

con.createStatement();

which returns the object with no argument like

Statement st= con.createStatement();

Executing Queries

For executing queries there are different methods in statement interface by retrieving records and updating records. For fetching queries we call method like executeQuery (string qry) by taking string as parameter.

st.executeQuery ("Select * from Employee");

This returns the object as resultset object

Resultset rs= st.executeQuery ("Select * from Employee”);

// once executeQuery() executes the query and stores the records in to ResultSet object.

Close connection

18 Responses

Revathi says:
December 20, 2020 at 12:11 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector.
It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
The steps are Load and register the driver , Establish connection , Creating statement object , Execute the statement ,
Closing the connection
Reply
Swarna says:
December 20, 2020 at 3:05 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Meetu Masih says:
December 20, 2020 at 6:11 am
How to connect Databases using JDBC?
JDBC (Java Database Connectivity) is the Java API that manages connecting to a database, issuing queries and commands, and handling result sets obtained from the database.
There are steps for database connectivity. Before proceeding, you need to have a MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Uma says:
December 22, 2020 at 12:41 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Farheen .s. says:
December 22, 2020 at 7:08 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Tara Shaju says:
December 22, 2020 at 10:11 am
For connectivity of database we need to have
– MySQL connector.: It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Steps for database connectivity:
1. Load and register the driver
2. Establish connection
3. Creating statement object
4. Execute the statement
5. Closing the connection
Reply
Jacintha Xavier says:
December 22, 2020 at 9:35 pm
There are steps for connectivity of database.You need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
vasukisathish says:
December 24, 2020 at 5:35 am
Here are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Sona Chandrasekar says:
March 14, 2021 at 12:08 am
How to connect Database using JDBC?
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
1. Load and register the driver
2. Establish connection
3. Creating statement object
4. Execute the statement
5. Closing the connection
1. Load and register the driver
For registering the driver we load the driver class using the name forName() method. This method loads the class which is mentioned as parameter.
1.Establishing the Connection:
2. Creating statement object
3. Executing Queries
Reply
Krishna Patel says:
March 16, 2021 at 1:49 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
1. Load and register the driver
2. Establish connection
3. Creating statement object
4. Execute the statement
5. Closing the connection
Reply
Janakba Rathod says:
March 16, 2021 at 10:32 pm
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
1. Load and register the driver
2. Establish connection
3. Creating statement object
4. Execute the statement
5. Closing the connection
Reply
Nicole Reed says:
March 17, 2021 at 11:23 pm
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Reply
Vaishaly Sharma says:
July 19, 2022 at 6:57 am
How to connect Database using JDBC?
There are steps for the connectivity of the database. Before proceeding, you need to have a MySQL connector. It can be downloaded from the Download MySQL connector Jar and add it as a build path by adding the Selenium web driver jar.
Below are the steps:
> Load and register the driver
> Establish connection
> Creating statement object
> Execute the statement
> Closing the connection
Reply
Rajveer says:
July 19, 2022 at 10:29 pm
How to connect Database using JDBC?
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
1. Load and register the driver
2. Establish connection
3. Creating statement object
4. Execute the statement
5. Closing the connection
Load and register the driver
For registering the driver we load the driver class using the name forName() method. This method loads the class which is mentioned as parameter.
Class.forName(“com.mysql.jdbc.Driver”);
//class.forName load the Driver class
Establishing the Connection:
For establishing connection with database static method called getConnection () is activated which is present in DriverManagerClass it has three arguments of string type URL, username and password.
DriverManager.getConnection (“jdbc:mysql://localhost:3306 Employee”,”root”,”root”);
URL contains JDBC (main protocol): MySQL (sub protocol for mySql)://localhost:3306(sub name for mySql(host:prot)/Employee(database) when this method returns an connection object that is
Connection
con=DriverManger.getConnection(“jdbc:mysql://localhost:3306/Employee”,”root”,”root”);
Creating statement object
For creating statement object a method is called createStatement() which is called present connection interface.
Con.createSatatement();
which returns the object with no argument like
Statement st=con.createStatement();
Executing Queries
For executing queries there are different methods in statement interface by retrieving records and updating records. For fetching queries we call method like executeQuery (string qry) by taking string as parameter.
st.executeQuery (Select*from Emplyee”);
This returns the object as resultset object
Resultset rs=st.executeQuery(“Select*from Employee”);
// once executeQuery() executes the query and stores the records in to ResultSet object.
Close connection
Reply
chaitanya says:
July 20, 2022 at 7:20 am
There are steps for connectivity of database. MySQL connector needs to be installed. The steps are: load and register the driver, establish connection, creating statement object, execute the statement and closing the connection.
Reply
Monika Joshi says:
July 21, 2022 at 3:11 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
The steps are listed below:
Load and register the driver
Establish connection
Creating statement object
Execute the statement
Closing the connection
Load and register the driver
For registering the driver we load the driver class using the name forName() method. This method loads the class which is mentioned as parameter.
Reply
Jia Nie says:
July 22, 2022 at 2:12 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
* Load and register the driver
* Establish connection
* Creating statement object
* Execute the statement
* Closing the connection
Reply
Sowmya says:
July 22, 2022 at 2:54 am
There are steps for connectivity of database. Before proceeding, you need to have MySQL connector. It can be downloaded from Download MySQL connector Jar and add it as a build path by adding Selenium web driver jar.
Below are the steps:
1.Load and register the driver
2.Establish connection
3.Creating statement object
4.Execute the statement
5.Closing the connection
Reply