title: filter table from database in jsp using jquery
body: <p>I am retrieving data from database and putting into table. I have combo box to select type.On change of combo box I want to filter data from database.I want to use jquery in jsp.</p>
  
  <p>Below is code for select type</p>
  
  <pre><code>    &lt;form method="post" action="dashboardcontrol.jsp"&gt;
              Type: &lt;select name="type" id="type"&gt;
                  &lt;option value="select" selected&gt;..select..&lt;/option&gt;
                  &lt;option value="agriculture"&gt;Agriculture&lt;/option&gt;
                  &lt;option value="fiction"&gt;Fiction&lt;/option&gt;
                  &lt;option value="Religion"&gt;Religion&lt;/option&gt;
                  &lt;option value="music"&gt;Music&lt;/option&gt;    
              &lt;/select&gt; 
             &lt;input type="submit" value="ok" /&gt;
      &lt;/form&gt;
  </code></pre>
  
  <p>this is the table which contain all data</p>
  
  <pre><code>&lt;TD&gt;&lt;%=resultset.getInt(1)%&gt;&lt;/TD&gt;
  &lt;TD&gt;&lt;%=resultset.getString(2)%&gt;&lt;/TD&gt;
  &lt;TD&gt;&lt;%=resultset.getString(3)%&gt;&lt;/TD&gt;
  &lt;TD&gt;&lt;%=resultset.getString(4)%&gt;&lt;/TD&gt;
  &lt;TD&gt;&lt;%=resultset.getString(5)%&gt;&lt;/TD&gt;
  &lt;TD&gt;&lt;%=resultset.getString(6)%&gt;&lt;/TD&gt;
  </code></pre>
  
  <p>Any advice!!!</p>