JavaSqlCon.java~

import java.sql.*;

public class JavaSqlCon{

    public static void main(String args[]) {

	String dbUrl = "jdbc:mysql://localhost/bookingSystem";
	String name = "root";
	String pass = "12345678";
	
	    //Database Connection
	try{
	    
	    Connection connection =
		DriverManager.getConnection(dbUrl, name, pass);

	    //Create a statement

	    String sqlQuery = "SELECT * FROM Booking";

	    Statement statement = connection.createStatement();

	    ResultSet results = statement.executeQuery(sqlQuery);


	    while(results.next()){
		System.out.println(results.getString(1) + " " +
				   results.getString(2));
	    

	    connection.close();
	} catch(SQLException ex){
	    System.out.println("SQL error: " + ex.getMessage());
	}
    }

    
}