org.apache.poi.ss.formula.functions.T Java Examples

/**
 * 使用指定的检索标准检索数据并分页返回数据
 * @throws IllegalAccessException 
 * @throws InstantiationException 
 */
public List<T> findObjForJdbc(String sql, int page, int rows,Class<T> clazz) {
	List<T> rsList = new ArrayList<T>();
	//封装分页SQL
	sql = jeecgCreatePageSql(sql,page,rows);
	List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
	
	T po = null;
	for(Map<String,Object> m:mapList){
		try {
			po = clazz.newInstance();
			MyBeanUtils.copyMap2Bean_Nobig(po, m);
			rsList.add(po);
		}  catch (Exception e) {
			e.printStackTrace();
		}
	}
	return rsList;
}
 

/**
 * 查看权限详情
 * @param permissionId 权限id
 * @param request
 * @return
 */
@RequiresPermissions("system:permission:view")
@RequestMapping(value="/view/{permissionId}",method=RequestMethod.GET)
public String permissionView(@PathVariable String permissionId, HttpServletRequest request){
    /*List<SysMenu> subMenus = menuService.getSubSysMenu(PublicEnum.NORMAL.value());
	request.setAttribute("subMenus", subMenus);*/
       List<SysMenu> sysMenus = menuService.querySysMenuByCondition(null, null, null);
       List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
       for (SysMenu sysMenu : sysMenus) {
           nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(sysMenu.getMenuId()), String.valueOf(sysMenu.getParentMenuId()), sysMenu));
       }
       List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "menuName");
       request.setAttribute("subMenus", list);

	SysPermission permission = permissionService.getSysPermissionById(permissionId);
	request.setAttribute("permission",permission);
	return "system/permission/view";
}
 

/**
 * 编辑权限
 * @param permissionId 权限id
 * @param request
 * @return
 */
@RequiresPermissions("system:permission:edit")
@RequestMapping(value="/edit/{permissionId}",method=RequestMethod.GET)
public String editPermission(@PathVariable String permissionId,HttpServletRequest request){
	/*List<SysMenu> subMenus = menuService.getSubSysMenu(PublicEnum.NORMAL.value());
	request.setAttribute("subMenus", subMenus);*/
       List<SysMenu> sysMenus = menuService.querySysMenuByCondition(null, null, null);
       List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
       for (SysMenu sysMenu : sysMenus) {
           nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(sysMenu.getMenuId()), String.valueOf(sysMenu.getParentMenuId()), sysMenu));
       }
       List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "menuName");
       request.setAttribute("subMenus", list);
	
	SysPermission permission = permissionService.getSysPermissionById(permissionId);
	request.setAttribute("permission",permission);
	return "system/permission/edit";
}
 

/**
 * 使用指定的检索标准检索数据并分页返回数据
 * @throws IllegalAccessException 
 * @throws InstantiationException 
 */
public List<T> findObjForJdbc(String sql, int page, int rows,Class<T> clazz) {
	List<T> rsList = new ArrayList<T>();
	//封装分页SQL
	sql = jeecgCreatePageSql(sql,page,rows);
	List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
	
	T po = null;
	for(Map<String,Object> m:mapList){
		try {
			po = clazz.newInstance();
			MyBeanUtils.copyMap2Bean_Nobig(po, m);
			rsList.add(po);
		}  catch (Exception e) {
			e.printStackTrace();
		}
	}
	return rsList;
}
 

/**
 * 查看用户组详情
 * @param groupId 用户组id
 * @return
 */
@RequiresPermissions("system:group:view")
@RequestMapping(value="/view/{groupId}",method=RequestMethod.GET)
public String groupView(@PathVariable String groupId,HttpServletRequest request){
	SysGroup group=groupService.getSysGroupById(groupId);
	request.setAttribute("group", group);

	List<SysOrganize> organizes = organizeService.querySysOrganizeByCondition(null);
	List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
	for (SysOrganize org : organizes) {
		nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(org.getOrgId()), String.valueOf(org.getParentOrgId()), org));
	}
	List<T> organizesList = NodeUtil.iterator(nodeBeans, "﹎﹎", "orgName");
	request.setAttribute("organizes", organizesList);
	return "system/group/view";
}
 

/**
 * 编辑用户组
 * @param groupId 用户组id
 * @return
 */
@RequiresPermissions("system:group:edit")
@RequestMapping(value="/edit/{groupId}",method=RequestMethod.GET)
public String groupEdit(@PathVariable String groupId,HttpServletRequest request){
	SysGroup group=groupService.getSysGroupById(groupId);
	request.setAttribute("group", group);
	
	List<SysOrganize> organizes = organizeService.querySysOrganizeByCondition(null);
	List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
	for (SysOrganize org : organizes) {
		nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(org.getOrgId()), String.valueOf(org.getParentOrgId()), org));
	}
	List<T> organizesList = NodeUtil.iterator(nodeBeans, "﹎﹎", "orgName");
	request.setAttribute("organizes", organizesList);
	return "system/group/edit";
}
 

