main - HW9

// Ibrahimli Farahim - HW9

import java.sql.*;

public class SomeProgram {
	public static void main(String[] args) throws SQLException {
		connectToAndQueryDatabase("root", "qwerty123");
	}

	public static void connectToAndQueryDatabase(String user, String pass) throws SQLException {
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/world", user, pass);
		Statement stmt = con.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT * from world.city");
		while (rs.next()) {System.out.println(rs.getString("Name"));}
	}
}