package postgres;

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

public class Program {
	// 10.10.4.79
	public static void main(String[] args) {
		try {
			Class.forName("org.postgresql.Driver");

			// LOCALHOST
			//String url = "jdbc:postgresql://localhost:5434/nuno";
			//Connection conn = DriverManager.getConnection(url);

			String url = "jdbc:postgresql://10.10.4.79/myclients";

			// /*
			Properties props = new Properties();
			props.setProperty("user", "Manuel Barata");
			props.setProperty("password", "xico57");
			Connection conn = DriverManager.getConnection(url,props);
			//*/


			Statement st = conn.createStatement();


			ResultSet rs = st.executeQuery("select * from cliente");
			ResultSetMetaData mtd = rs.getMetaData();

			for(int i =1; i<= mtd.getColumnCount(); i++)
				System.out.print(mtd.getColumnName(i)+", ");

			System.out.println();

			while(rs.next()) {
				for(int i=1; i<=mtd.getColumnCount(); i++)
					System.out.print(rs.getString(i)+", ");
				System.out.println();
			}
			rs.close();
		}
		catch(Exception e)
		{

			System.out.println(e.getMessage());
		}
	}


}