/**
 * 编辑组织机构
 * @param orgId 组织机构id
 * @param request
 * @return
 */
@RequiresPermissions("system:organize:edit")
@RequestMapping(value="/edit/{orgId}",method=RequestMethod.GET)
public String edit(@PathVariable String orgId,HttpServletRequest request){
    SysOrganize organize=organizeService.getSysOrganizeById(orgId);
    request.setAttribute("organize", organize);

    List<SysOrganize> organizes=organizeService.querySysOrganizeByCondition(null);
    List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
    for (SysOrganize org : organizes) {
        nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(org.getOrgId()), String.valueOf(org.getParentOrgId()), org));
    }
    List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "orgName");
    request.setAttribute("organizes", list);
    return "system/organize/edit";
}
 

/**
 * 进入到编辑数据字典页面
 * @param ddlId 数据字典id
 * @return
 */
@RequiresPermissions("system:ddl:edit")
@RequestMapping(value="/edit/{ddlId}",method = RequestMethod.GET)
public String ddlEdit(@PathVariable String ddlId,HttpServletRequest request){
    //获取所有的数据字典
    List<SysDDL> systemDDLs = systemDDLService.getSystemDDLs();
    List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
    for (SysDDL ddl : systemDDLs) {
        nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(ddl.getDdlCode()), ddl.getParentCode(), ddl));
    }
    List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "ddlValue");
    request.setAttribute("systemDDLs", list);

    SysDDL systemDDL = systemDDLService.getSystemDDLById(ddlId);
    request.setAttribute("systemDDL",systemDDL);
    return "system/ddl/edit";
}
 

/**
 * 进入到数据字典详情页面
 * @param ddlId 数据字典id
 * @return
 */
@RequiresPermissions("system:ddl:view")
@RequestMapping(value="/view/{ddlId}",method = RequestMethod.GET)
public String ddlView(@PathVariable String ddlId,HttpServletRequest request){
    //获取所有的数据字典
    List<SysDDL> systemDDLs = systemDDLService.getSystemDDLs();
    List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
    for (SysDDL ddl : systemDDLs) {
        nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(ddl.getDdlCode()), ddl.getParentCode(), ddl));
    }
    List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "ddlValue");
    request.setAttribute("systemDDLs", list);

    //获取数据字典详情
    SysDDL systemDDL = systemDDLService.getSystemDDLById(ddlId);
    request.setAttribute("systemDDL",systemDDL);
    return "system/ddl/view";
}
 

/**
 * 添加权限
 * @return
 */
@RequiresPermissions("system:permission:add")
@RequestMapping(value="/add",method=RequestMethod.GET)
public String permissionAdd(HttpServletRequest request){
       List<SysMenu> sysMenus = menuService.querySysMenuByCondition(null, null, null);
       List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
       for (SysMenu sysMenu : sysMenus) {
           nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(sysMenu.getMenuId()), String.valueOf(sysMenu.getParentMenuId()), sysMenu));
       }
       List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "menuName");
	request.setAttribute("subMenus", list);
	return "system/permission/add";
}
 

@Override
public T getParameter(String parameterName, Class<T> clazz) throws InvalidArgumentException {
	String param = getParameter(parameterName);
	if (param == null) return null;
	Object obj = ConvertUtils.convert(param, clazz);
	if (obj != null && obj.getClass().equals(clazz))
	{
		return (T) obj;
	}
	throw new InvalidArgumentException(InvalidArgumentException.DEFAULT_MESSAGE_ID, new Object[] {parameterName});
}
 

/**
 * 组织机构列表
 * @return
 */
@RequiresPermissions("system:organize:add")
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(HttpServletRequest request){
    List<SysOrganize> organizes=organizeService.querySysOrganizeByCondition(null);
    List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
    for (SysOrganize organize : organizes) {
        nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(organize.getOrgId()), String.valueOf(organize.getParentOrgId()), organize));
    }
    List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "orgName");
    request.setAttribute("organizes", list);
    return "system/organize/add";
}
 

/**
 * 添加用户组
 * @return
 */
@RequiresPermissions("system:group:add")
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(HttpServletRequest request){
	List<SysOrganize> organizes = organizeService.querySysOrganizeByCondition(null);
	List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
	for (SysOrganize org : organizes) {
		nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(org.getOrgId()), String.valueOf(org.getParentOrgId()), org));
	}
	List<T> organizesList = NodeUtil.iterator(nodeBeans, "﹎﹎", "orgName");
	request.setAttribute("organizes", organizesList);
	return "system/group/add";
}
 

/**
 * 进入到添加数据字典页面
 * @return
 */
