SSM+EasyUI集成

素颜马尾好姑娘i 2022-02-23 10:58 328阅读 0赞

# （一）SSM集成 #

###### 1. 创建maven项目 ######

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 1]

###### 2. 导包 ######

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>cn.itsource.crm</groupId>
        <artifactId>crm</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>crm Maven Webapp</name>
        
        <url>http://www.example.com</url>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            <org.springframework.version>4.2.5.RELEASE</org.springframework.version>
            <org.hibernate.version>4.3.8.Final</org.hibernate.version>
            <spring-data-jpa.version>1.9.0.RELEASE</spring-data-jpa.version>
            <com.fasterxml.jackson.version>2.5.0</com.fasterxml.jackson.version>
        </properties>
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.2.5.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${org.springframework.version}</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${org.springframework.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-io</artifactId>
                <version>1.3.2</version>
            </dependency>
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.2.2</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${com.fasterxml.jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${com.fasterxml.jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${com.fasterxml.jackson.version}</version>
            </dependency>
    
            <dependency>
                <groupId>commons-dbcp</groupId>
                <artifactId>commons-dbcp</artifactId>
                <version>1.2.2</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
            </dependency>
    
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
                <version>3.5</version>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
                
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>commons-logging</groupId>
                <artifactId>commons-logging</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            
            
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.0</version>
            </dependency>
            
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.2</version>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>1.7.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.5</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>5.0.1</version>
            </dependency>
    
        </dependencies>
    
        <build>
            <finalName>crm</finalName>
                <plugins>
                    <plugin>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-maven-plugin</artifactId>
                        <version>1.3.2</version>
                        <configuration>
                            <verbose>false</verbose>
                            <overwrite>true</overwrite>
                        </configuration>
                    </plugin>
                    <plugin>
                        <artifactId>maven-clean-plugin</artifactId>
                        <version>3.1.0</version>
                    </plugin>
                    
                    <plugin>
                        <artifactId>maven-resources-plugin</artifactId>
                        <version>3.0.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-compiler-plugin</artifactId>
                        <version>3.8.0</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-surefire-plugin</artifactId>
                        <version>2.22.1</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-war-plugin</artifactId>
                        <version>3.2.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-install-plugin</artifactId>
                        <version>2.5.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-deploy-plugin</artifactId>
                        <version>2.8.2</version>
                    </plugin>
                </plugins>
        </build>
    </project>

###### 3. 创建结构 ######

*  项目结构图：  
    ![在这里插入图片描述][20190407201137468.png]
 *  创建crm数据库，并导入表格

###### 4.创建配置文件 ######

*   *  jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql:///crm
    jdbc.username=root
    jdbc.password=admin

*  applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="
           http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
    ">
      
        <context:component-scan base-package="cn.lzj.crm.service" />
    
      
      <context:property-placeholder location="classpath:jdbc.properties" />
    
      
      <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
      </bean>
    
      
      <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          
          <property name="dataSource" ref="dataSource" />
          
          <property name="typeAliasesPackage" value="cn.lzj.crm.domain" />
          
          <property name="mapperLocations" value="classpath:cn/lzj/crm/mapper/*.xml" />
      </bean>
    
      
       
    
      
      <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
          
          <property name="basePackage" value="cn.lzj.crm.mapper" />
          <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
      </bean>
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource" />
        </bean>
        
        <tx:annotation-driven transaction-manager="transactionManager" />
    </beans>

*  applicationContext-mvc.xml

*  generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
        
        <classPathEntry   location="D:\openSource\mysql-connector-java-5.1.26-bin.jar"/>
        
        <context id="DB2Tables"   targetRuntime="MyBatis3Simple" >
            
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql:///crm"
                            userId="root" password="admin">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="cn.lzj.crm.domain" targetProject="src/main/java">
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="cn.lzj.crm.mapper" targetProject="src/main/resources">
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="cn.lzj.crm.mapper" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
            <table tableName="t_department" domainObjectName="Department">
                <generatedKey column="id" sqlStatement="MySql" />
            </table>
        </context>
    </generatorConfiguration>

*  log4j.properties

#全局:你要打印的东西:只打印错误
    log4j.rootLogger=ERROR, stdout
    #log4j.rootLogger=NONE
    #把左边包名需要修改为对应的包名
    #局部要求 ERROR:错误  Warn：警告 Info：信息 Debug:调试 TRACE:详细  NONE:不显示日志信息
    log4j.logger.cn.lzj=TRACE
    
    #代表的是打印的位置
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    #打印的格式(可以灵活地指定布局模式)
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    #这里就是自定义的格式 %d:时间  %p:级别
    log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

*  web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://java.sun.com/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
    		  http://java.sun.com/xml/ns/javaee/web-app_4_0.xsd"
             version="4.0">
      
      <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          
          <param-name>contextConfigLocation</param-name>
          
          <param-value>classpath:applicationContext-mvc.xml</param-value>
        </init-param>
        
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
      </context-param>
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
    
      
      <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
          <param-name>encoding</param-name>
          <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
          <param-name>forceEncoding</param-name>
          <param-value>true</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    </web-app>

###### 5.使用mybatis的代码生成器创建mapper和domain ######

###### 6.抽取公共代码 ######

*  BaseMapper

package cn.lzj.crm.mapper;
    import java.util.List;
    public interface BaseMapper<T> {
        int deleteByPrimaryKey(Long id);
        int insert(T record);
        T selectByPrimaryKey(Long id);
        List<T> selectAll();
        int updateByPrimaryKey(T record);
    }

DepartmentMapper 继承BaseMapper

public interface DepartmentMapper extends BaseMapper<Department> {}

*  IBaseService

public interface IBaseService<T> {
        void save(T department);
        void delete(Long id);
        void update(T department);
        T findOne(Long id);
        List<T> findAll();
    }

IDepartmentService继承IBaseService

public interface IDepartmentService extends IBaseService<Department>{}

*  BaseServiceImpl

package cn.lzj.crm.service.impl;
    
    import cn.lzj.crm.domain.Department;
    import cn.lzj.crm.mapper.BaseMapper;
    import cn.lzj.crm.mapper.DepartmentMapper;
    import cn.lzj.crm.service.IBaseService;
    import cn.lzj.crm.service.IDepartmentService;
    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 java.util.List;
    
    //注意父业务层，不要配置@Service，因为@Service是一个不能被继承的注解
    @Transactional(readOnly = true,propagation = Propagation.SUPPORTS)
    public class BaseServiceImpl<T> implements IBaseService<T> {
    
        @Autowired
        private BaseMapper<T> mapper;
    
        @Override
        @Transactional
        public void save(T t) {
            mapper.insert(t);
        }
    
        @Override
        @Transactional
        public void delete(Long id) {
            mapper.deleteByPrimaryKey(id);
        }
    
        @Override
        @Transactional
        public void update(T t) {
            mapper.updateByPrimaryKey(t);
        }
    
        @Override
        public T findOne(Long id) {
            return mapper.selectByPrimaryKey(id);
        }
    
        @Override
        public List<T> findAll() {
            return mapper.selectAll();
        }
    }

DepartmentServiceImpl继承BaseServiceImpl，并实现IDepartmentService

@Service
    public class DepartmentServiceImpl extends BaseServiceImpl<Department>
            implements IDepartmentService {
    }

###### 7.创建controller层，配置Tomcat，测试是否能访问页面内容 ######

到此SSM项目便成功集成

# （二）SSM框架集成EasyUI进行CRUD #

###### 1.引入EasyUI的js文件 ######

注：此处不需要再将整个easyUI资源全部拷入，只需要拷贝基本功能即可，简约空间，并且提高性能

> locale : 国际化支持的文件夹  
> themes ：主题(eaayui的样式)  
> jquery.easyui.min.js ： easyui核心的js功能  
> jquery.min.js ： jQuery的支持

![在这里插入图片描述][20190407220543822.png]

###### 2.上下文路径 ######

> idea中配置上下文路径 猫编辑 -> Deployment ->Application context  
> 所有的请求都必需加上这个路径  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 2]

方案一:在请求前 ： $\{pageContext.request.contextPath\}  
方案二:使用Base标签(推荐，建议在公共jsp内进行添加)

<%
     String path = request.getContextPath();
     String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    <base href="<%=basePath%>">

###### 3. 准备common.jsp (/WEB-INF/views/common/common.jsp) ######

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <%
        String path = request.getContextPath();
        String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    <base href="<%=basePath%>">
    <%--easyui的样式--%>
    <link rel="stylesheet" type="text/css" href="easyui/themes/default/easyui.css">
    <%--图标样式--%>
    <link rel="stylesheet" type="text/css" href="easyui/themes/icon.css">
    <%--jquery支持--%>
    <script type="text/javascript" src="easyui/jquery.min.js"></script>
    <%--easyui支持--%>
    <script type="text/javascript" src="easyui/jquery.easyui.min.js"></script>
    <%--按钮的风格样式--%>
    <link rel="stylesheet" type="text/css" href="easyui/themes/color.css">
    <%--国际化支持--%>
    <script type="text/javascript" src="easyui/locale/easyui-lang-zh_CN.js"></script>

###### 4.department.jsp (/WEB-INF/views/department/department.jsp) ######

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>Title</title>
        <%@ include file="/WEB-INF/views/common/common.jsp"%>
        <script src="static/js/model/department.js"></script>
    </head>
    <body>
        <table id="departmentDataGrid"></table>
        <div id="tools">
            <a href="javaScript:;" data-method="add" class="easyui-linkbutton" data-options="iconCls:'icon-search'">添加</a>
            <a href="javaScript:;" data-method="delete" class="easyui-linkbutton" data-options="iconCls:'icon-remove'">删除</a>
            <a href="javaScript:;" data-method="update" class="easyui-linkbutton" data-options="iconCls:'icon-update'">修改</a>
            <a href="javaScript:;" data-method="search" class="easyui-linkbutton" data-options="iconCls:'icon-search'">查询</a>
            <a href="javaScript:;" data-method="refulsh" class="easyui-linkbutton" data-options="iconCls:'icon-search'">刷新页面</a>
        </div>
        <div id="deptFromDialog">
            <form id="deptFrom" method="post">
                <input id="employeeId" type="hidden" name="id" />
                <table cellpadding="5">
                    <%--因为textbox在处理自定义验证时，有问题，所以使用validatebox进行验证--%>
                    <tr>
                        <td>标识:</td>
                        <td><input class="easyui-textbox" type="text" name="sn" data-options="required:true"></input></td>
                    </tr>
                    <tr>
                        <td>名称:</td>
                        <td><input class="easyui-textbox" type="text" name="name" data-options="required:true"></input></td>
                    </tr>
                    <tr>
                        <td>状态:</td>
                        <td>
                            <select class="easyui-combobox" name="state" style="width:200px;" panelHeight='auto'>
                                <option value="0">待审</option>
                                <option value="-1">已审</option>
                                <option value="1">未知</option>
                            </select>
                        </td>
                    </tr>
                </table>
            </form>
        </div>
        <div id="FromButtons">
            <a href="javaScript:;" data-method="save" class="easyui-linkbutton" data-options="">确认</a>
            <a href="javaScript:;" class="easyui-linkbutton" "$('#deptFromDialog').dialog('close')">取消</a>
        </div>
    </body>
    </html>

###### 5. 准备deparment.js (/static/js/model/department.js) ######

$(function () {
        /*公共组件的抽取*/
        var depertmentDataGrid =  $("#departmentDataGrid");
        var deptFrom =  $("#deptFrom");
        var deptFromDialog =  $("#deptFromDialog");
        /*注册事件*/
        $("*[data-method]").on("click",function () {
            var method = $(this).data("method");
            lzj[method]();
        })
        lzj = {
            add(){
                /*打开并居中*/
                deptFromDialog.dialog("open").dialog("center");
                /*清空表单内的数据*/
                deptFrom.form("clear");
            },
            save(){
                deptFrom.form('submit', {
                    url:"department/save",
                    onSubmit: function(){
                        return  $(this).form('validate');
                    },
                    success:function(data){
                        var result = JSON.parse(data);
                        if (result.success) {
                            depertmentDataGrid.datagrid("reload");
                            deptFromDialog.dialog("close");
                        }else{
                            $.messager.alert('提示',`保存失败，，原因是：${result.msg}`,'error');
                        }
                    }
                });
            },
            delete(){
                var selectRow = depertmentDataGrid.datagrid("getSelected");
                if(selectRow){
                    $.messager.confirm('确认对话框', '亲！您真的要删除它吗？', function(r){
                        if (r){
                            $.get("department/delete",{id:selectRow.id},function (result) {
                                if (result) {
                                    depertmentDataGrid.datagrid("reload");
                                }else{
                                    $.messager.alert('提示','删除失败，原因是：'+result.msg,'error');
                                }
                            })
                        }
                    });
                }else{
                    $.messager.alert('提示','亲，删除需要选中数据哦~','info');
                }
            },
            update(){
                var selectRow = depertmentDataGrid.datagrid("getSelected");
                if(selectRow){
                    deptFromDialog.dialog("open").dialog("center");
                    deptFrom.form("clear");
                    //回显数据
                    deptFrom.form("load",selectRow);
                }else{
                    $.messager.alert('提示','亲，修改需要选中数据哦~','info');
                }
            },
            search(){
                alert(1)
            },
            refulsh(){
                depertmentDataGrid.datagrid("reload");
            },
        }
        depertmentDataGrid.datagrid({
            fit:true,
            fitColumns:true,
            singleSelect:true,
            pagination:true,
            url:'department/list',
            toolbar:'#tools',
            columns:[[
                {field:'name',title:'名称',width:100},
                {field:'id',title:'编号',width:100},
                {field:'sn',title:'标识',width:100},
                {field:'state',title:'状态',width:100},
            ]]
        });
        deptFromDialog.dialog({
            title: '编辑',
            width: 350,
            height: 300,
            closed: true,
            modal: true,
            buttons:'#FromButtons'
        });
    })

###### 6.分页 ######

*  准备BaseQuery  
    因为前台使用的是EasyUI框架展示数据，添加分页导航栏之后，刷新数据需要传入的数据是page和rows  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 3]

public class BaseQuery {
        //因为前台使用的是easyUI框架，分页需要的参数是page和rows
        private int page;
        private int rows = 10;  //后台默认显示的数据是10条
        //getter与setter省略
    }

*  DepartmentQuery(如果以后有特殊的查询写在里面)

public class DepartmentQuery extends BaseQuery {
    }

*  departmentMapper.xml添加分页查询数据的方法

<select id="queryAll" parameterType="DepartmentQuery" resultMap="BaseResultMap" >
      select id, sn, name, dirPath, state, manager_id, parent_id
      from t_department
    </select>

*  BaseMapper接口添加分页查询数据的方法

public interface BaseMapper<T> {
        //....
        Page<T> queryAll(BaseQuery baseQuery);
    }

*  applicationContext.xml添加分页拦截器

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          
          <property name="dataSource" ref="dataSource" />
          
          <property name="typeAliasesPackage" value="cn.lzj.crm.domain,cn.lzj.crm.query" />
          
          <property name="mapperLocations" value="classpath:cn/lzj/crm/mapper/*.xml" />
          
          <property name="plugins">
              <array>
                  <bean class="com.github.pagehelper.PageInterceptor">
                      <property name="properties">
                          <value>helperDialect=mysql</value>
                      </property>
                  </bean>
              </array>
          </property>
      </bean>

*  service添加分页查询数据的方法  
    **注意：因为EasyUI内，分页查询数据向后台传入的是page和rows参数，但是响应的参数total和rows格式的JSON数据**  
    **所以，在后台返回的JSON格式的数据，也需要返回total和rows格式的数据**  
    **如果不使用这种返回的数据格式前台只会展示默认显示的10条数据，无法在选择查看其它数据**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 4]

