import java.sql.*;
import java.util.Scanner;

public class Main {



    public static void main(String[] args) {
        System.out.println("Introduceti un salariu: ");
        Scanner scanMin = new Scanner(System.in);
        Integer min = scanMin.nextInt();
        try {
            DB database = new DB();
            Connection con = database.getConnection();
            PreparedStatement ps = con.prepareStatement("SELECT * FROM DateAngajati WHERE salariu>=?");
            ps.setString(1, min.toString());
            ResultSet data = ps.executeQuery();
            System.out.println("Angajati cu salariul mai mare de: " + min);
            if (!data.isBeforeFirst() ) {
                System.out.println("Niciun angajat gasit.");
            }
            while(data.next()) {
                    String cnp = data.getString("CNP");
                    String nume = data.getString("Nume");
                    Integer varsta = data.getInt("Varsta");
                    Integer salariu = data.getInt("Salariu");
                    System.out.printf("Angajatul %s cu CNP: %s si varsta de %d de ani are salariul de %d \n", nume, cnp, varsta, salariu);
            }

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

    }

    public static class DB {
        public Connection getConnection(){
            Connection con=null;
            try{
                Class.forName("com.mysql.jdbc.Driver");
                con= DriverManager.getConnection("jdbc:mysql://programare.me/costi","costi","Costi123!");
            }catch(Exception e){System.out.println(e);}
            return con;
        }

    }


}