Java Éú³É EXCEL POIÎĵµËµÃ÷
Java Éú³É EXCEL POIÎĵµËµÃ÷
POI°æ±¾:3.0.2-FINAL
ÏÂÔØµØÖ·: http://poi.apache.org/index.html
Ò»°ãÔÚÏîÄ¿ÖÐÕæÕýҪʵÏÖÕâÑùÒ»¸ö±í¸ñµÄʱºò£¬ÀýÈçÏîÄ¿ÐèÒªÖÆ×÷±¨±íµÈµÈ£¬Í¨³£µÄ×ö·¨¶¼ÊÇÊÂÏȰѸñʽһÇеĶ«Î÷¶¼ÊÖ¶¯ÖÆ×÷ºÃ£¨Õâ¸ö×öºÃÁ˵ÄÎļþÔÚʵ¼ÊµÄÏîÄ¿ÀïÎÒÃdzÆÖ®Îª“Êý¾ÝÄ£°å”£¬¼ò³Æ“Ä£°å”£©£¬È»ºóÔÚJavaÓ¦ÓÃÖÐÊʵ±µÄʱ»ú°ÑÕâ¸öÎļþ¶Á½øÀ´Ð޸ģ¬×îºóÔÙÁí´æµ½Ö¸¶¨µÄλÖûòÕß´«µÝ¸øÏÂÒ»¸ö´¦ÀíÕߣ¨ÀýÈçÒÔÁ÷µÄ·½Ê½Ë͸øServletµÈµÈ£©£¬ÕâÑùÆäʵPOI¾ßÌå×öµÄÊÂÇé¾ÍÊÇÏòÄ£°åÀïдҵÎñµÄÊý¾Ý£¬»¹ÊǺܷ½±ã¿ì½ÝµÄ¡£
Ò»POI ¶ÁÈ¡Excel »ù±¾¹¤×÷
1. // Ö¸¶¨Òª¶ÁÈ¡µÄÎļþ£¬±¾ÀýʹÓÃÉÏÃæÉú³ÉµÄhelloworld.xls
FileInputStream readFile = new FileInputStream("c:/ceshi.xls");
// ´´½¨Ò»¸öWorkBook£¬´ÓÖ¸¶¨µÄÎļþÁ÷Öд´½¨£¬¼´ÉÏÃæÖ¸¶¨Á˵ÄÎļþÁ÷
HSSFWorkbook wb = new HSSFWorkbook(readFile);
// »ñÈ¡Ãû³ÆÎª“²âÊÔÒ³”µÄsheet
// ×¢Ò⣬Èç¹û²»ÄÜÈ·¶¨¾ßÌåµÄÃû³Æ£¬¿ÉÒÔÓÃgetSheetAt(int)·½·¨È¡µÃSheet
//HSSFSheet st = wb.getSheet("²âÊÔÒ³");
HSSFSheet st = wb.getSheetAt(0);
//´´½¨Ñùʽ±í£¬Ñùʽ±í¿ÉÒÔÉèÖõ¥Ôª¸ñµÄһЩÊôÐÔ ±ÈÈç±³¾°É«,Ëø¶¨×´Ì¬,ÐÐÁпí¸ßµÈ
HSSFCellStyle normalStyle = wb.createCellStyle();
//ÒÔÏÂÁз½Ê½´æ´¢µ±Ç°µ¥Ôª¸ñÑùʽ
µ¥Ôª¸ñ¶ÔÏó.setCellStyle(normalStyle);
¶þÉèÖÃÄ£°åÓ뽨Á¢ÐкÍÁÐ
1. Èç¹ûÔ¤ÏȵÄÄ£°åÓÐÄÚÈݵϰ,ÔÚ²Ù×÷µÄʱºòÔòÖ»ÐèÒª¶ÁÈ¥µ±Ç°µ¥Ôª¸ñµÄÄÚÈÝÒÔ¼°Ñùʽ£¬»òÕß¿ÉÒÔÖØÐ¶¨Òå¡£(Èç¹ûûÓÐÄÚÈÝ,ÓÖÏëÒÔ¶ÁÈ¥µÄ·½Ê½À´»ñÈ¡ExcelµÄ»°£¬ÐèÒªÊÖ¶¯³õʼ»¯Ä£°å£¬Èç¸øÄ£°åÖÐÐèÒªÓõ½µÄµ¥Ôª¸ñÉèÖñ߿ò»òÕß±³¾°É«µÈ)
ÀýÈç
HSSFRow row = st.getRow(0); //¶ÁÈ¡µÚÒ»ÐÐ
HSSFCell cell = row.getCell((short)0); //¶ÁÈ¡µÚÒ»ÐеÚÒ»¸ö×Ö¶Î
2. Èç¹ûÄ£°åÖÐÎ
Ïà¹ØÎĵµ£º
JavaỊ̈߳ºÏ̵߳Äͬ²½ÓëËø
Ò»¡¢Í¬²½ÎÊÌâÌá³ö
Ï̵߳Äͬ²½ÊÇΪÁË·ÀÖ¹¶à¸öÏ̷߳ÃÎÊÒ»¸öÊý¾Ý¶ÔÏóʱ£¬¶ÔÊý¾ÝÔì³ÉµÄÆÆ»µ¡£
ÀýÈ磺Á½¸öÏß³ÌThreadA¡¢ThreadB¶¼²Ù×÷ͬһ¸ö¶ÔÏóFoo¶ÔÏ󣬲¢ÐÞ¸ÄFoo¶ÔÏóÉϵÄÊý¾Ý¡£
public class Foo {
private int x = 100;
......
JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ºÏ²¢
Ï̵߳ĺϲ¢µÄº¬Òå¾ÍÊǽ«¼¸¸ö²¢ÐÐÏ̵߳ÄÏ̺߳ϲ¢ÎªÒ»¸öµ¥Ïß³ÌÖ´ÐУ¬Ó¦Óó¡¾°Êǵ±Ò»¸öÏ̱߳ØÐëµÈ´ýÁíÒ»¸öÏß³ÌÖ´ÐÐÍê±Ï²ÅÄÜÖ´ÐÐʱ¿ÉÒÔʹÓÃjoin·½·¨¡£
joinΪ·Ç¾²Ì¬·½·¨£¬¶¨ÒåÈçÏ£º
void join()
µÈ´ý¸ÃÏß³ÌÖÕÖ¹¡£ ......
JavaỊ̈߳º²¢·¢Ð×÷-ËÀËø
Ï̷߳¢ÉúËÀËø¿ÉÄÜÐÔºÜС£¬¼´Ê¹¿´ËÆ¿ÉÄÜ·¢ÉúËÀËøµÄ´úÂ룬ÔÚÔËÐÐʱ·¢ÉúËÀËøµÄ¿ÉÄÜÐÔÒ²ÊÇС֮ÓÖС¡£
·¢ÉúËÀËøµÄÔÒòÒ»°ãÊÇÁ½¸ö¶ÔÏóµÄËøÏ໥µÈ´ýÔì³ÉµÄ¡£
ÔÚ¡¶JavaỊ̈߳ºÏ̵߳Äͬ²½ÓëËø¡·Ò»ÎÄÖУ¬¼òÊöËÀËøµÄ¸ÅÄîÓë¼òµ¥Àý×Ó£¬µ«ÊÇËù¸øµÄÀý×ÓÊDz»ÍêÕûµÄ£¬ÕâÀï¸ø³öÒ»¸öÍêÕûµÄÀ ......
JavaỊ̈߳ºÐÂÌØÕ÷-Ëø£¨ÉÏ£©
ÔÚJava5ÖУ¬×¨ÃÅÌṩÁËËø¶ÔÏó£¬ÀûÓÃËø¿ÉÒÔ·½±ãµÄʵÏÖ×ÊÔ´µÄ·âËø£¬ÓÃÀ´¿ØÖƶԾºÕù×ÊÔ´²¢·¢·ÃÎʵĿØÖÆ£¬ÕâЩÄÚÈÝÖ÷Òª¼¯ÖÐÔÚjava.util.concurrent.locks °üÏÂÃæ£¬ÀïÃæÓÐÈý¸öÖØÒªµÄ½Ó¿ÚCondition¡¢Lock¡¢ReadWriteLock¡£
Condition
Condition ½« Object ¼àÊÓÆ÷·½·¨£¨wait¡¢notify ......
JavaỊ̈߳ºÐÂÌØÕ÷-Ëø£¨Ï£©
ÔÚÉÏÎÄÖÐÌáµ½ÁËLock½Ó¿ÚÒÔ¼°¶ÔÏó£¬Ê¹ÓÃËü£¬ºÜÓÅÑŵĿØÖÆÁ˾ºÕù×ÊÔ´µÄ°²È«·ÃÎÊ£¬µ«ÊÇÕâÖÖËø²»Çø·Ö¶Áд£¬³ÆÕâÖÖËøÎªÆÕÍ¨Ëø¡£ÎªÁËÌá¸ßÐÔÄÜ£¬JavaÌṩÁ˶ÁÐ´Ëø£¬ÔÚ¶ÁµÄµØ·½Ê¹ÓöÁËø£¬ÔÚдµÄµØ·½Ê¹ÓÃÐ´Ëø£¬Áé»î¿ØÖÆ£¬ÔÚÒ»¶¨³Ì¶ÈÉÏÌá¸ßÁ˳ÌÐòµÄÖ´ÐÐЧÂÊ¡£
JavaÖжÁÐ´ËøÓиö½Ó¿Újava ......