如何在无数据库场景下用Java将Bootstrap注册表单数据导出至Excel/CSV

Hey there! Since you're using a Bootstrap frontend and Java backend, and want to save form data to CSV/Excel instead of a database, I've got you covered with two straightforward solutions. Let's dive in:

CSV is super lightweight and easy to handle with Java's built-in IO classes—no extra libraries needed. Here's how to set it up:

Step 1: Frontend Form Setup #

Make sure your Bootstrap form uses POST method and points to your backend endpoint, with proper name attributes for each input (so the backend can grab the values):

<form action="/submit-registration" method="post" class="needs-validation" novalidate>
  <div class="mb-3">
    <label for="username" class="form-label">用户名</label>
    <input type="text" class="form-control" id="username" name="username" required>
  </div>
  <div class="mb-3">
    <label for="email" class="form-label">邮箱</label>
    <input type="email" class="form-control" id="email" name="email" required>
  </div>
  <div class="mb-3">
    <label for="phone" class="form-label">手机号</label>
    <input type="tel" class="form-control" id="phone" name="phone" required>
  </div>
  <button type="submit" class="btn btn-primary">提交注册</button>
</form>

Step 2: Backend Controller (Spring Boot Example) #

Create a controller to handle the form submission, write data to a CSV file, and handle edge cases like existing files or commas in user input:

import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.time.LocalDateTime;
import java.io.File;

@RestController
public class RegistrationController {

    // 可以改成服务器上的绝对路径，比如 "/var/app/registrations.csv"
    private static final String CSV_FILE_PATH = "./registrations.csv";

    @PostMapping("/submit-registration")
    public String handleRegistration(
            @RequestParam String username,
            @RequestParam String email,
            @RequestParam String phone
            // 注意：实际项目中不要明文存储密码！这里为了示例省略加密逻辑
    ) {
        boolean fileExists = new File(CSV_FILE_PATH).exists();

        try (BufferedWriter writer = new BufferedWriter(new FileWriter(CSV_FILE_PATH, true))) {
            // 如果文件是新的，先写表头
            if (!fileExists) {
                writer.write("用户名,邮箱,手机号,注册时间");
                writer.newLine();
            }
            // 转义用户输入中的逗号/引号，避免破坏CSV格式
            String formattedData = String.join(",",
                    escapeSpecialChars(username),
                    escapeSpecialChars(email),
                    escapeSpecialChars(phone),
                    LocalDateTime.now().toString());
            writer.write(formattedData);
            writer.newLine();
            return "注册成功！数据已保存";
        } catch (IOException e) {
            e.printStackTrace();
            return "注册失败：" + e.getMessage();
        }
    }

    // 辅助方法：处理CSV中的特殊字符
    private String escapeSpecialChars(String input) {
        if (input.contains(",") || input.contains("\"")) {
            return "\"" + input.replace("\"", "\"\"") + "\"";
        }
        return input;
    }
}

Pro Tips for CSV: #

• File Permissions: Ensure your Java backend has write access to the target file path (especially on production servers).
• Concurrency: If multiple users submit at the same time, add a synchronized block or use a file lock to prevent data overwrites.
• Security: Never store plaintext passwords—hash them with BCrypt or similar before saving.

If you need a more structured, spreadsheet-friendly format, Apache POI is the go-to library for handling Excel files in Java. Here's how to implement it:

Step 1: Add Apache POI Dependencies (Maven) #

Add these to your pom.xml to include the required libraries:

<dependencies>
    <!-- 处理.xls格式 -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>5.2.5</version>
    </dependency>
    <!-- 处理.xlsx格式 -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.2.5</version>
    </dependency>
</dependencies>

Step 2: Backend Controller for Excel #

This controller will either create a new Excel file or append to an existing one:

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.time.LocalDateTime;
import java.io.File;

@RestController
public class RegistrationExcelController {

    private static final String EXCEL_FILE_PATH = "./registrations.xlsx";

    @PostMapping("/submit-registration-excel")
    public String handleRegistrationToExcel(
            @RequestParam String username,
            @RequestParam String email,
            @RequestParam String phone
    ) {
        Workbook workbook = null;
        Sheet sheet = null;
        boolean fileExists = new File(EXCEL_FILE_PATH).exists();

        try {
            if (fileExists) {
                // 读取已存在的Excel文件
                FileInputStream fis = new FileInputStream(EXCEL_FILE_PATH);
                workbook = WorkbookFactory.create(fis);
                sheet = workbook.getSheetAt(0); // 操作第一个工作表
            } else {
                // 创建新的.xlsx工作簿和工作表
                workbook = new XSSFWorkbook();
                sheet = workbook.createSheet("注册记录");
                // 创建表头并设置样式
                Row headerRow = sheet.createRow(0);
                String[] headers = {"用户名", "邮箱", "手机号", "注册时间"};
                CellStyle headerStyle = workbook.createCellStyle();
                Font boldFont = workbook.createFont();
                boldFont.setBold(true);
                headerStyle.setFont(boldFont);

                for (int i = 0; i < headers.length; i++) {
                    Cell cell = headerRow.createCell(i);
                    cell.setCellValue(headers[i]);
                    cell.setCellStyle(headerStyle);
                }
            }

            // 获取下一行的行号（从表头下一行开始）
            int nextRowNum = sheet.getLastRowNum() + 1;
            Row dataRow = sheet.createRow(nextRowNum);

            // 填充用户数据
            dataRow.createCell(0).setCellValue(username);
            dataRow.createCell(1).setCellValue(email);
            dataRow.createCell(2).setCellValue(phone);
            dataRow.createCell(3).setCellValue(LocalDateTime.now().toString());

            // 自动调整列宽，优化显示
            for (int i = 0; i < 4; i++) {
                sheet.autoSizeColumn(i);
            }

            // 写入文件
            FileOutputStream fos = new FileOutputStream(EXCEL_FILE_PATH);
            workbook.write(fos);
            fos.close();

            return "注册成功！数据已保存至Excel";
        } catch (IOException e) {
            e.printStackTrace();
            return "注册失败：" + e.getMessage();
        } finally {
            // 确保关闭工作簿，释放资源
            if (workbook != null) {
                try {
                    workbook.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

Pro Tips for Excel: #

• Large Files: If you expect lots of registrations, use SXSSFWorkbook instead of XSSFWorkbook—it uses streaming to avoid memory overflow.
• Concurrency: Same as CSV—add synchronization or a queue system to handle concurrent writes safely.
• Dependency Versions: Stick to stable POI versions to avoid compatibility issues.

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