Connecting with Mysql

import java.sql.*;

public class MysqlDemo

{

    public static void main(String[] args)

    {

        try

        {

            Class.forName("com.mysql.jdbc.Driver");

            System.out.println("Driver is loaded");

            Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306/java2all","root","root");

            System.out.println("Connection created");

            Statement s = c.createStatement();

            ResultSet rs = s.executeQuery("select * from data");

            System.out.println("ID\tName\tCity\tAge");

             

            while(rs.next()) // Retrieve data from ResultSet

            {          

                             System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4));

            }

             

        }

        catch(Exception e)

        {

            System.out.println("Exception : " +e);

        }

    }

 

}