Forum:

HTML Pages with CSS and JavaScript

ask for the pass value

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i want to passing value in the same page. i want the user to choose the data from the combo box in the page, after the user select the data will directly retrieve out from the database depend on the information selected and display out in the same page. is it posible to do it?

if can please provide me suggestion and comment. thank you for the help.

regards,
albert

JAVA the only can called technology

Ajith George

Ranch Hand

Posts: 109

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If you want to do this with out submitting the page upon dropdown value selection, you need to use AJAX or some thing similar.

Another method: You can initialy fetch whole data and store it on local variables when page loads initialy. This is a very bad way of coding.

Next method is submit the page upon onChange and retrive data and show it according to the selection.

SCJP 1.4, Brainbench
LinkedIn - Blog

Bear Bibeault

Sheriff

Posts: 67752

173

I like...

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moved to the HTML/Javascript forum.

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

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

albert sie

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i still get nothing of this. if i using httprequest method can

can you provide some of the tutorial about this matter thank you

JAVA the only can called technology

Niki Nono

Ranch Hand

Posts: 256

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

that is called AJAX.
this whole forum has innumerable posts related to AJAX.
Try googling. you will find many links which provide free tutorials.

Life called,so here I am.<br />Cheers<br />Niki.:-)

albert sie

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i really cannot get what the ajax talking about. i want to get the value that user select in the combo box and pass it to the same page for doing data retrieving from database. but i no idea to do it. i also go through the xmlHttpRequest but i still donno how to create it. AJAX really hard to learn lah.
any one here please give me the solution and enlighten me in this problem . thank you.

regards,
albert

JAVA the only can called technology

Thara Visu

Ranch Hand

Posts: 87

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all,
I am not sure if I understand the situation, but shouldn't a submit on the onchange of the dropdown work? Should we opt for AJAX in such a situation also?

Thara<br />SCJP 1.4 96%<br />SCBCD 1.3 96%

Eric Pascarello

author

Posts: 15385

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Look at this post here which points to a sample chapter in my book and another example.

Eric

Eric Pascarello

author

Posts: 15385

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

whooops...the link: https://coderanch.com/t/117416/HTML-JavaScript/ajax-dynamic-combo

albert sie

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

my situation is like this, i have 1 jsp page. in the jsp page i have 2 combo box for user to select. what i want is after the user do the selection in 2 combo box, the page will directly retrieve out the data depend on the combo box value selected by user. so the main key is the value in combo box. how i gotta to write this code to make it can retrieve the database after user select and without reload the page. please provide me the relevent example. i also go through many AJAX material but i don't understand what the usage of the coding. i want the page write in jsp and java code.

thank you.
regards,
albert

JAVA the only can called technology

Eric Pascarello

author

Posts: 15385

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

And you are going to pay us how much to code it for you? You need to try to get it to work. Show us what you have tried.

Eric

Niki Nono

Ranch Hand

Posts: 256

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

if yiou want to do anything related to the database then you have got to go to the server. there are two ways of doing it in javascript which i am aware of. One is to post the whole page to a second JSP which will act on the values recived and prepare the html that you want.
Another is to use AJAX which will fetch the data from the server without refereshing the whole page.

you need to do this onchange of the second select box.
Please do not ask for code, you can write it on your own. Ultimately code is not that important, understanding the concept is important because that is what you remember and not the code.
just a friendly advice.

Life called,so here I am.<br />Cheers<br />Niki.:-)

albert sie

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

HERE IS THE CODE THAT I WRITE, I STUCK IN THE AJAX PART.

<%@page import = "java.sql.*,java.util.*,java.text.SimpleDateFormat,java.text.*"%>
<jsp:useBean id = "db" class="bgoc.dbConn.Conn" scope="request" />

<html>
<head>
<title>LA Detail</title>
<script language="javascript"  type="text/javascript">
function hide(){
document.all.la_no.disabled=false;
}
var url="getdata.jsp?supl=";
var url2=",la=";
function handleHttpResponse(){
if(http.readyState==4){
document.all.supl_typ.option.value=result;
document.all.la_no.value=;
}
 
function getData() {
if (http){
var supl_val=document.all.supl_typ.value;
var la_no=document.all.la_no.value;
http.open("GET", url+escape(supl_val)+url2+escape(la_no),true);
http.onreadystatechange = handleHttpResponse;
isWorking=true;
http.send(null);
}
}
 
function getHTTPObject() {
var xmlhttp;
/*@cc_on
@if (@_jscript_version >= 5)
try {
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (E) {
xmlhttp = false;
}
}
@else
xmlhttp = false;
@end @*/
if (!xmlhttp && typeof XMLHttpRequest != 'undefined') {
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
xmlhttp = false;
}
}
return xmlhttp;
}
var http = getHTTPObject(); // We create the HTTP Object
 
</script>
 
</head>
 
<body> 
<h1 style="font-family:Times New Roman; font-weight:bold; text-align:center;color:#0000FF" >LA Detail</h1>
<hr size=3 color=#87CEFA></br>
<table border=0 width=80%><tr><td>
<%//----------------------retrieve suplier type and la number into combo box for user select----------------------------------%>
<form method="post">
Supplier type</td><td>:<select name="supl_typ" onchange="hide()">
<option selected>select one</option>
<%Connection conn = db.getConnection(); 
String supl_typ=null;
int la_no=0;
String user_sel="select distinct mrl_supl_typ from mrlahf";
ResultSet getuser_sel=null;
try{
getuser_sel=db.execSQL(user_sel);
while(getuser_sel.next()){
supl_typ=getuser_sel.getString("mrl_supl_typ");
if (supl_typ.equals("P")){
%>
<option value=<%=supl_typ%>>Contractor</option>
<%}else{%>
<option value=<%=supl_typ%>>Clients</option>
<%}
}
}catch(SQLException e){
            System.err.println("error " + e);
        }%>
</select></td></tr>
<tr><td>LA number</td><td>:<select name="la_no" disabled=true onchange="getData()"> 
<%String user_sel2="select mrl_la_no from mrlahf";
ResultSet getuser_sel2=null;
try{
getuser_sel2=db.execSQL(user_sel2);
while(getuser_sel2.next()){
la_no=getuser_sel2.getInt("mrl_la_no");%>
<option><%=la_no%></option>
 
<%}
}catch(SQLException e){
            System.err.println("error " + e);
        }%>
</select></form></td>
<%//-----------------------------------------finish retrieve supltype and la number ---------------------------------------------%>
<%//-----------------------------------retrieve the detail of the LA from the mrlahf table---------------------------------------

String la_typ=null;
int proj=0;
int cont=0;
String iss_dte=null;
String la_desc=null;
String comm_dte=null;
String sub_typ=null;
String pay_trm=null;
String meet_day=null;
String meet_time=null;
String meet_freq=null;
String proj_nme=null;
String cont_nme=null;
int subm_pro_clm1=0;
int subm_pro_clm2=0;
int x_no=0;
String x_desc=null;
int y_no=0;
String y_desc=null;
String la_sql= "SELECT * FROM mrlahf,mbdept,povend where mrl_la_no="+la_val+" and mrlahf.mrl_jp_cde=mbdept.mbd_proj_cde "+
"and mrlahf.mrl_supl_cde=povend.pv_supl_cde";
ResultSet getresult = null;
 
try{
getresult=db.execSQL(la_sql);
while(getresult.next()){
la_typ=getresult.getString("mrl_la_typ");
proj=getresult.getInt("mrl_jp_cde");
cont=getresult.getInt("mrl_supl_cde");
iss_dte=getresult.getString("mrl_iss_dte");
la_desc=getresult.getString("mrl_desc_1");
comm_dte=getresult.getString("mrl_start_dte");
sub_typ=getresult.getString("mrl_sub_typ");
pay_trm=getresult.getString("mrl_trm");
meet_day=getresult.getString("mrl_meet_day");
meet_time=getresult.getString("mrl_meet_time");
meet_freq=getresult.getString("mrl_meet_freq");
subm_pro_clm1=getresult.getInt("mrl_day_subm_clm_1");
subm_pro_clm2=getresult.getInt("mrl_day_subm_clm_2");
x_no=getresult.getInt("mrl_xs_brk_no");
x_desc=getresult.getString("mrl_xs_desc");
y_no=getresult.getInt("mrl_ys_brk_no");
y_desc=getresult.getString("mrl_ys_desc");
proj_nme=getresult.getString("mbd_proj_nme");
cont_nme=getresult.getString("pv_supl_nme");
}
}catch(SQLException e){
            System.err.println("error " + e);
        }%>

