Database Integration with selenium #integration #database #databaseskills #jdbc #mysql_workbench

copy the following code in editor and Test

===========================================================
Package htmldriver;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
public class SQLConnector {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//Connection URL Syntax: "jdbc:mysql://ipaddress:portnumber/db_name"
String dbUrl = "jdbc:mysql://localhost:3036/emp";

//Database Username
String username = "root";

//Database Password
String password = "guru99";

//Query to Execute
String query = "select * from employee;";

//Load mysql jdbc driver
Class.forName("com.mysql.jdbc.Driver");

//Create Connection to DB
Connection con = DriverManager.getConnection(dbUrl,username,password);

//Create Statement Object
Statement stmt = con.createStatement();

// Execute the SQL Query. Store results in ResultSet
ResultSet rs= stmt.executeQuery(query);

// While Loop to iterate through all data and print results
while (rs.next()){
String myName = rs.getString(1);
String myAge = rs.getString(2);
System. out.println(myName+" "+myAge);
}
// closing DB Connection
con.close();
}
}
===========================================================

Default Values :
String host="localhost";
String port= "3306";
Connection con=DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/demo", "root", "root");

============================================================

IMPORTS:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

============================================================