import java.sql.*;

public class test {
    public static void main(String [] args){
	try{
	    String url = "jdbc:postgresql://localhost/test";
	    Connection conn = DriverManager.getConnection(url, "postgres" , "adrien");
	    Statement st = conn.createStatement();
	    ResultSet rs = st.executeQuery("SELECT * FROM mytable WHERE columnfoo = 500");
	    while (rs.next()) {
		System.out.print("Column 1 returned ");
		System.out.println(rs.getString(1));
	    }
	    rs.close();
	    st.close();
	}
	catch(Exception e) 
	    {
		e.printStackTrace();
	    }
    }
}