views:

37

answers:

1

I made a database, I am printing my required field in a marquee.

Now i want that

if (change>0);
print (image_21);
else print (image_2);

This is the code I am using:

<%@page  import="java.sql.*" %>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <script type="text/javascript">


          fucntion img()
            {
                if(change > 0)
                upimg();

                 else
                downimg();

            }
                    function upimg()
    {
             <img src="up.png" >
    }
           function downimg()
    {
             <img src="down.png">
    }  
        </script>
    </head>
    <body onload=" img() " >


    <marquee style="font-size: 28pt; text-transform: uppercase; font-family: Times New Roman; color: #000fff; font-weight: bold">

    <% 
try{
try{}
catch(Exception e)
{}


    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection conn=DriverManager.getConnection("jdbc:odbc:all","","");

         Statement stat=null;
     ResultSet rst=null;
     stat=conn.createStatement();


             String query="select * from list ";
             rst=stat.executeQuery(query);

             while(rst.next())
             {


String Company=(String)rst.getString("Company");
String Open_Price=(String)rst.getString("Open_Price");
String change=(String)rst.getString("change");


    out.println(Company);
    out.println("  ");
    out.println(Open_Price);
    out.println(",");        
}
}
catch(Exception e)
        {
    }

%>


    </marquee>



    </body>
</html>

Can anybody please help?

A: 

I'm afraid you're mixing up JSP and Javascript issues.

I notice that in the server side (i.e. JSP code) you're eating up any Exception thrown:

catch(Exception e) { }

which is bad, making it impossible to detect any underlying problem.

Aside from that, and assuming that change is valid Javascript (i.e. client-side) variable (I can't see it referenced anywhere else), I think there is a problem in the Javascript function:

function upimg()
{
     <img src="up.png" >
}

I'd rather put a static <img> in the HTML body, and dynamically change its source:

<body onLoad="img ()">
    ...
    <img name="dynImg" />
</body>

and then

function upimg()
{
    document["dynImg"].src = "up.png";
}

(Check the syntax).

AndreaG