java²Ù×÷excelÎļþ
Õâ¸öÊÇ×Ô¼º¹ýȥΪÁË·½±ã²Ù×÷excelÊý¾Ý,дµÄÒ»¸ö¹¤¾ßÀà,ûÓÐÓÅ»¯¹ý,ºÇºÇ
ÉÏÃæµÄÊǹ¤¾ßÀà,ÏÂÃæÌáÓ÷¨,д·¨ºÜ±¿,µ«ÓÃ×Å»¹ºÜ·½±ã
package com.dtb.utils;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
* JAVA ²Ù×÷ excel ÖÐµÄ .xlsÎļþ¸ñʽ
* @author dtb
*
*/
public class ExcelUtil {
/** ¹¤×÷±í*/
private Workbook rwb;
/** д²Ù×÷±í*/
private WritableWorkbook wwb;
public ExcelUtil(){}
/**
* ¹¹Ô캯Êý
* @param fileName - ÎļþÃû
*/
public ExcelUtil(String fileName) {
try {
rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* ¾²Ì¬¹¤³§·½·¨,·µ»Ø¶Á²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getReadExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.rwb = Workbook.getWorkbook(new FileInputStream(fileName));
} catch (BiffException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return eu;
}
/**
* ¾²Ì¬¹¤³§·½·¨,·µ»Øд²Ù×÷µÄExcelUtil¶ÔÏó
* @param fileName - ÎļþÃû
* @return this
*/
public static ExcelUtil getWriteExcelUtil(String fileName) {
ExcelUtil eu = new ExcelUtil();
try {
eu.wwb = Workbook.createWorkbook(new FileOutputStream(fileName));
} catch (FileNotFoundException e) {
e.printStackTrace();
} cat
Ïà¹ØÎĵµ£º
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔÇ°£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......
package io;
import java.io.*;
/**
* @author ¸ßÕíÎâÓÇ
* ÀûÓûº³åÇøÔÀí,BufferedInputStream,
* ʵÏÖµÄÎļþ×Ö½ÚÁ÷¶ÁÈ¡¹¦ÄÜʾ·¶
*
*/
public class BufferedInOutputStream {
public BufferedInOutputStream() {
ioTest2();
}
public void ioTest2() {
FileInputStream in = null ;
BufferedInput ......
Ò»¡¢ ¼ò½é
Berkeley DB Java Edition (JE)ÊÇÒ»¸öÍêÈ«ÓÃJAVAдµÄ£¬ËüÊʺÏÓÚ¹ÜÀíº£Á¿µÄ£¬¼òµ¥µÄÊý¾Ý¡£
Äܹ»¸ßЧÂʵĴ¦Àí1µ½1°ÙÍòÌõ¼Ç¼£¬ÖÆÔ¼JEÊý¾Ý¿âµÄÍùÍùÊÇÓ²¼þϵͳ,¶ø²»ÊÇJE±¾Éí¡£
¶ ......
ÎÒдÁËÒ»¸ö³ÌÐòÓÃÀ´½ÓÊÕ¿Í»§¶Ë·¢¹ýÀ´µÄÊý¾Ý£¬µ«ÊÇÈç¹û¶à¸ö¿Í»§¶ËÒ»ÆðÏñÕâÀï·¢ËÍÊý¾Ýʱ£¬±¨StandardWrapperValve[xmlreceiver]: Servlet.service() for servlet xmlreceiver threw exception java.lang.OutOfMemoryError£¬ÕâʱÐèÒªÀ©´ótomcatµÄjavaÐéÄâ»úÄڴ棬ÈçºÎ¸ü¸ÄÄØ£¿
ÔÚ Windows²Ëµ¥ÖÐÕÒµ½Tomcat°²×°²Ëµ¥ÖеÄMonitor ......
ÓÃJava½Ó¿ÚʵÏֻص÷º¯ÊýµÄµÈ¼Û¹¦ÄÜ
Ê×ÏÈ£¬¿´Ò»Ï»ص÷º¯ÊýµÄ¶¨Òå¼°ÆðÔ´£º
¼ò¶øÑÔÖ®£¬»Øµ÷º¯Êý¾ÍÊÇÒ»¸öͨ¹ýº¯ÊýÖ¸Õëµ÷Óõĺ¯Êý£¬Èç¹ûÄã°Ñº¯ÊýµÄÖ¸Õë(µØÖ·)×÷Ϊ²ÎÊý´«µÝ¸øÁíÒ»¸öº¯Êý£¬µ±Õâ¸öÖ¸Õë±»ÓÃΪµ÷ÓÃËüËùÖ¸ÏòµÄº¯Êýʱ£¬ÎÒÃǾÍ˵Êǻص÷º¯Êý¡£
ΪʲôҪʹÓûص÷º¯Êý£¿
ÒòΪ¿ÉÒ԰ѵ÷ÓÃÕßÓë±»µ÷ÓÃÕß·Ö¿ª¡£µ÷ÓÃÕß²»¹ØÐı» ......