模板汇总

模板                                                               
=====获取操作人信息代码=========================
@CookieValue(value ="token") String token,
TbSysUser user = RedisUtil.tokenToUser(token);
//操作人员代码
String operatorId = user.getOperatorId();
//操作人员姓名
String operatorName = user.getOperatorName();

// 操作时间
Timestamp operateDateTime = new Timestamp(new Date().getTime());
===============添加序列================
 <selectKey keyProperty="roleId" resultType="java.lang.Integer" order="BEFORE">
            select seq_TB_SYS_ROLE.nextval from dual
        </selectKey>
==============foreach====================
 <foreach collection="varietyAry" item="id" open="(" close=")" separator=",">
    #{id}
</foreach>
===============封装分页查询================
PageInfo<TbSysBlackList> pageInfo = new PageInfo<>(roles);
Map<String, Object> map = new HashMap<>();
map.put("pager.totalRows", pageInfo.getTotal());
map.put("pager.pageNo", pageInfo.getPageNum());
map.put("sort","");
map.put("direction","desc");
map.put("rows", roles);
=============message返回=================
JSONObject jsonObject = new JSONObject();
if (index > 0) {
    jsonObject.put("success", true);
    jsonObject.put("message", "添加成功");
} else {
    jsonObject.put("success", false);
    jsonObject.put("message", "添加失败");

}
===========, ROWNUM AS RN   ========

=================迭代=================
SELECT MARKETID FROM TB_SYS_MARKET START WITH MARKETID = 'G001' CONNECT BY PRIOR MARKETID = OWNEDMARKETID

=============调用核心===============
String returnCode = HttpToolkit.doGet(GetProperties.getTradeCoreUrl("CONSULT_BIDDING_URL"), queryString, "UTF-8", true);

===============将值为null的字段保留住==========
JSONObject.toJSONString(jsonObject,SerializerFeature.WriteMapNullValue);

================form表单excle 导出=============
var objAry = [["memberid", memberid], ["membername", membername], ["marketid", marketid], ["verifystatus", verifystatus], ["enterpriseproperty", enterpriseproperty], ["isdealer", isdealer],
    ["businesstype", businesstype], ["status", status], ["isdepot", isdepot], ["annualbegintime", annualbegintime], ["annualendtime", annualendtime], ["operatebegintime", operatebegintime],
    ["operateendtime", operateendtime], ["careviewstart", careviewstart], ["careviewend", careviewend]];
var form = document.createElement("form");
form.id = "formx1";
form.method = "post";
form.style = "display:none";
document.body.appendChild(form);
for (var i = 0; i < objAry.length; i++) {
    var obj = objAry[i];
    var input = document.createElement("input");
    input.type = "hidden";
    input.name = obj[0];
    input.value = obj[1];
    form.appendChild(input);
    var Item = '<input class="Item" type="checkbox" value="'
        + obj[0] + '" />';
    $("#bd").append(Item);
}
form.action = memberexport;
form.submit();
document.body.removeChild(form);
======================上传下载================
上传：FileUtils.copyInputStreamToFile(is,new File(dest));
下载：FileUtils.copyFile(new File(srcPath),new File(destPath)); 模板