import java.sql.*;

public class DBCreation {
    final static String DATABASE_URL = "jdbc:postgresql://localhost/";
    static Connection connection = null;
    static Statement statement = null;

    private static void createDatabase() throws SQLException{
        String dbname = "\"TesDB\"";
        String sql = "CREATE DATABASE " + dbname;
        statement = connection.createStatement();
        statement.executeUpdate(sql);
        System.out.println("Database created");
    }

    private static boolean exists() {
        boolean exists = true;
        try {
            connection = DriverManager.getConnection(DATABASE_URL, "postgres", "Katilla");
            String sql = "select * from \"TesDB\"";
            statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);
        } catch (SQLException e) {
            exists = false;
        }
        return exists;
    }

    public static void main(String[] args) {
        try {
            if (!exists()) {
                connection = DriverManager.getConnection(DATABASE_URL, "postgres", "Katilla");
                createDatabase();
            }
        } catch (SQLException e) {
            System.out.println("Already exists");
        }

    }
}