javaÉú³ÉEXCEL±í¸ñ£¨POI vs JXL£©
javaÉú³Éexcel±í¸ñ£¬ÒÔÇ°Ö»ÖªµÀPOI£¬ÕâÊÇApacheµÄ¿ªÔ´ÏîÄ¿£¬±¾À´ÊÇÒ»Ì׵ģ¬°üÀ¨word£¬µ«ÊÇÒòΪwordµÄ¸´ÔÓÐÔ£¬ÒÔ¼°¿ª·¢ÈËÔ±µÄȱ·¦£¬ºÃÏñ»ù±¾Í£ÖÍÁË¡£Ö»ÓÐExcel×öµÄ»¹Ëã±È½ÏÍêÕû£¬ÓÃÆðÀ´±È½ÏÇáËÉ¡£
ºóÀ´ÒòΪ×öÏîÄ¿µÄ¹Øϵ£¬ÖªµÀÁË»¹ÓиöJXL£¨java excel£©£¬Ò²ÊǸö¿ªÔ´ÏîÄ¿£¬ÓÃÆðÀ´µÄ¸Ð¾õ¸úPOIºÜÀàËÆ£¬ÒòΪÓõ½µÄ¹¦Äܶ¼ºÜ¼òµ¥£¬Ò²Ã»¾õµÃÓÐʲô´óµÄ²î¾à¡£ÍøÉÏÕÒÁËһЩËûÃǵÄÇø±ð£¬ËãÊǸø×Ô¼ºÉ¨Ã¤ÁË¡£
ÒÔÏÂΪתÌù£¬ºìɫΪ×Ô¼º±ê×¢¡£
×Ô´Ó MS ¹«¿ªÁË OFFICE µÄ±àÂë¸ñʽÒÔÀ´£¬ºÜ¶à¿ªÔ´µÄ×éÖ¯¶¼ÌṩÁË¶Ô Excel Ö§³Ö¶Áд²Ù×÷µÄ²å¼þ°ü¡£Java ÊÀ½çÀApacheÓ¦¸ÃËãÊÇ¿ªÔ´ÊÀ½çÖеÄÁìÍ·Ñò¡£ËûµÄJakarta Project ÖÐµÄ POI Project ¾ÍÌṩÁ˶ÔOFFICEµÄÍêÃÀÖ§³Ö£¨²»¹ý×î½üºÃÏñËû¶ÔWordµÄÖ§³ÖÏîÄ¿ÒѾֹͣ£¬¶øÇÒ¹«¿ªÔÚÍøÕ¾ÉÏȦÈËÄØ ^^ ,Èç¹ûÄã¶ÔWordÎļþµÄ±àÂë¸ñʽ·Ç³£ÊìϤ£¬¿ÉÒÔ·¢·âÓʼþŶ£¡£©£¬µ±È»³ý´ËÖ®Í⣬»¹ÓкܶàÆäËû¿ªÔ´×éÖ¯Ò²¶Ô Excel µÄ¶Áд²Ù×÷ÌṩÁ˺ܺõÄÖ§³Ö£¬ÆäÖмòµ¥¶øÇÒʵÓõıãÊÇ Display-tag £¬³ÌÐòÔ±¸ù±¾¾Í²»ÐèÒª¿¼ÂÇÈçºÎ½«Êý¾ÝºÏÀíµØдÈëExcelÖУ¬ÕâÒ»Çж¼ÊÇÓÉÆä Servlet ×Ô¶¯Íê³É£¬µ«Ò²ÕýÊÇÓÉÓÚËû¶Ô³ÌÐòÔ±ÊÇ͸Ã÷µÄ£¬Òò´ËΪºÜ¶à²Ù×÷Ò²´øÀ´Á˲»±ã¡£ÔÚ½ÓÏÂÀ´µÄÎÄ×ÖÖÐÎÒ»á½éÉÜÁíÍâÒ»ÖÖͬÑù¶ÔExcelÌṩÁËÍêÃÀÖ§³ÖµÄµÚÈý·½²å¼þ JXL £¬Java ExcelÊÇÒ»¿ª·ÅÔ´ÂëÏîÄ¿£¬Í¨¹ýËüJava¿ª·¢ÈËÔ±¿ÉÒÔ¶ÁÈ¡ExcelÎļþµÄÄÚÈÝ¡¢´´½¨ÐµÄExcelÎļþ¡¢¸üÐÂÒѾ´æÔÚµÄExcelÎļþ¡£Ê¹ÓøÃAPI·ÇWindows²Ù×÷ϵͳҲ¿ÉÒÔͨ¹ý´¿JavaÓ¦ÓÃÀ´´¦ÀíExcelÊý¾Ý±í¡£ÒòΪÊÇʹÓÃJava±àдµÄ£¬ËùÒÔÎÒÃÇÔÚWebÓ¦ÓÃÖпÉÒÔͨ¹ýJSP¡¢ServletÀ´µ÷ÓÃAPIʵÏÖ¶ÔExcelÊý¾Ý±íµÄ·ÃÎÊ¡£
Jakarta µÄ POI Project Óë Java Excel API ÔÚ¿ªÔ´ÊÀ½çÖпÉÒÔ˵ÊDz¢¼ÝÆëÇý£¬µ«ÊÇÒ²¸÷ÓÐÓÅÁÓ£¬poiÔÚijЩϸ½ÚÓÐЩСBug²¢ÇÒ²»Ö§³ÖдÈëͼƬ(poiÆäʵ¿ÉÒÔдÈëͼƬ£¬²»¹ýûÓÐjxlÀ´µÄ·½±ã£¬±È½ÏÂé·³)£¬ÆäËû·½Ã涼ͦ²»´íµÄ£»¶øJXLÌṩÁ˶ÔͼƬµÄÖ§³Ö£¨µ«Êǽö½öÖ§³Öpng¸ñʽµÄͼƬ£©£¬ÎÊÌâ¾ÍÊǶԹ«Ê½Ö§³Ö²»ÊǺܺ㬵«»¹ÊÇÌṩÁ˼òµ¥µÄ¹«Ê½¶ÁÈ¡Ö§³Ö¡£Òò´ËÄãµÄÏîÄ¿ÖÐҪѡÓÃʲôÑùµÄµÚÈý·½²å¼þΪÍêÈ«ÓÉÄãµÄÓ¦ÓÃÀ´¾ö¶¨¡£Èç¹ûÄãµÄÈí¼þÊǸú²ÆÎñÓÐÏ൱µÄ¹ØϵµÄ»°£¬½¨Òé²ÉÓà POI Project£¬¾ÍÎÒËùÔÚÄ¿Ç°µÄÏîÄ¿À´ËµÓÉÓÚÓò»µ½¼ÆË㹫ʽ£¬¶øÇҺܿÉÄÜÐèÒªµ¼³öͼƬ£¬Òò´Ë£¬ÎÒµÄÑ¡ÔñÊÇ JXL ¡£
http://huanqingblog.blog.sohu.com/63922965.html
Ïà¹ØÎĵµ£º
JavaÉè¼Æģʽ֮×ÛÊöƪ
http://tech.it168.com/a2009/0223/266/000000266380.shtml
×Ô´ÓJ2EE³öÏÖÒÔÀ´£¬¾Í´ó´ó¼ò»¯ÁËÔÚJavaϵÄÆóÒµ¼¶¿ª·¢¡£µ«ÊÇËæ×ÅJ2EEÔ½À´Ô½ÆÕ±éµØ±»Ó¦Óõ½¸÷¸öÁìÓòÖУ¬¿ª·¢ÕßÃǽ¥½¥Òâʶµ½ÐèÒªÒ»ÖÖ·½·¨À´±ê×¼»¯Ó¦ÓóÌÐòµÄ¿ª·¢¹ý³Ì£¬ËûÃDzÉÓõķ½·¨ÊDZê×¼»¯Ó¦ÓóÌÐòµÄ½á¹¹²ã¡£Ôڽṹ²ãͨ³£·â×°ÁËһЩ¶ÀÁ¢Ó ......
windows xpÏÂÅäÖÃJDK»·¾³±äÁ¿£º
1.°²×°JDK£¬°²×°¹ý³ÌÖпÉÒÔ×Ô¶¨Ò尲װĿ¼µÈÐÅÏ¢£¬ÀýÈçÎÒÃÇÑ¡Ôñ°²×°Ä¿Â¼ÎªD:\java\jdk1.5.0_08£»
¡¡ 2.°²×°Íê³Éºó£¬ÓÒ»÷“ÎҵĵçÄÔ”£¬µã»÷“ÊôÐÔ”£»
3.Ñ¡Ôñ“¸ß¼¶”Ñ¡Ï£¬µã»÷“ ......
ÔÚjavaÖУ¬¼ÙÉèÄãÓÐÒ»¸öuser ¶ÔÏóµÄlist£¬´Ëuser¶ÔÏó·â×°ÁËÓû§µÄid, first name, last name and age. È»ºóÄãÏëµ÷ÓÃÒ»¸öweb service(eg. UserService.deleteUsersByIds(List<Integer> userIds) ȥɾ³ýÊý¾Ý¿âÖÐÖ¸¶¨µÄÕâЩuser¡£ ÌýÆðÀ´Ëƺõ²»Ì«À§ÄÑ£¬²»ÊÇô? ÄãËùÐèÒªÖ»Êǽ« List<User> ת»¯³ÉList&l ......
ÊÂÎñ´¦Àí×ܽá
À´Ô´£ºhttp://space.itpub.net/13956325/viewspace-598381
Ò»¡¢Ê²Ã´ÊÇJava ÊÂÎñ
ͨ³£µÄ¹ÛÄîÈÏΪ£¬ÊÂÎñ½öÓëÊý¾Ý¿â Ïà¹Ø¡£
Ê Îñ±ØÐë·þ´ÓISO/IECËùÖƶ¨µÄACIDÔÔò¡£ACIDÊÇÔ×ÓÐÔ£¨atomicity£©¡¢Ò»ÖÂÐÔ£¨consistency£©¡¢¸ôÀëÐÔ £¨isolation£©ºÍ³Ö¾ÃÐÔ£¨durability£©µÄËõд¡£ÊÂÎñµÄÔ×ÓÐÔ±íʾÊÂÎñ ......
public class TestClass{
public static void main(String args[]){
VarArgs(1, "one");
VarArgs(2, "one", "two");
VarArgs(3, "one", "two", "three");
VarArgs(0); // Attention!
}
static void VarArgs(int nRequired, String... trailing){
System.out.print("Required: " + nRequired + " ");
......