Author - StudySection Post Views - 573 views

Database Testing using Selenium

All the applications need a database to store the data. In databases like MYSQL, SQL Server, and Oracle, Database Testing is performed to test the web application in conjunction with a database to ensure that the changes are reflected at both ends.

To test the database using the selenium we need JDBC (“Java Database Connectivity”). JDBC is a SQL level API that allows us to connect Java with the database and allows us to execute the SQL statements.

Why we need Database testing ?

  1. To ensure that data entered from the UI is consistently reflected in the database.
  2. When a user loads the test data or expected data from the Database.
  3. To ensure that changes updated in the data reflected in the database.

Steps to perform database testing:

  1. create a connection with the database.
  2. Execute the queries.
  3. Disconnect the database.

Code with description:

package databaseTesting;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseTesting {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
//Intialialization of variables
		String url = "jdbc:mysql://";
		String username = "doctor";
		String password = "doctor123";
		//Loading the required MYSQL JDBC Driver class
		//Creating a connection to the database
		Connection conn = DriverManager.getConnection(url, username, password);
		//Executing SQL query and fetching the result
		Statement fetchData = conn.createStatement();

		String excuteComm= "SELECT * FROM Doctor.Patients"; 
        ("SELECT * FROM DatabaseName.Table")			
		ResultSet getResult= fetchData .executeQuery(excuteComm);

		while ( {
			System.out.println("Patient_Id:  " + getResult.getString("Patient_Id"));  
   (Get the Column data)
//disconnect the database

Result Screenshot:

Selenium Testing


Leave a Reply

Your email address will not be published. Required fields are marked * cratosroyalbet betwoon grandpashabet grandpashabet giriş deneme bonusu veren siteler casino siteleri