crud（增删改查）操作

 

 

 

 

 

 

controller层

package com.example.fenhaoxuan.controller;
import com.example.fenhaoxuan.pojo.role_code;
import com.example.fenhaoxuan.service.Role_codeService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.annotation.Resource;
import java.util.List;
//@RequestMapping("/hello")
//@RestController
//public class runController {
//
//    @RequestMapping("a.ht")
//    public String HelloWorld() {
//        return "我裂开！！！";
//    }
//}
@Controller
public class runController {

    @Resource
    private Role_codeService role_codeService;
    @RequestMapping("index")
    public String index() {
        return "addUser";
    }
    //注册添加
    @RequestMapping("add")
    public String addUser(String menuId, String roleId){
        role_codeService.addUser(roleId, menuId);
        return "redirect:/show";
    }
    //查看所有数据库的数据，展示在页面。
    @RequestMapping("show")
    public String getUserAll(ModelMap mo) {
        List<role_code> list = role_codeService.getUserAll();
        mo.addAttribute("luo", list);
        return "listUsers";
    }
    //根据id去删除
    @RequestMapping("delUser")
    public String delUser(String MENU_ID){
        role_codeService.delUser(MENU_ID);
        return "redirect:show";
    }
}

 

mapper层：

package com.example.fenhaoxuan.mapper;

import com.example.fenhaoxuan.pojo.role_code;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
@Mapper
public interface Role_codeMappers {
        int addUser(@Param("MENU_ID") String MENU_ID, @Param("ROLE_ID") String ROLE_ID);

        String checkMenuID(String menuId);
        List<role_code> getUserAll();
        int delUser(String MENU_ID);
}

 pojo（user）层：

package com.example.fenhaoxuan.pojo;

import java.io.Serializable;

public class role