how to display one image per day from an array?

Reply
1 2

•
•
Join Date: Jun 2006
Posts: 7,648
Reputation: ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of 
Solved Threads: 473
Super Moderator
Featured Poster
~s.o.s~'s Avatar
~s.o.s~ ~s.o.s~ is offline Offline
Failure as a human

Re: how to display one image per day from an array?

 
0
  #11
May 18th, 2007
The usual "this doesn't work" is not helpful at all. You need to tell us 'what' is not working and what you have tried out. Post the most recent relevant code which shows the concerned logic and then we can work out something.
Last edited by ~s.o.s~; May 18th, 2007 at 1:49 pm.
I don't accept change; I don't deserve to live.

Jo Tujhe Jagaaye, Nindein Teri Udaaye Khwaab Hai Sachcha Wahi.
Nindon Mein Jo Aaye Jise To Bhul Jaaye Khawab Woh Sachcha Nahi.
Khwaab Ko Raag De, Nind Ko Aag De
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 14
Reputation: Thendral is an unknown quantity at this point 
Solved Threads: 0
Thendral Thendral is offline Offline
Newbie Poster

Re: how to display one image per day from an array?

 
0
  #12
May 22nd, 2007
hai..

Here is the code..


Servlet:


ResultSet rsid = null;
ResultSet rsw = null;
ResultSet rscount = null;
int arraylen = -1;
String dbimage = null;
Calendar cal = Calendar.getInstance();
int dayOfWeek = cal.get(cal.day_OF_WEEK);
int daycount = -1;
String sql = "select count(*) as count from banner where flag="+0;
stmt = con.prepareStatement(sql);
rscount = stmt.executeQuery();
while (rscount.next())
{
arraylen = rscount.getInt("count");
}
int[] array = new int[20];
String sql2 = "select imageid from banner where flag="+0;
stmt = con.prepareStatement(sql2);
rsid = stmt.executeQuery();
int loop = 1;
while(rsid.next())
{
array[loop++] = rsid.getInt("imageid");
}

if(arraylen==2)
{
if(dayofweek==1)
daycount=1;
else if(dayofweek==2)
daycount=2;
else if(dayofweek==3)
daycount=1;
else if(dayofweek==4)
daycount=2;
else if(dayofweek==5)
daycount=1;
else if(dayofweek==6)
daycount=2;
else if(dayofweek==7)
daycount=1;
}
else if(arraylen==3)
{
if(dayofweek==1)
daycount=1;
else if(dayofweek==2)
daycount=2;
else if(dayofweek==3)
daycount=3;
else if(dayofweek==4)
daycount=1;
else if(dayofweek==5)
daycount=2;
else if(dayofweek==6)
daycount=3;
else if(dayofweek==7)
daycount=1;
}
else if(arraylen==4)
{
if(dayofweek==1)
daycount=1;
else if(dayofweek==2)
daycount=2;
else if(dayofweek==3)
daycount=3;
else if(dayofweek==4)
daycount=4;
else if(dayofweek==5)
daycount=1;
else if(dayofweek==6)
daycount=2;
else if(dayofweek==7)
daycount=3;
}
else if(arraylen==5)
{
if(dayofweek==1)
daycount=1;
else if(dayofweek==2)
daycount=2;
else if(dayofweek==3)
daycount=3;
else if(dayofweek==4)
daycount=4;
else if(dayofweek==5)
daycount=5;
else if(dayofweek==6)
daycount=1;
else if(dayofweek==7)
daycount=2;
}
else if(arraylen==6)
{
if(dayofweek==1)
daycount=1;
else if(dayofweek==2)
daycount=2;
else if(dayofweek==3)
daycount=3;
else if(dayofweek==4)
daycount=4;
else if(dayofweek==5)
daycount=5;
else if(dayofweek==6)
daycount=6;
else if(dayofweek==7)
daycount=1;
}
else if(arraylen==7)
daycount = dayofweek;
else
daycount=arraylen;
int imageid = array[daycount];
String sql3 = "select image1 from image where imageid=?";
stmt = con.prepareStatement(sql3);
stmt.setInt(1, imageid);
rsw = stmt.executeQuery();
while(rsw.next())
{
dbimage = rsw.getString("image1");
}


Display(JSP):

<html>
<head>
Displaying the Image
</head>
<body bottommargin="0" topmargin="0" rightmargin="0" leftmargin="0" >
<center>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center">
<table width="164" height="198" border="1" cellpadding="0" cellspacing="0" bordercolor="#009933">
<tr >
<td height="28" align="center" bordercolor="#FFFFFF" bgcolor="#ff9c18" class="steps1" >&nbsp;</td>
</tr>
<tr>
<td align="center" valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<p><img src="../../resource/img/<%=dbimage%>" width="130" height="150" border="0"></a> </p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</tr>
</table>
</center>
</body>
</html>



Here i need to change the red colored code. Here i checked for the array length 2,3,4,5,6,&7 and assigning the imageid. I need this to be done dynamically for array length n(1 to n). Some calculation is needed. i used modulo. it is not working. Also i used division. it is not working. Kindly help me for getting some other calculation.

Thanking you..
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2006
Posts: 7,648
Reputation: ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of 
Solved Threads: 473
Super Moderator
Featured Poster
~s.o.s~'s Avatar
~s.o.s~ ~s.o.s~ is offline Offline
Failure as a human

Re: how to display one image per day from an array?

 
0
  #13
May 22nd, 2007
Why doesn't this work in your case:

java Syntax (Toggle Plain Text) 
  1. dayCount = (dayOfMonth - 1) % arraySize;
  2. imageId = myImageArray[dayCount];

Oh and BTW, your logic is wrong, the array indexing starts at 0 and not at 1. So your mesh of 'if' statements which use 1 as the starting index is wrong, unless you have something different planned out.

Plus you are using the wrong method to get the day. You should get the day of month, not the day of week otherwise you would always access the first 7 images since DAY_OF_WEEK ranges between 1 to 7. Use this:

java Syntax (Toggle Plain Text) 
  1. GregorianCalendar c = new GregorianCalendar();
  2. int day = c.get(Calendar.DAY_OF_MONTH);
I don't accept change; I don't deserve to live.

Jo Tujhe Jagaaye, Nindein Teri Udaaye Khwaab Hai Sachcha Wahi.
Nindon Mein Jo Aaye Jise To Bhul Jaaye Khawab Woh Sachcha Nahi.
Khwaab Ko Raag De, Nind Ko Aag De
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



Tag cloud for JSP
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient project read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC