Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to - Display database rows in a calendar format

 
Connie Kamrowski
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • 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.
 
Daniel Rhoades
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Stefan Evans
Bartender
Posts: 1691
10
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic