Database Testing: Establish JDBC – MySql

In this post, we’ll learn how to establish Java Database Connectivity in order to automate selenium tests where user needs to verify UI values with db values.

I’m assuming you already have MySql db set up locally.

Step 1: Add MySql dependency in pom.xml (MAVEN)

Step 2: Create JDBC Utility Java Class

Step 3: Open connection to MySql

Class.forName(“com.mysql.cj.jdbc.Driver”); Connection con = DriverManager.getConnection(dbUrl, user, pass);

In case, you do not remember db credentials, please redirect here.

Step 4: Create Statement

Statement statement = con.createStatement();

Step 5: Execute Query

statement.executeQuery(query);

Step 6: Close connection to MySql

con.close();