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²»ÄÜÔö¼Ó£¬É¾³ýµÈ
Ïà¹ØÎĵµ£º
Java Mail·¢ËÍ´øÓÐͼƬµÄhtml¸ñʽµÄÓʼþ£¬Õë¶ÔÓÚÏÔʾͼƬ£¬Ò»°ãÓÐÁ½ÖÖ·½·¨¡£
1. ͼƬ´æÔÚÓÚ·þÎñÆ÷ÉÏ£¬ÎÒÃÇÖ»ÐèÒª°ÑͼƬÔÚ·þÎñÆ÷µÄµÄÁ´½Ó·Å½øÈ¥¼´¿É¡£
ÕâÖÖ·¢Ê½±È½Ï¼òµ¥£¬µ«ÊÇÕâÖÖ·½·¨ÓÐЩȱÏÝ£º
ͼƬ²»Ö§³ÖÀëÏßä¯ÀÀ£»
ÿ´Îä¯ÀÀÓʼþÐèÒª·ÃÎÊweb·þÎñ£¬Ôö¼Ó·þÎñÆ÷¸ºµ££»
ÈôͼƬÒÔ¶þ½øÖƵķ½Ê½´æÔÚÓÚÊý¾Ý¿â»òÊǶ¯Ì¬É ......
/**
SimpleDateFormatº¯ÊýÓï·¨£º
G Äê´ú±êÖ¾·û
y Äê
M ÔÂ
d ÈÕ
h ʱ ÔÚÉÏÎç»òÏÂÎç (1~12)
H ʱ ÔÚÒ»ÌìÖÐ (0~23)
m ·Ö
s Ãë
S ºÁÃë
E ÐÇÆÚ
D Ò»ÄêÖеĵڼ¸Ìì
F Ò»ÔÂÖеڼ¸¸öÐÇÆÚ¼¸
w Ò»Äê ......
ÈçºÎ¶ÁÈ¡×ÊÔ´Îļþ£º
£¨Ò»£©
Properties props = new Properties();
props.load(new FileInputStream("db.properties"));
£¨¶þ£©
blog.propertiesÎļþÈçÏÂ
dbdriver=oracle.jdbc.driver.OracleDriver
dburl=jdbc:oracle:thin:@127.0.0.1:1521:ora92
dbuser=blog
dbpwd=blog
- ......
×î½üµÄDevoxx´ó»áÉÏ£¬Java 7½«°üº¬±Õ°üµÄÏûÏ¢ÁîºÜ¶àÈ˸е½Õñ·Ü——Õ⽫×öΪһ¸ö¶ÀÁ¢µÄJSR±»ÊµÏÖ¡£ÔÚÖÚ¶àJava 7еÄÓïÑÔÌØÐÔÖУ¬ÓÐһЩÏÖÔÚÒѾÍê³ÉÁË¡£Devoxx´ó»áµÄһλ²Î»áÕßÔÚ²©¿ÍÖб¨¸æÁËÏÂÃæÕâЩJava 7ÒѾÍê³ÉµÄ7´óй¦ÄÜ£º
1£©¶Ô¼¯ºÏÀàµÄÓïÑÔÖ§³Ö£»
2£©×Ô¶¯×ÊÔ´¹ÜÀí£»
3£©¸Ä½øµÄͨÓÃʵÀý´´½¨ÀàÐÍÍÆ¶Ï£»
......
×î½üÏîÄ¿ÖÐÓöµ½ÁËÉÏÒÆÏÂÒÆ²Ù×÷µÄÒ»¸ö²Ù×÷£¬ÒÔǰҲ¿´µ½¹ý£¬µ«Ò»Ö±Ã»ÓÐÈ¥Ñо¿¹ý£¬Õâ´ÎÏîÄ¿ÖÐÓöµ½ÁË£¬Ò²¾ÍÈ¥Ñо¿ÁËÒ»°Ñ£¬ÆäʵʵÏÖÔÀíҲͦ¼òµ¥µÄ£¬Ëµ°×Á˾ÍÊÇ
Òª¼Ç¼Êý¾Ý¿âÀïµÄÒª½øÐÐÅÅÐò±íµÄ×ܼǼÊýÁ¿£¬È»ºó¸ù¾ÝÑ»·µÄ´ÎÊý£¬¶àд¼¸¸öÒþ²Ø±äÁ¿£¬½øÐÐÉÏÒÆÏÂÒÆ²Ù×÷µÄʱºò½øÐÐÅжϾͿÉÒÔÁË¡£
&n ......