• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to - Display database rows in a calendar format

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I need to display rows from a database in an interactive calendar on my web front end. The dates are stored in an Informix database in format dd/mm/yyyy. I am trying to build an interactive diary format and want to display start and end dates in a calendar style display but am a little unsure where to start, any suggestions appreciated.
 
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is your question: "how do I format the dates" or "how do I build an interactive calender"
 
Connie Kamrowski
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry for the misunderstanding.

I am comfortable with formats and have no issues with the Java to get the information I want. I have not had a lot to do with JSP but it has been requested as the development environment for my pages. I need some direction on how to create the calender. I want it to display the days of the month and in each day the information recorded for that particular date in my database. I would also like to make it interactive but I have no issue with how to create that once I get my head around displaying the data as a calender. I realise this is probably newbie stuff. My experience to date has been rather specialised.
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
So, your question is how to display the data in calender like structure while presenting? You need a display algorithm, right??
 
Connie Kamrowski
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes. I do not know how to display my results in a calendar format. I ahev not done this before.
 
Bartender
Posts: 1845
10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I guess that makes the problem less one of JSP, and more of HTML/dHTML design.

What do you want the calendar to look like on the screen?
Can you create a static version of that in HTML/javascript?
Then you just need to convert that to build the HTML dynamically with JSP.
 
Connie Kamrowski
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Your right it probably is more a HTML issue, I want to display it as a month at a glance type display.
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Connie Kamrowski:
... but am a little unsure where to start, any suggestions appreciated.



I would start by playing around with some small command line apps that work with the GregorianCalendar class. Most of what you will need for date handling should be right there.
http://java.sun.com/j2se/1.5.0/docs/api/java/util/GregorianCalendar.html
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic