java²Ù×÷ExcelÓÐÈýÖÖµÚÈý·½×é¼þ£ºjxl¡¢poi¡¢jacob¡£
²»ÖªµÀÄÄÒ»ÖÖÄÜʵÏÖÏòExcelÎļþµÄÖ¸¶¨µ¥Ôª¸ñÖвåÈëÒ»¸öÎļþ(txt¼´¿É)¡£
Çë¸ßÊÖÏêϸָ½Ìһϣ¬ ·Ç³£¸ÐлͬʱËÍÉÏ·ÖÊý¡£
ÒýÓà java²Ù×÷ExcelÓÐÈýÖÖµÚÈý·½×é¼þ£ºjxl¡¢poi¡¢jacob¡£ ²»ÖªµÀÄÄÒ»ÖÖÄÜʵÏÖÏòExcelÎļþµÄÖ¸¶¨µ¥Ôª¸ñÖвåÈëÒ»¸öÎļþ(txt¼´¿É)¡£ÄǸö¶¼¿ÉÒÔ£¬ÄãÓÃÁ÷µÄÐÎʽ¶ÁÈ¡txt£¬È»ºó²åÈëµ½µ¥Ôª¸ñ¡£Óùýpoi ºÍ jxl . ¸Ð¾õjxlºÃÓúܶࡣ
°ÑËü¶Á³É×Ö·û´®É¶µÄ£¬·Å½øµ¥Ôª¸ñ¾ÍºÃÁË¡£
»¹¿ÉÒÔ°´Î¢ÈíµÄ¸ñʽд xml¾Í¿ÉÒÔÓÃexcel´ò¿ª¡£ÕâÑù¿ÉÒÔ½ÚÊ¡ÄÚ´æ¿Õ¼ä£¬ÉÙÉú³ÉºÜ¶àÀ࣬ÕâÈý¸öµ¹³ö·½°¸²»¼ÇµÃÄĸöºÃÏñÊÇ͵¿ªÏß³ÌÁË¡£
jExcel²»ÄÜʵÏÖ£¬ÕâÊÇËûµÄbug£¬¶øPOI¿ÉÒÔ£¡ÊÇapache´óµÄÒ»¸ö×ÓÏîÄ¿£¡
POIºÜºÃ£¬Ç°¶Îʱ¼ä¾ÍÓõ½ÁË£¬Â¥Ö÷ÐèÒª¿ÉÒÔÎÊÎÒÒª´úÂ룡
ÒýÓà ÄǸö¶¼¿ÉÒÔ£¬ÄãÓÃÁ÷µÄÐÎʽ¶ÁÈ¡txt£¬È»ºó²åÈëµ½µ¥Ôª¸ñ¡£Óùýpoi ºÍ jxl . ¸Ð¾õjxlºÃÓúܶࡣÎÒÊÇÒªÏòExcelÎļþÖвåÈëÒ»¸ötxtÎļþ¶ÔÏ󣬲»ÊǶÁÈ¡ÆäÖеÄÄÚÈÝдÈëExcelÖС£
²»Öª£¬ Õâλ´óÏÀÊÇ·ñûÓÐÀí½âÎÒÒâ˼
ÒýÓà °ÑËü¶Á³É×Ö·û´®É¶µÄ£¬·Å½øµ¥Ôª¸ñ¾ÍºÃÁË¡£ »¹¿ÉÒÔ°´Î¢ÈíµÄ¸ñʽд xml¾Í¿ÉÒÔÓÃexcel´ò¿ª¡£ÕâÑù¿ÉÒÔ½ÚÊ¡ÄÚ´æ¿Õ¼ä£¬ÉÙÉú³ÉºÜ¶àÀ࣬ÕâÈý¸öµ¹³ö·½°¸²»¼ÇµÃÄĸöºÃÏñÊÇ͵¿ªÏß³ÌÁË¡£°´Î¢ÈíµÄ¸ñʽд xml¾Í¿ÉÒÔÓÃexcel´ò¿ª
ÄܾßÌåµãÂ𣿠ÕâÊÇʲôÒâ˼£¿
ÒýÓà jExcel²»ÄÜʵÏÖ£¬ÕâÊÇËûµÄbug£¬¶øPOI¿ÉÒÔ£¡ÊÇapache´óµÄÒ»¸ö×ÓÏîÄ¿£¡
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö ±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910 Êä³ö20090901 20090910 È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value) ......
import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class QueryTest&n ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÒªÇóÊÇÊäÈëÒ»¸öÊý×Ö£¬È»ºó°´ÕÕÏÂÃæµÄ·½Ê½Êä³ö£¨Ë³Ê±ÕëÐýת£© ±ÈÈç ÊäÈë 2 ÔòÊä³öΪ 1 2 3 8 9 4 7 6 5 ÊäÈë 6 ÔòÊä³öΪ 1 2 3 4 5 6 20 21 22 23 24 7 19 32 33 34 25 8 18 31 36 ......