package Server;

import java.sql.*;

public class DB {
    static String url = "jdbc:postgresql:COREJAVA";
    public static void main(String args[])
    {
        try
        {
            runDB();
        }
        catch (SQLException ex)
        {
            for (Throwable t : ex)
                t.printStackTrace();
        }
    }
    public static void runDB() throws SQLException
    {
        try (Connection conn = getConnection())
        {
            Statement stat = conn.createStatement();
            stat.executeUpdate("CREATE TABLE Greetings (Message CHAR(20))");
            stat.executeUpdate("INSERT INTO Greetings VALUES ('Hello, World!')");
            try (ResultSet result = stat.executeQuery("SELECT * FROM Greetings"))
            {
                if (result.next())
                    System.out.println(result.getString(1));
            }
            stat.executeUpdate("DROP TABLE Greetings");
        }
    }

    public static Connection getConnection() throws SQLException
    {
        try
        {
            Class.forName("jdbc:postgresql");
        }
        catch (Exception e){};
        Connection conn = DriverManager.getConnection(url);
        return conn;
    }
}

static String url = "jdbc:org.apache.derby.jdbc.EmbeddedDriver:COREJAVA";

Class.forName("org.apache.derby.jdbc.EmbeddedDriver");