Write a java program to count the number of records in a table.

 DOWNLOAD      SLIP12Q1         SQLFORIT       SQL DRIVER

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * Created by : Amar Ghugare
 * created on : 21-05-2022 19:54
 * Purpose of class :
 */
public class Slip12Q1 {
    public static void main(String[] args) throws Exception {
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        String mysqlUrl = "jdbc:mysql://localhost/mydatabase";
        Connection con = DriverManager.getConnection(mysqlUrl, "root", "");
        System.out.println("Connection established......");
        Statement stmt = con.createStatement();
        String query = "select count(*) from Cricketers_Data";
        ResultSet rs = stmt.executeQuery(query);
        rs.next();
        int count = rs.getInt(1);
        System.out.println("Number of records in the cricketers_data table: "+count);
    }
}