spring mvc 实战化项目之三板斧

laravel实战化项目之三板斧

spring mvc 实战化项目之三板斧

asp.net mvc 实战化项目之三板斧

接上文希望从一张表（tb_role_info 用户角色表）的CRUD展开spring mvc的项目实战化魅力。

开发技术选型：spring mvc+freemarker+bootstrap+mybatis+mysql。

项目目录结构：

 (1)业务表 tb_role_info

-- ----------------------------
-- Table structure for `tb_role_info` 用户角色表
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_info`;
CREATE TABLE `tb_role_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(32) NOT NULL DEFAULT '' COMMENT '角色名称',
  `role_mark` varchar(255) DEFAULT '' COMMENT '角色备注',
  `creater_id` int(11) NOT NULL DEFAULT '0' COMMENT '记录创建者id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建日期',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新日期',
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间戳',
  PRIMARY KEY (`id`),
  KEY `tb_role_info_index` (`id`,`role_name`,`creater_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='角色信息表';

 

（2）业务界面 role.html

<!DOCTYPE html>
<html>
<head>
    <#include "header.html" />
    <link rel="stylesheet" type="text/css" href="../assets/backend/plugs/bootstrap-table/src/bootstrap-table.css?v=${version}"/>
</head>
<body> 
    <#include "navbar.html" />
    <div id="page-container">
             <!-- BEGIN SIDEBAR -->
       <#include "menu.html" />
    <!-- END SIDEBAR -->
        <!-- BEGIN RIGHTBAR -->
        <!-- END RIGHTBAR -->
        <div id="page-content">
            <div id="wrap">
                <div id="page-heading">
                    <ol class="breadcrumb">
                        <li><a href="#" title="icons">系统管理</a></li>
                        <li class="active">角色信息</li>
                    </ol>
                </div>
                <!-- container 内容显示区域begin-->
                <div class="container">
                    <div class='data_loading'></div>
                   <div class="row">
                           <div class="col-xs-9" id="panel_list">
                            <div class="panel panel-gray">
                                <div class="panel-heading">
                                    <h4>
                                            角色信息  
                                        
                                    </h4>
                                    <div class="options">
                                          <div class="btn-group" id="table_tools_bar">
                                            <button type="button" class="btn btn-default dropdown-toggle btn-tools" data-toggle="dropdown" title="定制列显示"><i class="fa fa-th-list"></i> <span class="caret"></span></button>
                                            <button id="btn_role_refresh" type="button" class="btn btn-default btn-tools" title="角色刷新"><i class="fa fa-refresh"></i></button>
                                            <button id="btn_role_search" type="button" class="btn btn-default btn-tools" title="角色查询"><i class="fa fa-search"></i></button>
                                        </div>
                                    </div>
                                    <div class="options options-groups">
                                        <a href="javascript:;" id="btn_role_delete" title="角色删除" style="display:none;"><i class="fa fa-times"></i> 删除</a> 
                                        <a data-toggle="modal" href="#modalDialog" id="btn_role_edit" title="角色编辑"><i class="fa fa-edit"></i> 编辑</a> 
                                        <a data-toggle="modal" href="#modalDialog" id="btn_role_add" title="角色添加"><i class="fa fa-pencil"></i> 添加</a> 
                                    </div>
                                </div>
                                <div class="panel-body">
                                    
                                    <div class="table-responsive">
                                        <table id="table_role"></table>
                                    </div>
                                    <!-- add/edit modal-begin -->
                                    <div id="modalDialog" class="modal fade md-trigger"
                                        data-modal="md-fade-in-scale-up"
                                        tabindex="-1" 
                                        role="dialog" 
                                        aria-labelledby="modalLabel" 
                                        data-keyboard="true"
                                        data-backdrop="static" 
                                        aria-hidden="true">

                                        <div id="modalBox" class="modal-dialog">
                                            <div class="modal-content">
                                                <div class="modal-header">
                                                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                                                        ×</button>
                                                    <h4 class="modal-title" id="modalLabel"></h4>
                                                </div>
                                                <div class="modal-body">
                                                    <form id="modalForm" class="form-horizontal" role="form" enctype="multipart/form-data">
                                                        <!-- 隐藏值存放区域  begin-->
                                                        <input name="id" id="form_hidden_id" type="hidden">
                                                         <!-- 隐藏值存放区域 end-->
                                                        <div class="form-group">
                                                            <label for="form_txt_roleName" class="col-sm-2 control-label">角色名称</label>
                                                            <div class="col-sm-7">
                                                              <input id="form_txt_roleName" name="roleName" maxlength="32" placeholder="角色名称最多32个字符" required="" type="text" class="form-control">
                                                            </div>
                                                            <div class="col-sm-3">
                                                                <p class="help-block">角色名称必填!</p>
                                                            </div>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="form_txt_roleName" class="col-sm-2 control-label">角色权限</label>
                                                            <div class="col-sm-10">
                                                             <table id="table_module" class="table table-bordered">
                                                                    <thead>
                                                                        <tr>
                                                                            <th width="2%" style="padding: 10px">
                                                                            
                                                                            </th>
                                                                            <th width="28%" style="padding: 10px">
                                                                                模块
                                                                            </th>
                                                                                <th width="30%" style="padding: 10px">
                                                                                功能
                                                                            </th>
                                                                                <th width="30%" style="padding: 10px">
                                                                                动作
                                                                            </th>
                                                                        </tr>
                                                                    </thead>
                                                                    <#if moduleList??>
                                                                    <tbody>
                                                                    <#list moduleList as module> 
                                                                            <#if module.id==1 && user['userRoleId']!=1>
                                                                              
                                                                            <#else> 
                                                                                <tr>
                                                                                    <td>
                                                                                        <input type="checkbox" id="power_${module.id}" name="mod_${module.id}" value="${module.id}" onclick="checkModule(${module.id});" />
                                                                                    </td>
                                                                                    <td>
                                                                                        ${module.moduleCnName}
                                                                                    </td>
                                                                                    <td>
                                                                                        <table width="100%">
                                                                                            <#if module.children??> 
                                                                                                <#list module.children as child> 
                                                                                            <tr>
                                                                                                <td width="6%"><input type="checkbox" id="power_${child.id}" name="fun_${module.id}" value="${child.id}" onclick="checkFun(${module.id});" /></td>
                                                                                                <td width="94%">${child.moduleCnName}</td>
                                                                                            </tr>
                                                                                                </#list>
                                                                                            </#if>
                                                                                         </table>
                                                                                  </td>
                                                                                    <td>
                                                                                         <table width="100%">
                                                                                            <#if module.children??> 
                                                                                                <#list module.children as child> 
                                                                                                    <#if child.children??> 
                                                                                                            <#list child.children as subChild>
                                                                                                             <tr>
                                                                                                                <td width="6%"><input type="checkbox" id="power_${subChild.id}" name="act_${child.id}" value="${subChild.id}"  onclick="checkAction(${child.id});"/></td>
                                                                                                                <td width="94%">${subChild.moduleCnName}</td>
                                                                                                             </tr>
                                                                                                            </#list>
                                                                                                     </#if> 
                                                                                                </#list>
                                                                                            </#if>
                                                                                         </table>
                                                                                    </td>
                                                                                </tr>
                                                                            </#if>
                                                                         </#list>
                                                                    </tbody>
                                                                  </#if>
                                                                </table>
                                                            </div>
                                                        </div>
                                                        <div class="form-group">
                                                            <label for="form_txt_roleMark" class="col-sm-2 control-label">
                                                                角色描述</label>
                                                            <div class="col-sm-10">
                                                                    <textarea  id="form_txt_roleMark" name="roleMark" maxlength="255" placeholder="角色描述最多255个字符" class="form-control autosize"></textarea>
                                                            </div>
                                                        </div>
                                                    </form>
                                                </div>
                                                <div class="modal-footer">
                                                    <button id="btn_modal_save" type="button" class="btn btn-primary">
                                                        确定</button>
                                                    <button type="button" class="btn btn-default" data-dismiss="modal">
                                                        取消</button>
                                                </div>
                                            </div>
                                            <!-- /.modal-content -->
                                        </div>
                                        <!-- /.modal-dialog -->
                                    </div>
                                  <!-- add/edit modal-end -->

                                </div>
                            </div>
                        </div>
                        
                        
                        <div class="col-xs-3" id="panel_search"  style="display: none">
                            <div class="panel panel-gray">
                                <div class="panel-heading">
                                    <h4>
                                            角色查询 
                                    </h4>
                                </div>
                                <div class="panel-body">
                                    <form class="form-horizontal">
                                       <div class="row">
                                           <div class="col-md-12">
                                                <div class="form-group">
                                                     <label for="search_txt_roleName" class="col-sm-4 control-label">角色名称</label>
                                                    <div class="col-sm-8">
                                                       <input id="search_txt_roleName"  type="text" class="form-control" placeholder="请输入关键字...">
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                                <div class="panel-footer">
                                    <div class="row">
                                        <div class="col-sm-12 col-sm-offset-3">
                                            <div class="btn-toolbar">
                                                <button id="btn_submit_search" class="btn-primary btn">确定</button>
                                               <button id="btn_cancel_search" class="btn-default btn">取消</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>  
                            </div>
                      </div> 
                        
                        
                        
                   </div>
                </div>
                <!-- container 内容显示区域end-->
            </div>
            <!--wrap -->
        </div>
    </div>
    <!-- page-container -->
    <!-- page-content -->
   <#include "footer.html" />
</body>
</html>
<script type="text/javascript" charset="utf-8" src="../assets/backend/plugs/bootstrap-table/src/bootstrap-table.js?v=${version}"></script>
<script type="text/javascript" charset="utf-8" src="../assets/backend/plugs/bootstrap-table/src/locale/bootstrap-table-zh-CN.js?v=${version}"></script>
<script type="text/javascript" charset="utf-8" src="../assets/backend/js/sys_role.js?v=${version}"></script>

 （3）业务界面逻辑 sys_role.js

/**
* sys_role
* 角色信息
* @author steven9801@163.com
* @date 2015-11-19
*/
(function ($) {
    $(document).ready(function () {
        /**
        * 初始化
        */
        init();
        /**
        * 新建模态
        */
        $('#btn_role_add').click(function () {
            addModal()
        });
        /**
        * 编辑模态
        */
        $('#btn_role_edit').click(function () {
            var rowList = dataGrid.bootstrapTable('getSelections');
            var length = rowList.length;
            if (length == 0) {
                warningBox('请选择编辑对象.');
                return false;
            }
            if (length > 1) {
                warningBox('只能编辑一项.');
                return false;
            }
            editModal(rowList[0]);
        });
        /**
        * 保存动作
        */
        $('#btn_role_save').click(function () {
            switch (dialogType) {
                case 'add':
                    onAdd();
                    break;
                case 'edit':
                    onEdit();
                    break;
                default:
                    break;
            }
        });
        /**
        * 删除
        */
        $('#btn_role_delete').click(function () {
            onDelete();
        });
        //-----------------常规事件----------begin-------//
        /**
        * 刷新
        */
        $('#btn_role_refresh').click(function () {
            dataGrid.bootstrapTable('destroy');
            loadGrid();
        });
        /**
        * 展开
        */
        $('#btn_search_expand').click(function () {
            $(this).html('');
            if(!searchStatus){
                 $('#search_more_panel').show('slow');
                 $(this).html('<i class="fa fa-angle-double-down"></i>');
                 searchStatus = true;
             }
             else{
                 $('#search_more_panel').hide('slow');
                 $(this).html('<i class="fa fa-angle-double-up"></i>');
                 searchStatus = false;
             }
             return false;
        });
        /**
        * 提交查询
        */
        $('#btn_search_save').click(function () {
            dataGrid.bootstrapTable('destroy');
            bindGrid(function (params) {
                var roleName = $('#search_txt_roleName').val();
                role.pageSize = params.pageSize;
                role.pageStart = params.pageSize * (params.pageNumber - 1);
                role.sortName = params.sortName;
                role.sortOrder = params.sortOrder;
                if (roleName.length > 0) {
                    role.roleName = roleName;
                }
                return JSON.stringify(role);
            });
        });

        //-----------------常规事件----------end-------//
    });
})(jQuery);
/**
* 全局变量
*/
//--------------------------全局变量区---------------------------//
var dataGrid = null; //列表对象
var dialogType = 'add';
var role = {};
var lock = false; //防止重复提交
var searchStatus = false; //查询面板状态
//--------------------------全局变量区---------------------------//
/**
* 初始化
*/
function init() {
    loadGrid();
    $("#form_modal .modal-body").css({ height: "650px", overflowX: "hidden", overflowY: "auto" });
    $('textarea.autosize').autosize({ append: "\n" });
};
/**
* 
* 加载列表
* 
*/
function loadGrid() {
    bindGrid(function (params) {
        return JSON.stringify({
            pageSize: params.pageSize,
            pageStart: params.pageSize * (params.pageNumber - 1),
            sortName: params.sortName,
            sortOrder: params.sortOrder
        });
    });
    return false;
};



/**
* 绑定列表
*/
function bindGrid(callBack) {
    dataGrid = $('#role_table').bootstrapTable({
        method: 'POST',
        contentType: 'application/json;charset=utf-8',
        url: '../admin/role',
        height: 500,
        striped: true,
        pagination: true,
        sidePagination: 'server',
        pageSize: 25,
        pageList: [25, 50, 100, 200],
        showExport: true,
        sortName: 'createdAt',
        sortOrder: 'desc',
        minimunCountColumns: 2,
        formatLoadingMessage: function () {
            return '<img src="../backend/images/loading.gif"/>';
        },
        queryParams: callBack,
        columns:
        [
        { field: 'state', checkbox: true },
        { field: 'roleName', title: '角色名称', align: 'left', valign: 'middle', sortable: true },
        { field: 'createdAt', title: '创建时间', align: 'center', valign: 'middle', sortable: true },
        { field: 'operate', title: '操作', align: 'left', valign: 'middle', sortable: false, formatter: operateFormatter, events: operateEvents }
        ]
    });
};

/**
* 格式化操作列
* 
*/
function operateFormatter(value, row, index) {
    var content = [];
    content.push(' <a class="view" data-toggle="modal" href="#form_modal" title="角色查看"><i class="fa fa-eye"></i></a>');
    content.push(' <a class="edit" data-toggle="modal" href="#form_modal" title="角色编辑"><i class="fa fa-edit"></i></a>');
    content.push(' <a class="delete" href="javascript:void(0)" title="角色删除"><i class="fa fa-times"></i></a>');
    return content.join('');
};

/**
* 操作列事件
*/
window.operateEvents = {
    'click .view': function (e, value, row, index) {
        viewModal(row);
        return false;
    },
    'click .edit': function (e, value, row, index) {
        editModal(row);
        return false;
    },
    'click .delete': function (e, value, row, index) {
        if (lock) return false;
        lock = true;
        if (userToken.id != row.createrId) {
            lock = false;
            warningBox('对不起,您无权删除该角色.');
            return false;
        }
        var ids = [];
        ids.push(row.id);
        var params = {};
        params.ids = ids;
        deleteModal(params);
    }
};

/**
* 显示模态
*/
function showModal(action, title, width) {
    dialogType = action;
    $('.modal-footer').show();
    $('#form_modal #form_modal_title').html(title);
    $('#form_modal_dialog').css({ width: width });
    $('select,textarea,input').prop('disabled', false);
    $('#back-to-top').trigger('click');
    return false;
};

/**
* 绑定模态
*/
function bindModal(row) {

    $('#form_hidden_id').val(row.id);
    $('#form_hidden_createrId').val(row.createrId);
    $('#form_txt_roleName').val(row.roleName);
    $('#form_txt_roleMark').val(row.roleMark);

    $("input[id^='power_']").removeAttr("checked");
    var moduleIdList = row.moduleIdList;
    for (var i in moduleIdList) {
        var id = moduleIdList[i];
        $("input[id='power_" + id + "']").prop("checked", true);
    }
};

/**
* 查看模态
*/
function viewModal(row) {
    showModal('view', '角色查看', '60%');
    bindModal(row);
    $('select,textarea,input:not(.fixed-table-container input)').prop('disabled', true);
    $('#search_panel select,#search_panel input').prop('disabled', false);
    $('#table_tools_bar').find('input').prop('disabled', false);
    $('.modal-footer').hide();
    return false;
};

/**
* 编辑模态
*/
function editModal(row) {
    role = row;
    if (userToken.id != row.createrId) {
        pauseModal('#form_modal');
        warningBox('对不起,您无权编辑该角色.');
        return false;
    }
    showModal('edit', '角色编辑', '60%');
    bindModal(row);
    return false;
};

/**
* 新建模态
*/
function addModal() {
    showModal('add', '角色新建', '60%');
    $('input[type=text],input[type=hidden],input[type=number],textarea').val('');
    $('select option').eq(0).prop('selected', true);
    $("input[id^='power_']").prop('checked', false);
    return false;
};

/**
* 验证表单
*/
function checkForm() {
    if (lock) return false;
    lock = true;
    var roleName = $("#form_txt_roleName").val();
    if (roleName.length == 0) {
        warningBox("角色名称不能为空.");
        lock = false;
        return false;
    }

    if (roleName.length > 32) {
        warningBox("角色名称最多32个字符.");
        lock = false;
        return false;
    }

    if ($("input[id^='power_']:checkbox:checked").length == 0) {
        warningBox("请选择权限.");
        lock = false;
        return false;
    }


    var roleMark = $("#form_txt_roleMark").val();
    if (roleMark.length > 255) {
        warningBox("角色描述最多255个字符.");
        lock = false;
        return false;
    }

    var moduleIdList = [];
    $("input[id^='power_']:checkbox:checked").each(function () {
        var id = parseInt($(this).val());
        moduleIdList.push(id);
    });

    role.roleName = roleName;
    role.roleMark = roleMark;
    role.moduleIdList = moduleIdList;
    return true;
};

/**
* 角色添加
*/
function onAdd() {
    if (!checkForm()) {
        return false;
    }
    $('.data-loading').show();
    var task = new DelayedTask(function () {
        $.ajax({
            cache: false,
            type: "POST",
            dataType: "json",
            contentType: "application/json;charset=utf-8",
            url: "../admin/role.add",
            data: JSON.stringify(role),
            timeout: 30000,
            success: function (data) {
                if (data) {
                    $(".data-loading").hide();
                    var code = data.code;
                    if (code != 0) {
                        dangerBox(data.message);
                        lock = false;
                        return false;
                    }
                    lock = false;
                    $('#form_modal').modal('hide')
                    successBox('角色新建成功.');
                    $('#btn_role_refresh').trigger('click');
                }
                return false;
            },
            error: function (e) {
                if (e.status == 404) {
                    window.location = "../404.html";
                }
                else if (e.status == 500) {
                    window.location = "../500.html";
                }
            }
        });
    });
    task.delay(500);
    return false;
};

/**
* 角色编辑
*/
function onEdit() {
    if (!checkForm()) {
        return false;
    }
    $('.data-loading').show();
    var task = new DelayedTask(function () {
        $.ajax({
            cache: false,
            type: "POST",
            dataType: "json",
            contentType: "application/json;charset=utf-8",
            url: "../admin/role.edit",
            data: JSON.stringify(role),
            timeout: 30000,
            success: function (data) {
                if (data) {
                    $(".data-loading").hide();
                    var code = data.code;
                    if (code != 0) {
                        dangerBox(data.message);
                        lock = false;
                        return false;
                    }

                    lock = false;
                    $('#form_modal').modal('hide')
                    successBox('角色编辑成功.');
                    $('#btn_role_refresh').trigger('click');
                }
                return false;
            },
            error: function (e) {
                if (e.status == 404) {
                    window.location = "../404.html";
                }
                else if (e.status == 500) {
                    window.location = "../500.html";
                }
            }
        });
    });
    task.delay(500);
    return false;
};

/**
* 角色删除
*/
function onDelete() {
    if (lock) return false;
    lock = true;
    var ids = [];
    var rowList = dataGrid.bootstrapTable('getSelections');
    var length = rowList.length;
    if (length == 0) {
        warningBox('请选择删除对象.');
        lock = false;
        return false;
    }
    var flag = false;
    for (var i in rowList) {
        var row = rowList[i];
        var createrId = row.createrId;
        if (userToken.id != createrId) {
            flag = true;
        }
        var id = row.id;
        ids.push(id);
    }
    if (flag) {
        warningBox('对不起,您无权删除该角色.');
        lock = false;
        return false;
    }
    var params = {};
    params.ids = ids;
    deleteModal(ids);
    return false;
};

/**
* 删除模态
*/
function deleteModal(ids) {
    confirmBox('您确定要删除吗?!', function (result) {
        if (result) {
            $('.data-loading').show();
            $.ajax({
                cache: false,
                type: 'POST',
                dataType: 'json',
                contentType: 'application/json;charset=utf-8',
                url: '../admin/role.delete',
                data: JSON.stringify(ids),
                timeout: 30000,
                success: function (data) {
                    if (data) {
                        $('.data-loading').hide();
                        var code = data.code;
                        if (code != 0) {
                            dangerBox(data.message);
                            lock = false;
                            return false;
                        }
                        lock = false;
                        successBox('角色删除成功.');
                        $('#btn_role_refresh').trigger('click');
                    }
                    return false;
                },
                error: function (e) {
                    if (e.status == 404) {
                        window.location = '../404.html';
                    }
                    else if (e.status == 500) {
                        window.location = '../500.html';
                    }
                }
            });
        }
        else {
            lock = false;
        }
    });
    return false;
};



/**
* 选择模块
*/
function checkModule(moduleId) {
    $("input[name='fun_" + moduleId + "']").each(function () {
        if ($(this).is(":checked") == true) {
            $(this).prop("checked", false)
        }
        else {
            $(this).prop("checked", true);
        }
    });

};
/**
* 选择功能
*/
function checkFun(moduleId) {
    var funLength = $("input[name='fun_" + moduleId + "']:checkbox:checked").length;
    if (funLength != 0) {
        $("input[name='mod_" + moduleId + "']").prop("checked", true);
    }
    else {
        $("input[name='mod_" + moduleId + "']").prop("checked", false);
    }
};

/**
* 选择动作
*/
function checkAction(funId) {
    var actLength = $("input[name='act_" + funId + "']:checkbox:checked").length;
    if (actLength != 0) {
        $("input[id='power_" + funId + "']").prop("checked", true);
    }
    else {
        $("input[id='power_" + funId + "']").prop("checked", false);
    }

};

4）业务控制器 RoleController.java

package com.hwabao.controller;

import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
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.servlet.ModelAndView;

import com.hwabao.common.CommanUtil;
import com.hwabao.common.EntityGrid;
import com.hwabao.common.SessionValidate;
import com.hwabao.model.ModuleInfo;
import com.hwabao.model.RoleInfo;
import com.hwabao.model.RoleModule;
import com.hwabao.model.UserInfo;
import com.hwabao.service.IModuleInfoService;
import com.hwabao.service.IRoleInfoService;
import com.hwabao.service.IRoleModuleService;
import com.hwabao.service.ITransactionalService;

/**
 * 
* @ClassName: RoleController 
* @Description: 角色控制器
* @author steven9801@163.com 
* @date 2015-4-21 下午04:36:24 
*
 */
@Controller
@RequestMapping("/admin")
public class RoleController extends BaseController
{
    private static final Logger logger = LoggerFactory.getLogger(RoleController.class);
    
    @Autowired
    private HttpServletRequest request;

    @Autowired
    private IRoleInfoService roleInfoService;
    @Autowired
    private IModuleInfoService moduleInfoService;
    @Autowired
    private IRoleModuleService roleModuleService;
    @Autowired
    private ITransactionalService transactionalService;
    /**
     * 角色界面
     */
    @SessionValidate(comment="角色界面")
    @RequestMapping(value = "/role", method = RequestMethod.GET)
    public ModelAndView index() throws Exception
    {
        UserInfo user =  this.appContext.getCurrentUser(request);
        if(user!=null)
        {
            ModelAndView mv = this.handlerModelView(user,"backend/role");
            ModuleInfo model = new ModuleInfo();
            model.moduleSortAsc();
            List<ModuleInfo> list = moduleInfoService.selectModuleInfo(model);
            List<ModuleInfo> moduleList = this.toObjectModuleTree(list,0);
            mv.addObject("moduleList", moduleList);
            return  mv;
        }
        return this.handlerModelView("backend/login"); 
    }

    
    @SessionValidate(comment="角色列表")
    @RequestMapping(value = "/role", method = RequestMethod.POST)
    @ResponseBody
    public String grid(@RequestBody RoleInfo roleInfo) throws Exception
    {
        UserInfo user =  this.appContext.getCurrentUser(request);
        if(user==null)
        {
            return this.handlerSuccessMessage("../admin/login");
        }
    
        try 
        {
            RoleInfo roleInfoModel = findRoleInfo(roleInfo);
    
            int total  = roleInfoService.getRoleInfoSearchCount(roleInfoModel);
            List<RoleInfo> roleList = roleInfoService.searchRoleInfo(roleInfoModel);
            
            EntityGrid<RoleInfo> entityGrid = null;
            if(roleList!=null&&roleList.size()>0)
            {
                for(RoleInfo role:roleList)
                {
                    List<Integer> moduleIdList =  new ArrayList<Integer>();
                    RoleModule roleModule = new RoleModule();
                    roleModule.setRoleId(role.getId());
                    List<RoleModule> roleModuleList = roleModuleService.selectRoleModule(roleModule);
                    for(RoleModule module:roleModuleList)
                    {
                        moduleIdList.add(module.getModuleId());
                    }
                    role.setModuleIdList(moduleIdList);
                }

                entityGrid = new EntityGrid<RoleInfo>();
                entityGrid.rows = roleList;
                entityGrid.total = total;
            }
            else
            {
                entityGrid = new EntityGrid<RoleInfo>();
            }
            return this.handlerResponseMessage(entityGrid);
        } 
        catch (Exception e) 
        {
            logger.debug(e.getMessage().toString());
            return this.handlerFailMessage(e.getMessage().toString());
        }
    }
    
    
    /**
     * 角色添加
     */
    @SessionValidate(comment="角色添加")
    @RequestMapping(value = "/role.add", method = RequestMethod.POST,consumes="application/json")
    @ResponseBody
    public String add(@RequestBody RoleInfo roleInfo) throws Exception 
    {
        UserInfo user =  this.appContext.getCurrentUser(request);
        if(user==null)
        {
            return this.handlerSuccessMessage("../admin/login");
        }
    
        try 
        {
            String roleName = roleInfo.getRoleName();
            RoleInfo model = new RoleInfo();
            model.setRoleName(roleName);
            RoleInfo cl = roleInfoService.getRoleInfo(model);
            if(cl!=null)
            {
                throw new Exception("角色名称重复.");
            }
            
            roleInfo.setCreatedAt(CommanUtil.getCurrentDatetime());
            roleInfo.setCreaterId(user.getId());
            int change = transactionalService.insertRoleInfo(roleInfo);
            if(change==0)
            {
                throw new Exception("角色新建失败.");
            }
            this.logSuccess("角色新建");
            return this.handlerSuccessMessage("../admin/role");
        } 
        catch (Exception e) 
        {
            this.logFailed("角色新建");
            logger.debug(e.getMessage().toString());
            return this.handlerFailMessage(e.getMessage().toString());
        }
    }

    
    /**
     * 角色编辑
     */
    @SessionValidate(comment="角色编辑")
    @RequestMapping(value = "/role.edit", method = RequestMethod.POST,consumes="application/json")
    @ResponseBody
    public String edit(@RequestBody RoleInfo roleInfo) throws Exception 
    {
        UserInfo user =  this.appContext.getCurrentUser(request);
        if(user==null)
        {
            return this.handlerSuccessMessage("../admin/login");
        }
        
        try 
        {
            int change = transactionalService.updateRoleInfo(roleInfo);
            if(change==0)
            {
                throw new Exception("角色编辑失败.");
            }
            this.logSuccess("角色编辑");
            return this.handlerSuccessMessage("../admin/role");
        } 
        catch (Exception e) 
        {
            this.logFailed("角色编辑");
            logger.debug(e.getMessage().toString());
            return this.handlerFailMessage(e.getMessage().toString());
        }
    }
    
    /**
     * 角色删除
     */
    @SessionValidate(comment="角色删除")
    @RequestMapping(value = "/role.delete",method = RequestMethod.POST,consumes="application/json")
    @ResponseBody
    public String delete(@RequestBody List<Integer> params) throws Exception
    {
        UserInfo user =  this.appContext.getCurrentUser(request);
        if(user==null)
        {
            return this.handlerSuccessMessage("../admin/login");
        }
        
        try 
        {
            if(params.size()==0)
            {
                throw new Exception("params参数非空.");
            }
            
            List<RoleInfo> roleList = new ArrayList<RoleInfo>();
            for(Integer roleid : params)
            {
                RoleInfo roleInfo = new RoleInfo();
                roleInfo.setId(roleid);
                roleList.add(roleInfo);
            }
            int change = transactionalService.deleteRoleInfo((ArrayList<RoleInfo>)roleList);
            if(change==0)
            {
                throw new Exception("角色删除失败.");
            }
            this.logSuccess("角色删除");
            return this.handlerSuccessMessage("../admin/role");
        }
        catch (Exception e) 
        {
            this.logFailed("角色删除");
            logger.debug(e.getMessage().toString());
            return this.handlerFailMessage(e.getMessage().toString());
        }
    }
    
    /**
     * 封装前端查询角色条件的方法
     * @param roleInfo
     * @return
     */
    private RoleInfo findRoleInfo(RoleInfo roleInfo)
    {
        if(roleInfo.getSortName()!=null&&roleInfo.getSortOrder()!=null)
        {
            String sortName = roleInfo.getSortName();
            String sortOrder = roleInfo.getSortOrder();
            roleInfo.setOrderBy(sortName, sortOrder);
        }
        if(roleInfo.getRoleName() != null)
        {
            roleInfo.roleNameLike(roleInfo.getRoleName());
        }
        return roleInfo;
    }
    
}

（5）业务实体层 RoleInfo.java

package com.hwabao.model;

import java.util.List;

import com.hwabao.common.VoBase;

/**
 * @author steven9801@163.com
 */

public class RoleInfo extends VoBase<RoleInfo> {

    private static final long serialVersionUID = 1L;

 /**
  * 
  */
    private Integer id;

 /**
  * 角色名称
  */
    private String roleName;

 /**
  * 角色备注
  */
    private String roleMark;

 /**
  * 记录创建者id
  */
    private Integer createrId;

 /**
  * 
  */
    private String updatedAt;

 /**
  * 
  */
    private String createdAt;

 /**
  * 记录更新时间戳
  */
    private String timeStamp;

    //---------------------扩展属性-----------begin-----------//
    
    private List<Integer> moduleIdList;  
    public List<Integer> getModuleIdList() {
        return moduleIdList;
    }

    public void setModuleIdList(List<Integer> moduleIdList) {
        this.moduleIdList = moduleIdList;
    }


    //---------------------扩展属性-----------end-----------//
    

    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public void idDesc() {
        _setOrder("id", "DESC");
    }

    public void idAsc() {
        _setOrder("id", "ASC");
    }

    public void idMax(Integer max) {
        _setRangeMax("id", String.valueOf(max));
    }

    public void idMin(Integer min) {
        _setRangeMin("id", String.valueOf(min));
    }

    public void idEqual(boolean equal) {
        _setRangeEqual("id", equal);
    }

    public void idIn(Integer in) {
        _setIn("id", String.valueOf(in));
    }

    public void idNotIn(Integer notin) {
        _setNotIn("id", String.valueOf(notin));
    }

    public void idOr(Integer or) {
        _setOr("id", String.valueOf(or));
    }

    public void idOrIn(Integer in) {
        _setOrIn("id", String.valueOf(in));
    }

    public void idOrNotIn(Integer notin) {
        _setOrNotIn("id", String.valueOf(notin));
    }

    public void idNull() {
        _setNull("id", null);
    }

    public void idNotNull(Integer nl) {
        _setNotNull("id", String.valueOf(nl));
    }

    public String getRoleName() {
        return this.roleName;
    }

    public void setRoleName(String roleName) {
        this.roleName = roleName;
    }

    public void roleNameDesc() {
        _setOrder("roleName", "DESC");
    }

    public void roleNameAsc() {
        _setOrder("roleName", "ASC");
    }

    public void roleNameMax(String max) {
        _setRangeMax("roleName", max);
    }

    public void roleNameMin(String min) {
        _setRangeMin("roleName", min);
    }

    public void roleNameEqual(boolean equal) {
        _setRangeEqual("roleName", equal);
    }

    public void roleNameLike(String like) {
        _setLike("roleName", like);
        setRoleName(null);
    }

    public void roleNameOrLike(String like) {
        _setOrLike("roleName", like);
        setRoleName(null);
    }

    public void roleNameIn(String in) {
        _setIn("roleName", in);
    }

    public void roleNameNotIn(String notin) {
        _setNotIn("roleName", notin);
    }

    public void roleNameOr(String or) {
        _setOr("roleName", or);
    }

    public void roleNameOrIn(String in) {
        _setOrIn("roleName", in);
    }

    public void roleNameOrNotIn(String notin) {
        _setOrNotIn("roleName", notin);
    }

    public void roleNameNull() {
        _setNull("roleName", null);
    }

    public void roleNameNotNull(String nl) {
        _setNotNull("roleName", nl);
    }

    public String getRoleMark() {
        return this.roleMark;
    }

    public void setRoleMark(String roleMark) {
        this.roleMark = roleMark;
    }

    public void roleMarkDesc() {
        _setOrder("roleMark", "DESC");
    }

    public void roleMarkAsc() {
        _setOrder("roleMark", "ASC");
    }

    public void roleMarkMax(String max) {
        _setRangeMax("roleMark", max);
    }

    public void roleMarkMin(String min) {
        _setRangeMin("roleMark", min);
    }

    public void roleMarkEqual(boolean equal) {
        _setRangeEqual("roleMark", equal);
    }

    public void roleMarkLike(String like) {
        _setLike("roleMark", like);
        setRoleMark(null);
    }

    public void roleMarkOrLike(String like) {
        _setOrLike("roleMark", like);
        setRoleMark(null);
    }

    public void roleMarkIn(String in) {
        _setIn("roleMark", in);
    }

    public void roleMarkNotIn(String notin) {
        _setNotIn("roleMark", notin);
    }

    public void roleMarkOr(String or) {
        _setOr("roleMark", or);
    }

    public void roleMarkOrIn(String in) {
        _setOrIn("roleMark", in);
    }

    public void roleMarkOrNotIn(String notin) {
        _setOrNotIn("roleMark", notin);
    }

    public void roleMarkNull() {
        _setNull("roleMark", null);
    }

    public void roleMarkNotNull(String nl) {
        _setNotNull("roleMark", nl);
    }

    public Integer getCreaterId() {
        return this.createrId;
    }

    public void setCreaterId(Integer createrId) {
        this.createrId = createrId;
    }

    public void createrIdDesc() {
        _setOrder("createrId", "DESC");
    }

    public void createrIdAsc() {
        _setOrder("createrId", "ASC");
    }

    public void createrIdMax(Integer max) {
        _setRangeMax("createrId", String.valueOf(max));
    }

    public void createrIdMin(Integer min) {
        _setRangeMin("createrId", String.valueOf(min));
    }

    public void createrIdEqual(boolean equal) {
        _setRangeEqual("createrId", equal);
    }

    public void createrIdIn(Integer in) {
        _setIn("createrId", String.valueOf(in));
    }

    public void createrIdNotIn(Integer notin) {
        _setNotIn("createrId", String.valueOf(notin));
    }

    public void createrIdOr(Integer or) {
        _setOr("createrId", String.valueOf(or));
    }

    public void createrIdOrIn(Integer in) {
        _setOrIn("createrId", String.valueOf(in));
    }

    public void createrIdOrNotIn(Integer notin) {
        _setOrNotIn("createrId", String.valueOf(notin));
    }

    public void createrIdNull() {
        _setNull("createrId", null);
    }

    public void createrIdNotNull(Integer nl) {
        _setNotNull("createrId", String.valueOf(nl));
    }

    public String getUpdatedAt() {
        return this.updatedAt;
    }

    public void setUpdatedAt(String updatedAt) {
        this.updatedAt = updatedAt;
    }

    public void updatedAtDesc() {
        _setOrder("updatedAt", "DESC");
    }

    public void updatedAtAsc() {
        _setOrder("updatedAt", "ASC");
    }

    public void updatedAtMax(String max) {
        _setRangeMax("updatedAt", max);
    }

    public void updatedAtMin(String min) {
        _setRangeMin("updatedAt", min);
    }

    public void updatedAtEqual(boolean equal) {
        _setRangeEqual("updatedAt", equal);
    }

    public void updatedAtLike(String like) {
        _setLike("updatedAt", like);
        setUpdatedAt(null);
    }

    public void updatedAtOrLike(String like) {
        _setOrLike("updatedAt", like);
        setUpdatedAt(null);
    }

    public void updatedAtIn(String in) {
        _setIn("updatedAt", in);
    }

    public void updatedAtNotIn(String notin) {
        _setNotIn("updatedAt", notin);
    }

    public void updatedAtOr(String or) {
        _setOr("updatedAt", or);
    }

    public void updatedAtOrIn(String in) {
        _setOrIn("updatedAt", in);
    }

    public void updatedAtOrNotIn(String notin) {
        _setOrNotIn("updatedAt", notin);
    }

    public void updatedAtNull() {
        _setNull("updatedAt", null);
    }

    public void updatedAtNotNull(String nl) {
        _setNotNull("updatedAt", nl);
    }

    public String getCreatedAt() {
        return this.createdAt;
    }

    public void setCreatedAt(String createdAt) {
        this.createdAt = createdAt;
    }

    public void createdAtDesc() {
        _setOrder("createdAt", "DESC");
    }

    public void createdAtAsc() {
        _setOrder("createdAt", "ASC");
    }

    public void createdAtMax(String max) {
        _setRangeMax("createdAt", max);
    }

    public void createdAtMin(String min) {
        _setRangeMin("createdAt", min);
    }

    public void createdAtEqual(boolean equal) {
        _setRangeEqual("createdAt", equal);
    }

    public void createdAtLike(String like) {
        _setLike("createdAt", like);
        setCreatedAt(null);
    }

    public void createdAtOrLike(String like) {
        _setOrLike("createdAt", like);
        setCreatedAt(null);
    }

    public void createdAtIn(String in) {
        _setIn("createdAt", in);
    }

    public void createdAtNotIn(String notin) {
        _setNotIn("createdAt", notin);
    }

    public void createdAtOr(String or) {
        _setOr("createdAt", or);
    }

    public void createdAtOrIn(String in) {
        _setOrIn("createdAt", in);
    }

    public void createdAtOrNotIn(String notin) {
        _setOrNotIn("createdAt", notin);
    }

    public void createdAtNull() {
        _setNull("createdAt", null);
    }

    public void createdAtNotNull(String nl) {
        _setNotNull("createdAt", nl);
    }

    public String getTimeStamp() {
        return this.timeStamp;
    }

    public void setTimeStamp(String timeStamp) {
        this.timeStamp = timeStamp;
    }

    public void timeStampDesc() {
        _setOrder("timeStamp", "DESC");
    }

    public void timeStampAsc() {
        _setOrder("timeStamp", "ASC");
    }

    public void timeStampMax(String max) {
        _setRangeMax("timeStamp", max);
    }

    public void timeStampMin(String min) {
        _setRangeMin("timeStamp", min);
    }

    public void timeStampEqual(boolean equal) {
        _setRangeEqual("timeStamp", equal);
    }

    public void timeStampLike(String like) {
        _setLike("timeStamp", like);
        setTimeStamp(null);
    }

    public void timeStampOrLike(String like) {
        _setOrLike("timeStamp", like);
        setTimeStamp(null);
    }

    public void timeStampIn(String in) {
        _setIn("timeStamp", in);
    }

    public void timeStampNotIn(String notin) {
        _setNotIn("timeStamp", notin);
    }

    public void timeStampOr(String or) {
        _setOr("timeStamp", or);
    }

    public void timeStampOrIn(String in) {
        _setOrIn("timeStamp", in);
    }

    public void timeStampOrNotIn(String notin) {
        _setOrNotIn("timeStamp", notin);
    }

    public void timeStampNull() {
        _setNull("timeStamp", null);
    }

    public void timeStampNotNull(String nl) {
        _setNotNull("timeStamp", nl);
    }

    public String _getPrimary() {
        return String.valueOf(id);
    }

    public String toString() {
        StringBuffer sb = new StringBuffer();
        sb.append("{\n");
        sb.append("    id:" + getId() + ",\n");
        sb.append("    role_name:" + _getSnap(getRoleName()) + ",\n");
        sb.append("    role_mark:" + _getSnap(getRoleMark()) + ",\n");
        sb.append("    creater_id:" + getCreaterId() + ",\n");
        sb.append("    updated_at:" + _getSnap(getUpdatedAt()) + ",\n");
        sb.append("    created_at:" + _getSnap(getCreatedAt()) + ",\n");
        sb.append("    time_stamp:" + _getSnap(getTimeStamp()) + "\n");
        sb.append("}\n");
        return sb.toString();
    }

    public void setOrderBy(String sortName,String sortOrder){
      if(sortOrder.equalsIgnoreCase("asc")){
          if(sortName.equalsIgnoreCase("id")){
           idAsc();
               }
          if(sortName.equalsIgnoreCase("roleName")){
           roleNameAsc();
               }
          if(sortName.equalsIgnoreCase("roleMark")){
           roleMarkAsc();
               }
          if(sortName.equalsIgnoreCase("createrId")){
           createrIdAsc();
               }
          if(sortName.equalsIgnoreCase("updatedAt")){
           updatedAtAsc();
               }
          if(sortName.equalsIgnoreCase("createdAt")){
           createdAtAsc();
               }
          if(sortName.equalsIgnoreCase("timeStamp")){
           timeStampAsc();
               }
            }
       else if(sortOrder.equalsIgnoreCase("desc")){
       if(sortName.equalsIgnoreCase("id")){
           idDesc();
                  }
       if(sortName.equalsIgnoreCase("roleName")){
           roleNameDesc();
                  }
       if(sortName.equalsIgnoreCase("roleMark")){
           roleMarkDesc();
                  }
       if(sortName.equalsIgnoreCase("createrId")){
           createrIdDesc();
                  }
       if(sortName.equalsIgnoreCase("updatedAt")){
           updatedAtDesc();
                  }
       if(sortName.equalsIgnoreCase("createdAt")){
           createdAtDesc();
                  }
       if(sortName.equalsIgnoreCase("timeStamp")){
           timeStampDesc();
                  }
              }
}
    public boolean equals(Object o) {
        if (o instanceof RoleInfo) {
            RoleInfo roleInfo = (RoleInfo) o;
            return roleInfo.getId().equals(getId()) &&
                   roleInfo.getRoleName().equals(getRoleName()) &&
                   roleInfo.getRoleMark().equals(getRoleMark()) &&
                   roleInfo.getCreaterId().equals(getCreaterId()) &&
                   roleInfo.getUpdatedAt().equals(getUpdatedAt()) &&
                   roleInfo.getCreatedAt().equals(getCreatedAt()) &&
                   roleInfo.getTimeStamp().equals(getTimeStamp());
        }
        return false;
    }
}

（6）业务数据层 IRoleInfoData.java

package com.hwabao.data;

import java.util.List;
import java.util.ArrayList;
import com.hwabao.model.RoleInfo;
import com.hwabao.common.Pager;

/**
 * @author steven9801@163.com
 */

public interface IRoleInfoData {

    public int insertRoleInfo(RoleInfo roleInfo);

    public int updateRoleInfo(RoleInfo roleInfo);

    public int deleteRoleInfo(RoleInfo roleInfo);

    public RoleInfo getRoleInfo(RoleInfo roleInfo);

    public int getRoleInfoCount(RoleInfo roleInfo);

    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo);

    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo, Pager pager);

    public List<RoleInfo> selectRoleInfoByList(ArrayList<Integer> arrListId);

    public int getRoleInfoSearchCount(RoleInfo roleInfo);

    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo);

    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo, Pager pager);

}

（7）业务服务层 RoleInfoService.java

package com.hwabao.service.impl;

import java.util.List;
import java.util.ArrayList;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.hwabao.data.IRoleInfoData;
import com.hwabao.model.RoleInfo;
import com.hwabao.service.IRoleInfoService;
import com.hwabao.common.Pager;

/**
 * @author steven9801@163.com
 */

@Service
public class RoleInfoService implements IRoleInfoService {

    @Autowired
    private IRoleInfoData roleInfoData;

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int insertRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.insertRoleInfo(roleInfo);
    }

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int insertRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo) {
        int insertedCount = 0;
        int result;
        RoleInfo roleInfo;
        for (int i = 0; i < arrListRoleInfo.size(); i++) {
            roleInfo = arrListRoleInfo.get(i);
            result = roleInfoData.insertRoleInfo(roleInfo);
            if (result < 1) {
                return 0;
            }
            insertedCount++;
        }
        return insertedCount;
    }

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int updateRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.updateRoleInfo(roleInfo);
    }

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int updateRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo) {
        int updatedCount = 0;
        int result;
        RoleInfo roleInfo;
        for (int i = 0; i < arrListRoleInfo.size(); i++) {
            roleInfo = arrListRoleInfo.get(i);
            result = roleInfoData.updateRoleInfo(roleInfo);
            if (result < 1) {
                return 0;
            }
            updatedCount++;
        }
        return updatedCount;
    }

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int deleteRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.deleteRoleInfo(roleInfo);
    }

    @Override
    @Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = { Exception.class })
    public int deleteRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo) {
        int deletedCount = 0;
        int result;
        RoleInfo roleInfo;
        for (int i = 0; i < arrListRoleInfo.size(); i++) {
            roleInfo = arrListRoleInfo.get(i);
            result = roleInfoData.deleteRoleInfo(roleInfo);
            if (result < 1) {
                return 0;
            }
            deletedCount++;
        }
        return deletedCount;
    }

    @Override
    public RoleInfo getRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.getRoleInfo(roleInfo);
    }

    @Override
    public RoleInfo getRoleInfo(Integer id) {
        RoleInfo roleInfo = new RoleInfo();
        roleInfo.setId(id);
        return getRoleInfo(roleInfo);
    }

    @Override
    public int getRoleInfoCount(RoleInfo roleInfo) {
        return roleInfoData.getRoleInfoCount(roleInfo);
    }

    @Override
    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.selectRoleInfo(roleInfo);
    }

    @Override
    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo, Pager pager) {
        if (null != pager) {
            int count = roleInfoData.getRoleInfoCount(roleInfo);
            if (count == 0) {
                return null;
            }
            pager.setRowCount(count);
        }
        return roleInfoData.selectRoleInfo(roleInfo, pager);
    }

    @Override
    public List<RoleInfo> selectRoleInfoByList(ArrayList<Integer> arrListId) {
        if (arrListId.size() == 0) {
            return null;
        }
        return roleInfoData.selectRoleInfoByList(arrListId);
    }

    @Override
    public int getRoleInfoSearchCount(RoleInfo roleInfo) {
        return roleInfoData.getRoleInfoSearchCount(roleInfo);
    }

    @Override
    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo) {
        return roleInfoData.searchRoleInfo(roleInfo);
    }

    @Override
    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo, Pager pager) {
        if (null != pager) {
            int count = roleInfoData.getRoleInfoSearchCount(roleInfo);
            if (count == 0) {
                return null;
            }
            pager.setRowCount(count);
        }
        return roleInfoData.searchRoleInfo(roleInfo, pager);
    }

}
package com.hwabao.service;

import java.util.List;
import java.util.ArrayList;
import com.hwabao.model.RoleInfo;
import com.hwabao.common.Pager;

/**
 * @author steven9801@163.com
 */

public interface IRoleInfoService {

    public int insertRoleInfo(RoleInfo roleInfo);

    public int insertRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo);

    public int updateRoleInfo(RoleInfo roleInfo);

    public int updateRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo);

    public int deleteRoleInfo(RoleInfo roleInfo);

    public int deleteRoleInfoBatch(ArrayList<RoleInfo> arrListRoleInfo);

    public RoleInfo getRoleInfo(RoleInfo roleInfo);

    public RoleInfo getRoleInfo(Integer id);

    public int getRoleInfoCount(RoleInfo roleInfo);

    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo);

    public List<RoleInfo> selectRoleInfo(RoleInfo roleInfo, Pager pager);

    public List<RoleInfo> selectRoleInfoByList(ArrayList<Integer> arrListId);

    public int getRoleInfoSearchCount(RoleInfo roleInfo);

    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo);

    public List<RoleInfo> searchRoleInfo(RoleInfo roleInfo, Pager pager);

}

就这样简单整个业务表的CRUD结构清晰的完整的呈现在你面前啦。管中窥豹，真正拥有者会如获至宝。

敬请期待下期：

asp.net mvc 实战化项目之三板斧

感兴趣的朋友扫下面的二维码给点打赏吧！

                  

posted @ 2016-11-21 10:16  火腿骑士  阅读(473)  评论(0)  编辑  收藏  举报