Mybatis 复杂数据模型创建与接收

朱雀 2022-11-28 10:51 17阅读 0赞

> <table> 
>  <tbody> 
>   <tr> 
>    <td><strong>Mybatis总结2020</strong></td> 
>    <td><strong><a href="https://blog.csdn.net/libusi001/article/details/100066086" rel="nofollow">https://blog.csdn.net/libusi001/article/details/100066086</a></strong></td> 
>   </tr> 
>  </tbody> 
> </table>
> 
> **目录**
> 
> 一、Echart图表数据准备
> 
> 二、GsonFormat插件
> 
> 三、得到图标数据
> 
> 四、Mapper.xml接收
> 
> ### 一、Echart图表数据准备 ###
> 
> **Echart堆叠区域图简化后的图表数据**
> 
>     {
>         "title": {"text": "堆叠区域图"},
>         "legend": {"data": [
>             "邮件营销",
>             "联盟广告",
>             "视频广告",
>             "直接访问",
>             "搜索引擎"
>         ]},
>         "toolbox": {"feature": {"saveAsImage": {}}},
>         "grid": {
>             "left": "3%",
>             "right": "4%",
>             "bottom": "3%",
>             "containLabel": true
>         },
>         "xAxis": [{
>             "type": "category",
>             "boundaryGap": false,
>             "data": [
>                 "周一",
>                 "周二",
>                 "周三",
>                 "周四",
>                 "周五",
>                 "周六",
>                 "周日"
>             ]
>         }],
>         "yAxis": [{"type": "value"}],
>         "series": [
>             {
>                 "name": "邮件营销",
>                 "type": "line",
>                 "stack": "总量",
>                 "areaStyle": {},
>                 "data": [
>                     120,
>                     132,
>                     101,
>                     134,
>                     90,
>                     230,
>                     210
>                 ]
>             },
>             {
>                 "name": "联盟广告",
>                 "type": "line",
>                 "stack": "总量",
>                 "areaStyle": {},
>                 "data": [
>                     220,
>                     182,
>                     191,
>                     234,
>                     290,
>                     330,
>                     310
>                 ]
>             },
>             {
>                 "name": "视频广告",
>                 "type": "line",
>                 "stack": "总量",
>                 "areaStyle": {},
>                 "data": [
>                     150,
>                     232,
>                     201,
>                     154,
>                     190,
>                     330,
>                     410
>                 ]
>             },
>             {
>                 "name": "直接访问",
>                 "type": "line",
>                 "stack": "总量",
>                 "areaStyle": {},
>                 "data": [
>                     320,
>                     332,
>                     301,
>                     334,
>                     390,
>                     330,
>                     320
>                 ]
>             },
>             {
>                 "name": "搜索引擎",
>                 "type": "line",
>                 "stack": "总量",
>                 "label": {"normal": {
>                     "show": true,
>                     "position": "top"
>                 }},
>                 "areaStyle": {},
>                 "data": [
>                     820,
>                     932,
>                     901,
>                     934,
>                     1290,
>                     1330,
>                     1320
>                 ]
>             }
>         ]
>     }
> 
> ### 二、GsonFormat插件 ###
> 
> **Alt+S并Format后OK**
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpYnVzaTAwMQ_size_16_color_FFFFFF_t_70][]
> 
> ### 三、得到图标数据 ###
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpYnVzaTAwMQ_size_16_color_FFFFFF_t_70 1][]
> 
> ### 四、Mapper.xml接收 ###
> 
> **不用.而是用$链接下一级的Bean**
> 
>     <select id="selectxx" resultType="com.xxx.vo.yyVo$LegendBean"
>                 parameterType="com.yy.yyDto">
>     ...
>     </select>
> 
>

--------------------

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpYnVzaTAwMQ_size_16_color_FFFFFF_t_70]: /images/20221124/e1856fb98cc341818e2a01a1043169de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpYnVzaTAwMQ_size_16_color_FFFFFF_t_70 1]: /images/20221124/7f8f4df6218641b7b3260f9de6efb55f.png