selenium training in Bangalore (53) - PowerPoint PPT Presentation

About This Presentation
Title:

selenium training in Bangalore (53)

Description:

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 . – PowerPoint PPT presentation

Number of Views:32

less

Transcript and Presenter's Notes

Title: selenium training in Bangalore (53)


1
Using Selenium and Java for Database testing
2
  • As we probably aware each application needs to
    keep up a database to store every one of its
    information. Selenium Webdriver is utilized for
    testing web applications and we perform numerous
    operations like submitting data and a few times
    recovering data and approve them.
  • 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.

3
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.

4
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.

5
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.for
    Name stack the Driver class
  • Inside this Driver class will enlist the driver
    by utilizing static strategy called
    registerDriver().

6
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("jdbcmysql//localhos
    t3306/Employee","root","root")
  • URL contains "jdbc(main protocol)mysql(sub
    convention for mySql)//localhost3306(sub name
    for mysql (hostprot))/Employee(database)" and
    this strategy return sort is Connection Object
    ie., Association
  • conDriverManager.getConnection("jdbcmysql//loca
    lhost3306/Employee","root","root")

7
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()

8
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.

9
  • 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.

10
  • 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.

11
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.

12
  • 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.

13
  • 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 _at_ 9738001024 or visit
    http//infocampus.co.in/best-selenium-testing-trai
    ning-center-in-bangalore.html.

14
(No Transcript)
15
Visit Here.
  • Infocampus Training Institute,
  • 1st 4th Floor, Above HDFC Bank,
  • Near Kalamandir,
  • Outer Ring Road,
  • Marathahalli,
  • Bangalore- 560037
Write a Comment
User Comments (0)
About PowerShow.com