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