public class PageResult<T> {
        private long total; //总条数
    
        private List<T> rows; //这一行的数据
    
        public PageResult(Page<T> page) {
            this.total = page.getTotal();
            this.rows = page.getResult();
        }
    	//省略getter和setter方法
    }

*  BaseServiceImpl中添加方法

//完成分页功能性
        @Override
        public PageResult<T> queryAll(BaseQuery query) {
            //配置分页的值
            PageHelper.startPage(query.getPage(),query.getRows());
            Page<T> page = mapper.queryAll(query);
            return new PageResult<T>(page);
        }

*  DepartmentController层添加分页的方法

@RequestMapping("/page")
        @ResponseBody
        public PageResult<Department> queryAll(DepartmentQuery query){
            return service.queryAll(query);
        }

# （三）多模块开发 #

都没空看开发的目的就是为了实现高内聚、低耦合。利于组件（代码）的重组。

###### 1、模块划分 ######

basic-util:工具(不依赖于其它模块,但是其它模块都要依赖)
    basic-core:所有模块的公共代码部分
    crm-common:crm这个模块的公共代码部分
    crm-mapper:crm这个模块的持久层部分
    crm-service:crm这个模块的业务层
    crm-web:crm这个模块的web层

###### 2、父项目引入子模块 ######

###### 3、子模块中引入其它子模块 ######

在其他子模块的pom.xml中

<dependencies>
        <dependency>
            <groupId>cn.lzj</groupId>
            <artifactId>basic-util</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
    </dependencies>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70]: /images/20220223/7d811c8da4a1497fa45c9dc4e12b13ee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 1]: /images/20220223/b666ee5f0f364d109ca1c163cfe60fda.png
[20190407201137468.png]: /images/20220223/b2d41f3529024d69a2467c033f50c51f.png
[20190407220543822.png]: /images/20220223/5fe2e6e5ada54d39acea3ec7abef266a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 2]: /images/20220223/89fde7f1df42450c88700ad6e73ad0c7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 3]: /images/20220223/1ac8151abbf84bc18f1426ce4f47ffaa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM2MjUw_size_16_color_FFFFFF_t_70 4]: /images/20220223/e579d275feef42b1972e670daae9ddf7.png