File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes need a help ,any one make it soon Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need a help ,any one make it soon" Watch "need a help ,any one make it soon" New topic
Author

need a help ,any one make it soon

Deepthi Xavy
Ranch Hand

Joined: Aug 31, 2009
Posts: 32
Hai friends...

Am doing campus management system..in that for attendance module,for a student per month one column should be used..for the next month next entry has to be made in next row ..and so on...so that the number of entryies will be minimised & it will be easy to retrieve...can any one help me ut from here for this querry please...

Thanks in advance......
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41073
    
  43
That's a complete problem description (albeit lacking many details). Which part of this task are you having problems with? What do you have so far? If you haven't started, what ideas have you had?


Ping & DNS - my free Android networking tools app
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

You could use text column with 31 positions. One position per day.
Put in a '1' if the student attended, put in a '0' if the student was absent, on the position that matches the day.
If the student attended 1 to 3 september, and was absent on the 4th, you would get:


(disclaimer: I am not really a fan of composed columns, it's not quite as per the data normalization rules).

OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need a help ,any one make it soon
 
Similar Threads
Is this true!
Any discounted voucher available for SCWCD to be used in UK?
Date picker
help in Javascript calendar display
When is SCJP 1.4 going to END