`

spring集成poi完成电子表格报表完全版

 
阅读更多
由于本人最近完成项目的需要,作基于web方式的报表功能,要是对要求不是很严格的报表来说,spring+poi就可以实现件呵呵:
首先是我的配置文件: 在 web.xml中 进行
<!--========================================================-->
<!--SpringMVCDispatcherServletServlet-->
<!--========================================================-->
<servlet>
<servlet-name>ftldpt</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet>
<servlet>
<servlet-name>xlsdpt</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<load-on-startup>3</load-on-startup>
</servlet>

<!--========================================================-->
<!--过滤器过滤的链接映射定义-->
<!--========================================================-->
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>*.ftl</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>*.slt</url-pattern>
</filter-mapping>
<!-- ======================================================== -->
<!-- Spring MVC Config Mapping -->
<!-- ======================================================== -->
<servlet-mapping>
<servlet-name>ftldpt</servlet-name>
<url-pattern>*.ftl</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>xlsdpt</servlet-name>
<url-pattern>*.xls</url-pattern>
</servlet-mapping>

下面是关于 xls 的配置文件:
<?xmlversion="1.0"encoding="GB2312"?>
<beansxmlns="http://www.springframework.org/schema/beans"
xmlns:xsi
="http://www.w3.org/2001/XMLSchema-instance"
xmlns:util
="http://www.springframework.org/schema/util"
xmlns:aop
="http://www.springframework.org/schema/aop"
xsi:schemaLocation
="
http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/utilhttp://www.springframework.org/schema/util/spring-util-2.0.xsd
http://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-2.0.xsd"
>

<beanid="xmlViewResolver"
class
="org.springframework.web.servlet.view.XmlViewResolver">
<propertyname="location">
<value>/WEB-INF/report-views.xml</value>
</property>
</bean>
<!--========================================================-->
<!--=========封装XlsHssfMap================-->
<!--========================================================-->
<beanid="simBscXlsModelWrapperImpl"
class
="com.ecpay.pojo.xlsmodel.impl.SimBscXlsModelWrapperImpl">
</bean>
<beanid="auditLogXlsModelWrapperImpl"
class
="com.ecpay.pojo.xlsmodel.impl.AuditLogXlsModelWrapperImpl">
</bean>
<beanid="merchantBscXlsModelWrapperImpl"
class
="com.ecpay.pojo.xlsmodel.impl.MerchantBscXlsModelWrapperImpl">
</bean>

<!--========================================================-->
<!--=========HandleofMap================-->
<!--========================================================-->
<beanid="simBscStatisticXlsViewControllerHandle"
class
="com.ecpay.mvc.xlsview.handle.SimBscStatisticXlsViewControllerHandle">
<propertyname="xlsModelWrapper"
ref
="simBscXlsModelWrapperImpl">
</property>
<propertyname="simltjmhtViewDAO"ref="simltjmhtViewDAOImpl"></property>
</bean>
<beanid="auditLogXlsViewControllerHandle"
class
="com.ecpay.mvc.xlsview.handle.AuditLogXlsViewControllerHandle">
<propertyname="xlsModelWrapper"
ref
="auditLogXlsModelWrapperImpl">
</property>
<propertyname="adtLfjMhtViewDAO"ref="adtLfjMhtViewDAOImpl"></property>
</bean>
<beanid="merchantXlsViewControllerHandle"
class
="com.ecpay.mvc.xlsview.handle.MerchantXlsViewControllerHandle">
<propertyname="xlsModelWrapper"
ref
="merchantBscXlsModelWrapperImpl">
</property>
<propertyname="merhcantBscDAO"ref="merchantBscDAOImpl"></property>
</bean>

<!--========================================================-->
<!--=========MappingofURL================-->
<!--========================================================-->
<beanid="simBscStatisticXlsViewController"
class
="com.ecpay.mvc.xlsview.SimBscStatisticXlsViewController">
<propertyname="handle"
ref
="simBscStatisticXlsViewControllerHandle">
</property>
<propertyname="clazzName"
value
="com.ecpay.pojo.dataview.SimLtjMht">
</property>
<propertyname="viewPath"value="reportXlsViewResolver"></property>
</bean>
<beanid="merchantXlsViewController"
class
="com.ecpay.mvc.xlsview.MerchantXlsViewController">
<propertyname="clazzName"
value
="com.ecpay.pojo.database.MerchantBsc">
</property>
<propertyname="viewPath"value="reportXlsViewResolver"></property>
<propertyname="handle"ref="merchantXlsViewControllerHandle"></property>
</bean>

<beanid="urlMapping"
class
="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<propertyname="interceptors">
<list>
<refbean="accountRoleHeadOffInterceptor"/>
</list>
</property>
<propertyname="mappings">
<props>
<propkey="/report/simBscxls.xls">
simBscStatisticXlsViewController
</prop>
<propkey="/report/merchantBscxls.xls">
merchantXlsViewController
</prop>
</props>
</property>
</bean>
</beans>
xls工厂声明文件:
<?xmlversion="1.0"encoding="GB2312"?>
<beansxmlns="http://www.springframework.org/schema/beans"
xmlns:xsi
="http://www.w3.org/2001/XMLSchema-instance"
xmlns:util
="http://www.springframework.org/schema/util"
xmlns:aop
="http://www.springframework.org/schema/aop"
xsi:schemaLocation
="
http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/utilhttp://www.springframework.org/schema/util/spring-util-2.0.xsd
http://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-2.0.xsd"
>

<beanid="reportXlsViewResolver"
class
="com.ecpay.mvc.xlsviewresolver.ReportXlsViewResolver">
</bean>

</beans>

好多xls可以共享一个 xls 工厂class

下面是我关于xls工厂类的
importjava.util.Iterator;
importjava.util.Map;
importjava.util.Vector;

importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;

importorg.apache.log4j.Logger;
importorg.apache.poi.hssf.usermodel.HSSFCellStyle;
importorg.apache.poi.hssf.usermodel.HSSFRichTextString;
importorg.apache.poi.hssf.usermodel.HSSFCell;
importorg.apache.poi.hssf.usermodel.HSSFRow;
importorg.apache.poi.hssf.usermodel.HSSFSheet;
importorg.apache.poi.hssf.usermodel.HSSFWorkbook;
importorg.springframework.web.servlet.view.document.AbstractExcelView;

importcom.ecpay.kitsbag.FinalStaticParam;
importcom.ecpay.pojo.xlsmodel.HssfCall;

publicclassReportXlsViewResolverextendsAbstractExcelView...{

privatestaticfinalLoggerlogger=Logger
.getLogger(ReportXlsViewResolver.
class);

publicReportXlsViewResolver()...{
if(logger.isInfoEnabled())...{
logger.info(
"电子表格制造工厂启动...");
}
//end_log
}
//end_fun

@SuppressWarnings(
"unchecked")
@Override
protectedvoidbuildExcelDocument(MaprootMap,HSSFWorkbookworkbook,
HttpServletRequestrequest,HttpServletResponseresponse)
throwsException...{
HSSFSheethssfSheet
=workbook.createSheet("报表");
Vector
<Vector<HssfCall>>hssfRowList=(Vector<Vector<HssfCall>>)rootMap
.get(FinalStaticParam.HSSF_ROW_LIST);
if(logger.isDebugEnabled())...{
logger.debug(
"当前共计["+hssfRowList.size()+"]行电子表格数据");
}

Iterator
<Vector<HssfCall>>iterator=hssfRowList.iterator();
introwIndex=1;
while(iterator.hasNext())...{
HSSFRowhssfRow
=hssfSheet.createRow(rowIndex++);
Vector
<HssfCall>cellList=iterator.next();
Iterator
<HssfCall>iterators=cellList.iterator();
shortcellIndex=0;
while(iterators.hasNext())...{
HSSFCellStylecellStyle
=workbook.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
HssfCallcall
=iterators.next();
HSSFCellcell
=hssfRow.createCell(cellIndex++);
cell.setCellStyle(cellStyle);
turnCallToHssfCell(call,cell);
}
//end_while
}
//end_while
if(logger.isDebugEnabled())...{
logger.debug(
"完成对电子表格的构建...HTTP-输出到客户端");
}
//end_log
}
//end_fun

/***//**
*
*
@paramcall
*
@paramcell
*@note函数功能描述:
*/

privatevoidturnCallToHssfCell(HssfCallcall,HSSFCellcell)...{
if(call.getCallType()==HssfCall.CALL_TYPE_STRING)...{
HSSFRichTextStringrichTextString
=newHSSFRichTextString(String
.valueOf(call.getCallValue()));
cell.setCellValue(richTextString);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
}
elseif(call.getCallType()==HssfCall.CALL_TYPE_NUMERIC)...{
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
cell.setCellValue(Double.valueOf(call.getCallValue()));
}
//end_if
}
//end_fun
}
//end_clazz

电子表格;类代码
packagecom.ecpay.mvc.xlsview;

importjava.util.Map;
importjava.util.Vector;

importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;

importorg.springframework.web.servlet.ModelAndView;

importcom.ecpay.kitsbag.AssembleHqlKit;
importcom.ecpay.mvc.AbstractViewController;
importcom.ecpay.mvc.xlsview.handle.AuditLogXlsViewControllerHandle;
importcom.ecpay.pojo.xlsmodel.HssfCall;

publicclassAuditLogXlsViewControllerextendsAbstractViewController...{

privateStringclazzName;

privateAuditLogXlsViewControllerHandlehandle;

publicAuditLogXlsViewController()...{
}


@Override
protectedModelAndViewhandleRequestInternal(HttpServletRequestrequest,
HttpServletResponseresponse)
throwsException...{
ModelAndViewmav
=newModelAndView(getViewPath());
Stringhql
="";
Stringtemp
="";
Stringcondtions
=request.getParameter("condtions");
if(condtions!=null&&(!condtions.equals("")))...{
temp
=newString(condtions.getBytes("ISO-8859-1"),"GB2312");
}
//end_if
hql=AssembleHqlKit.assembleFindHql(clazzName,temp);
if(logger.isDebugEnabled())...{
logger.debug(
"生成AuditLog报表的hql:"+hql);
}
//end_log
Map<String,Vector<Vector<HssfCall>>>rootMap=handle
.handleViewProcess(hql);
mav.addAllObjects(rootMap);
returnmav;
}
//end_fun

publicvoidsetClazzName(StringclazzName)...{
this.clazzName=clazzName;
}


publicvoidsetHandle(AuditLogXlsViewControllerHandlehandle)...{
this.handle=handle;
}


}
//end_clazz


希望对大家有点 帮助
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics