private void readFilesFromDirectory(String path) {
    File directory = new File(path);
    tableRow = 0;
    if (directory.isDirectory()) {
      int count = 0;
      int row = 0;
      String name = "";
      String pathSql = "";
      for (File fi : directory.listFiles()) {
        if (fi.isFile()) {
          try {
            name = fi.getName();
            pathSql =
                fi.getParentFile()
                    + File.separator
                    + "sql"
                    + File.separator
                    + name.split("\\.")[0]
                    + ".sql";
            jTable2.getModel().setValueAt(++count, row, 0);
            jTable2.getModel().setValueAt(name, row, 1);
            if (ioService.checkFileExist(pathSql)) {
              jTable2.getModel().setValueAt(true, row, 2);
            }
            tableRow++;
            row++;
          } catch (Exception e) {

          }
        }
      }
    }
  }
 private void jButton1ActionPerformed(
     java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed
   // TODO add your handling code here:
   Boolean sqlStatus = false;
   Boolean selected = false;
   String fileName = "";
   String parentPath = templatePath.getText() + File.separator;
   String sqlQuery = "";
   for (int i = 0; i < tableRow; i++) {
     try {
       sqlStatus = (Boolean) jTable2.getModel().getValueAt(i, 2);
       selected = (Boolean) jTable2.getModel().getValueAt(i, 3);
       fileName = (String) jTable2.getModel().getValueAt(i, 1);
       if ((sqlStatus != null && sqlStatus == true) && (selected != null && selected == true)) {
         sqlQuery =
             ioService.readSql(
                 parentPath + "sql" + File.separator + fileName.split("\\.")[0] + ".sql");
         reconcileDo.doReconcile(parentPath + fileName, fileName, sqlQuery);
       }
     } catch (IOException ex) {
       Logger.getLogger(MainFrame.class.getName()).log(Level.SEVERE, null, ex);
     } catch (SQLException ex) {
       Logger.getLogger(MainFrame.class.getName()).log(Level.SEVERE, null, ex);
     }
   }
   System.out.println("Finsih");
 } // GEN-LAST:event_jButton1ActionPerformed