System.out.println("===============students==== firstname, middlename, lastname, fname, dob, address, Curriculum, Grade;===========");
out.println("<html><body background=welcome.jpg ><h1 align=center ><font color=blue>Student Details</font></h1><br><table border =1 align=center ><tr><th>FirstName</th><th>Middle Name</th><th>LastName</th> <th>Father Name</th> <th>Date of birth</th> <th>Address</th> <th>Curriculum</th> <th>Grade</th></tr>");
while(rs.next()){
Student s = new Student();
s.setStudentid(rs.getInt(1));
s.setFirstname(rs.getString(2));
s.setMiddlename(rs.getString(3));
s.setLastname(rs.getString(4));
s.setFname(rs.getString(5));
s.setDob(rs.getString(6));
s.setAddress(rs.getString(7));
s.setCurriculum(rs.getString(8));
s.setGrade(rs.getString(9));
l.add(s);
System.out.println("student name:"+s.getFirstname());
out.println("<tr><td>"+s.getFirstname() +"</td><td>"+s.getMiddlename()+"</td><td>"+s.getLastname()+"</td><td>"+s.getFname()+"</td><td>"+s.getDob()+"</td><td>"+s.getAddress()+"</td><td>"+s.getCurriculum()+"</td><td>"+s.getGrade()+"</td></tr>");
}
out.println("</table border=3 ></body></html>");
out.println("<br/><br/>");
out.println(" <h2 align=center><a href=./student.jsp>Register a new Student</a><br/></h2>");