Forum:

Help ME PLZ. Very Soon..

Greenhorn

Posts: 14

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Friends!!
How can i use JavaScript Variable within JSP page..
like my requirement is, i want to use that JavaScript variable in a SQL-query (everything within JSP page)..
plz look into this code below..
--code start--

<%@page language="java" import="java.sql.*" %>
<html><head><title>Report Page..</title>
<STYLE type="text/css">
P#pid1 { font-size: 9pt; color: 'brown'; font-weight: 'bold'; }
P#pid2 { font-size: 9pt; color: 'brown'; font-weight: 'bold'; }
P#pid3 { font-size: 9pt; color: 'brown'; font-weight: 'bold'; }
select#selectid1 { color: 'blue'; font-size: 7pt; font-stretch: narrower; }
select#selectid2 { color: 'blue'; font-size: 7pt; font-stretch: narrower; }
select#selectid3 { color: 'blue'; font-size: 7pt; font-stretch: narrower; }
</style>
<SCRIPT>
var str1_mod;
function func(str1)
{
var x=10;
str1_mod=str1.substr(x,2);
return str1_mod;
}
</SCRIPT>
</head>
<body bgcolor='antiquewhite'>
<form name="form1">
<%
String st1="",st2="",st3="",st4="",st5="",st6="";
Connection conn=null;
Statement stmt,stmt1,stmt2;
try
{
out.println("<table border=0 cellspacing=0 cellpadding=0><TR><TD><P id='pid1' align=right>Department:</P></TD><TD><SELECT id='selectid1' NAME='DEPTSELECT'>");
Class.forName("oracle.jdbc.OracleDriver");
conn=DriverManager.getConnection("jdbc :-o	 racle:thin:gwdev/gwdev@192.168.10.5:1521 :mrgreen: evdb");
stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select dep_id_itm,dep_name_itm from imdept order by dep_id_itm");
 while(rs.next())
 {
    st1=rs.getString(1);
    st2=rs.getString(2); 
    out.println("<option>"+st2+"::"+st1);
 }
out.println("</SELECT>");
out.println("</TD><TD><P id='pid2' align=right>Category:</P></TD><TD><SELECT id=selectid2 NAME='CATSELECT' onFocus='func(form1.DEPTSELECT.options[form1.DEPTSELECT.selectedIndex].text)'>");
stmt1=conn.createStatement();
ResultSet rs1=stmt1.executeQuery("select ctg_id,ctg_name from imctgy where ctg_dep_id_itm=\'"+str1_mod+" \' order by ctg_id");
out.println("</SELECT>");
}
catch(Exception e)
{
   out.println("Connection Failed.::::.");
   out.println("</form></body</html>");
}
%>
</TD></TR></TABLE>
</FORM></BODY></HTML>

--code end--
in the above code, how can i use JavaScript variable (str1_mod) outside the html page in a query while preparing servlet code(observe the query)...if i run the above code, 'am getting compilation error of UnKnown Variable str1_mod ..
'am using Tomcat4.1.18 server..
'am in real-need of you..
Kindly Help me Plz..
thanks in advance,to everyone,
anticipating replies very eagerly..
Sreekanth.

Anonymous

Ranch Hand

Posts: 18944

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i didn't check your complete code, but as far as i understood you want to use a Javascript variable in a JSP.
The way you are trying to do this will never work, cause the JSP code is executed on server side and your javascript on client side. This means
while the JSP is created and delivered to the client. Then on client side
the Javascript variable is set.
Try to create a form which has another JSP or Servlet as action. To this
you pass the content of your Javascript variable over some parameter in the URL (GET) or within a hidden field you filled with your javascript code.
Hope that helps you out