aspose file tools*
The moose likes JSP and the fly likes Attendance Record Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Attendance Record" Watch "Attendance Record" New topic
Author

Attendance Record

Nups Dhawan
Greenhorn

Joined: Nov 24, 2012
Posts: 2
Can please anyone suggest me how would I start attendance module for my project which is related to school..I mean in which form school attendance are displayed for Admin & Teachers of all the students I am very much confused as I have never seen attendance of students displayed on website .There are 12 Std in school & each standard has many sections & each section has many students so how can we manage to display attendance of each & every student.
I am using JSP as my front end & MS access as my back end. So how would I design Table in Access for storing attendance.

Please provide solution as soon as possible in the form of relevant code..
Thanks
Nupur Dhawan
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29254
    
140

See NotACodeMill for why nobody is going to provide the relevant code.

To start out, draw on paper what you might show on the screen. There isn't one right answer to this. Just try. If you have specific questions, folks here will help. But they will not do your homework assignment for you.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Nups Dhawan
Greenhorn

Joined: Nov 24, 2012
Posts: 2
Jeanne Boyarsky wrote:See NotACodeMill for why nobody is going to provide the relevant code.

To start out, draw on paper what you might show on the screen. There isn't one right answer to this. Just try. If you have specific questions, folks here will help. But they will not do your homework assignment for you.

Thanks for replying ..I have just made the same module but its not working the way i want it to work.
I have made table in access named one field as date of type string but when i m using between query to fetch record between dates i am geeting wrong output..I may show you the code
<% String name=(String)session.getAttribute("username");
String classId=request.getParameter("n1");
String from=request.getParameter("T4");
String to=request.getParameter("T5");

if(name!=null )
{
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:School_mgmt");
String sql1="SELECT * FROM Attendance_Record WHERE ClassID='"+classId+"' AND DateofAtt BETWEEN '"+from+"' AND '"+to+"' ";
// out.print(sql1);
Statement stmt1=con.createStatement();
ResultSet rs=stmt1.executeQuery(sql1);
%>

the table is displayed in this form

<% while(rs.next()) { //java.util.Date a=rs.getDate(5); String a=rs.getString(5); String b=rs.getString(1); String c=(String)rs.getString(2); String d=(String)rs.getString(3); %> <% }%>
Date Student ID Student Name Status
<%=a%> <%=b%> <%=c%> <%=d%>


Now can you please help me..Thanks
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29254
    
140

Yes, now we can help! SHowing effor is what matters and you certainly did that.


This code doesn't appear to match your output. Perhaps there was a little more code after that? My guess is that you have an extra set of <% %> around a/b/c/d.

Also, note that it is considered bad practice to put Java code in a JSP. Especially JDBC. It is harder to write, debug and maintain. After your assignment, I recommend you read up on MVC.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Attendance Record
 
Similar Threads
Multiple Object Select Problems
How to model a relation where a column has to refer two columns in different tables?
Magic Number 7 ??
Can I use Hibernate in my RFID based attendance tracking application?
Class Diagram - How to model requirements ??