How to disolay selected value in JSP dynamically

Hi,
I have two display grid in my JSP page- WorkForcememberIDSearch and WorkForcememberIDSearchHistory.

When ever user select the data using radio button in WorkForcememberIDSearch, based on that I have query database and display values based on the result from DB. Please provide me a sample how can I do this? I am enclosing html page html code please let me know if jsp page is needed.


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Workforce Member Screen</title>
<link href="../css/TM_Styles.css" type="text/css" rel="stylesheet" />
<link href="../css/TM_Styles_2.css" type="text/css" rel="stylesheet" />
<script type="text/javascript">
	var formInUse = false;
	function setFocus()
		{
 			if(!formInUse) {
  								document.add.lname.focus();
 							}
		}
</script></head>
 
<body onload="setFocus()">
<form action="XXXXXX" method="post" name="add" target="_self">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="outertblborder">
    <tr class="tableheading" >
    <td height="25" nowrap="nowrap" colspan="5">
    	<strong> &nbsp;<span class="outtblheading">LTC TrainingRecords Manager</span></strong> 
        <strong> - Workforce Members Screen</strong>    
    	<span class="outtblheading">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;
        User -   	    </span>
    	<input name="username" type="hidden" value="" />
    </td>
  </tr>
  <tr>
  <td width="8" >&nbsp;</td>
    <td width="544" height="369" align="center">
        <table width="97%" border="0" cellpadding="0" cellspacing="0" class="innertableborder tableborder">
          <tr>
            <td height="28" colspan="3" class="tableheading"><p><strong>Workforce  Member ID Search</strong></p></td>
          </tr>
          <tr>
            <td height="28" width="54%" nowrap="nowrap" align="left">&nbsp;<span class="loginfont">
            <strong>Last Name </strong></span>
            <span class="error">(type part or all of a last name)</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
            <td width="46%" nowrap="nowrap">
            <span class="loginfont"><strong>Workforce ID</strong></span>
            <span class="error"> (type in part or all of an ID)</span>        </td>
          </tr>
          <tr>
            <td height="28" align="left">&nbsp;&nbsp;<input type="text" name="lname" id="lname" tabindex="1" maxlength="25"/></td>
            <td><input type="text" name="workfid" id="workfid" tabindex="3" maxlength="10" /></td>
          </tr>
          <tr>
            <td height="28" width="54%" nowrap="nowrap" align="left">&nbsp;<span class="loginfont">
            <strong>First Name </strong></span>
            <span class="error">(type part or all of a first name)</span>        </td>
            <td width="46%">&nbsp;</td>
          </tr>
          <tr>
            <td  height="28" align="left">&nbsp;&nbsp;<input type="text" name="fname" id="fname" tabindex="2" maxlength="25" /></td>
            <td align="center">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<input type="submit" name="Find" id="Find" value=" Find " tabindex="4" /></td>
          </tr>
          <tr>
            <td height="28" >&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td height="27" colspan="2">
        <table width="100%" border="0" cellspacing="0" cellpadding="0" class="innertableborder loginfont">
                  <tr>
                    <td width="6%"  height="28">&nbsp;</td>
                    <td width="18%"><strong>Full Name</strong></td>
                    <td width="24%"><strong>  Workforce ID  </strong></td>
                    <td width="18%"><strong>Service</strong></td>
                    <td width="34%"><strong>Role </strong></td>
                </tr>
              </table>
            </td>
          </tr>
          <tr>
            <td height="116" colspan="2">
	      <div class="searchlist">
          <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
                  <tr>
                    <td width="6%" align="center"><input type="radio" name="radio" id="radio" value="radio" /></td>
                    <td width="18%">&nbsp;</td>
                    <td width="24%">&nbsp;</td>
                    <td width="18%">&nbsp;</td>
                    <td width="34%">&nbsp;</td>
                </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
              </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                </table>            
      </div>
      </td>
    </tr>
        </table>    
     </td>
    <td width="5">&nbsp;</td>
    <td width="649" height="369" >
