• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Attendance Record

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Nups Dhawan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Do not set lab on fire. Or this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic