wood burning stoves 2.0*
The moose likes JSP and the fly likes How to - Display database rows in a calendar format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "How to - Display database rows in a calendar format" Watch "How to - Display database rows in a calendar format" New topic
Author

How to - Display database rows in a calendar format

Connie Kamrowski
Greenhorn

Joined: Aug 15, 2004
Posts: 23
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.


**How much deeper would the ocean be if Sponges didn't grow in it?**
Daniel Rhoades
Ranch Hand

Joined: Jun 30, 2004
Posts: 186
Is your question: "how do I format the dates" or "how do I build an interactive calender"


Drinking more tea is the key...
Connie Kamrowski
Greenhorn

Joined: Aug 15, 2004
Posts: 23
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

Joined: Aug 15, 2004
Posts: 2874
So, your question is how to display the data in calender like structure while presenting? You need a display algorithm, right??
Connie Kamrowski
Greenhorn

Joined: Aug 15, 2004
Posts: 23
Yes. I do not know how to display my results in a calendar format. I ahev not done this before.
Stefan Evans
Bartender

Joined: Jul 06, 2005
Posts: 1016
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

Joined: Aug 15, 2004
Posts: 23
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

Joined: Dec 11, 2004
Posts: 13410

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


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to - Display database rows in a calendar format
 
Similar Threads
Appointment Calendar
Iterating Through Dates
dates between two dates
Appointment Calendar
how do i get todays dat without the time