123ArticleOnline Logo
Welcome to 123ArticleOnline.com!

ALL >> Computer-Programming >> View Article

Using Selenium And Java For Database Testing

By Author: Siyaram Ray
Total Articles: 152

In selenium contents, when there is a need of getting the Data from the database we may need to utilize APIs which communicates with database like JDBC. Java Database Connectivity (JDBC) is a Java API which is utilized to associate and collaborate with Database.
For what reason do we utilize JDBC rather ODBC?
ODBC is produced and written in C, which is stage Independent. Whereas JDBC API is a detail gives set of interfaces which are composed and created in Java programming dialect.
How to connect to database utilizing JDBC?
The beneath are the Steps to Connect to database, before continuing, you need MySQL Connector. You can download from here Download MySQL Connector Jar and include it the construct way as we include selenium webdriver jar.
• Load and Registering the Driver
• Setting up Connection.
• Making Statement Object
• Execute the Statement
• Shutting the association.
1. Load and Register the Driver:
For enrolling the Driver we Load the Driver class utilizing forName() strategy. forName() is the static manufacturing plant strategy which is available in predefined class called "Class". This strategy stacks the class which is specified as parameter.
Class.forName("com.mysql.jdbc.Driver");//class.forName stack the Driver class
Inside this Driver class will enlist the driver by utilizing static strategy called registerDriver().
2. Building up Connection:
For building up association with database we call static strategy called getConnection(...) introduce in DriverManager Class. This technique contains three contentions of string sort. i.e., url, username and secret key
DriverManager.getConnection("jdbc:mysql://localhost:3306/Employee","root","root");
URL contains "jdbc(main protocol):mysql(sub convention for mySql)://localhost:3306(sub name for mysql (host:prot))/Employee(database)" and this strategy return sort is Connection Object ie., Association
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Employee","root","root");
3. Making Statement Object:
For making articulation question we have to call a strategy called createStatement() which is available in Connection Interface.
con.createStatement();
What's more, this strategy returns Statement question and it is no contention technique.
statement st= con.createStatement();
4.Executing Queries:
For executing inquiries there are distinctive techniques exhibit in Statement Interface for recovering records and for refreshing records.
Recovering records:
for executing select queries(for bringing records) we call a strategy called executeQuery(String qry) by taking string as parameter.
st.executeQuery("Select * from Employee");
This strategy returns ResultSet protest.
Resultset rs= st.executeQuery("Select * from Employee");//once executeQuery() executes the inquiry and stores the records in to ResultSet question.
Presently we have to get the records from ResultSet question. To get to the resultset protest it utilizes a strategy called next() which displays in ResultSet Interface.
Naturally Resultset reference 'rs' focuses to before first column. it moves rs to next line and returns genuine. When it returns genuine we recover the information in first column. next() returns false when rs focuses to after the last column. this next() will rehashes the execution utilizing while circle till it returns false.
Refreshing records:
To refresh records in a table we utilize a technique called executeUpdate(String str) which returns whole number an incentive as what number of records have been refreshed.
5. Shutting the Connection:
When execution of all announcements were finished we have to close every one of the associations by utilizing strategy called close() show in Connection interface
There are fundamentally two things that we should need to test to confirm database with Selenium.
To begin with, in the wake of making any activity in the web application (Front-end), we might need to check the database if every one of the subtle elements we submitted are put away effectively. Presently for instance, while making a record, we will enter a few information email Id, username and so forth. To ensure a record is made, we can check record made in database with every one of the subtle elements client gave.
Other case can resemble, subsequent to playing out any activity, we might need to check the information showed in the UI is right by looking at the Database.
About Author:
An excellence institute for selenium training in Bangalore is Infocampus. It is a step for freshers and experienced people to get a job in testing. Infocampus is going to start a new batch regarding Selenium training. For those who are interested, please visit Institute on any day and Refer to your friends, who want to build their careers in the field of software testing. For more information please contact: Infocampus training Institute @ 9738001024 or visit http://infocampus.co.in/best-selenium-testing-training-center-in-bangalore.html.

Total Views: 11Word Count: 703See All articles From Author

Computer Programming Articles

1. Selenium Testing Strategy – Automation Testing Tool
Author: Siyaram Ray

2. Open Source Tools For Java Deployment
Author: Infocampus

3. Single Versus Multi-tenant Saas – Which Is Best?
Author: namitaghate

4. A Popular Automation Testing Tool - Selenium
Author: Siyaram Ray

5. Disc Publishing Media - Time For Entertainment Anytime And Anywhere
Author: Lingan

6. Step By Step Guidelines To Succeed With Selenium - Automation Testing Tool
Author: Siyaram Ray

7. Automation Testing Tool - Selenium Architecture With Webdriver Features
Author: Siyaram Ray

8. Top 6 Patterns You Will See In 2018 Website Architecture
Author: Infocampus Logics Pvt Ltd

9. Ms Access Database Images: How To Correctly Handle Them ?
Author: Ben Beitler

10. How Android App Development Are Beneficial For Business
Author: Meer Sayed

11. Know Why Selenium Is Popular And Features Of Selenium Webdriver
Author: Siyaram Ray

12. 8 Great Applications Of “machine Learning”
Author: Sana Mulla

13. How To Learn Machine Learning From Scratch?
Author: Sana Mulla

14. Machine Learning “hello World” Using Python
Author: Sana Mulla

15. Logistics App Development: The Tech Behind
Author: Recrosoft Technologies

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: