Home » Software Testing » Automation Testing » Selenium WebDriver Tutorial » Getting started with Java Database Connectivity (JDBC)

Getting started with Java Database Connectivity (JDBC)

Many a times in testing, we face a situation where we need to test the data into database. Database testing usually includes verifying the field length validation, checking the soft delete of a record, checking the business logic i.e. whether the data is correctly getting manipulated on the basis of the business rules etc. Well before we actually dig deep into the concept of database testing. let’s kick start with a Java API which is commonly used to interact with data sources.




When testing database using Selenium, we connect our JAVA program to Database via JDBC (Java Database Connectivity). We can easily perform CRUD (Create/Read/Update/Remove) operations on Database with the help of JDBC. Basically we perform 3 activities with the help of JDBC as below:

  1. Get Connection to Database.
  2. Execute CRUD queries on the database.
  3. Get ResultSet as result of query after executing the query to database.

Now let’s try a very basic read operation with database. First we will try on command line then we will try with Java Program.

Command Line: I hope you have installed MySQL. If you haven’t installed MySQL, then first install MySQL.My SQL can be easily downloaded from http://dev.mysql.com/downloads/ .

Let’s connect to MySQL server and type “show databases;” to see databases list. Then type “use test;” to select test database. And type “show tables;” to list down all the tables available in test database.

Now let’s see with the help of following example how this works does. Following is a sample database and table it consists of:

Database_Table

 

The test database consists of a ‘users’ table only. Type select * from users, this will list down all user data. ‘users’ table basically consists of following 3 columns:

  1. Name
  2. City
  3. Sex

It basically has two records:

Database_Records




Java Program:The first and foremost thing to remember while working with JDBC is that, there are different set of connectors for connecting to different databases. These connectors are available as jars and they need to be imported to your project library before starting. Since we are working with MySQL, so therefore we have used MySQL  connector jar. The one which I have imported to my project is “mysql-connector-java-5.0.8-bin.jar”.

Now, let us have a look at the basic steps that are required for the JDBC connectivity:

JDBC_Connectivity_Steps_abodeqa

The output of the above code is:
Krishna
Ram
In the next blog we will learn more about various classes in JDBC API, till then Happy Learning!

2 thoughts on “Getting started with Java Database Connectivity (JDBC)”

  1. Acolyte framework can be used to mock up JDBC result: return some result set when query is executed on test connection, have row count for update statement.

    It doesn’t require separate test DB or to manage complexity of fixtures management (cleanup, reload, …).

    This way, each test are fully isolated with a specific test connection described for each one, with just what they required in JDBC to be validated (keep it simple).

    It open source, work with any JVM based project. Interactive demo at http://tour.acolyte.eu.org .

  2. Dear Admin,

    Nice topic. Very useful. But am getting error like “com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘ DB name . Table Name’ doesn’t exist.

    Kindly assit Please help. ASAP

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: