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?