[FIXED] How to list data from database in a web page in spring framework

Issue

I have created a database called student base on the tutorial provided by tutorials point PDF, they have covered how to map the form and insert values in to the database using controllers, but they have not explained how to display the data from the database on to the webpage.

My code to list all students.

@Override
public List<Student> listStudents() {
    String SQL = "select * from Student";
    List<Student> students = jdbcTemplateObject.query(SQL, new StudentMapper());
    return students;
}

How to call this from my controller in spring and return the list to my webpage.

My contoller is given below

@Controller 
public class StudentController {
 @RequestMapping(value = "/student", method = RequestMethod.GET) 
 public ModelAndView student() 
 { 
     return new ModelAndView("student", "command", new Student()); 
 } 
 @RequestMapping(value = "/addStudent", method = RequestMethod.POST) 
 public String addStudent(@ModelAttribute("SpringWeb")Student student, ModelMap model) 
 { 
     ApplicationContext context = new ClassPathXmlApplicationContext("Beans.xml");
     StudentJDBCTemplate studentJDBCTemplate = (StudentJDBCTemplate)context.getBean("studentJDBCTemplate");
     studentJDBCTemplate.create(student.getName(), student.getAge());
     model.addAttribute("name", student.getName()); 
     model.addAttribute("age", student.getAge()); 
     model.addAttribute("msg", "Student Enrolled"); 
     return "result"; 
 } 

 // How to write the listing controller?
}

Solution

From the details you provide ,

public String ListStudents(ModelMap model) 
 { 
     List<Student> list= YourServiceClassObj.listStudents();
      model.addAttribute("result", list);
     return "View Name here"; 
 } 

Answered By - Santhosh
Answer Checked By - Candace Johnson (JavaFixing Volunteer)