Gradle+SpringBoot+JPA单表的增删改查实例

package com.example.controller; import com.example.entity.User; import com.example.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import java.util.ArrayList; import java.util.Iterator; import java.util.List; @Controller public class UserController { @Autowired private UserService userService ; //http://localhost:8101/GradleDemo1/hello @RequestMapping(value ="/hello",method = RequestMethod.GET) @ResponseBody public String hello(){ return "hello"; } /** *根据用户名查找 * http://localhost:8101/GradleDemo1/findUserByUserName?name=wanglan */ @RequestMapping(value = "/findUserByUserName",method = RequestMethod.GET) @ResponseBody public String findUserByUserName(@RequestParam("name") String username){ User user = null ; user = userService.findUserByUserName_(username) ; if(user == null){ return "controller层：您所查找的用户名不存在！"; }else{ return user.toString(); } } /** *根据id查找 * http://localhost:8101/GradleDemo1/findUserById?userid=1 */ @RequestMapping(value = "/findUserById",method = RequestMethod.GET) @ResponseBody public String findUserById(@RequestParam("userid") Long userid){ User user = null ; user = userService.findOne_(userid) ; if(user == null){ return "controller层：您所查找的用户名不存在！"; }else{ return user.toString(); } } /** *根据address查找 * http://localhost:8101/GradleDemo1/findUsersByAddress?addr=扶风 */ @RequestMapping(value = "/findUsersByAddress",method = RequestMethod.GET) @ResponseBody public String findUsersByAddress(@RequestParam("addr") String address){ User user = null ; List<User> list = null; list = userService.findUsersByAddress_(address) ; if(list == null){ return "controller层：您所查找的用户名不存在！"; }else{ return list.toString()+";\n"; } } /** *添加user * localhost:8101/GradleDemo1/addUser?userid=66&username=wanglan666&password=wanglan666&address=宝鸡 */ @RequestMapping(value = "/addUser",method = RequestMethod.GET) @ResponseBody public String addUser(User user){ User user1 = userService.save_(user) ; if(user1 == null){ return "controller层：您所注册的用户名已经被占用！"; }else{ return user1.toString()+"添加成功！"; } } /** *根据id删除user * localhost:8101/GradleDemo1/deleteUserById?id=24 */ @RequestMapping(value = "/deleteUserById",method = RequestMethod.GET) @ResponseBody public String deleteUserById(@RequestParam("id") Long userid){ String msg = userService.deleteUserById_(userid) ; if(msg.equals("0")){ return "controller层：您所删除的用户名不存在！"; }else{ return "删除成功！"; } } /** *根据用户名删除user * localhost:8101/GradleDemo1/deleteUserByUsername?name=孙伟 */ @RequestMapping(value = "/deleteUserByUsername",method = RequestMethod.GET) @ResponseBody public String deleteUserByUsername(@RequestParam("name") String username){ String msg = userService.deleteUserByUsername_(username) ; if(msg.equals("0")){ return "controller层：您所删除的用户名不存在！"; }else{ return "删除成功！"; } } /** *根据id修改user * localhost:8101/GradleDemo1/updateUserById?userid=25&username=wanglan7&password=wanglan7&address=故乡扶风 */ @RequestMapping(value = "/updateUserById",method = RequestMethod.GET) @ResponseBody public String updateUserById(String username,String password,String address,Long userid){ User user = userService.updateUserById_(username,password,address,userid) ; User user2 = new User(userid,username,password,address); if(user == null){ return "controller层：您所修改的用户名不存在！"; }else{ return "用户"+user.getUsername()+"信息修改成功！\t\n"+ "▷修改前：" + " 【" + user.toString() + "" + " 】;\r\n" + " ▷修改后：【" + user2.toString() + "】 修改成功！"; } } /** *根据name修改user * * localhost:8101/GradleDemo1/updateUserByUsername?username=wl&password=wl&address=陕西省扶风县&userid=99 */ @RequestMapping(value = "/updateUserByUsername",method = RequestMethod.GET) @ResponseBody public String updateUserByUsername(Long userid,String password,String address,String username){ User user = userService.updateUserByUsername_(userid,password,address,username) ; User user2 = new User(userid,username,password,address); if(user == null){ return "controller层：您所修改的用户名不存在！"; }else{ return "▷修改前：" + " 【" + user.toString() + "" + " 】;\r\n" + " ▷修改后：【" + user2.toString() + "】 修改成功！"; } } /** * localhost:8101/GradleDemo1/findAllToPage?page=1&size=3 * 以3条记录为一页，查找第三页的三条数据，按ID升序排列。page=0是第一页 * defaultValue="0"默认访问第一页 */ @RequestMapping(value = "/findAllToPage",method = RequestMethod.GET) @ResponseBody public String findAllToPage(@RequestParam(value = "page",defaultValue="0") Integer page, @RequestParam(value = "size",defaultValue = "5")Integer size){ Sort sort = new Sort(Sort.Direction.ASC,"userid"); Pageable pageable = new PageRequest(page,size,sort); Page<User> pageAll = userService.findAllToPage(pageable) ; Iterator<User> pageIterator = pageAll.iterator() ; List<User> list = new ArrayList<User>(); while(pageIterator.hasNext()){ list.add((User) pageIterator.next()); } return list.toString()+pageable.toString() ; } }