1.前台html

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@include file="../header.jsp"%>    
     
        
     
            
      
                
       
                            
         
                                  
上级菜单:
                                  
                             
                             
                                  
功能名称:
                                  
                             
                             
                                  
功能路径:
                                  
                             
                                            
       
            
      
        
     
        
     
            
      确定 
      取消        
     
    

 

2.前台js

/** * 初始化界面 */var dataGrid;var rowEditor = undefined;$(function() {        hideDialog();        dataGrid = $("#function_tb")            .treegrid(                    {                        url : "../service/func/all",// 加载的URL                        idField : "id",                        method : "GET",                        treeField : "funcName",                        pagination : false,// 显示分页                        fit : true,// 自动补全                        fitColumns : true,                        singleSelect : true,                        iconCls : "icon-save",// 图标                        columns : [ [ // 每个列具体内容                                {                                    field : 'id',                                    title : '编号',                                    align : 'center',                                    width : 100,                                },                                {                                    field : 'funcName',                                    title : '功能名称',                                    align : 'center',                                    width : 100,                                    editor : 'text'                                },                                {                                    field : 'url',                                    title : '功能路径',                                    align : 'center',                                    width : 100,                                    editor : 'text'                                },                                {                                    field : 'createTm',                                    title : '创建时间',                                    align : 'center',                                    width : 100                                },                                {                                    field : 'modifiedTm',                                    title : '修改时间',                                    align : 'center',                                    width : 100                                },                                {                                    field : 'isDelete',                                    title : '是否禁用',                                    align : 'center',                                    width : 100,                                    editor : {                                        type : 'checkbox',                                        options : {                                            on : '1',                                            off : '0'                                        }                                    },                                    formatter : function(value, row, index) {                                        if (value == '0') {                                            return '正常';                                        } else {                                            return '禁用';                                        }                                    }                                } ] ],                        toolbar : [ // 工具条                                {                                    text : "增加",                                    iconCls : "icon-add",                                    handler : function() {
   // 回调函数                                        openDialog();                                    }                                },                                {                                    text : "删除",                                    iconCls : "icon-remove",                                    handler : function() {                                        var rows = dataGrid                                                .treegrid('getSelections');                                        if (rows.length <= 0) {                                            $.messager.alert('警告', '您没有选择',                                                    'error');                                        } else if (rows.length > 1) {                                            $.messager.alert('警告', '不支持批量删除',                                                    'error');                                        } else {                                            $.messager                                                    .confirm(                                                            '确定',                                                            '您确定要删除吗',                                                            function(t) {                                                                if (t) {                                                                    $                                                                            .ajax({                                                                                url : '../service/func/del',                                                                                method : 'POST',                                                                                data : rows[0],                                                                                dataType : 'json',                                                                                success : function(                                                                                        r) {                                                                                    if (r.code == "1") {                                                                                        dataGrid                                                                                                .treegrid('acceptChanges');                                                                                        $.messager                                                                                                .show({                                                                                                    msg : r.msg,                                                                                                    title : '成功'                                                                                                });                                                                                        editRow = undefined;                                                                                        dataGrid                                                                                                .treegrid('reload');                                                                                    } else {                                                                                        dataGrid                                                                                                .treegrid(                                                                                                        'beginEdit',                                                                                                        editRow);                                                                                        $.messager                                                                                                .alert(                                                                                                        '错误',                                                                                                        r.msg,                                                                                                        'error');                                                                                    }                                                                                    dataGrid                                                                                            .treegrid('unselectAll');                                                                                }                                                                            });                                                                }                                                            })                                        }                                    }                                },                                {                                    text : "修改",                                    iconCls : "icon-edit",                                    handler : function() {                                        var rows = dataGrid                                                .treegrid('getSelections');                                        if (rows.length == 1) {                                            if (rowEditor == undefined) {                                                //var index = dataGrid.treegrid('getRowIndex', rows[0]);                                                var index = rows[0].id;                                                rowEditor = index;                                                dataGrid.treegrid('unselectAll');                                                dataGrid.treegrid('beginEdit',                                                        index);                                            }                                        }                                    }                                }, {                                    text : "保存",                                    iconCls : "icon-save",                                    handler : function() {                                        dataGrid.treegrid('endEdit', rowEditor);                                        rowEditor = undefined;                                    }                                }, {                                    text : "取消编辑",                                    iconCls : "icon-redo",                                    handler : function() {                                        dataGrid.treegrid('cancelEdit', rowEditor);                                        rowEditor = undefined;                                    }                                } ],                                onAfterEdit : function(rowIndex, rowData, changes) {                                    var inserted = dataGrid.treegrid('getChanges',                                            'inserted');                                    var updated = dataGrid.treegrid('getChanges',                                            'updated');                                    if (inserted.length < 1 && updated.length < 1) {                                        editRow = undefined;                                        dataGrid.treegrid('unselectAll');                                        return;                                    }                                    var url = '';                                    if (inserted.length > 0) {                                        url = '../service/func/add';                                    }                                    if (updated.length > 0) {                                        url = '../service/func/update';                                    }                                    $.ajax({                                                url : url,                                                method : "POST",                                                data : rowIndex,                                                dataType : 'json',                                                success : function(r) {                                                    if (r.code=="1") {                                                        dataGrid                                                                .treegrid('acceptChanges');                                                        $.messager.show({                                                            msg : r.msg,                                                            title : '成功'                                                        });                                                        editRow = undefined;                                                        dataGrid.treegrid('reload');                                                    } else {                                                        /* datagrid.treegrid('rejectChanges'); */                                                        dataGrid.treegrid('beginEdit',                                                                editRow);                                                        $.messager.alert('错误', r.msg,                                                                'error');                                                    }                                                    dataGrid.treegrid('unselectAll');                                                }                                            });                                },                                onDblClickCell : function(index, field, value) {                                    if (rowEditor == undefined) {                                        dataGrid.treegrid('beginEdit', field.id);                                        rowEditor = field.id;                                    }                                }                    });});var editingId;function edit() {    if (editingId != undefined) {        dataGrid.treegrid('select', editingId);        return;    }    var row = dataGrid.treegrid('getSelected');    if (row) {        editingId = row.id;        dataGrid.treegrid('beginEdit', editingId);    }}function save() {    if (editingId != undefined) {        var t = $("#function_tb");        t.treegrid('endEdit', editingId);        editingId = undefined;        var persons = 0;        var rows = t.treegrid('getChildren');        for ( var i = 0; i < rows.length; i++) {            var p = parseInt(rows[i].persons);            if (!isNaN(p)) {                persons += p;            }        }        var frow = t.treegrid('getFooterRows')[0];        frow.persons = persons;        t.treegrid('reloadFooter');    }}function cancel() {    if (editingId != undefined) {        dataGrid.treegrid('cancelEdit', editingId);        editingId = undefined;    }}function hideDialog(){    $('#dlg').dialog('close');}function openDialog(){    //$("#add_select").attr('url','../service/func/allTree');    $('#add_select').combotree({          url : '../service/func/allTree'    });      $('#dlg').dialog('open');}function addFunc(){    $('#ff').form('submit',{        url:'../service/func/add',        success:function(data){            var r = JSON.parse(data);            if(r.code=="1"){                $.messager.show({                    msg : r.msg,                    title : '成功'                });                                hideDialog();                dataGrid                .treegrid('reload');            }else{                $.messager.alert(                        '错误',                        r.msg,                        'error');                hideDialog();                dataGrid                .treegrid('reload');            }        }    });}

 

3.后台controller中

/** * */package com.sf.fys.controller.role;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.commons.lang.StringUtils;import org.apache.log4j.Logger;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.web.bind.annotation.RestController;import com.google.gson.Gson;import com.sf.fys.config.LogAppender;import com.sf.fys.controller.BaseController;import com.sf.fys.data.Res;import com.sf.fys.data.TreeGrid;import com.sf.fys.model.Function;import com.sf.fys.result.ListResultMsg;import com.sf.fys.result.ResultResponse;import com.sf.fys.result.ReturnCode;import com.sf.fys.result.StringResult;import com.sf.fys.service.role.FunctionService;/** * @author sfit0512 * */@RestControllerpublic class FuncController extends BaseController {Logger log = Logger.getLogger(LogAppender.ADMIN);        @Autowired    private FunctionService funcService;        @RequestMapping(value = "/func/allTree", method = RequestMethod.POST)    @ResponseBody    public String getFuncsTree(HttpServletRequest request,            HttpServletResponse response) throws Exception {        Gson gson = new Gson();        List
     
       list = funcService.getFuncs();        if(!list.isEmpty()){            String ret =  gson.toJson(list);            ret = ret.replace("funcName", "text");            return ret;        }        return FAIL;    }        @RequestMapping(value = "/func/roleTree", method = RequestMethod.POST)    @ResponseBody    public String getFuncsTreeByRole(HttpServletRequest request,            HttpServletResponse response) throws Exception {        String roleId = request.getParameter("roleId");        Gson gson = new Gson();        List
      
        list = funcService.getFuncsByRole(Long.parseLong(roleId));        if(!list.isEmpty()){            String ret =  gson.toJson(list);            ret = ret.replace("funcName", "text");            return ret;        }        return FAIL;    }            /**     * 查询所有功能权限     * @param request     * @param response     * @return     * @throws Exception     */    @RequestMapping(value = "/func/all", method = RequestMethod.GET)    @ResponseBody    public String getFuncs(HttpServletRequest request,            HttpServletResponse response) throws Exception {        Gson gson = new Gson();        //List
       
         list = funcService.getFunctions();        List
        
          list = funcService.getFuncs();        TreeGrid
         
           treeGrid = new TreeGrid
          
           (); treeGrid.setTotal(String.valueOf(list.size())); treeGrid.setRows(list); if(!list.isEmpty()){ String ret = gson.toJson(treeGrid); return ret; } return FAIL; } /** * 添加功能权限 * @param request * @param response * @return * @throws Exception */ @RequestMapping(value = "/func/add", method = RequestMethod.POST) @ResponseBody public Res addFunc(HttpServletRequest request, HttpServletResponse response) throws Exception { String funcName = request.getParameter("funcName"); String parentId = request.getParameter("parentId"); String url = request.getParameter("url"); if(parentId==null||"".equals(parentId)){ parentId = "0";//为空则设为根目录 } Function func = new Function(); func.setFuncName(funcName); func.setParentId(Long.parseLong(parentId)); func.setUrl(url); func.setIsDelete('0'); int ret = funcService.addFunc(func); if(ret>0){ return success(); } return fail(); } /** * 修改功能权限 * @param request * @param response * @return * @throws Exception */ @RequestMapping(value = "/func/update", method = RequestMethod.POST) @ResponseBody public Res updateFunc(HttpServletRequest request, HttpServletResponse response) throws Exception { String funcName = request.getParameter("funcName"); String parentId = request.getParameter("parentId"); String url = request.getParameter("url"); String isDelete = request.getParameter("isDelete"); String id = request.getParameter("id"); //如果不选择就是一级菜单 if("".equals(parentId)){ parentId = "0"; } Function func = new Function(); func.setFuncName(funcName); func.setParentId(Long.parseLong(parentId)); func.setUrl(url); func.setIsDelete(isDelete.charAt(0)); func.setId(Long.parseLong(id)); int ret = funcService.updateFunc(func); if(ret>0){ return success(); } return fail(); } /** * 删除角色 * @param request * @param response * @return * @throws Exception */ @RequestMapping(value = "/func/del", method = RequestMethod.POST) @ResponseBody public Res deleteFunc(HttpServletRequest request, HttpServletResponse response) throws Exception { String id = request.getParameter("id"); int ret = funcService.deleteFunc(Long.parseLong(id)); if(ret>0){ return success(); } return fail(); } @RequestMapping(value = "/func/getUserFunc", method = RequestMethod.POST) @ResponseBody public ResultResponse getUserFunc(HttpServletRequest request, HttpServletResponse response) throws Exception { String userId = request.getParameter("userId"); log.info("getUserFunc|userId="+userId); if(StringUtils.isEmpty(userId)){ return new StringResult(ReturnCode.FAIL, ReturnCode.get(ReturnCode.FAIL), ""); } List
           
             list = funcService.getUserFunc(Long.parseLong(userId)); if(null != list){ return new ListResultMsg
            
             (ReturnCode.SUCCESS, "", list); }else{ return new StringResult(ReturnCode.FAIL, ReturnCode.get(ReturnCode.FAIL), ""); } } }4.后台service/** * */package com.sf.fys.service.role;import java.util.ArrayList;import java.util.List;import org.apache.log4j.Logger;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.sf.fys.mapper.role.FunctionMapper;import com.sf.fys.model.Function;/** * 功能权限管理 * @author sfit0512 * */@Servicepublic class FunctionService{ private static Logger log = Logger.getLogger(FunctionService.class); @Autowired private FunctionMapper functionMapper; /** * 查询所有功能列表 * @return */ public List
             
               getFuncs() { List
              
                list = functionMapper.getFuncs(); List
               
                 newList = getTree(list); return newList; } /** * 根据角色查询功能列表 * @param roleId * @return */ public List
                
                  getFuncsByRole(long roleId) { List
                 
                   list = functionMapper.getFuncsByRole(roleId); List
                  
                    newList = getTree(list); return newList; } /** * 转成树形集合 * @param list * @return */ public List
                   
                     getTree(List
                    
                      list) { List
                     
                       nodeList = new ArrayList
                      
                       (); for (Function f : list) { boolean mark = false; for (Function f2 : list) { if (f.getParentId() == f2.getId()) { mark = true; if (f2.getChildren() == null) { f2.setChildren(new ArrayList
                       
                        ()); } f2.getChildren().add(f); break; } } if (!mark) { nodeList.add(f); } } return nodeList; } /** * 添加功能 * @param func * @return */ public int addFunc(Function func) { return functionMapper.addFunction(func); } /** * 修改功能 * @param func * @return */ public int updateFunc(Function func) { return functionMapper.updateFunction(func); } /** * 删除功能 * @param id * @return */ public int deleteFunc(long id) { return functionMapper.delFunction(id); } /** * 根据用户编号查询该用户拥有的功能权限 * @param id * @return */ public List
                        
                          getUserFunc(long userId) { log.info("getUserFunc|id=" + userId); // 1.根据用户id查询该用户拥有的角色 // 2.遍历所有角色，查询对应的功能id（去掉重复） List
                         
                           list = functionMapper.getFuncByUser(userId); if(list!=null){ log.info("getUserFunc|list.size="+list.size()); } return list; }}
                         
                        
                       
                      
                     
                    
                   
                  
                 
                
               
              
             
            
           
          
         
        
       
      
     

5.mapper

     
         
          
              select func_id as        id,func_name        as funcName,create_tm as        createTm,modified_tm as modifiedTm,parent_id        as parentId,url,is_delete as isDelete from Functions        where is_delete =        0        
              select f.func_id as        id,f.func_name as funcName,f.create_tm as        createTm,f.modified_tm as        modifiedTm,f.parent_id as parentId,f.url,f.is_delete as isDelete from        Functions f,        Role_Functions rf        where f.func_id = rf.func_id and        f.is_delete = 0 and rf.role_id = #{roleId,jdbcType=BIGINT};        
          
              select func_id as        id,func_name as funcName,create_tm as        createTm,modified_tm as        modifiedTm,parent_id as parentId,url,is_delete as isDelete from        Functions        where parent_id = 0;        
          
              select        func_id as        id,func_name as funcName,create_tm as        createTm,modified_tm as        modifiedTm,parent_id as parentId,url,is_delete as isDelete        from        Functions        where parent_id = #{id,jdbcType=BIGINT};        
          
      
               insert into        Functions(FUNC_NAME,CREATE_TM,MODIFIED_TM,PARENT_ID,URL,IS_DELETE)        values(        #{funcName,jdbcType=VARCHAR},        now(),        now(),        #{parentId,jdbcType=BIGINT},        #{url,jdbcType=VARCHAR},        #{isDelete,jdbcType=CHAR}        )    
          
          
      
               update Functions set        FUNC_NAME=#{funcName,jdbcType=VARCHAR},        MODIFIED_TM = now(),        PARENT_ID =        #{parentId,jdbcType=BIGINT},        URL = #{url,jdbcType=VARCHAR},        IS_DELETE =        #{isDelete,jdbcType=CHAR}        where FUNC_ID = #{id,jdbcType=BIGINT}    
          
          
              
               update Functions set IS_DELETE = 1 where FUNC_ID =        #{id,jdbcType=BIGINT}    
          
          
              select func_id as        id,func_name        as funcName,create_tm as        createTm,modified_tm as modifiedTm,parent_id        as parentId,url,is_delete as isDelete from Functions where func_id in        (select distinct(func_id) from Role_Functions        where role_id in ( select role_id from Role_User where user_id = #{userId,jdbcType=BIGINT})) and        is_delete =0