<table width="100%"  border="0" cellpadding="0" cellspacing="0" class="innertableborder tableborder">
                       <tr>
            <td height="28" colspan="4" class="tableheading"><p><strong>Workforce Employment  Information Form</strong></p></td>
          </tr>
             <tr>
                <td height="28" width="18%" nowrap="nowrap" class="loginfont">
                &nbsp;<span class="error">* </span><strong>Last Name</strong>&nbsp;&nbsp;                </td>
            <td width="30%">
            <input type="text" name="lname2" id="lname2" tabindex="5" maxlength="25"/>&nbsp;&nbsp;               </td>
               <td width="17%" nowrap="nowrap" class="loginfont"><span class="error">* </span><strong>WorkforceID</strong>&nbsp;
&nbsp;                </td>
               <td width="35%"><input type="text" name="wkid2" id="wkid2" tabindex="13" maxlength="10"/>
&nbsp;&nbsp;               </td>
          	  </tr>
              <tr>
                <td  height="28" nowrap="nowrap" class="loginfont">
                &nbsp;<span class="error">*</span><strong> First Name</strong>&nbsp;&nbsp;                </td>
                <td><input type="text" name="fname2" id="fname2" tabindex="6" maxlength="25"/>
&nbsp;&nbsp;                </td>
                <td nowrap="nowrap" class="loginfont"><span class="error">* </span><strong>Service</strong>&nbsp;&nbsp;</td>
                <td><select name="tenure2" tabindex="14" >
                  <option> XXXX </option>
                </select>&nbsp;&nbsp;                </td>
              </tr>
              <tr>
                <td  height="28" nowrap="nowrap" class="loginfont">
                &nbsp;&nbsp;&nbsp;&nbsp;Middle Initial&nbsp;&nbsp;                </td>
              <td>
                   <input type="mname" name="mname" id="wkfid" maxlength="1" size="5" tabindex="7"/>
&nbsp;&nbsp;                </td>
                <td class="loginfont"><strong>&nbsp;&nbsp;Role </strong></td>
                <td><input type="text" name="role" id="role" tabindex="15" maxlength="10"/></td>
              </tr>
              <tr>
                <td  height="32" nowrap="nowrap" class="loginfont">&nbsp;<span class="error">* </span><strong>Tenure</strong>&nbsp;&nbsp;</td>
              <td>
                    <select name="tenure" tabindex="8" >
                    <option>
                     XXXX                    </option>
                    </select>
