Database Connection

 class DbConnection

{

    {    

        Connection con=DriverManager.getConnection("jdbc:postgresql://"+hostname+":"+port+"/"+dbname, username, password);

        Statement stmt=con.createStatement();

        ResultSet rs=stmt.executeQuery("select * from students where id=123456");

        while(rs.next())

        {

             System.out.println(rs.getString(1));

        }

    }

    catch(SQLException e)

    {

        e.printStackTrash();    

    }

}

Comments

Post a Comment

Popular posts from this blog

Run Selenium Tests on Chrome Browser

package com.qa.tests; import org.openqa.selenium.WebDriver; import org.openqa.selenium.chrome.ChromeDriver; import org.testng.annotations.BeforeClass; import org.testng.annotations.Test; public class RunTestsOnChrome { WebDriver driver; @BeforeClass public void loadResources() { //---------Open in chrome browser------- //for downloading chromeDriver exe file visit "https://chromedriver.chromium.org/" System.setProperty("webdriver.chrome.driver", "D://driversBrowser//chromedriver_win32//chromedriver.exe"); driver = new ChromeDriver(); } @Test public void navUrlForTestGA() { for(int i=0;i<50;i++) { driver.get("https://letstryselenium.blogspot.com"); } } }
Read more

Collection Framework

Image
Class Name Duplicate Allowed Null Insertion Order of Insersion Maintained Index/Hashcode Default capacity Data Structure Arraylist ✓ ✓ ✓ Index ✓ 10 Re-sizable data structure Vector ✓ ✓ ✓ Index ✓ 10 Doubly Data Structure Linked List ✓ ✓ ✓ Index X Linear Data Structure Hash Set X ✓ X Hash Code X Hash Table Data Structure Linked HashSet X ✓ ✓ Hash Code X Hybrid Data Structure Tree Set X X X Hash Code X Balanced Data Structure Priority Queue ------ ------ ------ ------ ------ ------ Collection Framework -->Collection: Collection is a frame used to perform Insertion and retrieval operation of an unique element as an single entity. -->If you wan...
Read more

Emulate Chrome Browser into mobile View by Using Selenium part-1

                    WebDriver driver ;           ChromeOptions chromeOptions ;   @BeforeClass     public void Resources()   {                                    System. setProperty ( "webdriver.chrome.driver" , "/Users/abc/Desktop/chromedriver/chromedriver" );   Map<String, String> mobileEmulation = new HashMap<>();     mobileEmulation .put( "deviceName" , "iPhone 6/7/8" );     chromeOptions = new ChromeOptions();   chromeOptions .setExperimentalOption( "mobileEmulation" , mobileEmulation );   driver = new ChromeDriver( chromeOptions );   }
Read more