JSPÖн«Êý¾ÝÉú³ÉExcel¸ñʽ
JSPÖн«Êý¾ÝÉú³ÉExcel¸ñʽ
ExcelÊǰ칫³£ÓÃÈí¼þÖ®Ò»¡£ÔÚÒ»¸öJavaÓ¦ÓÃÖУ¬½«Ò»²¿·ÖÊý¾ÝÉú³ÉExcel¸ñʽ£¬ÊÇÓëÆäËûϵͳÎÞ·ìÁ¬½áµÄÖØÒªÊֶΡ£POIÊÇApache JakartaµÄ×ÓÏîÄ¿£¬Ê¹Óüòµ¥·½±ã£¬¶ÔÖÐÎÄÖ§³Ö·Ç³£ºÃ,¹¦ÄÜÒ²±È½ÏÇ¿´ó¡£ÏÂÔÚµØÖ·Îª£ºhttp://jakarta.apache.org/poi¡£ÕâÌ×APIÊÇ´¿JavaµÄ£¬²¢²»ÒÀÀµWindowsϵͳ£¬¼´Ê¹ÔËÐÐÔÚLinuxÏ£¬ËüͬÑùÄܹ»ÕýÈ·µÄ´¦ÀíExcelÎļþ¡£Ä¿Ç°´ÓÍøÉÏÏÂÔØ×îÐµİ²×°°üµÄÃû×ÖÊÇpoi-bin-2.5.1-final-20040804.zip,½«¸ÃÎļþ½âѹËõÖ®ºó£¬ÔÚÉú³ÉµÄÎļþ¼ÐÖУ¬ÕÒµ½poi-2.5.1-final-20040804.jar°ü¡£È»ºó£¬½«¸Ã°ü·ÅÖõ½Ó¦ÓóÌÐòµÄWEB-INFµÄlibÏ£¬ÖØÆôTomcat¼´¿É¡£
ÒÔÏÂÊÇÓÃPOI´´½¨Excel¹¤×÷±¡µÄÀý×Ó£º
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*,org.apache.poi.hssf.usermodel.*"%>
<%
HSSFWorkbook workbook = new HSSFWorkbook(); //´´½¨ÐµÄExcel¹¤×÷±¡
HSSFSheet sheet = workbook.createSheet("JSP"); //ÔÚExcel¹¤×÷±¡Öн¨¹¤×÷±í£¬ÃûΪȱʡ
HSSFRow row = sheet.createRow((short)0); //ÔÚË÷Òý0µÄλÖý¨ÐУ¨×î¶¥¶ËµÄÐУ©
HSSFCell cell = row.createCell((short)0); //ÔÚË÷Òý0µÄλÖý¨µ¥Ôª¸ñ
cell.setEncoding(HSSFCell.ENCODING_UTF_16); //¶¨Òåµ¥Ôª¸ñΪ×Ö·û´®ÀàÐÍ
cell.setCellValue("×÷Õß"); //ÔÚµ¥Ôª¸ñÊäÈëһЩÄÚÈÝ
cell = row.createCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16); //¶¨Òåµ¥Ôª¸ñΪ×Ö·û´®ÀàÐÍ
cell.setCellValue("±à¼"); //ÔÚµ¥Ôª¸ñÊäÈëһЩÄÚÈÝ
row = sheet.createRow((short)1); //ÔÚË÷Òý1µÄλÖô´½¨ÐУ¨×î¶¥¶ËµÄÐУ©
cell = row.createCell((short)0); //ÔÚË÷Òý0µÄλÖô´½¨µ¥Ôª¸ñ£¨×óÉ϶ˣ©
; cell.setEncoding(HSSFCell.ENCODING_UTF_16); //¶¨Òåµ¥Ôª¸ñΪ×Ö·û´®ÀàÐÍ
cell.setCellValue("ÕÅÈý"); //ÔÚµ¥Ôª¸ñÊäÈëһЩÄÚÈÝ
cell=row.createCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16); //¶¨Òåµ¥Ôª¸ñΪ×Ö·û´®ÀàÐÍ
cell.setCellValue("ÀîËÄ");
;
String filename = application.getRealPath("/") + "text.xls"; //filenameÊǹ¤×÷±¡µÄ´æ·ÅλÖ㬴æ·ÅÔÚ
Ïà¹ØÎĵµ£º
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ page import="java.io.*,java.sql.*,net.sf.jasperreports.engine.*" %>
<%@ page import="com.microsoft.sqlserver.jdbc.SQLServerDriver" %>
<%@ include file="/common/header.jsp" %>
<!DOCTYPE HTM ......
ÎÒÃǶ¼ÖªµÀÔÚjspÖÐincludeÓÐÁ½ÖÖÐÎʽ,·Ö±ðÊÇ
< %@ include file=” ”%>
< jsp:include page=” ” flush=”true”/>
¡¡¡¡Ç°ÕßÊÇÖ¸ÁîÔªËØ¡¢ºóÕßÊÇÐÐÎªÔªËØ¡£¾ßÌåËüÃǽ«Ôںδ¦Óã¿ÈçºÎÓü°ËüÃÇÓÐÊ²Ã´Çø±ð£¿ÕâÓ¦¸ÃÊǺܶàÈË¿´µ½Ëü¶¼»áÏëµ½µÄÎÊÌâ¡£ÏÂÃæÒ»ÆðÀ´¿´¿´°É¡£
¡ ......
Ò»¡¢»ù±¾¸ÅÄ 1.±êÇ©(Tag): ±êÇ©ÊÇÒ»ÖÖXMLÔªËØ£¬Í¨¹ý±êÇ©¿ÉÒÔʹJSPÍøÒ³±äµÃ¼ò½à²¢ÇÒÒ×ÓÚά»¤£¬»¹¿ÉÒÔ·½±ãµØÊµÏÖͬһ¸öJSPÎļþÖ§³Ö¶àÖÖÓïÑÔ°æ±¾¡£ÓÉÓÚ±êÇ©ÊÇXMLÔªËØ£¬ËùÒÔËüµÄÃû³ÆºÍÊôÐÔ¶¼ÊÇ´óСдÃô¸ÐµÄ 2.±êÇ©¿â(Tag library): ÓÉһϵÁй¦ÄÜÏàËÆ¡¢Âß¼ÉÏ»¥ÏàÁªÏµµÄ±êÇ©¹¹³ÉµÄ¼¯ºÏ³ÆÎª±êÇ©¿â¡£ 3.±êÇ©¿âÃèÊöÎļþ(Tag Libr ......
ÓÃÕýÔò±í´ïʽÏÞÖÆÖ»ÄÜÊäÈëÖÐÎÄ£ºonkeyup="value=value.replace(/[^\u4E00-\u9FA5]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\u4E00-\u9FA5]/g,''))"
ÓÃÕýÔò±í´ïʽÏÞÖÆÖ»ÄÜÊäÈëÈ«½Ç×Ö·û£º onkeyup="value=value.replace(/[^\uFF00-\uFFFF]/g,'')" onbeforepaste="cl ......
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔÊ¾Ò³Ãæ(display.jsp)¾Í³öÏÖÂÒÂ룺
<html>
<head>
<title>JSPµÄÖÐÎÄ´¦Àí</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
out.print("JSPµÄÖÐÎÄ´¦Àí");
%>
< ......