In selenium testing how to connect with database , any one
pls give the entire information
Answers were Sorted based on User's Feedback
Answer / guest
Just create a java class for jdbc connection, call it when
you need to connect to database. to crate a jdbc connection
class please follow
http://www.roseindia.net/jdbc/jdbc-mysql/MysqlConnect.shtml
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sandip
public class dbconnection
{
public static void main(String args[])
{
String email;
String dbUrl = "jdbc:mysql://localhost:3306/test"; //This
URL is based on your IP address
String username="username"; //Default username is root
String password="password"; //Default password is root
String dbClass = "com.mysql.jdbc.Driver";
String query = "Select email from users where user_id = 1;";
try
{
Class.forName(dbClass);
Connection con = DriverManager.getConnection
(dbUrl,username,password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next())
{
dbtime = rs.getString(1);
System.out.println(email);
} //end while
con.close();
} //end try
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
} //end main
} //end class
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the best scripting language for automation (function) testing
pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?
What are the challenges using QTP11, QC11 with SAP TAO?
Give some examples for test management tools?
Elaborate the situation where automation testing can’t be used for agile methods?
hi friends i got placed in accenture july stil i hav not recieved offer letter... 2 weeks b4 HR cllaed ask abt the location do u perfer.... stil i am waiting i jus wanted to know wat posotin is going if somebody knows pls help me
Could someone educate me on automation testing process followed in a company. I have a vague idea, but i need concrete answers. And thank you all in advance.
Does automation testing have any disadvantages?
Is automation testing a black box testing or white-box testing?
In realtime what is the Testing Process especially in automation plz its very urgent
Where to maintain information like login, password and url?
What are the most popular tools for automation testing?