Mysql使用freemarker将表格打印到html上

import java.sql.*;

public class MysqlConnection {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/database_name";
        String username = "username";
        String password = "password";

        try {
            Connection connection = DriverManager.getConnection(url, username, password);
            // 连接成功后的操作
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

String sql = "SELECT * FROM table_name";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);

import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;

import java.io.*;
import java.util.HashMap;
import java.util.Map;

public class FreemarkerExample {
    public static void main(String[] args) {
        Configuration configuration = new Configuration(Configuration.VERSION_2_3_31);
        configuration.setClassForTemplateLoading(FreemarkerExample.class, "/templates");

        try {
            Template template = configuration.getTemplate("table_template.ftl");
            Map<String, Object> data = new HashMap<>();
            data.put("tableData", resultSet);

            Writer writer = new FileWriter(new File("output.html"));
            template.process(data, writer);
            writer.close();
        } catch (IOException | TemplateException e) {
            e.printStackTrace();
        }
    }
}