Selenium DB connectivity

Connecting database using java for selenium test 

 Jar file download : mysql-connector-java-5.1.8-bin.jar
Table Created : Test

 Code:

import java.sql.*;
import javax.sql.*;

public class jdbcdemo{

public static void main(String args[]){
String dbtime;
String dbUrl = "jdbc:mysql://localhost:3306/test";
String username="root";
String password="root";
String dbClass = "com.mysql.jdbc.Driver";
String query = "show tables;";

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(dbtime);
} //end while

con.close();
} //end try

catch(ClassNotFoundException e) {
e.printStackTrace();
}

catch(SQLException e) {
e.printStackTrace();
}

}  //end main

}  //end class

Note: Use --> String dbUrl = "jdbc:mysql://ip/yourDBname"; if you know the ip address of remote host!


keep testing!