Java²Ù×÷Excel£ºbook±£»¤
ExcelµÄbook±£»¤ÊǺܳ£Óõģ¬Ö÷ÒªÊDz»ÏëÈñðÈËÐÞ¸ÄExcelµÄʱºòÓá£ÕâÑùÄܹ»±ÜÃâ¶ñÒâËæ±ãÐÞ¸ÄÊý¾Ý£¬Ìá¸ßÊý¾ÝµÄ¿ÉÐжȡ£
ÄÇôJAVAÀ´ÊµÏÖÉèÖÃbook±£»¤Ôõô×öÄØ£¿
²éÕÒÁ˼¸ÖÖ³£¼ûµÄJAVA²Ù×÷ExcelµÄһЩ°ü£¬´óÌå½á¹ûÈçÏ£º
1. POI
POIµÄHSSFWorkbookÀàÓÐwriteProtectWorkbook(password, username)¡£Õâ±ß¿ÉÒÔÉèÖÃÃÜÂëºÍÊÂ˱£»¤µÄ£¬µ«Õâ¸ö¹ËÃû˼Òå¾Íд±£»¤£¬ÊµÏÖºÍExcelµÄbook±£»¤ÓгöÈë¡£
µ±È»£¬sheet±£»¤µÄ»°ÓÃHSSFSheetÀàµÄprotectSheet(password)·½·¨¾Í¿ÉÒÔÁË¡£
2. JXL
WorkbookÀàµÄsetProtected£¨boolean£©·½·¨¸Ð¾õÊÇÓÃÀ´×öbook±£»¤µÄ£¬µ«¿´ÁË˵Ã÷ÊÇÉèÖÃsheet±£»¤µÄ¡£Òò´ËÒ²ÊÇʵÏÖ²»ÁËbook±£»¤µÄЧ¹û¡£
3. OpenXLS
×îºóºÃ²»ÈÝÒ×ÕÒµ½ÁËÕâ¸ö°ü¡£WorkBookµÄsetProtected(true)·½·¨ÉèÖúó¾ÍʵÏÖÁËbook±£»¤¡£´úÂëÈçÏ£º
// read file
WorkBook workbook = new WorkBookHandle(new FileInputStream(new File("d:/openxlsTest.xls")));
// protect
workbook.setProtected(true);
// write file
workbook.writeBytes(new FileOutputStream(new File("d:/openxlsProtect.xls")));
book±£»¤ºóµÄЧ¹û£¬sheet²»ÄÜÔö¼Ó£¬É¾³ýµÈ
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
±¾ÎĽéÉÜÁËJavaÄÚ´æÒç³öµÄÏêϸ½â¾ö·½°¸¡£±¾ÎÄ×ܽáÄÚ´æÒç³öÖ÷ÒªÓÐÁ½ÖÖÇé¿ö£¬¶øJVM¾³£µ÷ÓÃÀ¬»ø»ØÊÕÆ÷½â¾öÄÚ´æ¶Ñ²»×ãµÄÎÊÌ⣬µ«ÊÇÓÐʱÈÔ»áÓÐÄÚ´æ²»×ãµÄ´íÎó¡£×÷Õß·ÖÎöÁËJVMÄÚ´æÇøÓò×é³É¼°JVMÉèÖÃÐéÄâÄÚ´æµÄ·½Ê½£¬´Ó¶ø¸ø³öÁËһϵÁнâ¾ö·½°¸¡£ Ò»¡¢ÄÚ´æÒç³öÀàÐÍ 1¡¢java.lang.OutOfMemoryError: PermGen space JVM¹ ......
Java Mail·¢ËÍ´øÓÐͼƬµÄhtml¸ñʽµÄÓʼþ£¬Õë¶ÔÓÚÏÔʾͼƬ£¬Ò»°ãÓÐÁ½ÖÖ·½·¨¡£
1. ͼƬ´æÔÚÓÚ·þÎñÆ÷ÉÏ£¬ÎÒÃÇÖ»ÐèÒª°ÑͼƬÔÚ·þÎñÆ÷µÄµÄÁ´½Ó·Å½øÈ¥¼´¿É¡£
ÕâÖÖ·¢Ê½±È½Ï¼òµ¥£¬µ«ÊÇÕâÖÖ·½·¨ÓÐЩȱÏÝ£º
ͼƬ²»Ö§³ÖÀëÏßä¯ÀÀ£»
ÿ´Îä¯ÀÀÓʼþÐèÒª·ÃÎÊweb·þÎñ£¬Ôö¼Ó·þÎñÆ÷¸ºµ££»
ÈôͼƬÒÔ¶þ½øÖƵķ½Ê½´æÔÚÓÚÊý¾Ý¿â»òÊǶ¯Ì¬É ......
//ÓÉÓÚJAVAÓïÑÔµÄÊý¾ÝÀàÐͶ¼ÊÇÓзûºÅÀàÐÍ£¬¶øC# C++Ò»°ãÊý¾ÝÀàÐͶ¼ÊÇ·ÖÓзûºÅºÍÎÞ·ûºÅ,
//Òò´ËÔÚͨÐŹý³ÌÖд«µÝµÄByte[]ÎÞ·¨Ö±½Óת»»³ÉC#ÐèÒªµÄÀàÐÍ£¬
//ÒÔǰµ¹ÊÇûעÒâÕâЩϸ½Ú£¬ÒòΪһ°ãÓÃÒ»ÖÖÓïÑÔ±à³Ì£¬
//´ó¶¼ÓÐÄÚÖõÄת»»·½·¨¡£¿çÓïÑÔ»·¾³µÄת»»¾ÍµÄ×Ô¼º¶¯ÊÖÏë°ì·¨ÁË¡£
1¡¢javaµÄByte[]ת»»³Éc#µÄInt32
private i ......