<%if(la_typ.equals("1")){%>
<td>LA Type</td><td>: By BQ</td></tr>
<%}else{%>
<td>LA Type</td><td>: By schedule of payment</td></tr>
<%}%>
<tr><td>Project</td><td>: [<%=proj%>] [<%=proj_nme%>]</td></tr>
<tr><td>Contractor</td><td>: [<%=cont%>] [<%=cont_nme%>]</td>
<td>Issue Date</td><td>: <%=iss_dte%></td></tr>
<tr><td>LA Description</td><td>: <%=la_desc%></td></tr>
<tr><td>Commencement Date</td><td>: <%=comm_dte%></td>
<%if(sub_typ.equals("L")){%>
<td>Sub-Con type</td><td>: Labour Sub</td></tr>
<%}else if(sub_typ.equals("T")){%>
<td>Sub-Con type</td><td>: Total Sub</td></tr>
<%}else if(sub_typ.equals("K")){%>
<td>Sub-Con type</td><td>: Turn key</td></tr>
<%}%>
<tr><td>Site Meetings-Day</td><td>: <%=meet_day%></td>
<td>Payment term</td><td>: <%=pay_trm%></td></tr>
<tr><td>                   
 -Time</td><td>: <%=meet_time%></td></tr>
<tr><td>                   
 -Frequency</td><td>: <%=meet_freq%></td></tr>
<tr><td>Submission of progress claim</td><td>: <%=subm_pro_clm1%>/<%=subm_pro_clm2%></td></tr>
<%if(x_no == 0 ){

}else{%>
<tr><td>Breakdown:</td></tr>
<tr><td>X-axis</td><td>: <%=x_no%> <%=x_desc%></td></tr>
<tr><td>Y-axis</td><td>: <%=y_no%> <%=y_desc%></td></tr>
<%}%></table>
<%//----------------------------------end of the retrieve of LA Detail from the mrlahf-------------------------------------------%>

<%//----------------------------retrieve the Work Package and Line information from mrladf---------------------------------------%>
<%int wp=0;
int ln=0;
String wpln_desc=null;
String item=null;
String item_desc=null;
int quantity=0;
int vo_no=0;
String vo_typ=null;
String wp_info="select distinct * from mrladf, inmast, mrlatf where mrladf.pf_la_no=493 and mrladf.pf_item_num=inmast.in_num and mrlatf.pt_la_no=mrladf.pf_la_no";
ResultSet getInfo=null;
try{%>

<table border=1 width=100%>
<tr style="background:#87CEFA">
<th>WP</th>
<th>LN</th>
<th>WP/LN description</th>
<th>Item</th>
<th>Item Description</th>
<th>Quantity/LS</th>
<th>VO No</th>
<th>VO Type</th></tr>

<%getInfo=db.execSQL(wp_info);
while(getInfo.next()){
wp=getInfo.getInt("pf_wp_no");
ln=getInfo.getInt("pf_ln_no");
item=getInfo.getString("pf_item_num");
item_desc=getInfo.getString("in_desc_1");
quantity=getInfo.getInt("pf_take_off_qty");
vo_no=getInfo.getInt("pf_vo_no");
vo_typ=getInfo.getString("pf_vo_typ");
//wpln_desc=getInfo.getString("pt_desc_1");
%><tr>
<td><%=wp%></td>
<td><%=ln%></td>
<td><%//<%=wpln_desc%></td>
<td><%=item%></td>
<td><%=item_desc%></td>
<td><%=quantity%></td>
<td><%=vo_no%></td>
<td><%=vo_typ%></td></tr>
<%}%></table>
<%}catch(SQLException e){
            System.err.println("error " + e);
        }%>

</p>
<div align="center"><input type="button" value="Main Menu">
<input type="button" value="Back"></div>
 
</body>
</html>

JAVA the only can called technology

albert sie

Ranch Hand

Posts: 108

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i request to close this topic. i think i need to understand more about the ajax, so i make decision to close this topic and open a new topic to understand the ajax from the beginning. thank you for the co operation .

JAVA the only can called technology

For my next trick, I'll need the help of a tiny ad ...

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing