数据库（表）：结构与数据分离脚本

import java.io.*;

/**

• @author caq
• sql文件结构与数据分离工具
• @version 1.0
  */
  public class FileDemo {
  public static void main(String[] ags) {
  File file = new File(“D:\Caq\CODE\JAVA\Practice\FileDemo\file\caqtestNew.sql”);
  File fileData = new File(“D:\Caq\CODE\JAVA\Practice\FileDemo\file\data.sql”);
  File fileSchema = new File(“D:\Caq\CODE\JAVA\Practice\FileDemo\file\Schema.sql”);
  if (!fileData.exists()) {
  try {
  fileData.createNewFile();
  } catch (IOException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
  }
  if (!fileSchema.exists()) {
  try {
  fileSchema.createNewFile();
  } catch (IOException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
  }
  try (BufferedReader reader = new BufferedReader(new InputStreamReader(new FileInputStream(file)));
  BufferedWriter outputData = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(fileData)));
  BufferedWriter outputSchema = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(fileSchema)))) {
  String lineTxt;
  while ((lineTxt = reader.readLine()) != null) {
  lineTxt += “\r\n”;
  if (!lineTxt.contains(“INSERT”)) {
  outputSchema.write(lineTxt);
  } else {
  outputData.write(lineTxt);
  }
  }
  } catch (IOException e) {
  System.out.println(“复制文件异常” + e.getMessage());
  }
  }
  }