Connect to DataBase in Java and Selenium Implementation

For initial understanding on database and SQL queries,
refer MySQL Basics

To automate database testing, we will use selenium with java language.

JDBC (Java DataBase Connectivity) is an API (using Java language) to connect and play with database with SQL queries.

DataBase testing

Database testing: validate the front end data with the database.

Let's take an example of a e-commerce application,
user booked a mobile phone by entering phone model, shipping / billing address, and submits, Data stored into database.

Here we need to validate what the user enters data, should save exactly same to the database, then only correct device can be shipped to user.

In real time automation on database testing, user takes test data from external sources (excel or text file), enters detail on web application (then, data stores into database), then compares the external test data with the stored database data.....

Initial setup of MySQL database and it's basic

MySQL is considered to be most popular open source database,

For more information regarding versions and features, please refer http://dev.mysql.com/

Topics

• Download and Install.
• Initial Setup
• Creating database tables
• Adding/updating/deleting data to tables