[jaysyshaw]

Hello,

I want to create a scheduling program and I am not sure how to go about it. I am hoping you can point me in the right direction.

I want to create a scheduling program where it would be a rows and columns. The columns would be the days of the week and the rows would be the hours within in that day. Here is what I am talking about http://i45.tinypic.com/10o32bm.png Underneath the columns would be people that are available to make an appointment with on that day and hour. If the person is available during that day and hour the cell would be white and when you click on it another window would pop up and you can enter in your information to create the appointment....if they are not available then it would be black and so and so. I want to be able to store this information using whichever database is simpler....I am considering MySQL, but if you guys think otherwise I'd appreciate your input....


Thank You.
Jay.

[pbl]

If you are familiar with relational database go for it MySql or HSqlDb or any other one
If you are new to Java learning both the GUI and the Database interface will be a lot too much at the same time better to use simpler data interface like arrays or ArrayList

[jaysyshaw]

Im not new to Java so it would'nt be too hard for me to find the answers about the database, but what I also want to know specifically about the grid. How do I go about creating something like that in the image i posted above?

This post has been edited by jaysyshaw: 12 January 2010 - 05:36 PM

[pbl]

For the GUI part: a JTable
For the data part: your SQL db

[jaysyshaw]

Thank you!