@RequiresPermissions("system:ddl:add")
@RequestMapping(value="/add",method = RequestMethod.GET)
public String ddlAdd(HttpServletRequest request){
    //获取所有的数据字典
    List<SysDDL> systemDDLs = systemDDLService.getSystemDDLs();

    List<NodeUtil.NodeBean> nodeBeans = new ArrayList<NodeUtil.NodeBean>();
    for (SysDDL ddl : systemDDLs) {
        nodeBeans.add(new NodeUtil.NodeBean(String.valueOf(ddl.getDdlCode()), ddl.getParentCode(), ddl));
    }
    List<T> list = NodeUtil.iterator(nodeBeans, "﹎﹎", "ddlValue");
    request.setAttribute("systemDDLs", list);
    return "system/ddl/add";
}
 

@Override
public void write(List<? extends T> items) {
    //nothing to do
}
 

public JSONConverter(T resource){
	this.resource = resource;
}
 

public JSONConverter(T resource){
	this.resource = resource;
}
 

@Override
@Deprecated
public void Save() throws Exception {
    OutputStream out =createStream();
    createWK();
    tryCreateCellStyle();
    checkData();
    Class<?> clazz = list.get(0).getClass();
    Field[] fields = ExcelTool.GetFilesDeep(clazz);
    String[] title = new String[fields.length];
    short[] align = new short[fields.length];
    ExcelAnno ea = null;
    if(anyColByKey.isEmpty()) {
        for (int i = 0; i < fields.length; i++) {
            fields[i].setAccessible(true);
            //过滤列
            if (filterColByKey.contains(fields[i].getName())) {
                continue;
            }

            ea = fields[i].getAnnotation(ExcelAnno.class);
            if (ea != null) {
                if(ea.Pass()) {
                    continue;
                }}
            title[i] = fields[i].getName();
            align[i] = 0x2;
            if (ea != null) {
                if(ea.Align()!=0x2){
                    align[i] = ea.Align();
                }
                if (!ea.Value().equals("Null")) {
                    title[i] = ea.Value();
                }
            }
        }
    }else {
        for (int i = 0; i < fields.length; i++) {
            fields[i].setAccessible(true);
            if(!anyColByKey.contains(fields[i].getName())){
                throw new Exception("字段名无效");
            }
        }
        title = anyColByKey.toArray(new String[anyColByKey.size()]);
    }


    if (c != null) {
        list.sort(c);
    }
    Sheet sheet = wk.createSheet("sheet1");
    sheet.setDefaultColumnWidth((short) 15);
    CellStyle style = wk.createCellStyle();
    style.setAlignment(HorizontalAlignment.CENTER);
    Row row = sheet.createRow(0);
    initTitle(title,row,style);
    int index = 0;
    Object object=null;
    String fn;
    for (T o : list) {
        //过滤行
        if (!filter.test(o)) {
            continue;
        }
        process.accept(o);//加工每一行
        row = sheet.createRow(++index);
        for (int i = 0; i < title.length; i++) {
            Cell cell = row.createCell(i);
            cell.setCellStyle(style);
            object=fields[i].get(o);
            if(cellStyle.containsKey(title[i])){
                cell.setCellStyle(cellStyle.get(title[i]).getRealyStyle());
            }
            cell.setCellValue(object==null?"":object.toString());

        }
    }

    try {
        wk.write(out);
        out.flush();
    } finally {
        ExcelTool.Close(wk,out);
    }
}
 

public ResExportObj(List<T> list){
    super(list);
}
 

public ResExportObj(List<T> list, String path) {
    super(list, path);
}
 

/**
 * 转换字段
 *
 * @param titleMapping
 * @return
 */
SaveExcel<T> ConvertName(HashMap<String, String> titleMapping, Boolean isInit);
 

/***
 * 根据key获取缓存，如果还不存在，则上锁执行cacheLoader
 * @author weishao zeng
 * @param key
 * @param cacheLoader
 * @return
 */
<T> T getCache(String key, Supplier<CacheData<T>> cacheLoader);
 

@Override
public void accept(T o) {

}
 

/**
 * 设置风格.必须保证wk不能为null。
 *
 * @param name
 * @param cellStyle
 * @return
 */
SaveExcel<T> SetCellStyle(String name, CellStyleInterface cellStyle);
 

/**
 * 转换字段
 *
 * @param titleMapping
 * @return
 */
SaveExcel<T> ConvertName(HashMap<String, String> titleMapping);
 

/**
 * 转换字段名称
 *
 * @param title
 * @param newTitle
 * @return
 */
SaveExcel<T> ConvertName(String title, String newTitle);
 

/**
 * 设置保存路径
 *
 * @param path
 */
SaveExcel<T> SetPath(String path);
 

/**
 * 网页输出流
 *
 * @param stream
 * @return
 */
SaveExcel<T> SetOutputStream(OutputStream stream) throws Exception;
 

/**
 * 此处过滤Excel的列数据（列名）\n
 * 如果加入后，删除这些列
 *
 * @param consumer {@link DataFilterColumnInterface}
 */
SaveExcel<T> AnyCol(Consumer<List<String>> consumer);
 

/**
 * 此处过滤Excel的列数据（列名）\n
 * 如果加入后，只保留对应数据
 *
 * @param consumer {@link DataFilterColumnInterface}
 */
SaveExcel<T> FilterCol(Consumer<List<String>> consumer);