根据Excel数据生成sql语句

1.读取Excel表格数据

private static void writeStore(String path) throws Exception {
        Workbook workbook = new XSSFWorkbook(new File(path));
        //读取excel中的sheet表名
        Sheet sheet = workbook.getSheet("xxx表名");
        int totalRow = sheet.getLastRowNum();
        System.out.println("总共：" + totalRow);
        //循环独处表中每一行中每一列的值
            for (int i = 1; i <= totalRow; i++) {
            Row row = sheet.getRow(i);
            // 门店编码
            String store_code = row.getCell(1).getStringCellValue();
            // 门店名称
            String store_name = row.getCell(2).getStringCellValue();
            // 门店地址
            String store_address = row.getCell(3).getStringCellValue();
            // 经度 转换string类型
            String longitude = resultContent(row.getCell(4));
            // 纬度
            String latitude = resultContent(row.getCell(5));
    .....
            String storeSql = "insert into 表名 (store_code,store_name,store_address,longitude,latitude,......)"
                    + " values('" + store_code + "','" + store_name + "','" + store_address + "','" + longitude + "','"
                    + latitude + "');";
            System.out.println(storeSql);
//将sql写入文档中
            writeTxtCount("存入sql文件.sql", storeSql);
        }
    }

2.存入.sql文件中

//传入文件路径  和生成的sql
private static boolean writeTxtCount(String path, String content) {
        BufferedWriter bufferedWriter = null;
        try {
            bufferedWriter = new BufferedWriter(new FileWriter(path, true));
            bufferedWriter.write(content + "\r\n");
            return true;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                bufferedWriter.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return false;
    }

##方法

//转化成string
private static String resultContent(Cell cell) {
        cell.setCellType(CellType.STRING);
        return cell.getStringCellValue();
    }

public static void main(String[] args) throws Exception {
        writeStore("表名路径.xlsx ");
    }