Division division = new Division("A", standard,"paplubhai",new Integer(50),new Integer(20),new Date());
this.divisionDAO.save(division);
Date dateOfAdmission = new Date();
Student student = new Student("123123","345345",standard,dateOfAdmission,details);
student.setDivision(division);
this.studentDAO.save(student);
List<Student> listOfStudents = this.studentDAO.getAll();
assertNotNull(listOfStudents);
assertEquals(1, listOfStudents.size());
listOfStudents = this.studentDAO.getByAdmissionNumber("123123");
assertNotNull(listOfStudents);
assertEquals(1, listOfStudents.size());
listOfStudents = this.studentDAO.getByFormNumber("345345");
assertNotNull(listOfStudents);
assertEquals(1, listOfStudents.size());
listOfStudents = this.studentDAO.getByStandard(standard);
assertNotNull(listOfStudents);
assertEquals(1, listOfStudents.size());
listOfStudents = this.studentDAO.getByStandardAndDivision(standard, division);
assertNotNull(listOfStudents);
assertEquals(1, listOfStudents.size());
Student student2 = this.studentDAO.get(student.getStudentId());
assertNotNull(student2);
DatabaseOperation.DELETE_ALL.execute(connection, studentDataSet);
DatabaseOperation.DELETE_ALL.execute(connection, divisionDataSet);
DatabaseOperation.DELETE_ALL.execute(connection, standardDataSet);