package ui.ui;

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

import db.DbException;
import domain.Person;

public class DatabaseApp {


	public static void main(String[] args) throws SQLException{

		String url = "jdbc:postgresql://gegevensbanken.khleuven.be:51617/1TX34?currentSchema=r0667009_Web3";
		Properties properties = new Properties();
		properties.setProperty("user", "r0667009");
		properties.setProperty("password", "johnisnedikkevettehomow");
		properties.setProperty("ssl", "true");
		properties.setProperty("sslfactory", "org.postgresql.ssl.NonValidatingFactory");

		try(Connection connection = DriverManager.getConnection(url, properties);

		Statement statement = connection.createStatement();)



		{

		ResultSet result = statement.executeQuery("SELECT * FROM person");

			while(result.next())
			{
				String id = result.getString("userid");
				String email = result.getString("email");
				String password = result.getString("password");
				String firstName = result.getString("firstName");
				String lastName = result.getString("lastName");

				Person person = new Person(id, email, password, firstName, lastName);
				System.out.println(person);
			}

		}
		catch(SQLException e)
		{
			throw new DbException("Database error", e);
		}






		}




	}



}