［Mac/Java/Eclipse/PostgreSQL］Javaアプリとデータベースを接続する

rails model User name:String email:String
rails:db mingrate

SELECT * FROM USER;

package jp.co.sample;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Sampleapp6 {

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

        String url = "jdbc:postgresql://localhost:5432/sample";
        String user = "sampleデータベースのユーザー";
        String password = "samleデータベースのパスワード";


        // データベースに接続
        try(Connection conn = DriverManager.getConnection(url,user,password)) {

            //SELECT文を準備
            String sql = "SELECT * FROM CUSTOMER";
            PreparedStatement pStmt = conn.prepareStatement(sql);

            ResultSet rs = pStmt.executeQuery();

            //結果を表示
            while (rs.next()) {
                String id = rs.getString("ID");
                String name = rs.getString("NAME");
                String email = rs.getString("EMAIL");

                System.out.println(id + " " + name + " " + email);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
    };