用JBuilder2005开发spring MVC应用-显示PDF/Excel文档
用JBuilder2005开发spring MVC应用-显示PDF/Excel文档
高科华
作者简介：高科华，南京航空学院计算数学专业硕士，有十年以上的企业信息化工作经验。目前的研究兴趣,J2EE企业应用、ERP软件研发、数据仓库系统研发。
1. 按照“用JBuilder2005开发spring MVC应用” -与表示层技术xslt集成一文建立spring应用
2. 增加poi、iText类库
3. 修改views.properties文件
/web-inf/classes/views.properties
home.stylesheetLocation=/WEB-INF/xsl/home.xslt
home.root=words
xl.class=excel.HomePage
pdf.class=pdf.PDFPage
4. 增加两个类文件
/src/excel/HomePage.java
package excel;
import java.util.*;
import javax.servlet.http.*;
import org.apache.poi.hssf.usermodel.*;
import org.springframework.web.servlet.view.document.*;
public class HomePage extends AbstractExcelView {
protected void buildExcelDocument(
Map model,
HSSFWorkbook wb,
HttpServletRequest req,
HttpServletResponse resp) throws Exception {
HSSFSheet sheet;
HSSFRow sheetRow;
HSSFCell cell;
// Go to the first sheet
// getSheetAt: only if wb is created from an existing document
//sheet = wb.getSheetAt( 0 );
sheet = wb.createSheet("Spring");
sheet.setDefaultColumnWidth((short) 12);
// write a text at A1
cell = getCell(sheet, 0, 0);
setText(cell, "Spring-Excel test");
List words = (List) model.get("wordList");
for (int i = 0; i < words.size(); i++) {
cell = getCell(sheet, 2 + i, 0);
setText(cell, (String) words.get(i));
}
}
}
/web-inf/pdf/PDFPage.java
package pdf;
import java.util.*;
import java.util.List;
import javax.servlet.http.*;
import com.lowagie.text.*;
import com.lowagie.text.pdf.*;
import org.springframework.web.servlet.view.document.*;
public class PDFPage extends AbstractPdfView {
protected void buildPdfDocument(
Map model,
Document doc,
PdfWriter writer,
HttpServletRequest req,
HttpServletResponse resp) throws Exception {
List words = (List) model.get("wordList");
for (int i = 0; i < words.size(); i++) {
doc.add(new Paragraph((String) words.get(i)));
}
}
}
5. 修改HomePageController.java
return new ModelAndView("home", map);
改home为xl或pdf。运行就可以看到不同的结果。