spring - 如何在Spring框架的网页中列出数据库中的数据

Question

我根据教程点 PDF 提供的教程创建了一个名为 Student Base 的数据库，他们介绍了如何使用 Controller 映射表单并将值插入数据库，但没有解释如何显示来自数据库到网页。

我的代码列出所有学生。

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

如何在 Spring 从我的 Controller 调用它并将列表返回到我的网页。

下面给出了我的 Controller

@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?
}

Answer 1

根据您提供的详细信息，

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