Forum:

Combo box problem in jsp

venkatesh warlu

Ranch Hand

Posts: 33

posted 9 years ago

hi frnds

i have a problem in workin out one small module in my project.

i have one drop down box with values selected in it from my database.
i have few text boxes below. i want to display corresponding values from the database with respect to the option i selected in drop down box.
Can anyone help me out this problem.

this is how my code looks like :

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
 
<%!
Connection con=null;
Statement stmt=null;
ResultSet rset=null;
%>
 
 
 
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection("jdbc:odbc:job","","");
stmt=con.createStatement();

rset=stmt.executeQuery("select * from tbl_job");
//ResultSet rset2=stmt.executeQuery("select Avg_Start_Time from tbl_job");

}
 
   catch(Exception e){
out.println("error in getting data"+e);
}
%>
 
 
<table align="center" border=1 cellpadding="1" cellspacing="1" width="850" height="10"> 
<tr>
<td align="center">
Job Entry | P/U Entry | P/U to table xref | Job to P/U xref | Table entry | Run schedule entry | Runschedule to dayofweek | Report all jobs
</td>
</tr>
</table><br>
 
<table align="center" border="1" cellpadding="1" cellspacing="1" width="850" height"550">
<tr><td>
 
<form action="" name="jobform">
<table align="center" cellpadding="1" cellspacing="2">
<tr align="center"><p align="center"> ADD  |  DELETE  |  UPDATE </p></tr>
<tr></tr>
 
<tr>
<td align="right">
Job Name :
</td>
<td align="left">
 
<select  name="combo1" id="abc" onchange="javascript: a();" >
<option selected="selected" value="select">select</option>
 
<%
while(rset.next())
{

String str=rset.getString("Job_Name");
out.println("<option value="+str+">"+str+"</option>");
}
%>
 
</select>
 
 
 
<script type="text/javascript">
function a()
{
document.jobform.action="";
document.jobform.submit();
}
</script>
 
 
 
</td>
</tr>
 
<tr>
<td align="right">
Job Seq. No :
<input type="text" width="20" value="">
</td>
<td align="left">
 
</td>
</tr>
 
<tr>
<td align="right">
Run Schedule Code Desc :
</td>
<td align="left">
<input type="text" width="20">
</td>
</tr>
</table>
</form>
 
</td></tr>
</table>
 
</body>
</html>

i wanna know if scriplet will run inside jscript??? how to approach dis issue.

[BPSouther: Added code tags]
[ April 25, 2008: Message edited by: Ben Souther ]

Ben Souther

Sheriff

Posts: 13411

I like...

posted 9 years ago

Hi venkatesh,

Welcome to Javaranch.
What you're trying to do is very common.
Search this, our HTML/Javascript forum, and/or Google for
'cascading select lists' or dependent 'select lists' and
you should find plenty of solutions.

This is commonly done using AJAX (which is discussed in our HTML forum).

One thing to keep in mind when asking or searching about this is that HTML (and thus JSP) does not
have a 'combo box' control.
It does have a select list which is commonly called a dropdown list.

-Ben
[ April 25, 2008: Message edited by: Ben Souther ]

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf

venkatesh warlu

Ranch Hand

Posts: 33

posted 9 years ago

thanks ben .. since i m new to java ranch.. i didnt know about other forums. i will follow your guidelines.. i ll search as said.

Subhash Chandran

Greenhorn

Posts: 5

posted 9 years ago

[Edit: please restrict promotional post to the Blatant Advertising forum]
[ July 05, 2008: Message edited by: Bear Bibeault ]

Bear Bibeault

Author and ninkuma
Marshal

Posts: 66205

151

I like...

posted 9 years ago

"Subu cc",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]

Combo box problem in jsp

Similar Threads