发一下牢骚和主题无关:
在用利FileNet API获得doucmnt实例总量时要需注意获得的是root folder(/),而要虑考UnfiledDocument中的document是不是有效。例如,在zhy的某项目中UnfiledDocument下的文档虽然跟文档管理平台,但它面里却存储着Notes归档来的邮件附件。简略的询查操纵,如下码代所示(注意PageIterator 的用使)。
无知者为梦想中的虚幻而苦苦等待,换回的不是所求的,而是岁月在脸上留下的印痕,一事无成的人一生便是虚度。生活中,与其花时间去等待,不如加快步伐去追寻理想,试着与时间赛跑,也许身躯、心理会感到劳累,但这样的生活毕竟是充实的。
public int queryTotal(ObjectStore os,String docType){
String sql = "select ID FROM " + docType + " d WITH INCLUDESUBCLASSES WHERE d.This INSUBFOLDER '/' ";
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, null, filter, null);
Iterator iter = rows.iterator();
int count = 0 ;
while(iter.hasNext()){
iter.next();
count++;
}
return count;
}
public int queryRangeAmount(ObjectStore os,String docType,Date startDate,Date endDate){
String sql = "select ID FROM " + docType + " d WITH INCLUDESUBCLASSES WHERE (d.This INSUBFOLDER '/') AND " +
PropertyNames.DATE_CREATED + " >= " + dateFormat(startDate) +
" AND " +
PropertyNames.DATE_CREATED + " < " + dateFormat(endDate) ;
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, null, filter, null);
Iterator iter = rows.iterator();
int count = 0 ;
while(iter.hasNext()){
iter.next();
count++;
}
return count;
}
private String dateFormat(Date date){
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String dateStr = sdf.format(date);
sdf = new SimpleDateFormat("HHmmss");
dateStr = dateStr + "T" + sdf.format(date) + "Z";
return dateStr;
}
public void testQueryTotalByDocType(){
String sql = "select ID FROM CompanyDoc d WITH INCLUDESUBCLASSES WHERE d.This INSUBFOLDER '/' ";
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, 1000, filter, true);
Iterator iter = rows.iterator();
int count = 0 ;
PageIterator pageIterator = rows.pageIterator();
while(pageIterator.nextPage()){
count = count + pageIterator.getElementCount();
}
logger.info("count is : " + count );
}
文章结束给大家分享下程序员的一些笑话语录: 程序语言综述
CLIPPER 程序员不去真的猎捕大象,他们只是购买大象部分的库然后花几年的时间试图综合它们。
DBASE 程序员只在夜间猎捕大象,因为那时没人会注意到他们还在使用石弓。
FOXPRO 程序员开始使用更新更好的步枪,这使他们花掉比实际狩猎更多的时间学习新的射击技术。
C 程序员拒绝直接购买步枪,宁可带着钢管和一个移动式机器车间到非洲,意欲从零开始造一枝完美的步枪。
PARADOX 程序员去非洲时带着好莱坞关于猎捕大象的电影剧本,他们认为照剧本行事就会逮到一头大象。
ACCESS 程序员在没有任何猎象经验的经验下就出发了,他们穿着华丽的猎装、带着全部装备,用漂亮的望远镜找到了大象,然后发觉忘了带扳机。
RBASE 程序员比大象还要稀少,事实上,如果一头大象看到了一个RBASE程序员,对他是个幸运日。
VISUAL ACCESS 程序员装上子弹、举起步枪、瞄准大象,这使大象感到可笑,究竟谁逃跑。他们无法抓住大象,因为由于他们对多重控制的偏爱,他们的吉普车有太多的方向盘因而无法驾驶。
ADA、APL和FORTRAN 程序员与圣诞老人和仙女一样是虚构的。
COBOL 程序员对和自己一样濒临灭绝的大象寄予了深切的同情。