import java.sql.*;
import java.io.*;

public class MyJDBCEx
{
  public static void main(String args[]) throws Exception
  {

    Class.forName("org.postgresql.Driver"); 
    
    String url = "jdbc:postgresql://web0.site.uottawa.ca:15432/";
    
    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
    System.out.print("Entrez le nom d'usager SITE: ");
    String dbname = br.readLine();
    System.out.print("Entrez votre mot de passe SITE: ");
    String pwd = br.readLine();

    Connection conn = DriverManager.getConnection(url + dbname, dbname, pwd);
    Statement st = conn.createStatement();
    ResultSet rs = st.executeQuery("SELECT * FROM artist");
    int i = 0; 
    while (rs.next()) 
    {
      i++;
    	System.out.print("Row " + i + " returned: "); 
    	System.out.print("Column 1: "); 
      System.out.print(rs.getString(1)); 
    	System.out.print(", Column 2: "); 
      System.out.println(rs.getString(2)); 
    } 
    rs.close(); 
    st.close(); 
  }
}