title: Setting up multiple parameter Values in a Sql query
body: <p>Im trying to pass Multiple Parameter values from one jsp page to another jsp page.
  How do i pass these values in a Sql query.</p>
  
  <p><strong>First page:</strong></p>
  
  <pre><code>  &lt;th&gt;Revenue&lt;/th&gt;
    &lt;select name="Student" multiple &gt;
    &lt;option value="CST"&gt;CST&lt;/option&gt;
    &lt;option value="EST"&gt;EST&lt;/option&gt;
    &lt;option value="MST"&gt;MST&lt;/option&gt;
    &lt;option value="MDT"&gt;MDT&lt;/option&gt;
    &lt;option value="PST"&gt;PST&lt;/option&gt;`
  </code></pre>
  
  <p><strong>Second Page:</strong></p>
  
  <pre><code>String[] t2=request.getParameterValues("Student");
  
  if(t2!=null){
      for( i=0;i&lt;t2.length;i++){
          out.println(t2[i]);
      }
  }
  
  String QueryString1 = "Select * from School where Student in ('t2[i]')";
  </code></pre>