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
Ïà¹ØÎĵµ£º
ÀàµÄ³õʼ»¯ºÍ¶ÔÏó³õʼ»¯ÊÇ JVM ¹ÜÀíµÄÀàÐÍÉúÃüÖÜÆÚÖзdz£ÖØÒªµÄÁ½¸ö»·½Ú£¬Google ÁËÒ»±éÍøÂ磬ÓйØÀà×°ÔØ»úÖÆµÄÎÄÕµ¹ÊDz»ÉÙ£¬È»¶øÀà³õʼ»¯ºÍ¶ÔÏó³õʼ»¯µÄÎÄÕ²¢²»¶à£¬ÌرðÊÇ´Ó×Ö½ÚÂëºÍ JVM ²ã´ÎÀ´·ÖÎöµÄÎÄÕ¸üÊÇÏÊÓÐËù¼û¡£
±¾ÎÄÖ÷Òª¶ÔÀàºÍ¶ÔÏó³õʼ»¯È«¹ý³Ì½øÐзÖÎö£¬Í¨¹ýÒ»¸öʵ¼ÊÎÊÌâÒýÈ룬½«Ô´´úÂëת»»³É JVM ×Ö½ÚÂëºó£¬ ......
Ï̳߳ØÖ÷ÒªÊÇÓÃÀ´ ´¦Àí¶à¸öÇëÇóʱ£¬¼õÉÙ×ÊÔ´ÏûºÄ£¬Ìá¸ßÓ¦ÓÃÐÔÄÜ¡£
ÏÂÃæµÄ´úÂëÊÇÀ´×ÔÓÚ ËïÎÀÇÙ£º<<JavaÍøÂç±à³Ì¾«½â>> ÖÐÏ̳߳ØÊµÏÖÔ´Âë, ´úÂë½á¹¹¼òµ¥ÇåÎú£¬¶ÔÓÚÀí½âÏ̳߳أ¬wait(),notify()·½·¨¶¼ÓÐÓÐºÜ ......
Berkely DB¶ÔÓڸ߲¢·¢¡¢ÒªÇóËÙ¶È¿ìµÄÓ¦ÓÃÀ´ËµÊǸö²»´íµÄÑ¡Ôñ£¬mysql¾ÍÊÇÓÃBDBʵÏÖµÄ(mysqlµÄºǫ́) £¬mysql¿ì£¬BDB±Èmysql»¹Òª¿ìN±¶¡£BDBÊÇÒ»ÖÖǶÈëʽµÄ¡¢·Ç¹ØÏµÊý¾Ý¿â£¬ËüÓëÆäËûµÄ¹ØÏµÊý¾Ý¿âRMDBS²»Í¬,ËüûÓÐÌṩSQL,¶øÊÇÌṩÁË×Ô¼ºµÄ·ÃÎʽӿڡ£×÷ΪһÖÖǶÈëʽµÄÊý¾Ý¿â£¬ËüÊǽø³ÌÄÚģʽµÄ£¬Ò²¾ÍÊÇ˵ËüºÍÓ¦ÓóÌÐòÔÚͬһÄÚ´æ¿ ......
Õ»Óë¶Ñ¶¼ÊÇJavaÓÃÀ´ÔÚRAMÖдæ·ÅÊý¾ÝµÄµØ·½¡£ÓëC++²»Í¬£¬Java×Ô¶¯¹ÜÀíÕ»ºÍ¶Ñ£¬³ÌÐòÔ±²»ÄÜÖ±½ÓµØÉèÖÃÕ»»ò¶Ñ¡£
JavaµÄ¶ÑÊÇÒ»¸öÔËÐÐʱÊý¾ÝÇø,ÀàµÄ¶ÔÏó´ÓÖзÖÅä¿Õ¼ä¡£ÕâЩ¶ÔÏóͨ¹ýnew¡¢newarray¡¢anewarrayºÍmultianewarrayµÈÖ¸ÁÁ¢£¬ËüÃDz»ÐèÒª³ÌÐò´úÂëÀ´ÏÔʽµÄÊÍ·Å¡£¶ÑÊÇÓÉÀ¬»ø»ØÊÕÀ´¸ºÔðµÄ£¬¶ÑµÄÓÅÊÆÊÇ¿ÉÒÔ¶¯Ì¬µØ·ÖÅäÄÚ´æ´ ......
Java ¶¨ÒåµÄλÔËË㣨bitwise operators £©Ö±½Ó¶ÔÕûÊýÀàÐ͵Äλ½øÐвÙ×÷£¬ÕâЩÕûÊýÀàÐͰüÀ¨long£¬int£¬short£¬char£¬and byte ¡£±í4-2 ÁгöÁËλÔËË㣺
±í4.2 λÔËËã·û¼°Æä½á¹û
ÔËËã·û ½á¹û
~ °´Î»·Ç£¨NOT£©£¨Ò»ÔªÔËË㣩
& °´Î»Ó루AND£©
| °´Î»»ò£¨OR£©
^ °´Î»Òì»ò£¨XOR£©
>> ÓÒÒÆ
>>> ÓÒÒ ......