12-企业权限管理-资源权限

@Controller
@RequestMapping("/permission")
public class PermissionController {
    @Autowired
    private IPermissionService permissionService;
    @RequestMapping("/save.do")
    public String save(Permission permission) throws Exception {
        permissionService.save(permission);
        return "redirect:findAll.do";
    }
    @RequestMapping("/findAll.do")
    public ModelAndView findAll() throws Exception {
        ModelAndView mv=new ModelAndView();
        List<Permission> permissionList = permissionService.findAll();
        mv.addObject("permissionList",permissionList);
        mv.setViewName("permission-list");
        return mv;
    }
}

@Service
public class PermissionServiceImpl implements IPermissionService{
    @Autowired
    private IPermissionDao permissionDao;
    @Override
    public void save(Permission permission) throws Exception{
        permissionDao.save(permission);
    }
    @Override
    public List<Permission> findAll() throws Exception{
        return permissionDao.findAll();
    }
}

public interface IPermissionDao {
    @Select("select * from permission where id in (select permissionId from role_permission where roleId=#{id} )")
    public List<Permission> findPermissionByRoleId(String id) throws Exception;
    @Select("select * from permission")
    List<Permission> findAll() throws Exception;
    @Insert("insert into permission(permissionName,url) values(#{permissionName},#{url})")
    void save(Permission permission) throws Exception;
}

  <div class="wrapper">
    <!-- 页面头部 -->
    <jsp:include page="header.jsp"></jsp:include>
    <!-- 页面头部 /-->
    <!-- 导航侧栏 -->
    <jsp:include page="aside.jsp"></jsp:include>
    <!-- 导航侧栏 /-->
    <!-- 内容区域 -->
    <div class="content-wrapper">
      <!-- 内容头部 -->
      <section class="content-header">
      <h1>
        资源权限管理 <small>全部权限</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="${pageContext.request.contextPath}/index.jsp"><i
            class="fa fa-dashboard"></i> 首页</a></li>
        <li><a
          href="${pageContext.request.contextPath}/permission/findAll.do">资源权限管理</a></li>
        <li class="active">全部权限</li>
      </ol>
      </section>
      <!-- 内容头部 /-->
        <!-- 正文区域 -->
        <section class="content"> <!-- .box-body -->
        <div class="box box-primary">
          <div class="box-header with-border">
            <h3 class="box-title">列表</h3>
          </div>
          <div class="box-body">
            <!-- 数据表格 -->
            <div class="table-box">
              <!--工具栏-->
              <div class="pull-left">
                <div class="form-group form-inline">
                  <div class="btn-group">
                    <button type="button" class="btn btn-default" title="新建" onclick="location.href='${pageContext.request.contextPath}/pages/permission-add.jsp'">
                      <i class="fa fa-file-o"></i> 新建
                    </button>
                    <button type="button" class="btn btn-default" title="刷新">
                      <i class="fa fa-refresh"></i> 刷新
                    </button>
                  </div>
                </div>
              </div>
              <div class="box-tools pull-right">
                <div class="has-feedback">
                  <input type="text" class="form-control input-sm"
                    placeholder="搜索"> <span
                    class="glyphicon glyphicon-search form-control-feedback"></span>
                </div>
              </div>
              <!--工具栏/-->
              <!--数据列表-->
              <table id="dataList"
                class="table table-bordered table-striped table-hover dataTable">
                <thead>
                  <tr>
                    <th class="" style="padding-right: 0px"><input
                      id="selall" type="checkbox" class="icheckbox_square-blue">
                    </th>
                    <th class="sorting_asc">ID</th>
                    <th class="sorting_desc">权限名称</th>
                    <th class="sorting_asc sorting_asc_disabled">URL</th>
                    <th class="text-center">操作</th>
                  </tr>
                </thead>
                <tbody>
                  <c:forEach items="${permissionList}" var="p">
                    <tr>
                      <td><input name="ids" type="checkbox"></td>
                      <td>${p.id }</td>
                      <td>${p.permissionName }</td>
                      <td>${p.url }</td>
                      <td class="text-center">
                        <a href="${pageContext.request.contextPath}/permission/findById.do?id=${p.id}" class="btn bg-olive btn-xs">详情</a>
                        <a href="${pageContext.request.contextPath}/permission/deletePermission.do?id=${p.id}" class="btn bg-olive btn-xs">删除权限</a>
                        <a href="${pageContext.request.contextPath}/user/findUserByIdAndAllRole.do?id=${p.id}" class="btn bg-olive btn-xs">添加权限</a>
                      </td>
                    </tr>
                  </c:forEach>
                </tbody>
                <!--
                            <tfoot>
                            <tr>
                            <th>Rendering engine</th>
                            <th>Browser</th>
                            <th>Platform(s)</th>
                            <th>Engine version</th>
                            <th>CSS grade</th>
                            </tr>
                            </tfoot>-->
              </table>
              <!--数据列表/-->
            </div>
            <!-- 数据表格 /-->
          </div>
          <!-- /.box-body -->
          <!-- .box-footer-->
          <div class="box-footer">
            <div class="pull-left">
              <div class="form-group form-inline">
                总共2 页，共14 条数据。 每页 <select class="form-control">
                  <option>1</option>
                  <option>2</option>
                  <option>3</option>
                  <option>4</option>
                  <option>5</option>
                </select> 条
              </div>
            </div>
            <div class="box-tools pull-right">
              <ul class="pagination">
                <li><a href="#" aria-label="Previous">首页</a></li>
                <li><a href="#">上一页</a></li>
                <li><a href="#">1</a></li>
                <li><a href="#">2</a></li>
                <li><a href="#">3</a></li>
                <li><a href="#">4</a></li>
                <li><a href="#">5</a></li>
                <li><a href="#">下一页</a></li>
                <li><a href="#" aria-label="Next">尾页</a></li>
              </ul>
            </div>
          </div>
          <!-- /.box-footer-->
        </div>
        </section>
        <!-- 正文区域 /-->
      </div>
      <!-- @@close -->
      <!-- 内容区域 /-->
      <!-- 底部导航 -->
      <footer class="main-footer">
      <div class="pull-right hidden-xs">
        <b>Version</b> 1.0.8
      </div>
      <strong>Copyright &copy; 2014-2017 <a
        href="http://www.itcast.cn">研究院研发部</a>.
      </strong> All rights reserved. </footer>
      <!-- 底部导航 /-->
    </div>

  <div class="wrapper">
    <!-- 页面头部 -->
    <jsp:include page="header.jsp"></jsp:include>
    <!-- 页面头部 /-->
    <!-- 导航侧栏 -->
    <jsp:include page="aside.jsp"></jsp:include>
    <!-- 导航侧栏 /-->
    <!-- 内容区域 -->
    <div class="content-wrapper">
      <!-- 内容头部 -->
      <section class="content-header">
      <h1>
        资源权限管理 <small>资源权限表单</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="${pageContext.request.contextPath}/index.jsp"><i
            class="fa fa-dashboard"></i> 首页</a></li>
        <li><a href="${pageContext.request.contextPath}/permission/findAll.do">资源权限管理</a></li>
        <li class="active">资源权限表单</li>
      </ol>
      </section>
      <!-- 内容头部 /-->
      <form action="${pageContext.request.contextPath}/permission/save.do"
        method="post">
        <!-- 正文区域 -->
        <section class="content"> <!--产品信息-->
        <div class="panel panel-default">
          <div class="panel-heading">资源权限信息</div>
          <div class="row data-type">
            <div class="col-md-2 title">权限名称</div>
            <div class="col-md-4 data">
              <input type="text" class="form-control" name="permissionName"
                placeholder="权限名称" value="">
            </div>
            <div class="col-md-2 title">RUL</div>
            <div class="col-md-4 data">
              <input type="text" class="form-control" name="url"
                placeholder="URL" value="">
            </div>
          </div>
        </div>
        <!--订单信息/--> <!--工具栏-->
        <div class="box-tools text-center">
          <button type="submit" class="btn bg-maroon">保存</button>
          <button type="button" class="btn bg-default"
            onclick="history.back(-1);">返回</button>
        </div>
        <!--工具栏/--> </section>
        <!-- 正文区域 /-->
      </form>
    </div>
    <!-- 内容区域 /-->
    <!-- 底部导航 -->
    <footer class="main-footer">
    <div class="pull-right hidden-xs">
      <b>Version</b> 1.0.8
    </div>
    <strong>Copyright &copy; 2014-2017 <a
      href="http://www.itcast.cn">研究院研发部</a>.
    </strong> All rights reserved. </footer>
    <!-- 底部导航 /-->
  </div>

    @RequestMapping("/deletePermission")
    public String deletePermission(String id) throws Exception {
        permissionService.deleteById(id);
        return "redirect:findAll.do";
    }
    @RequestMapping("/findById")
    public ModelAndView findById(String id) throws Exception {
        Permission permission=  permissionService.findById(id);
        ModelAndView mv=new ModelAndView();
        mv.setViewName("permission-show");
        mv.addObject("permission",permission);
        return mv;
    }

    @Override
    public void deleteById(String id) throws Exception {
        permissionDao.deleteFromRole_Permission(id);
        permissionDao.deleteById(id);
    }
    @Override
    public Permission findById(String id) throws Exception {
        return permissionDao.findById(id);
    }

    @Delete("delete from role_permission where permissionId=#{id}")
    void deleteFromRole_Permission(String id);
    @Delete("delete from permission where id=#{id}")
    void deleteById(String id);
    @Select("select * from permission where id=#{id}")
    Permission findById(String id);

    <td class="text-center">
      <a href="${pageContext.request.contextPath}/permission/findById.do?id=${p.id}" class="btn bg-olive btn-xs">详情</a>
      <a href="${pageContext.request.contextPath}/permission/deletePermission.do?id=${p.id}" class="btn bg-olive btn-xs">删除权限</a>
      <a href="${pageContext.request.contextPath}/user/findUserByIdAndAllRole.do?id=${p.id}" class="btn bg-olive btn-xs">添加权限</a>
    </td>