<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ##### 2.3.2 集合定義 路飛很快的完成了老師的任務,花了也就是喝杯茶的時間,就交差了,但過了一會就又被老師叫去了,讓他給出一個某個班級選擇選擇某些課的學生以及對應的老師 路飛又很快的想到了Easypoi,其中有一對多的導出,這不正是一對多的體現嗎,然后他繼續定義實體: 一個課程對應一個老師 一個課程對應N個學生 課程的實體 ~~~ @ExcelTarget("courseEntity") public class CourseEntity implements java.io.Serializable { /** 主鍵 */ private String id; /** 課程名稱 */ @Excel(name = "課程名稱", orderNum = "1", width = 25) private String name; /** 老師主鍵 */ @ExcelEntity(id = "absent") private TeacherEntity mathTeacher; @ExcelCollection(name = "學生", orderNum = "4") private List<StudentEntity> students; } ~~~ 教師的實體 ~~~ @ExcelTarget("teacherEntity") public class TeacherEntity implements java.io.Serializable { private String id; /** name */ @Excel(name = "主講老師_major,代課老師_absent", orderNum = "1", isImportField = "true_major,true_absent") private String name; ~~~ 這里在課程這個實體里面就完成了一堆多的導出,達到了我們基礎需求,同時使用了orderNum對我們的列進行了排序,滿足老師的需求,導出代碼如下 ~~~ Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("2412312", "測試", "測試"), CourseEntity.class, list); ~~~ 這樣我們就完成了老師的需求,效果如圖2.3.2-1 但是課程名和代課老師沒有合并,不太美觀 路飛又果斷給課程名稱和代課老師加了needMerge = true的屬性,就可以完成單元格的合并 ~~~ /** 課程名稱 */ @Excel(name = "課程名稱", orderNum = "1", width = 25,needMerge = true) private String name; //-------------------------------- /** name */ @Excel(name = "主講老師_major,代課老師_absent", orderNum = "1",needMerge = true, isImportField = "true_major,true_absent") ~~~ 效果如圖2.3.2-2 到這里,路飛就完美的完成了老師的任務,快樂的去交差了 圖2.3.2-1 ![](https://static.oschina.net/uploads/space/2017/0622/221100_MD8y_1157922.png) 圖2.3.2-2 ![](https://static.oschina.net/uploads/space/2017/0622/222202_217m_1157922.png)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看