@SuppressWarnings("empty-statement")
    public Vector getClientRecherche(String recepNumCli, String recepNom) {
        Vector myVector2D = new Vector();
        try {
            int recepNUCLI;
            Connection connection = factory.getConnection();
            Statement statement = connection.createStatement();
            ResultSet resultSet = null;
            System.out.println(recepNom);
            System.out.println("1");
            System.out.println(recepNumCli);
            System.out.println("1");
            if (!recepNom.isEmpty() && !recepNumCli.isEmpty()) {
                recepNUCLI = Integer.parseInt(recepNumCli);
                resultSet = statement.executeQuery("SELECT * FROM Client WHERE `idClient`=" + recepNUCLI + " AND `nomClient`like '%" + recepNom + "%';");
            } else if (recepNom.isEmpty() && !recepNumCli.isEmpty()) {
                recepNUCLI = Integer.parseInt(recepNumCli);
                resultSet = statement.executeQuery("SELECT * FROM Client WHERE `idClient`=" + recepNUCLI + ";");
            } else if (!recepNom.isEmpty() && recepNumCli.isEmpty()) {
                resultSet = statement.executeQuery("SELECT * FROM Client WHERE `nomClient`like '%" + recepNom + "%';");
            }
            int i = 0;

            while (resultSet.next()) {
                    Vector line = new Vector();

                    line.add(resultSet.getString("idClient"));
                    line.add(resultSet.getString("nomClient"));
                    line.add(resultSet.getString("adresseClient"));
                    line.add(resultSet.getString("telClient"));
                    line.add(resultSet.getString("contactClient"));

                    myVector2D.add(line);
                
            }
        } catch (SQLException e) {
            throw new DAO.DAOException(e.getSQLState());
        }

        return myVector2D;
    }