{"id":3122,"date":"2020-08-14T04:33:10","date_gmt":"2020-08-14T04:33:10","guid":{"rendered":"https:\/\/studysection.com\/blog\/?p=3122"},"modified":"2020-08-14T06:19:17","modified_gmt":"2020-08-14T06:19:17","slug":"steps-to-connect-a-database-to-selenium-test-cases","status":"publish","type":"post","link":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/","title":{"rendered":"Steps to Connect a Database to Selenium Test Cases"},"content":{"rendered":"

Introduction<\/h2>\n

Every application requires a database like My SQL, Oracle<\/a>, or any other database to store all its data. Selenium Webdriver is used for examining web applications. We can perform many operations like submitting information and some times retrieving information and validate them. Here we will discuss the steps to connect a database to a selenium test case.<\/p>\n

How to connect a database to selenium test cases<\/h3>\n

Here are the following steps to connect your database with selenium:<\/p>\n

    \n
  1. Download MYSQL and create a database<\/li>\n
  2. JDBC connection with Java programming<\/li>\n
  3. Selenium code to integrate with JDBC and retrieving data from the database.<\/li>\n<\/ol>\n

    Step1:<\/strong>
    \nFirstly, download the MYSQL from this link:     https:\/\/dev.mysql.com\/downloads\/windows\/installer\/<\/a> <\/p>\n

    \"sql-installer\"\/<\/p>\n

    After installing the Mysql Workbench and made a connection by filling credentials to create Workbench access. Once we successfully log in to the workbench then we create a database and table to insert the data. <\/p>\n

    Step2:<\/strong><\/p>\n

    In this step, we integrate the database with JDBC API and for that, we need to download the Jar File<\/strong>.We can download this jar file directly from this link: “www.java2s.com\/Code\/Jar\/m\/Downloadmysqlconnectorjava5121jar.htm<\/a>\u201d <\/p>\n

    Then we need to add this Jar file in eclipse.
    \nSteps:<\/strong> project->properties->add external jars.<\/p>\n

    Step3:<\/strong>
    \nMake connection with database from your project with this code:
    \nOn running this whole code we retrieve data from the database and automate our test case which is entering username and password on the web:<\/p>\n


    \nimport java.sql.Connection;<\/p>\n

    import java.sql.DriverManager;<\/p>\n

    import java.sql.SQLException;<\/p>\n

    import java.sql.Connection;<\/p>\n

    import java.sql.DriverManager;<\/p>\n

    import java.sql.ResultSet;<\/p>\n

    import java.sql.SQLException;<\/p>\n

    import java.sql.Statement;<\/p>\n

    import org.openqa.selenium.By;<\/p>\n

    import org.openqa.selenium.WebDriver;<\/p>\n

    import org.openqa.selenium.firefox.FirefoxDriver;<\/p>\n

    public class jdbcconection {<\/p>\n

    public static void main(String[] args) throws SQLException, ClassNotFoundException {<\/p>\n

    \/\/Initialization of variables<\/strong>
    \nString host=\"localhost\";
    \nString port= \"3306\";<\/p>\n

    \/\/Loading the required MYSQL JDBC Driver class<\/strong>
    \nClass.forName(\"com.mysql.jdbc.Driver\");\t<\/p>\n

    \/\/creating connection to a database<\/strong>
    \nConnection con=DriverManager.getConnection(\"jdbc:mysql:\/\/\" + host + \":\" + port + \"\/demo\", \"root\", \"root\");<\/p>\n

    \/\/Executing SQL query and fetching the result<\/strong>
    \nStatement s=con.createStatement();<\/p>\n

    ResultSet rs=s.executeQuery(\"select * from credentials where scenario ='demo'\");
    \nwhile(rs.next())
    \n{
    \nWebDriver driver= new FirefoxDriver();
    \ndriver.get(\"    https:\/\/login.salesforce.com<\/a>\");
    \n\/\/retrieving username and password from database<\/strong>
    \ndriver.findElement(By.xpath(\".\/\/*[@id='username']\")).sendKeys(rs.getString(\"username\"));
    \ndriver.findElement(By.xpath(\".\/\/*[@id='password']\")).sendKeys(rs.getString(\"password\"));<\/p>\n

    }
    \n}
    \n}
    \n<\/code>
    \nNow, This code executes the query and gets the username and password to login to the \u201c    https:\/\/login.salesforce.com<\/a>\u201d account.<\/p>\n

    As we have a username and password in the credential table:<\/p>\n

    \"demo\"\/<\/p>\n

    Result:<\/strong><\/p>\n

    \"salesforce\"\/<\/p>\n

    Being the most extensively used JavaScript library, a jQuery certification<\/a> will add enormous value to your skill-set. jQuery provides various functionalities to the developer in order to develop complex applications with ease and efficiency.<\/em><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium<\/p>\n","protected":false},"author":1,"featured_media":3123,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[149,124],"acf":[],"yoast_head":"\nStudySection Blog - Steps to connect a database to selenium test cases<\/title>\n<meta name=\"description\" content=\"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"StudySection Blog - Steps to connect a database to selenium test cases\" \/>\n<meta property=\"og:description\" content=\"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Posts on famous people, innovations and educational topics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/studysection\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-14T04:33:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-14T06:19:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2020\/08\/steps.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin-studysection-blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@studysection\" \/>\n<meta name=\"twitter:site\" content=\"@studysection\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin-studysection-blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\"},\"author\":{\"name\":\"admin-studysection-blog\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\"},\"headline\":\"Steps to Connect a Database to Selenium Test Cases\",\"datePublished\":\"2020-08-14T04:33:10+00:00\",\"dateModified\":\"2020-08-14T06:19:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\"},\"wordCount\":320,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"keywords\":[\"database\",\"selenium\"],\"articleSection\":[\"Learn and Grow\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\",\"url\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\",\"name\":\"StudySection Blog - Steps to connect a database to selenium test cases\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/#website\"},\"datePublished\":\"2020-08-14T04:33:10+00:00\",\"dateModified\":\"2020-08-14T06:19:17+00:00\",\"description\":\"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.\",\"breadcrumb\":{\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/studysection.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Steps to Connect a Database to Selenium Test Cases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/studysection.com\/blog\/#website\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"name\":\"Blog Posts on famous people, innovations and educational topics\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/studysection.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/studysection.com\/blog\/#organization\",\"name\":\"StudySection\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"contentUrl\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"width\":920,\"height\":440,\"caption\":\"StudySection\"},\"image\":{\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/studysection\",\"https:\/\/twitter.com\/studysection\",\"https:\/\/www.instagram.com\/study.section\/\",\"https:\/\/www.linkedin.com\/company\/studysection\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\",\"name\":\"admin-studysection-blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"caption\":\"admin-studysection-blog\"},\"url\":\"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"StudySection Blog - Steps to connect a database to selenium test cases","description":"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/","og_locale":"en_US","og_type":"article","og_title":"StudySection Blog - Steps to connect a database to selenium test cases","og_description":"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.","og_url":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/","og_site_name":"Blog Posts on famous people, innovations and educational topics","article_publisher":"https:\/\/www.facebook.com\/studysection","article_published_time":"2020-08-14T04:33:10+00:00","article_modified_time":"2020-08-14T06:19:17+00:00","og_image":[{"width":300,"height":200,"url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2020\/08\/steps.png","type":"image\/png"}],"author":"admin-studysection-blog","twitter_card":"summary_large_image","twitter_creator":"@studysection","twitter_site":"@studysection","twitter_misc":{"Written by":"admin-studysection-blog","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#article","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/"},"author":{"name":"admin-studysection-blog","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402"},"headline":"Steps to Connect a Database to Selenium Test Cases","datePublished":"2020-08-14T04:33:10+00:00","dateModified":"2020-08-14T06:19:17+00:00","mainEntityOfPage":{"@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/"},"wordCount":320,"commentCount":0,"publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"keywords":["database","selenium"],"articleSection":["Learn and Grow"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/","url":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/","name":"StudySection Blog - Steps to connect a database to selenium test cases","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/#website"},"datePublished":"2020-08-14T04:33:10+00:00","dateModified":"2020-08-14T06:19:17+00:00","description":"Every application requires a database like My SQL, Oracle, or any other database to store all its data. Selenium is used for examining web.","breadcrumb":{"@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/studysection.com\/blog\/steps-to-connect-a-database-to-selenium-test-cases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/studysection.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Steps to Connect a Database to Selenium Test Cases"}]},{"@type":"WebSite","@id":"https:\/\/studysection.com\/blog\/#website","url":"https:\/\/studysection.com\/blog\/","name":"Blog Posts on famous people, innovations and educational topics","description":"","publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/studysection.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/studysection.com\/blog\/#organization","name":"StudySection","url":"https:\/\/studysection.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","contentUrl":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","width":920,"height":440,"caption":"StudySection"},"image":{"@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/studysection","https:\/\/twitter.com\/studysection","https:\/\/www.instagram.com\/study.section\/","https:\/\/www.linkedin.com\/company\/studysection"]},{"@type":"Person","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402","name":"admin-studysection-blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","caption":"admin-studysection-blog"},"url":"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/"}]}},"views":1500,"_links":{"self":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/3122"}],"collection":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/comments?post=3122"}],"version-history":[{"count":4,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/3122\/revisions"}],"predecessor-version":[{"id":3130,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/3122\/revisions\/3130"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media\/3123"}],"wp:attachment":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media?parent=3122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/categories?post=3122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/tags?post=3122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}