code

import com.github.javafaker.Faker;

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Main
{
    public static void main(String[] args) throws SQLException
    {

        BufferedReader reader;
        BufferedReader readers;




        Faker faker = new Faker();

        Connection connect = null;

        //pripojenie k databaze

        connect = DriverManager.getConnection("jdbc:postgresql://localhost:5432/HotRes", "postgres", "paradajka");

//        for(int i = 0; i < 781824; i++)
//        {
        try
        {
            reader = new BufferedReader(new FileReader("/home/nikoleta/Desktop/cities.txt"));

            String line = reader.readLine();

            while (line != null)
            {
                String createTable = "INSERT INTO lokalita(mesto, krajina) VALUES(?, ?);";

                PreparedStatement pst = connect.prepareStatement(createTable);
                pst.setString(1, line);
                pst.setString(2, faker.address().country());

//                System.out.println(line);
                // read next line
                pst.executeUpdate();
                line = reader.readLine();

            }
            reader.close();

        } catch (IOException e) {
            e.printStackTrace();
        }





//        }

//        String createTable = "INSERT INTO lokalita(id, meno, krajina) VALUES(DEFAULT,'apple');";


       // String query = "SELECT mesto FROM lokalita WHERE mesto LIKE ?";

//            pst.setString(1,  insertedString + "%");
//            ResultSet result = pst.executeQuery();
//            while(result.next())
//            {
//                cities.add(result.getString("mesto"));
//            }


//        PrintWriter writer = null;
//        try
//        {
//            writer = new PrintWriter("countries.txt", "UTF-8");
//            for(int i = 0; i < 781824; i++)
//            {
//                writer.println(faker.address().city());
//                //System.out.println();
//            }
//        } catch (FileNotFoundException e) {
//            e.printStackTrace();
//        } catch (UnsupportedEncodingException e) {
//            e.printStackTrace();
//        }
//        writer.println("The first line");
//        writer.println("The second line");
//        writer.close();


    }
}