A2

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.*;

public class A2 {

    public static void main(String[] args) {


        Connection con = null;
        try {
            String url =
                    "jdbc:postgresql://db.intern.mi.hs-rm.de:5432/database";
            con = DriverManager.getConnection(url, args[0], args[1]);
            Statement stmt = con.createStatement();
            String query = "SELECT * FROM event";
            ResultSet result = stmt.executeQuery(query);
            try (BufferedWriter writer = new BufferedWriter(new FileWriter("aktEvents.csv"))) {
                writer.write("aktuelle Events: \n \n");
                while(result.next()){
                    writer.write("ID: " + result.getString("eventID" +
                     "  Bezeichnung: " + result.getString("bezeichnung") +
                     "  Konzept: " + result.getString("verName") +
                     "  Datum: " + result.getString("datum") +
                    "  Uhrzeit: " + result.getString("uhrzeit") +
                    "  Preis: " + result.getString("preis")) );
                }

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

        {
            System.out.println("Couldn't connect - aborting");
            System.exit(-1);
        }

    }

}