方式一:layui签到导入导出
    layui第三方插件地址:https://fly.layui.com/jie/47273/ http://excel.wj2015.com/_book/

    jsp页面:
    jquery-1.11.3.min.js
    layui.js
    excel.js

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: jiaming
    4.   Date: 2019/12/31
    5.   Time: 12:34
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <html>
    10. <head>
    11.     <title>excel导入导出</title>
    12.     <!--先加载jquery-->
    13.     <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
    14.     <script src="layui_new/layui/layui.js" charset="utf-8"></script>
    15.     <!--再加载插件-->
    16.     <script src="layui_exts/excel.js" charset="utf-8"></script>
    17.     <script type="text/javascript">
    18.         $(function () {
    19.             layui.config({
    20.                 base: 'layui_exts/'
    21.             }).extend({
    22.                 excel: 'excel'
    23.             });
    24.             // LAY_EXCEL.exportExcel([[1, 2, 3]], '表格导出.xlsx', 'xlsx');
    25.             layui.use(['jquery', 'excel', 'layer'], function () {
    26.                 var $ = layui.jquery;
    27.                 var excel = layui.excel;
    28.                 $.ajax({
    29.                     url: '/path/to/get/data',
    30.                     dataType: 'json',
    31.                     success: function (res) {
    32.                         // 假如返回的 res.data 是需要导出的列表数据
    33.                         console.log(res.data);// [{name: 'wang', age: 18, sex: '男'}, {name: 'layui', age: 3, sex: '女'}]
    34.                         // 1. 数组头部新增表头
    35.                         res.data.unshift({name: '用户名', sex: '男', age: '年龄'});
    36.                         // 2. 如果需要调整顺序，请执行梳理函数
    37.                         var data = excel.filterExportData(res.data, [
    38.                             'name',
    39.                             'sex',
    40.                             'age',
    41.                         ]);
    42.                         // 3. 执行导出函数，系统会弹出弹框
    43.                         excel.exportExcel({
    44.                             sheet1: data
    45.                         }, '导出接口数据.xlsx', 'xlsx');
    46.                     }
    47.                 });
    49.                 // 监听上传文件的事件
    50.                 $('#LAY-excel-import-excel').change(function (e) {
    51.                     var files = e.target.files;
    52.                     try {
    53.                         // 方式一：先读取数据，后梳理数据
    54.                         excel.importExcel(files, {}, function (data) {
    55.                             console.log(data);
    56.                             data = excel.filterImportData(data, {
    57.                                 'id': 'A'
    58.                                 , 'username': 'B'
    59.                                 , 'experience': 'C'
    60.                                 , 'sex': 'D'
    61.                                 , 'score': 'E'
    62.                                 , 'city': 'F'
    63.                                 , 'classify': 'G'
    64.                                 , 'wealth': 'H'
    65.                                 , 'sign': 'I'
    66.                             })
    67.                             console.log(data);
    68.                         });
    69.                         // 方式二：可以在读取过程中梳理数据
    70.                         excel.importExcel(files, {
    71.                             fields: {
    72.                                 'id': 'A'
    73.                                 , 'username': 'B'
    74.                                 , 'experience': 'C'
    75.                                 , 'sex': 'D'
    76.                                 , 'score': 'E'
    77.                                 , 'city': 'F'
    78.                                 , 'classify': 'G'
    79.                                 , 'wealth': 'H'
    80.                                 , 'sign': 'I'
    81.                             }
    82.                         }, function (data) {
    83.                             console.log(data);
    84.                         });
    85.                     } catch (e) {
    86.                         layer.alert(e.message);
    87.                     }
    88.                 });
    89.             });
    92.         });
    93.     </script>
    94. </head>
    95. <body>
    96. <input type="file" class="layui-btn layui-btn-primary" id="LAY-excel-import-excel" multiple="multiple">
    97. </body>
    98. </html>

    方式二:poi后端导入,layui前端导出
    **
    前台jsp:
    jquery-1.11.3.min.js
    public.js

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: jiaming
    4.   Date: 2020/1/1
    5.   Time: 12:05
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <html>
    10. <head>
    11.     <title>后台实现excel导入操作</title>
    12.     <script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
    13.     <script type="text/javascript" src="js/public.js"></script>
    14. </head>
    15. <body>
    16. <script>
    17.     function submit3() {
    18.         // ajax里面将参数自动转换为json格式,所以后台接收必须用"@RequestBody"接收
    19.         doUploadFile("TestExcel/addExcel","myForm", function (data) {
    20.             console.log(data);
    21.         });
    22.     }
    23. </script>
    24. <form id="myForm">
    25.     请选择上传的excel文件:
    26.     <input type="file" name="file">
    27.     额外参数:
    28.     <input type="text" name="name">
    29.     <input type="button" value="提交" onclick="submit3();">
    30. </form>
    32. </body>
    33. </html>

    后端java:
    控制层

    1. package jxxdxy.controller;
    3. import jxxdxy.model.Back;
    4. import jxxdxy.model.Result;
    5. import jxxdxy.model.TestFile;
    6. import jxxdxy.util.ExcelUtil;
    7. import org.apache.poi.ss.usermodel.Cell;
    8. import org.apache.poi.ss.usermodel.Row;
    9. import org.springframework.stereotype.Controller;
    10. import org.springframework.web.bind.annotation.RequestMapping;
    11. import org.springframework.web.bind.annotation.ResponseBody;
    12. import org.springframework.web.multipart.MultipartFile;
    13. import org.springframework.web.multipart.MultipartHttpServletRequest;
    15. import javax.servlet.http.HttpServletRequest;
    16. import java.io.InputStream;
    17. import java.util.List;
    19. @Controller
    20. @RequestMapping("TestExcel")
    21. public class TestExcel {
    23.     @RequestMapping("addExcel")
    24.     @ResponseBody
    25.     public Back addFile(TestFile file, HttpServletRequest request){
    26.         System.out.println("接收的对象:"+file);
    27.         System.out.println(file.getFile().getOriginalFilename()+"--"+file.getFile().getSize());
    28.         Back back = new Back();
    29.         MultipartFile excl = file.getFile();
    30.         if (request instanceof MultipartHttpServletRequest) {
    31.             //说明文件不为空
    32.             if (!excl.isEmpty()) {
    33.                 try {
    34.                     String fileName = excl.getOriginalFilename();
    35.                     //转化为流的形式
    36.                     InputStream is = excl.getInputStream();
    37.                     List<Row> list = ExcelUtil.getExcelRead(fileName, is, true);
    38.                     //首先是读取行 也就是一行一行读，然后在取到列，遍历行里面的行，根据行得到列的值
    39.                     for (Row row : list) {
    40.                         Cell cell_0 = row.getCell(0);
    41.                         System.out.println(ExcelUtil.getValue(cell_0));
    42.                         //得到每个元素的值start
    43. //                        Cell cell_0 = row.getCell(0);
    44. //                        Cell cell_1 = row.getCell(1);
    45. //                        Cell cell_2 = row.getCell(2);
    46. //                        Cell cell_3 = row.getCell(3);
    47. //                        Cell cell_4 = row.getCell(4);
    48. //                        //得到列的值，也就是你需要解析的字段的值
    49. //                        String name = ExcelUtil.getValue(cell_0);
    50. //                        String nickName = ExcelUtil.getValue(cell_1);
    51. //                        String phone = ExcelUtil.getValue(cell_2);
    52. //                        String actorName = ExcelUtil.getValue(cell_3);
    53. //                        String status = ExcelUtil.getValue(cell_4);
    54. //                        String regex = "^1[3|4|5|8][0-9]\\d{8}$";
    55. //                        if ("".equals(name)){
    56. //                            result.setSuccess(false);
    57. //                            result.setErrorMessage("第"+(row.getRowNum())+"行第"+1+"列的姓名不能为空!");
    58. //                            return result;
    59. //                        } else if (!(phone.matches(regex))){
    60. //                            result.setSuccess(false);
    61. //                            result.setErrorMessage("第"+(row.getRowNum())+"行第" +3+ "列的手机号码格式不正确");
    62. //                            return result;
    63. //                        } else if("".equals(actorName)){
    64. //                            result.setSuccess(false);
    65. //                            result.setErrorMessage("第"+(row.getRowNum())+"行第"+5+"列的角色名不能为空!");
    66. //                            return result;
    67. //                        } else if("".equals(status)) {
    68. //                            result.setSuccess(false);
    69. //                            result.setErrorMessage("第"+(row.getRowNum())+"行第" + 6 + "列的状态不能为空!");
    70. //                            return result;
    71. //                        }else if (!("启用".equals(status)) || ("禁用".equals(status))){
    72. //                            result.setSuccess(false);
    73. //                            result.setErrorMessage("第"+(row.getRowNum())+"行第" + 6 + "列的状态只能为启用或禁用");
    74. //                            return result;
    75. //                        }
    76.                     }
    77.                     System.out.println("预览成功");
    78.                     back.setCode(0);
    79.                     back.setMsg("表格数据预览");
    80.                 } catch (Exception e) {
    81.                     e.printStackTrace();
    82.                     System.out.println("预览出现异常");
    83.                     back.setCode(0);
    84.                     back.setMsg("预览失败,预览出现异常");
    85.                 }
    86.             } else {
    87.                 System.out.println("预览失败,文件为空");
    88.                 back.setCode(0);
    89.                 back.setMsg("预览失败,文件为空");
    90.             }
    91.         }
    92.         return back;
    93.     }
    94. }

    模型层

    1. package jxxdxy.model;
    3. import org.springframework.web.multipart.MultipartFile;
    5. import java.util.Arrays;
    7. public class TestFile {
    8.     private String name;//额外参数
    9.     private MultipartFile file;//上传文件
    10.     private MultipartFile[] files;//上传多个文件
    12.     @Override
    13.     public String toString() {
    14.         return "TestFile{" +
    15.                 "name='" + name + '\'' +
    16.                 ", file=" + file +
    17.                 ", files=" + Arrays.toString(files) +
    18.                 '}';
    19.     }
    21.     public String getName() {
    22.         return name;
    23.     }
    25.     public void setName(String name) {
    26.         this.name = name;
    27.     }
    29.     public MultipartFile getFile() {
    30.         return file;
    31.     }
    33.     public void setFile(MultipartFile file) {
    34.         this.file = file;
    35.     }
    37.     public MultipartFile[] getFiles() {
    38.         return files;
    39.     }
    41.     public void setFiles(MultipartFile[] files) {
    42.         this.files = files;
    43.     }
    44. }

    帮助类

    1. package jxxdxy.util;
    3. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    4. import org.apache.poi.ss.usermodel.Cell;
    5. import org.apache.poi.ss.usermodel.Row;
    6. import org.apache.poi.ss.usermodel.Sheet;
    7. import org.apache.poi.ss.usermodel.Workbook;
    8. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    10. import java.io.InputStream;
    11. import java.math.BigDecimal;
    12. import java.util.ArrayList;
    13. import java.util.List;
    15. /**
    16.  * @author huwei
    17.  */
    18. public class ExcelUtil {
    20.     /**
    21.      * 获取解析文件行数据
    22.      * @param fileName : 文件地址
    23.      * @param isTitle  : 是否过滤第一行解析
    24.      * @return
    25.      * @throws Exception
    26.      */
    27.     public static List<Row> getExcelRead(String fileName, InputStream is, boolean isTitle) throws Exception{
    28.         try {
    29.             //判断其兼容版本 调用了判断版本的方法
    30.             Workbook workbook = getWorkbook(fileName,is);
    31.             Sheet sheet = workbook.getSheetAt(0);
    32.             int count = 0;
    33.             List<Row> list = new ArrayList<Row>();
    34.             for (Row row : sheet) {
    35.                 // 跳过第一行的目录
    36.                 if (count == 0 && isTitle) {
    37.                     count++;
    38.                     continue;
    39.                 }
    40.                 list.add(row);
    41.             }
    42.             return list;
    43.         } catch (Exception e) {
    44.             throw e;
    45.         }
    46.     }
    48. /**判断版本的方法*/
    49.     public static Workbook getWorkbook(String fileName,InputStream is) throws Exception{
    50.         Workbook workbook = null;
    51.         try {
    52.             /** 判断文件的类型，是2003还是2007 */
    53.             boolean isExcel2003 = true;
    54.             if (WDWUtil.isExcel2007(fileName)) {
    55.                 isExcel2003 = false;
    56.             }
    58.             if (isExcel2003) {
    59.                 workbook = new HSSFWorkbook(is);
    60.             } else {
    61.                 workbook = new XSSFWorkbook(is);
    62.             }
    63.         } catch (Exception e) {
    64.             throw e;
    65.         }
    66.         return workbook;
    67.     }
    69.     /**得到celL值的方法：*/
    70.     public static String getValue(Cell cell){
    71.         if (cell == null || cell.equals(""))
    72.         {
    73.             return String.valueOf("");
    74.         }
    75.         else {
    76.             switch (cell.getCellTypeEnum()) {
    77.                 case BOOLEAN:
    78.                     return String.valueOf(cell.getBooleanCellValue());
    80.                 case NUMERIC:
    81.                     double value = cell.getNumericCellValue();
    82.                     return new BigDecimal(value).toString();
    84.                 case STRING:
    85.                     return String.valueOf(cell.getStringCellValue());
    87.                 default:
    88.                     return String.valueOf(cell.getStringCellValue());
    90.             }
    91.         }
    92.     }
    93. }

    pom.xml文件

    1. <?xml version="1.0" encoding="UTF-8"?>
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.   <modelVersion>4.0.0</modelVersion>
    7.   <groupId>com.jxxdxy</groupId>
    8.   <artifactId>wlms</artifactId>
    9.   <version>1.0-SNAPSHOT</version>
    10.   <packaging>war</packaging>
    13.   <name>wlms Maven Webapp</name>
    14.   <!-- FIXME change it to the project's website -->
    15.   <url>http://www.example.com</url>
    17.   <properties>
    18.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    19.     <maven.compiler.source>1.7</maven.compiler.source>
    20.     <maven.compiler.target>1.7</maven.compiler.target>
    21.     <spring-version>3.2.8.RELEASE</spring-version>
    22.     <jdbc.version>8.0.12</jdbc.version>
    23.     <log4j.version>2.7</log4j.version>
    24.     <slf4j.version>1.7.21</slf4j.version>
    25.     <httpasyncclient.version>4.1.2</httpasyncclient.version>
    26.     <jdk.version>1.7</jdk.version>
    27.   </properties>
    29.   <profiles>
    30.     <profile>
    31.       <id>maven2-release</id>
    32.       <distributionManagement>
    33.         <snapshotRepository>
    34.           <id>oss</id>
    35.           <url>https://oss.sonatype.org/content/repositories/snapshots/</url>
    36.         </snapshotRepository>
    37.         <repository>
    38.           <id>oss</id>
    39.           <url>https://oss.sonatype.org/service/local/staging/deploy/maven2/</url>
    40.         </repository>
    41.       </distributionManagement>
    42.     </profile>
    43.   </profiles>
    45.   <dependencies>
    46.       <!--      短信发送-->
    47.       <dependency>
    48.           <groupId>com.yunpian.sdk</groupId>
    49.           <artifactId>yunpian-java-sdk</artifactId>
    50.           <version>1.2.7</version>
    51.       </dependency>
    52.       <!--支付宝-->
    53.       <dependency>
    54.           <groupId>com.alipay.sdk</groupId>
    55.           <artifactId>alipay-sdk-java</artifactId>
    56.           <version>3.7.4.ALL</version>
    57.       </dependency>
    58.     <dependency>
    59.       <groupId>org.slf4j</groupId>
    60.       <artifactId>slf4j-api</artifactId>
    61.       <version>${slf4j.version}</version>
    62.     </dependency>
    63.     <dependency>
    64.       <groupId>org.slf4j</groupId>
    65.       <artifactId>slf4j-simple</artifactId>
    66.       <version>${slf4j.version}</version>
    67.       <scope>test</scope>
    68.     </dependency>
    70.       <dependency>
    71.                <groupId>org.slf4j</groupId>
    72.               <artifactId>slf4j-nop</artifactId>
    73.              <version>1.7.2</version>
    74.       </dependency>
    76.     <dependency>
    77.       <groupId>com.google.code.gson</groupId>
    78.       <artifactId>gson</artifactId>
    79.       <version>2.8.0</version>
    80.     </dependency>
    82.     <dependency>
    83.       <groupId>org.apache.httpcomponents</groupId>
    84.       <artifactId>httpasyncclient</artifactId>
    85.       <version>${httpasyncclient.version}</version>
    86.     </dependency>
    87.     <dependency>
    88.       <groupId>org.apache.httpcomponents</groupId>
    89.       <artifactId>httpasyncclient-cache</artifactId>
    90.       <version>${httpasyncclient.version}</version>
    91.     </dependency>
    92.     <dependency>
    93.       <groupId>org.apache.httpcomponents</groupId>
    94.       <artifactId>httpmime</artifactId>
    95.       <version>4.5.2</version>
    96.     </dependency>
    98.       <!--    连接池-->
    99.     <dependency>
    100.       <groupId>com.alibaba</groupId>
    101.       <artifactId>druid</artifactId>
    102.       <version>1.0.9</version>
    103.     </dependency>
    104.     <dependency>
    105.       <groupId>org.aspectj</groupId>
    106.       <artifactId>aspectjweaver</artifactId>
    107.       <version>1.8.8</version>
    108.     </dependency>
    111.     <dependency>
    112.       <groupId>log4j</groupId>
    113.       <artifactId>log4j</artifactId>
    114.       <version>1.2.17</version>
    115.     </dependency>
    117.     <dependency>
    118.       <groupId>org.codehaus.xfire</groupId>
    119.       <artifactId>xfire-spring</artifactId>
    120.       <version>1.2.6</version>
    121.       <exclusions>
    122.         <exclusion>
    123.           <groupId>org.springframework</groupId>
    124.           <artifactId>spring</artifactId>
    125.         </exclusion>
    126.       </exclusions>
    127.     </dependency>
    129.     <dependency>
    130.       <groupId>org.apache.poi</groupId>
    131.       <artifactId>poi-ooxml</artifactId>
    132.       <version>3.17</version>
    133.     </dependency>
    134.     <dependency>
    135.       <groupId>org.apache.poi</groupId>
    136.       <artifactId>poi</artifactId>
    137.       <version>3.17</version>
    138.     </dependency>
    139.     <dependency>
    140.       <groupId>org.apache.poi</groupId>
    141.       <artifactId>poi-ooxml-schemas</artifactId>
    142.       <version>3.17</version>
    143.     </dependency>
    145.     <dependency>
    146.       <groupId>junit</groupId>
    147.       <artifactId>junit</artifactId>
    148.       <version>4.11</version>
    149.       <scope>test</scope>
    150.     </dependency>
    151.     <!--Spring配置-->
    152.     <dependency>
    153.       <groupId>commons-dbcp</groupId>
    154.       <artifactId>commons-dbcp</artifactId>
    155.       <version>1.4</version>
    156.     </dependency>
    157.     <dependency>
    158.       <groupId>commons-pool</groupId>
    159.       <artifactId>commons-pool</artifactId>
    160.       <version>1.6</version>
    161.     </dependency>
    163.     <dependency>
    164.       <groupId>org.springframework</groupId>
    165.       <artifactId>spring-core</artifactId>
    166.       <version>${spring-version}</version>
    167.     </dependency>
    169.     <dependency>
    170.       <groupId>org.springframework</groupId>
    171.       <artifactId>spring-test</artifactId>
    172.       <version>${spring-version}</version>
    173.     </dependency>
    175.     <dependency>
    176.       <groupId>org.springframework</groupId>
    177.       <artifactId>spring-context</artifactId>
    178.       <version>${spring-version}</version>
    179.     </dependency>
    181.     <dependency>
    182.       <groupId>org.springframework</groupId>
    183.       <artifactId>spring-tx</artifactId>
    184.       <version>${spring-version}</version>
    185.     </dependency>
    187.     <dependency>
    188.       <groupId>org.springframework</groupId>
    189.       <artifactId>spring-context-support</artifactId>
    190.       <version>${spring-version}</version>
    191.     </dependency>
    194.     <dependency>
    195.       <groupId>org.springframework</groupId>
    196.       <artifactId>spring-jdbc</artifactId>
    197.       <version>${spring-version}</version>
    198.     </dependency>
    200.     <dependency>
    201.       <groupId>org.springframework</groupId>
    202.       <artifactId>spring-aop</artifactId>
    203.       <version>${spring-version}</version>
    204.     </dependency>
    206.     <dependency>
    207.       <groupId>org.springframework</groupId>
    208.       <artifactId>spring-beans</artifactId>
    209.       <version>${spring-version}</version>
    210.     </dependency>
    212.     <dependency>
    213.       <groupId>org.springframework</groupId>
    214.       <artifactId>spring-webmvc</artifactId>
    215.       <version>${spring-version}</version>
    216.     </dependency>
    217.     <!--事务-->
    218.     <dependency>
    219.       <groupId>org.springframework</groupId>
    220.       <artifactId>spring-aspects</artifactId>
    221.       <version>${spring-version}</version>
    222.     </dependency>
    223.     <dependency>
    224.       <groupId>org.springframework</groupId>
    225.       <artifactId>spring-jms</artifactId>
    226.       <version>${spring-version}</version>
    227.     </dependency>
    228.     <!-- mybatis核心包 -->
    229.     <dependency>
    230.       <groupId>org.mybatis</groupId>
    231.       <artifactId>mybatis</artifactId>
    232.       <version>3.3.0</version>
    233.     </dependency>
    234.     <!-- mybatis/spring包 -->
    235.     <dependency>
    236.       <groupId>org.mybatis</groupId>
    237.       <artifactId>mybatis-spring</artifactId>
    238.       <version>1.2.2</version>
    239.     </dependency>
    241.     <!-- 数据库驱动 -->
    242.     <dependency>
    243.       <groupId>mysql</groupId>
    244.       <artifactId>mysql-connector-java</artifactId>
    245.       <version>${jdbc.version}</version>
    246.     </dependency>
    248.     <!-- json包-->
    249.     <dependency>
    250.       <groupId>com.alibaba</groupId>
    251.       <artifactId>fastjson</artifactId>
    252.       <version>1.2.31</version>
    253.     </dependency>
    255.     <!-- log4j -->
    256.     <dependency>
    257.       <groupId>org.apache.logging.log4j</groupId>
    258.       <artifactId>log4j-core</artifactId>
    259.       <version>${log4j.version}</version>
    260.     </dependency>
    261.     <!--文件上传包 -->
    262.     <dependency>
    263.       <groupId>commons-fileupload</groupId>
    264.       <artifactId>commons-fileupload</artifactId>
    265.       <version>1.3.2</version>
    266.     </dependency>
    267.     <dependency>
    268.       <groupId>commons-io</groupId>
    269.       <artifactId>commons-io</artifactId>
    270.       <version>2.5</version>
    271.     </dependency>
    272.     <dependency>
    273.       <groupId>javax.servlet</groupId>
    274.       <artifactId>servlet-api</artifactId>
    275.       <version>2.5</version>
    276.     </dependency>
    277.       <dependency>
    278.           <groupId>org.json</groupId>
    279.           <artifactId>json</artifactId>
    280.           <version>20160810</version>
    281.       </dependency>
    283.   </dependencies>
    285.   <build>
    286. <!--      短信发送-->
    287.       <resources>
    288.           <resource>
    289.               <directory>src/main/java</directory>
    290.               <includes>
    291.                   <include>**/*.properties</include>
    292.                   <include>**/*.xml</include>
    293.               </includes>
    294.           </resource>
    295.           <resource>
    296.               <directory>src/main/resources</directory>
    297.               <includes>
    298.                   <include>**/*.properties</include>
    299.                   <include>**/*.xml</include>
    300.               </includes>
    301.           </resource>
    302.       </resources>
    303.       <plugins>
    304.           <plugin>
    305.               <groupId>org.apache.maven.plugins</groupId>
    306.               <artifactId>maven-compiler-plugin</artifactId>
    307.               <version>3.6.0</version>
    308.               <configuration>
    309.                   <source>${jdk.version}</source>
    310.                   <target>${jdk.version}</target>
    311.                   <encoding>${project.build.sourceEncoding}</encoding>
    312.               </configuration>
    313.           </plugin>
    314.           <plugin>
    315.               <groupId>org.apache.maven.plugins</groupId>
    316.               <artifactId>maven-resources-plugin</artifactId>
    317.               <version>3.0.1</version>
    318.               <executions>
    319.                   <execution>
    320.                       <phase>compile</phase>
    321.                   </execution>
    322.               </executions>
    323.               <configuration>
    324.                   <encoding>${project.build.sourceEncoding}</encoding>
    325.               </configuration>
    326.           </plugin>
    327.           <plugin>
    328.               <groupId>org.apache.maven.plugins</groupId>
    329.               <artifactId>maven-surefire-plugin</artifactId>
    330.               <version>2.19.1</version>
    331.               <configuration>
    332.                   <skip>true</skip>
    333.               </configuration>
    334.           </plugin>
    335.           <plugin>
    336.               <artifactId>maven-assembly-plugin</artifactId>
    337.               <executions>
    338.                   <execution>
    339.                       <phase>package</phase>
    340.                       <goals>
    341.                           <goal>single</goal>
    342.                       </goals>
    343.                   </execution>
    344.               </executions>
    345.               <configuration>
    346.                   <descriptorRefs>
    347.                       <descriptorRef>jar-with-dependencies</descriptorRef>
    348.                   </descriptorRefs>
    349.               </configuration>
    350.           </plugin>
    351.       </plugins>
    352. <!--      end-->
    354.     <finalName>wlms</finalName>
    355.     <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
    356.       <plugins>
    357.         <plugin>
    358.           <artifactId>maven-clean-plugin</artifactId>
    359.           <version>3.0.0</version>
    360.         </plugin>
    361.         <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
    362.         <plugin>
    363.           <artifactId>maven-resources-plugin</artifactId>
    364.           <version>3.0.2</version>
    365.         </plugin>
    366.         <plugin>
    367.           <artifactId>maven-compiler-plugin</artifactId>
    368.           <version>3.7.0</version>
    369.         </plugin>
    370.         <plugin>
    371.           <artifactId>maven-surefire-plugin</artifactId>
    372.           <version>2.20.1</version>
    373.         </plugin>
    374.         <plugin>
    375.           <artifactId>maven-war-plugin</artifactId>
    376.           <version>3.2.0</version>
    377.         </plugin>
    378.         <plugin>
    379.           <artifactId>maven-install-plugin</artifactId>
    380.           <version>2.5.2</version>
    381.         </plugin>
    382.         <plugin>
    383.           <artifactId>maven-deploy-plugin</artifactId>
    384.           <version>2.8.2</version>
    385.         </plugin>
    386.       </plugins>
    387.     </pluginManagement>
    388.   </build>
    389. </project>