Generation

generate functionFri, 20 Jan 2023

read file with sql script with multiline commands for mssql and run it

private void readFileByLine(String path) throws IOException { String fileName = path; ClassLoader classLoader = getClass().getClassLoader(); File file = new File(classLoader.getResource(fileName).getFile()); if (fileName == null || "".equals(fileName)) { System.out.println("ERROR: File name is empty"); return; } String sql = ""; String temp = ""; String[] sqls = new String[2000]; int index = 0; FileReader fileReader = new FileReader(file); BufferedReader bufferedReader = new BufferedReader(fileReader); while ((temp = bufferedReader.readLine()) != null) { if ("".equals(temp)) { System.out.println("ERROR: Line is empty"); continue; } if (temp.startsWith("--")) { System.out.println("INFO: Skipping Comment line"); continue; } else { sql =

Questions about programming?Chat with your personal AI assistant