JPA

JPA增加 删除 获取 修改映射

@RequestMapping("/addCategory")
public String addCategory(Category c) throws Exception {
	categoryDAO.save(c);
	return "redirect:listCategory";
}
@RequestMapping("/deleteCategory")
public String deleteCategory(Category c) throws Exception {
	categoryDAO.delete(c);
	return "redirect:listCategory";
}
@RequestMapping("/updateCategory")
public String updateCategory(Category c) throws Exception {
	categoryDAO.save(c);
	return "redirect:listCategory";
}
@RequestMapping("/editCategory")
public String editCategory(int id,Model m) throws Exception {
	Category c= categoryDAO.getOne(id);
	m.addAttribute("c", c);
	return "editCategory";
}

JPA分页

@RequestMapping("/listCategory")
public String listCategory(Model m,@RequestParam(value = "start", defaultValue = "0") int start,@RequestParam(value = "size", defaultValue = "5") int size) throws Exception {
	start = start<0?0:start;
	Sort sort = new Sort(Sort.Direction.DESC, "id");
	Pageable pageable = new PageRequest(start, size, sort);
	Page<Category> page =categoryDAO.findAll(pageable);
	m.addAttribute("page", page);
    return "listCategory";
}

如果new Sort和new PageRequest报错，原因是SpringBoot版本太高，改为Sort.by和PageRequest.of

@RequestMapping("/listCategory")
    public String listCategory(Model m,
                               @RequestParam(value="start",defaultValue ="0") int start
                              ,@RequestParam(value = "size",defaultValue = "5")int size)
                              throws Exception{
        start=start<0?0:start;
        Sort sort=Sort.by(Sort.Direction.DESC,"id");
        Pageable pageable=PageRequest.of(start,size,sort);
        Page<Category> page = categoryDAO.findAll(pageable);

        System.out.println(page.getNumber());
        System.out.println(page.getNumberOfElements());
        System.out.println(page.getSize());
        System.out.println(page.getTotalElements());
        System.out.println(page.getTotalPages());

        m.addAttribute("page",page);
        return "listCategory";
    }

JPA条件查询