title: How to execute Query Select that WHERE clause using ARRAY Variable in JAVA
body: <p>i have a code input array like this the variable name is <strong>"output"</strong>
  Assume that variable "output" is a list of a Column_Name in Array. the real output i want to get is the list of Table_name and Column_Name that i will show in the Jtable that i have set. the main of things to do is how to execute those Query using all of the "output" values so i can get every Table_Name of its </p>
  
  <pre><code>String[] output= example.split(",");
  </code></pre>
  
  <p>after i got an Array list i want to execute one by one of the Array value to a SQL statement and the processing code is like this</p>
  
  <pre><code>for (String outputInsert : output) {
      try {
          rs2 = stmt.executeQuery("SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA ='"+sqldb+ "' AND COLUMN_NAME = '"+outputInsert+"';");           
      } catch (SQLException ex) {
          Logger.getLogger(Retrieve.class.getName()).log(Level.SEVERE, null, ex);
      }
  } result rs2;
  </code></pre>
  
  <p>but i didn't get the result that i want that show all the value of every executed SQL statement</p>