TIL : 230131

• statement.close(); connection.close(); 을 따로 안 하는 방법 : try문 안에 넣기

try {
            Connection connection = DriverManager.getConnection(url, username, password);
            String creatSql = "CREATE TABLE ACCOUNT (id SERIAL PRIMARY KEY, username varchar(255), password varchar(255))";
            PreparedStatement statement = connection.prepareStatement(creatSql);
            statement.execute();

            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

try (Connection connection = DriverManager.getConnection(url, username, password)) {
            String creatSql = "CREATE TABLE ACCOUNT (id SERIAL PRIMARY KEY, username varchar(255), password varchar(255))";
            try(PreparedStatement statement = connection.prepareStatement(creatSql)) {
                statement.execute();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }