Excel转sql用Java实现

wang948

于 2023-12-15 15:58:20 发布

阅读量485

点赞数 10

文章标签： excel sql java

本文链接：https://blog.csdn.net/wang948/article/details/135019347

版权

前言

Excel转sql用Java实现

引入依赖

    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>5.2.4</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.2.4</version>
    </dependency>

完整代码

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.*;

public class ExcelToSQLUpdate {
    public static void main(String[] args) {
        try {
            FileInputStream file = new FileInputStream(new File("C:\\Users\\WHT\\Desktop\\22.xlsx"));
            Workbook workbook = new XSSFWorkbook(file);
            Sheet sheet = workbook.getSheetAt(0);

            FileWriter fileWriter = new FileWriter("C:\\Users\\WHT\\Desktop\\output.txt");
            BufferedWriter bufferedWriter = new BufferedWriter(fileWriter);

            for (Row row : sheet) {
                String column1Value = row.getCell(16).getStringCellValue();
                String column2Value = row.getCell(19).getStringCellValue();
                String conditionValue = row.getCell(2).getStringCellValue();

                String updateStatement = "UPDATE T_FCP_STANDBOOK SET column = '" + column1Value + "', column = '" + column2Value + "' WHERE condition = '" + conditionValue + "';";
                System.out.println(updateStatement);
                bufferedWriter.write(updateStatement);
                bufferedWriter.newLine();
            }

            bufferedWriter.close();
            fileWriter.close();
            workbook.close();
            file.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

---