&nbsp;&nbsp;                </td>
                <td class="loginfont"><strong>&nbsp;&nbsp;Approver?</strong></td>
                <td><input type="mname" name="approver" id="approver" maxlength="1" size="5" tabindex="16"/></td>
              </tr>
              <tr>
                <td  height="28"><span class="loginfont">&nbsp;<span class="error">* </span><strong>Department</strong></span>                </td>
                <td><select name="dept" tabindex="9" >
                  <option> DL-00000001 </option>
                </select>                </td>
                <td class="loginfont"><strong>&nbsp;&nbsp;Trainer? </strong>                </td>
                <td><input type="mname" name="trainer" id="trainer" tabindex="17" maxlength="1" size="5"/>                </td>
              </tr>
              <tr>
                <td  height="28"><span class="loginfont">&nbsp;<span class="error">*</span><strong> Job Title</strong></span>                </td>
                <td><input type="text" name="jtitle" id="jtitle" tabindex="10" maxlength="70"/>                </td>
                <td class="loginfont"><strong>&nbsp;&nbsp;Comments </strong>                </td>
                <td>&nbsp;                </td>
              </tr>
              <tr>
                <td  height="28"><span class="loginfont">&nbsp;<span class="error">*</span><strong> Position Level</strong></span>                
                </td>
                <td><input type="text" name="poslevel" id="poslevel" tabindex="11" maxlength="10"/>                
                </td>
                <td colspan="2" rowspan="3">&nbsp;&nbsp;
                <textarea name="commenttxtbox" id="commenttxtbox" cols="30" rows="5" tabindex="18" wrap="soft" ></textarea>
                </td>
              </tr>
              <tr>
                <td height="28"><span class="loginfont">&nbsp;<span class="error">*</span><strong> Effective Date</strong></span>                
                </td>
                <td><input type="text" name="effdate" id="effdate" tabindex="12" maxlength="11"/>                </td>
              </tr>
              <tr>
                <td>&nbsp;                </td>
                <td>&nbsp;                </td>
              </tr>
  			  <tr>
                <td height="19" colspan="4">
                  <div class="error" id="valerror3"> </div>                
                </td>
              </tr>
              <tr>
                <td align="right" colspan="2" nowrap="nowrap">
                  <input type="submit" name="add" id="add" value=" ADD " tabindex="19" />&nbsp;&nbsp; &nbsp;
                  <input type="submit" name="edit" id="edit" value=" EDIT " tabindex="20" />&nbsp;&nbsp; &nbsp;
                  <input type="submit" name="delete" id="delete" value="DELETE" tabindex="21" />&nbsp;&nbsp;&nbsp;&nbsp;                </td>
              <td colspan="2" nowrap="nowrap" align="center">
                    <input type="submit" name="save" id="save" value=" Save " tabindex="22" /> &nbsp;&nbsp;&nbsp;
                  <input type="submit" name="cancel" id="cancel" value="Cancel" tabindex="23" />&nbsp;&nbsp;&nbsp;                </td>
              </tr>
  			  <tr>
                <td height="23" colspan="4">
                  <div class="error" id="valerror3"> </div>                
                </td>
          </tr>
          </table>    	
    </td>
    <td width="4" >&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5">
    
<!--      Insert the HMTL table below and the heading above 			-->
<!--    	<div class="accountsearchlist">
            <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" class="tablefont" >
            
-->
            
<!--            </table>
        </div>
-->
    </td>
  </tr>
<!--  <tr>
    <td colspan="5" align="center">&nbsp;</td>
  </tr>-->
  <tr>
    <td colspan="5">
	<table width="97%" border="0" cellspacing="0" cellpadding="0" align="center">
	<tr>
   		<td class="tableheading" height="28"><p><strong>Workforce  Member ID Search HISTORY</strong></p></td>
  	</tr>
  	<tr>
   		<td >
        <div class="accountsearchlist">
           <table width="100%" border="1px" cellspacing="0" cellpadding="2" class="tablefont">
             <tr>
               <td width="6%">&nbsp;</td>
               <td width="8%"><div align="center"><strong>Effective Date</strong></div></td>
               <td width="8%"><div align="center"><strong>Last Name</strong></div></td>
               <td width="8%"><div align="center"><strong>First Name</strong></div></td>
               <td width="9%"><p align="center"><strong>Middle Initial</strong></p>             </td>
               <td width="5%"><div align="center"><strong>Service</strong></div></td>
               <td width="5%"><div align="center"><strong>Tenure</strong></div></td>
               <td width="11%"><div align="center"><strong>Department</strong></div></td>
               <td width="8%"><div align="center"><strong>Job Title</strong></div></td>
               <td width="10%"><div align="center"><strong>Position Level</strong></div></td>
               <td width="22%"><div align="center"><strong>Comments</strong></div></td>
             </tr>
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>         
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>         
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>         
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>         
             <tr>
               <td align="center"><input type="radio" name="radio" id="r1" value="r1" /></td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
               <td>&nbsp;</td>
             </tr>
           </table>
           </div>
         </td>
      </tr>
    </table>
	</td>
  </tr>
  <tr>
   <td colspan="5">
       	<table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="9%" height="85">&nbsp;</td>
            <td width="15%" nowrap="nowrap">
            <fieldset>
                  <legend class="loginfont">Navigation</legend>
                  <br />
                    <input type="submit" name="mainmenu" id="mainmenu" value="Main Menu" tabindex="24" />&nbsp;&nbsp;
                    <input type="submit" name="logout" id="logout" value="Log out" tabindex="25" />
                  <br />  
                </fieldset>
            </td>
            <td width="76%">&nbsp;</td>
          </tr>
    	</table>
   </td>
  </tr>
