import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.StringTokenizer;

public class Departamentos {

    private static String url = "jdbc:mysql://localhost:3306/empresa";
    private static String usuario = "root";
    private static String password = "";

    public static void main(String[] args) throws Exception{
        // TODO Auto-generated method stub

        ArrayList<String> depbbdd = new ArrayList<String>();

        Connection con = DriverManager.getConnection(url, usuario, password);
        PreparedStatement ps1 = con.prepareStatement("SELECT nombre FROM departamentos;");
        ps1.executeQuery();
        ResultSet rs = ps1.getResultSet();

        while(rs.next()){

            depbbdd.add(rs.getString("nombre"));

        }

        ArrayList <String> palabrasFichero = new ArrayList<>();

            String ruta="Departamentos.txt";
            String ruta2="temporal.txt";
            String ruta3="Descartados.txt";

            BufferedReader br = new BufferedReader(new FileReader(ruta));
            BufferedReader br2 = new BufferedReader(new FileReader(ruta2));
            BufferedWriter bw = new BufferedWriter(new FileWriter(ruta));
            BufferedWriter bw2 = new BufferedWriter(new FileWriter(ruta2));
            BufferedWriter bw3 = new BufferedWriter(new FileWriter(ruta3));

            String l;
            while((l = br.readLine()) != null) {

                bw2.write(l.replace('*', ' '));
                bw2.newLine();

            }
            br.close();
            bw2.close();

            String n;
            while((n = br2.readLine()) != null) {

                StringTokenizer token = new StringTokenizer(n);
                 while (token.hasMoreTokens()) {
                     palabrasFichero.add(token.nextToken());
                 }

            }
            br2.close();

            for (int i = 0; i < depbbdd.size(); i++) {
                 bw.write(depbbdd.get(i));
                 bw.write("*");
            }
            bw.close();

            Iterator<String> iteradorDepartamentos = palabrasFichero.iterator();
            while (iteradorDepartamentos.hasNext()) {
              if (depbbdd.contains(iteradorDepartamentos.next()))
              {
                  iteradorDepartamentos.remove();
              }
            }

            for (int i = 0; i < palabrasFichero.size(); i++) {
                 bw3.write(palabrasFichero.get(i));
                 bw3.write("*");
            }
            bw3.close();

            File temporal = new File(ruta2);
            //temporal.delete();

}

}