Comparing arrays

I have the following code

Code:

---

import java.io.*;
import java.util.*;
import javax.swing.JOptionPane;


public class SQL {
       
       
        public static void main(String[] args)throws IOException{

               
        String text =  JOptionPane.showInputDialog("Please enter your sentence here");
    String text2= null;
    String Text3 = "";
    StringTokenizer st;
    String[] keyword = {"employees", "managers"}; 
   
        st = new StringTokenizer (text, " ");
               
                while (st.hasMoreElements()){
                      text2 = (st.nextToken());
                      System.out.println (text2);
                   
                      Text3 = Text3 + " " + text2;
                    }
                String[] words = Text3.split (" ");
        //System.out.println(words);
       
        for (int i=0; i < words.length; i++){
                               
          System.out.println (words[i]);
                  }
       
              }

       
}

---

I'm trying to compare two arrays. The first array is the user input, for example can we use the followiing

'show all employees who are managers'

I have the second array which is called keyword. I want the keyword array to search through the user input (which is stored as an array now) and identify if both keywords are mentioned by the user?

I think its an if statement but I'm not sure how to go about it.

I had the following structure in mind

if userinput array was equal to keyword1 AND userinput array was equal to keyword 2
then do this.

its just the array searching which I'm struggling with.

Does anyone have any ideas that might be able to help as I can only find examples of array comparison to see if two arrays are identical.

/Mitty

here's an algorithm outline:

Code:

---

matchCounter = 0
for each String k in keywords array:
  for each String w in words array:
    if k equals w:
      matchCounter ++;

if matchCounter >= 2:
  // whatever you need to do

---

Quote:

---

Originally Posted by iluxa

here's an algorithm outline:

Code:

---

matchCounter = 0
for each String k in keywords array:
  for each String w in words array:
    if k equals w:
      matchCounter ++;

if matchCounter >= 2:
  // whatever you need to do

---

---

I think that this algorithm will consider the words array "valid" if contains two or more of only one of the Strings in the keywords array which may not be what you want. You may wish to use two boolean variables, one for each String in the keywords array and in your iteration set each boolean if its corresponding String is found. Then at the end check if both are true.

True that. I kinda wish they'd covered hash tables... ;)

Any Collection such as a simple ArrayList has the contains(...) method, and that could be one way to solve this problem.

Quote:

---

Originally Posted by Fubarable

I think that this algorithm will consider the words array "valid" if contains two or more of only one of the Strings in the keywords array which may not be what you want. You may wish to use two boolean variables, one for each String in the keywords array and in your iteration set each boolean if its corresponding String is found. Then at the end check if both are true.

---

How would I go about this? I understand the concept, just a matter of implementing it. Is there an example you could point me to so I could go through it and then try to implement it into my own work?

I altered the previous code to the following

Code:

---

import java.io.*;
import java.util.*;
import javax.swing.JOptionPane;


public class SQL {
       
       
        public static void main(String[] args)throws IOException{

               
        String text =  JOptionPane.showInputDialog("Please enter your sentence here");
    String text2= null;
    String Text3 = "";
    StringTokenizer st;
    String[] keyword = {"employees", "managers"}; 
   
        st = new StringTokenizer (text, " ");
               
                while (st.hasMoreElements()){
                      text2 = (st.nextToken());
                      System.out.println (text2);
                   
                      Text3 = Text3 + " " + text2;
                    }
                String[] words = Text3.split (" ");
        //System.out.println(words);
       
        for (int i=0; i < words.length; i++){
                               
          System.out.println (words[i]);
                 
        int matchCounter = 0;
        for ( String k : keyword)
                for (String w: words)
                        if (k == w){
                                matchCounter ++;
                                if (matchCounter >=2) {
                                        System.out.println("SELECT * FROM employees WHERE Position = 'Manager'");                       
                                                        }
                       
                        }
               
       
}
                        }
       
               
              }

---

but here was still no luck. That was he original suggestion by iluxa.

