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 MongoDB db set up locally and created a database with collection JSON.
Step 1: Add MongoDB dependency in pom.xml (MAVEN)
Step 2: Create JDBC Utility Java Class.
Step 3: Open connection to MongoDB:
MongoClient mongoClient = new MongoClient(“localhost”, 27017);
Step 4: Get DataBase to be used for operations:
mongoClient.getDatabase(“<database-name>”)
Step 5: Get Collections stored in database:
mongoClient.getDatabase(“<database-name>”).getCollection(“<collection-name>”)
Step 6: Close Connection to MongoDB:
mongoClient.close();