import java.sql.*;

public class JdbcNext {

    static public final String driver = "com.mysql.jdbc.Driver";
    static public final String connection =
            "jdbc:mysql://localhost:3306/komal";
    static public final String user = "root";
    static public final String password = "root";

    public static void main(String args[]) {

        try {
            Class.forName(driver);
            Connection con =
                    DriverManager.getConnection(connection, user, password);

            Statement st = con.createStatement();

            String sql = "select * from person";
            ResultSet rs = st.executeQuery(sql);
            
            int i=0;
            while(rs.next()){
                    i++;
            }
            System.out.println("No. of Row :"+i);
            
        } catch (Exception e) {
            System.out.println(e);
        }
    }
}