"k==w" doesnt work. Try "k.equals(w)" and you should be good

Quote:

---

Originally Posted by iluxa

"k==w" doesnt work. Try "k.equals(w)" and you should be good

---

Thanks for that, I've altered the code now to the following,

Code:

---

import java.io.*;
import java.util.*;
import javax.swing.JOptionPane;


public class SQL {
       
       
        public static void main(String[] args)throws IOException{

               
        String text =  JOptionPane.showInputDialog("Please enter your sentence here");
    String text2= null;
    String text3 = "";
    StringTokenizer st;
    String[] keyword = {"employees", "managers"}; 
   
        st = new StringTokenizer (text, " ");
               
                while (st.hasMoreElements()){
                      text2 = (st.nextToken());
                      System.out.println (text2);
                   
                      text3 = text3 + " " + text2;
                    }
                String[] words = text3.split (" ");
        //System.out.println(words);
       
        for (int i=0; i < words.length; i++){
                               
          System.out.println (words[i]);
                 
        int matchCounter = 0;
        String querycode;
       
                for ( String k : keyword){
                       
                        for (String w: words) {
                               
                                if (k.equals(w)){
                                        matchCounter ++;
                                }
                               
                                if (matchCounter ==2) {
                                        //System.out.println("SELECT * FROM employees WHERE Position = 'Manager'");       
                                        querycode = ("SELECT * FROM employees WHERE Position = 'Manager'");
                                        System.out.println(querycode);
                                }
                                       
                        }
                }
               
        }
        }
}

---

a query which include BOTH employees and managers now returns:

Code:

---


which
employees
are
managers

SELECT * FROM employees WHERE Position = 'Manager'
which
SELECT * FROM employees WHERE Position = 'Manager'
employees
SELECT * FROM employees WHERE Position = 'Manager'
are
SELECT * FROM employees WHERE Position = 'Manager'
managers
SELECT * FROM employees WHERE Position = 'Manager'

---

I was wondering why the statement has been returned that many times instead of once. I tried to move it out of the for loop but this did not work.

It's OK now. I played around with the code and came out with the following.

Code:

---

import java.io.*;
import java.util.*;
import javax.swing.JOptionPane;


public class SQL {
       
       
        public static void main(String[] args)throws IOException{

               
        String text =  JOptionPane.showInputDialog("Please enter your sentence here");
    String text2= null;
    String text3 = "";
    StringTokenizer st;
    String[] keyword = {"employees", "managers"}; 
    String[] keyword2 = {"employees", "admins"};
    int key = 0;
        st = new StringTokenizer (text, " ");
        int count;
         
               
                while (st.hasMoreElements()){
                      text2 = (st.nextToken());
                      System.out.println (text2);
                   
                      text3 = text3 + " " + text2;
                    }
                String[] words = text3.split (" ");
        //System.out.println(words);
       
        for (int i=0; i < words.length; i++){
                               
          System.out.println (words[i]);
                 
         
         
        count = words.length; 
/*        boolean found = false;
        if (found == false) {*/       
       
          while (i < count){
                  String Word = words[i];
                  if (Word.equals ("managers")){
                          key ++;
                    }
                  else if (Word.equals ("employees")){
                          key ++;
                  }
                      i++;
                  }
          if (key == 2){
                  System.out.println("SELECT * FROM employees WHERE Position = 'Manager'");
                  /*found = true;*/
                  key = 0;
                  i=0;
          }
          else {
                        key= 0; 
                        i=0;
          }         
         
          while (i < count){
                          String Word = words[i];
                  if (Word.equals ("admins")){
                                  key ++;
                            }
                  else if (Word.equals ("employees")){
                                  key ++;
                          }
                              i++;
                          }
          if  (key == 2){
              System.out.println("SELECT * FROM employees WHERE Position = 'admin'");
                  /* found = true;*/
                  key = 0; 
          }
          else {
                        key= 0;     
          }
         
        }
                       
        }
        /*}*/

       
}

---

Thanks for all your help guys :)