Using where Clause To Get Data From Table Using Selenium WebDriver

Now you lot are good aware nearly how to INSTALL MYSQL, CREATING TABLES as well as ACCESS DATA from MySql information tables for your selenium WebDriver test. You tin sack compare as well as verify that information or you lot tin sack purpose all those information every bit Input values In roughly spider web forms. In previous example, We learnt

how to execute elementary pick out enquiry to acquire all information from MySql table. You tin sack every bit good use where clause In query to acquire specific information rows from table.

How to purpose where clause amongst enquiry In test

If you lot are executing enquiry In database manually as well as then you lot tin sack purpose where clause rattling merely amongst your query. To purpose where clause In query, You involve to use PreparedStatement Interface. PreparedStatement Interface volition permit you lot to purpose where clause amongst enquiry In your test. I convey prepared instance to acquire value from database using where clause every bit bellow. It volition acquire as well as impress number In console where advert = "smith" as well as historic menstruation = 25.

Download MySqlReadDatawithwhere.zip folder. There volition be MySqlReadData.java evidence script file In cipher folder. Extract cipher folder as well as Import It In your eclipse as well as and then execute.

When you lot execute inwards a higher house evidence In eclipse, It volition supply number every bit bellow In console.

This agency you lot tin sack purpose where clause amongst enquiry to acquire specific result. Next post service volition demo you lot how to update tape In MySQL tabular array to evidence information In selenium.

<< PREVIOUS || NEXT >>

More interesting articles here :Generation Enggelmundus Internet Marketing Tool here :Zeageat IM http://www.software-testing-tutorials-automation.com/