package JDBCExample.JDBCExample;

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


/**
 * Hello world!
 *
 */
public class Driver
{
    public static void main( String[] args )
    {
        try{
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3307/demo", "root", "root");
            Statement statement = connection.createStatement();
            ResultSet set = statement.executeQuery("select * from employees");
            while(set.next()){
                System.out.println(set.getString("last_name") + ", " + set.getString("first_name"));
            }
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}