</table>
</form>
</body>
</html>

Open in new window

sanrichAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chaitu chaituCommented:
In WorkForcememberIDSearch if user enter data in any one of thefields(Workforce ID,Last Name,First Name) and select any one of the radio button(Full Name,Workforce ID,Service,Role) and click Find button ,the data should be displayed in Workforce Member ID Search HISTORY.Is it Right?

If that is the case use one servlet.there open the database connection in servelt and put all the data in one object and put the data in request object and send it back to this jsp?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sanrichAuthor Commented:
NO, He will only select radio button and we have display its deatils in history grid.
0
chaitu chaituCommented:
user select radio button  in In WorkForcememberIDSearch and click Find button.am i right?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sanrichAuthor Commented:
No, just select radio button and not find button. We have to query DB .
0
chaitu chaituCommented:

call onchange function when user click radio button.
 
<input type="radio" name="radio" id="radio" value="radio" onChange="ex()" />
 
	function ex()
		{
			document.forms[0].action="/SomeServlet?operation=getFullNameFromDB"
			document.forms[0].submit();
 
		}
 
SERVLET
*********
if(request.getParameter("operation").equals("getFullNameFromDB"))
{
 
DataSource ds= (DataSource) context.lookUp("java:oraclePool");
 
Connection con = ds.getConnection(); 
PreparedStatement stmt =con.preparedStatement();
ResultSet rs= stmt.createQuery("select * from table where table='fullname'";
ArrayList al = new ArrayList();
while(rs.next())
{
Customer c =new Customer();
c.setEffectiveDate(rs.getDate(1))
c.setLastname(rs.getString(2))
c.setFirstName(rs.getString(3));
...
al.add(c);
}
 
request.setAttribute("results",al);
}
 
 
in jsp print these values in History grid.
 
ArrayList results = (ArrayList)request.getAttribute("results");
 
for(int i=0;i<results.size();i++)
{
   (Customer) c =(Customer)results.get(i);
print these values in the history grid jsp
}

Open in new window

0
sanrichAuthor Commented:
Thanks this is working but, there is problem it works fine when I click on twice on radio button but not first time. i.e. suppose I have three radio button. When I select first one nothing happens then when I select second one at that time first one gets called. same it with other buttons like when I click 3rd then nothing happens and when I click first then 3rd is called. Here whats I did

<script type="text/javascript">
      var formInUse = false;
      function setFocus()
            {
                   if(!formInUse) {
                                                  document.add.lname.focus();
                                           }
            }

       function triggerval()
            {
                  document.forms[0].action="/jsp/S1Controller.jsp?operation=getval";
                  document.forms[0].submit();
 
            }

</script></head>


In in JSP FORM

 <tr>
                    <td width="6%" align="center"><input type="radio" name="wfradio" id="radio" value="<%= strValue %>"  
                               onChange="triggerval()"   /></td>
                    <td width="18%"><%= strScreenName[0] %></td>
                    <td width="24%"><%= strScreenName[1] %></td>
                    <td width="18%"><%= strScreenName[2] %></td>
                    <td width="34%"><%= strScreenName[3] %></td>
                </tr>
0
chaitu chaituCommented:
insteadof onChange use onClick ;

<input type="radio" name="wfradio" id="radio" value="<%= strValue %>"  
                               onClick="triggerval()"   />
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JavaScript

From novice to tech pro — start learning today.