Datenbankabgleich mal anders

package listmissingmovies;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;


import jcifs.smb.NtlmPasswordAuthentication;
import jcifs.smb.SmbFile;


public class ListMissingMovies
{
  private static final String dbUser = "xbmc";
  private static final String dbPasswd = "xbmc";
  private static final String smbUser = "<username>";
  private static final String smbPasswd = "<secret>";


  public static void main(String[] args)
  {
    try
    {
      // Load driver
      Class.forName("org.mariadb.jdbc.Driver");


      System.out.println("Open connection");
      Connection connection = DriverManager.getConnection("jdbc:mysql://XBMC-Datenbank:3306/xbmc_video75", dbUser, dbPasswd);
      System.out.println("Connection ready");


      System.out.println("Load files from database");
      List<String> filesFromDB = new ArrayList<String>();
      Statement stmt1 = connection.createStatement();
      ResultSet rs = stmt1.executeQuery("select f.strFileName as fileName, p.strPath as path from files f join path p on p.idPath = f.idPath");
      while (rs.next())
      {
        String fileName = rs.getString("fileName");
        String path = rs.getString("path");
        if (fileName != null && !fileName.equals("") && path.startsWith("smb"))
        {
          filesFromDB.add(path + fileName);
        }
      }
      System.out.println("Loading finished");


      Collections.sort(filesFromDB);


      NtlmPasswordAuthentication auth = new NtlmPasswordAuthentication("", smbUser, smbPasswd);
      int index = 1;
      for (String currFile : filesFromDB)
      {
        SmbFile smbFile = new SmbFile(currFile, auth);
        if (!smbFile.exists())
        {
          if (index < 10)
          {
            System.out.print("000");
          } else if (index < 100)
          {
            System.out.print("00");
          } else if (index < 1000)
          {
            System.out.print("0");
          }


          System.out.println(index++ + ": " + currFile);
        }
      }
      System.out.println("Done");


    } catch (Exception ex)
    {
      ex.printStackTrace();
    }
  }
}