package com.example.demo03.conttroller; import com.example.demo03.entity.Person; import com.example.demo03.service.PersonService; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.List; import java.util.Map; @RestController @RequestMapping("/person") public class PersonController { @Resource PersonService personService; //查询 @GetMapping("/findById") public Person selectuserbyid(Integer id) { return personService.findById(id); } //更新 @PostMapping("/update") public Boolean update(@RequestBody Map<String, Object> json) { Integer uid = (Integer)json.get("uid"); String name = (String)json.get("name"); Integer password = (Integer)json.get("password"); Integer role_id = (Integer) json.get("role_id"); Integer phone = (Integer) json.get("phone"); String email = (String)json.get("email"); return personService.update(uid, name, password, role_id, phone, email); } //查询所有 @GetMapping("/list") public List<Person> list() { return personService.list(); } @PostMapping("/store") public Boolean store(@RequestBody Map<String, Object> json) { Integer uid = (Integer)json.get("uid"); String name = (String)json.get("name"); Integer password = (Integer)json.get("password"); Integer role_id = (Integer) json.get("role_id"); Integer phone = (Integer) json.get("phone"); String email = (String)json.get("email"); return personService.store(uid, name, password, role_id, phone, email); } //删除 @GetMapping("/del") public Boolean del(Integer id) { return personService.del(id); } //禁用 @GetMapping("/disable") public Boolean disable(Integer uid) { return personService.disable(uid); } //启用 @GetMapping("enable") public Boolean enable(Integer uid) { return personService.enable(uid); } }
package com.example.demo03.entity; public class Person { private Integer uid; private String name; private Integer creatime; private String password; private Integer role_id; private Integer phone; private Integer email; public Integer getUid() { return uid; } public void setUid(Integer uid) { this.uid = uid; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getCreatime() { return creatime; } public void setCreatime(Integer creatime) { this.creatime = creatime; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Integer getRole_id() { return role_id; } public void setRole_id(Integer role_id) { this.role_id = role_id; } public Integer getPhone() { return phone; } public void setPhone(Integer phone) { this.phone = phone; } public Integer getEmail() { return email; } public void setEmail(Integer email) { this.email = email; } }
package com.example.demo03.mapper; import com.example.demo03.entity.Person; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import java.util.List; @Mapper public interface PersonMapper { @Select("select * from persontable where id=#{uid} where is_del = 0") Person findById(Integer id); @Select("select * from persontable where is_del = 0") List<Person> list(); @Select("update persontable set name=#{name},password = #{password},role_id=#{role_id},phone=#{phone},email=#{email} where uid=#{id} and is_del = 0") Boolean update(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email); @Select("insert into persontable (name,password,role_id,phone,email) values (#{name}, #{password}, #{role_id}, #{phone}, #{email})") Boolean store(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email); @Select("update persontable set is_del=1 where uid=#{uid} where is_del = 0") Boolean del(Integer uid); @Select("update persontable set user_state=0 where uid=#{uid} where is_del = 0") Boolean disable(Integer id); @Select("update persontable set user_state=1 where uid=#{uid} where is_del = 0") Boolean enable(Integer id); }
package com.example.demo03.service; import com.example.demo03.entity.Person; import com.example.demo03.entity.Role; import java.util.List; public interface PersonService { Person findById(Integer uid); List<Person> list(); Boolean update(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email); Boolean store(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email); Boolean del(Integer uid); Boolean disable(Integer uid); Boolean enable(Integer uid); }
package com.example.demo03.service; import com.example.demo03.entity.Person; import com.example.demo03.entity.Role; import com.example.demo03.mapper.PersonMapper; import com.example.demo03.mapper.RoleMapper; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Service; import org.springframework.web.bind.annotation.PostMapping; import javax.annotation.Resource; import java.util.List; @Service public class PersonServiceImpl implements PersonService { @Resource PersonMapper personMapper; @Override public Person findById(Integer id) { return personMapper.findById(id); } @Override public List<Person> list() { return personMapper.list(); } @Override public Boolean update(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email) { return personMapper.update(uid, name, password, role_id, phone, email); } @Override public Boolean store(Integer uid, String name, Integer password, Integer role_id, Integer phone, String email) { return personMapper.store(uid, name, password, role_id, phone, email); } @Override public Boolean del(Integer id) { return personMapper.del(id); } @Override public Boolean disable(Integer uid) { return personMapper.disable(uid); } @Override public Boolean enable(Integer uid) { return personMapper.enable(uid); } }