import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import javax.xml.transform.Result;

public class TestJava {
    private final String url = "jdbc:postgresql://localhost:5433/dvdrental";
    private final String user = "postgres";
    private final String password = "makary123";

    public static void main(String[] args) {
    // TODO Auto-generated method stub
        callProcedure();
    }

    public Connection connect() throws SQLException {
        return DriverManager.getConnection(url, user, password);
    }

    public void callProcedure() {
        try {
            Connection conn = connect();
            CallableStatement cstmt = conn.prepareCall("{? = call print_full_name(?)}");
            cstmt.setInt(2, 1);
            cstmt.registerOutParameter(1, Types.VARCHAR);
            cstmt.execute();
            String name = cstmt.getString(1);
            System.out.println(name);
        }
        catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }
}