在完成初步的超市列表功能开发后,要加入联盟的考虑,对代码进行修改。
super_user的DAO层的可以继续使用,不需要修改,因为考虑到要在添加时为联盟选项添加一个选择框,所以需要向前端返回联盟表的相关数据。
关于联盟的代码:
DAO层
@Repository
public interface Admin_SuperUnionDao extends JpaRepository<Admin, Integer> {
@Query(value = "from Admin_SuperUnion a")
List<Admin_SuperUnion> findAllSuperUnion();
model层
@Entity
@Table(name = "super_union")
public class Admin_SuperUnion {
@Id
@GeneratedValue(
strategy = GenerationType.IDENTITY
)
private int super_union_id;
private String super_union_name;
private String super_union_leaderid;
public void setSuper_union_id(int super_union_id) {
this.super_union_id = super_union_id;
}
public void setSuper_union_name(String super_union_name) {
this.super_union_name = super_union_name;
}
public void setSuper_union_leaderid(String super_union_leaderid) {
this.super_union_leaderid = super_union_leaderid;
}
public int getSuper_union_id() {
return super_union_id;
}
public String getSuper_union_name() {
return super_union_name;
}
public String getSuper_union_leaderid() {
return super_union_leaderid;
}
}
Controller层
@RestController
public class Admin_SuperUnionController {
@Autowired
private Admin_SuperUnionDao admin_superUnionDao;
public Admin_SuperUnionController(){
}
@RequestMapping(value = {"/findallsuperunion"}, method = RequestMethod.POST)
public Map findAllSuperUnion(@RequestBody Object obj, HttpServletRequest request){
Map para = (Map) obj;
HttpSession session = request.getSession();
List<Admin_SuperUnion> list = this.admin_superUnionDao.findAllSuperUnion();
Map data = new HashMap();
if (list!=null&&list.size()!=0){
data.put("super_union",list);
data.put("status","1");
data.put("message","完成查找");
data.put("sessionId",session.getId());
}else {
data.put("status","-1");
data.put("message","未找到联盟");
data.put("sessionId",session.getId());
}
return data;
}
}
修改后的超市列表相关代码:
model层
@Entity
@Table(name = "super_user")
public class SuperUser {
@Id
@GeneratedValue(
strategy = GenerationType.IDENTITY
)
private int super_user_id;
private String super_user_name;
private String super_user_password;
private String super_phone;
private String super_address;
@OneToOne
@JoinColumn(name = "super_union_id")
private Admin_SuperUnion admin_superUnion;
public void setSuper_user_id(int super_user_id) {
this.super_user_id = super_user_id;
}
public void setSuper_user_name(String super_user_name) {
this.super_user_name = super_user_name;
}
public void setSuper_user_password(String super_user_password) {
this.super_user_password = super_user_password;
}
public void setSuper_phone(String super_phone) {
this.super_phone = super_phone;
}
public void setSuper_address(String super_address) {
this.super_address = super_address;
}
public void setAdmin_superUnion(Admin_SuperUnion admin_superUnion) {
this.admin_superUnion = admin_superUnion;
}
public int getSuper_user_id() {
return super_user_id;
}
public String getSuper_user_name() {
return super_user_name;
}
public String getSuper_user_password() {
return super_user_password;
}
public String getSuper_phone() {
return super_phone;
}
public String getSuper_address() {
return super_address;
}
public Admin_SuperUnion getAdmin_superUnion() {
return admin_superUnion;
}
}
因为没有想到好的解决直接为前端返回超市用户身份的方法,最后选择了使用一个新实体,添加一个role属性。
public class Admin_SuperUser {
private int super_user_id;
private String super_user_name;
private String super_user_password;
private String super_phone;
private String super_address;
private String super_union_name;
private int role;
public void setSuper_user_id(int super_user_id) {
this.super_user_id = super_user_id;
}
public void setSuper_user_name(String super_user_name) {
this.super_user_name = super_user_name;
}
public void setSuper_user_password(String super_user_password) {
this.super_user_password = super_user_password;
}
public void setSuper_phone(String super_phone) {
this.super_phone = super_phone;
}
public void setSuper_address(String super_address) {
this.super_address = super_address;
}
public void setSuper_union_name(String super_union_name) {
this.super_union_name = super_union_name;
}
public void setRole(int role) {
this.role = role;
}
public int getSuper_user_id() {
return super_user_id;
}
public String getSuper_user_name() {
return super_user_name;
}
public String getSuper_user_password() {
return super_user_password;
}
public String getSuper_phone() {
return super_phone;
}
public String getSuper_address() {
return super_address;
}
public String getSuper_union_name() {
return super_union_name;
}
public int getRole() {
return role;
}
}
Controller层
@RestController
public class SuperUserController {
@Autowired
private SuperUserDao superUserDao;
@Autowired
private Admin_SuperUnionDao admin_superUnionDao;
@Autowired
private JdbcTemplate jdbcTemplate;
public SuperUserController(){
}
@RequestMapping(value = "/findallsuperuser",method = RequestMethod.POST)
public Map listAllSuperUser(@RequestBody Object obj, HttpServletRequest request){
Map para = (Map) obj;
HttpSession session = request.getSession();
List<SuperUser> list = this.superUserDao.findAllSuperUser();
List<Admin_SuperUser> admin_superUserList = new ArrayList<>();
Map data = new HashMap();
if (list!=null&&list.size()!=0){
for (int i=0;i<list.size();i++){
Admin_SuperUser admin_superUser =new Admin_SuperUser();
admin_superUser.setSuper_user_id(list.get(i).getSuper_user_id());
admin_superUser.setSuper_user_name(list.get(i).getSuper_user_name());
admin_superUser.setSuper_user_password(list.get(i).getSuper_user_password());
admin_superUser.setSuper_phone(list.get(i).getSuper_phone());
admin_superUser.setSuper_address(list.get(i).getSuper_address());
admin_superUser.setSuper_union_name(list.get(i).getAdmin_superUnion().getSuper_union_name());
if(list.get(i).getAdmin_superUnion().getSuper_union_leaderid().equals(list.get(i).getSuper_user_id())){
admin_superUser.setRole(1);
}else {
admin_superUser.setRole(0);
}
admin_superUserList.add(admin_superUser);
}
data.put("superusers",admin_superUserList);
data.put("message","完成查找");
data.put("status","1");
}else {
data.put("message","没有找到超市");
data.put("status","-1");
}
data.put("sessionId", session.getId());
return data;
}
@RequestMapping(value = "/findsuperuserbyname",method = RequestMethod.POST)
public Map findSuper_UserBySuper_user_name(@RequestBody Object obj, HttpServletRequest request){
Map para = (Map) obj;
String name = (String) para.get("super_user_name");
HttpSession session = request.getSession();
List<SuperUser> list = this.superUserDao.findSuperUserBySuper_user_name(name);
List<Admin_SuperUser> admin_superUserList = new ArrayList<>();
Map data = new HashMap();
if (list!=null&&list.size()!=0){
for (int i=0;i<list.size();i++){
Admin_SuperUser admin_superUser =new Admin_SuperUser();
admin_superUser.setSuper_user_id(list.get(i).getSuper_user_id());
admin_superUser.setSuper_user_name(list.get(i).getSuper_user_name());
admin_superUser.setSuper_user_password(list.get(i).getSuper_user_password());
admin_superUser.setSuper_phone(list.get(i).getSuper_phone());
admin_superUser.setSuper_address(list.get(i).getSuper_address());
admin_superUser.setSuper_union_name(list.get(i).getAdmin_superUnion().getSuper_union_name());
if(list.get(i).getAdmin_superUnion().getSuper_union_leaderid().equals(list.get(i).getSuper_user_id())){
admin_superUser.setRole(1);
}else {
admin_superUser.setRole(0);
}
admin_superUserList.add(admin_superUser);
}
data.put("superusers",admin_superUserList);
data.put("message","完成查找");
data.put("status","1");
}else {
data.put("message","没有找到超市");
data.put("status","-1");
}
data.put("sessionId", session.getId());
return data;
}
@RequestMapping(value = "/addsuperuser",method = RequestMethod.POST)
public Map addSuperUser(@RequestBody Object obj, HttpServletRequest request){
Map para = (Map) obj;
HttpSession session = request.getSession();
List<SuperUser> list = superUserDao.findAllSuperUser();
String super_user_name = (String)para.get("super_user_name");
String super_user_password = (String)para.get("super_user_password");
String super_phone = (String)para.get("super_phone");
String super_address = (String)para.get("super_address");
String super_union_name = (String) para.get("super_union_name");
String checkstring = superUserDao.checkSuperUserisexist(super_user_name);
boolean isexist = false;
if (checkstring==null){
isexist = true;
}
int super_union_id = admin_superUnionDao.findSuperUnionIdBySuperUnionname(super_union_name);
Map data = new HashMap();
if(!list.contains(super_user_name)&&isexist!=false){
String sql = "insert into super_user(super_user_name,super_user_password,super_union_id," +
"super_phone,super_address) values('"+super_user_name+"','"+super_user_password+"'," +
"'"+super_union_id+"','"+super_phone+"','"+super_address+"')";
this.jdbcTemplate.update(sql);
data.put("status","1");
data.put("message","添加成功");
}else {
data.put("status", "-1");
data.put("message", "添加失败");
}
return data;
}
@RequestMapping(value = "/deletesuperuser",method = RequestMethod.POST)
public Map deleteSuperUser(@RequestBody Object obj, HttpServletRequest request){
Map para = (Map) obj;
HttpSession session = request.getSession();
int super_user_id = (int) para.get("super_user_id");
List<SuperUser> list = this.superUserDao.findSuper_UserBySuper_user_id(super_user_id);
Map data = new HashMap();
if(list!=null&&list.size()!=0){
String sql = "delete from super_user where super_user_id = '"+super_user_id+"'";
this.jdbcTemplate.update(sql);
data.put("status","1");
data.put("message","删除成功");
}else {
data.put("status", "-1");
data.put("message", "用户不存在");
}
data.put("sessionId", session.getId());
return data;
}
}