package pack;

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

public class Main {
	Connection con = null;
	public Main()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException e)
		{
			return;
		}

		con = null;

		try {
			con = DriverManager.getConnection("jdbc:mysql://84.200.222.219/insta?" +
					                          "user=insta&password=yxcvbnm");
		} catch (SQLException e) {

			e.printStackTrace();
		}
	}
	public static void main(String[] args) {

		Main m = new Main();
		m.selectAll();
	}

	public void selectAll()
	{
		Statement stat = null;
		try {
			stat = con.createStatement();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		String sql = "SELECT * From accounts";

		try {
			ResultSet res = stat.executeQuery(sql);
			while(res.next())
			{
				String id = res.getString(1);
				String User = res.getString(2);
				String Password = res.getString(3);
				String ip = res.getString(4);
				System.out.println("ID = " + id + " ," +"User = " + User + " ," + "Password = " + Password + " ," + "IP-Adresse = " + ip);
			}
			res.close();
			stat.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}


	}

}