使用Java程序更新HTML文件：实现定时生成含5小时数据的HTML邮件

Got it, let's work through this problem step by step. Since you're storing historical status data directly in an HTML file and need to keep only the last 5 hours of entries (current hour + past 4), using an HTML parser is way safer than regex (which can break if your HTML structure shifts even slightly). Below's a practical implementation using Python's BeautifulSoup library—easy to adapt if you're using another language, but Python is common for these automation tasks.

Step 1: Install Dependencies #

First, install the BeautifulSoup library if you haven't already:

pip install beautifulsoup4

Step 2: Full Implementation Code #

This code reads your existing HTML file, modifies the table to add the new row at the top, removes the oldest row if needed, and saves the updated HTML back to the file:

from bs4 import BeautifulSoup

def update_status_table(html_content, new_row_html):
    # Parse the HTML string into a manipulable object
    soup = BeautifulSoup(html_content, 'html.parser')
    
    # Locate your status table (adjust the selector if your table has an ID/class, e.g., soup.find('table', id='status-history'))
    status_table = soup.find('table')
    if not status_table:
        raise ValueError("Could not find the status table in your HTML content")
    
    # Separate header row from data rows (skip this block if your table has no header)
    all_rows = status_table.find_all('tr')
    header_row = all_rows[0] if all_rows else None
    data_rows = all_rows[1:] if header_row else all_rows
    
    # If we already have 4 historical rows, delete the oldest one (last in the list)
    if len(data_rows) >= 4:
        data_rows[-1].decompose()
    
    # Convert your new row HTML string into a BeautifulSoup element
    new_row = BeautifulSoup(new_row_html, 'html.parser').tr
    
    # Insert the new row right after the header (or at the start of the table if no header)
    if header_row:
        header_row.insert_after(new_row)
    else:
        status_table.append(new_row)
    
    # Return the modified HTML as a string
    return str(soup)

# ------------------- Example Usage -------------------
# 1. Read existing HTML from your file
with open('status_report.html', 'r') as file:
    existing_html = file.read()

# 2. Define your new status row (customize this with real-time data)
new_status_entry = '<tr><td>19-Mar 7.00 PM</td><td>4&deg;C</td><td>Operational</td></tr>'

# 3. Update the table
updated_html = update_status_table(existing_html, new_status_entry)

# 4. Save the updated HTML back to the file
with open('status_report.html', 'w') as file:
    file.write(updated_html)

Key Details & Adjustments #

• Handling Headers: If your table doesn't have a header row, remove the lines that separate header_row and data_rows, and set data_rows = all_rows instead.
• Table Selection: If you have multiple tables in your HTML, use a more specific selector (like soup.find('table', class_='status-table') or soup.find('table', id='history-table')) to target the correct one.
• Parser Option: For faster/more strict HTML parsing, install lxml (pip install lxml) and replace 'html.parser' with 'lxml' in the BeautifulSoup calls.
• Valid New Rows: Ensure your new_row_html is a complete, valid <tr> element—this avoids corrupting the HTML structure.

How It Works #

1. Parses the existing HTML into a structured object so we can interact with elements directly.
2. Checks if we already have 4 historical data rows (to keep the total at 5 when adding the new one).
3. Removes the oldest row (last in the data rows list) if needed.
4. Inserts the new row at the top of the data section, so the most recent status is first.
5. Converts the modified structure back to an HTML string and saves it.

内容的提问来源于stack exchange，提问作者Dinesh Kumar