µ±Java³ÌÐò´´½¨Ò»¸öÀàµÄʵÀý»òÕßÊý×éʱ£¬¶¼ÔÚ¶ÑÖÐΪеĶÔÏó·ÖÅäÄÚ´æ¡£ÐéÄâ»úÖÐÖ»ÓÐÒ»¸ö¶Ñ£¬ËùÓеÄÏ̶߳¼¹²ÏíËü¡£
1¡¢À¬»øÊÕ¼¯£¨Garbage Collection£©
À¬»øÊÕ¼¯ÊÇÊÍ·ÅûÓб»ÒýÓõĶÔÏóµÄÖ÷Òª·½·¨¡£ËüÒ²¿ÉÄÜ»áΪÁ˼õÉٶѵÄË鯬£¬¶øÒƶ¯¶ÔÏó¡£ÔÚJavaÐéÄâ»úµÄ¹æ·¶ÖÐûÓÐÑϸñ¶¨ÒåÀ¬»øÊÕ¼¯£¬Ö»ÊǶ¨ÒåÒ»¸öJavaÐéÄâ»úµÄʵÏÖ±ØÐëͨ¹ýijÖÖ·½Ê½¹ÜÀí×Ô¼ºµÄ¶Ñ¡£ÏêÇé²Î¼ûµÚ¾ÅÕ“Garbage Collection”¡£
2¡¢¶ÔÏó´æ´¢½á¹¹£¨Object Representation£©
JavaÐéÄâ»úµÄ¹æ·¶ÖÐûÓж¨Òå¶ÔÏóÔõÑùÔÚ¶ÑÖд洢¡£Ã¿Ò»¸ö¶ÔÏóÖ÷Òª´æ´¢µÄÊÇËûµÄÀàºÍ¸¸ÀàÖж¨ÒåµÄ¶ÔÏó±äÁ¿¡£¶ÔÓÚ¸ø¶¨µÄ¶ÔÏóµÄÒýÓã¬ÐéÄâ»ú±ØÐëÄܺܿìµÄ ¶¨Î»µ½Õâ¸ö¶ÔÏóµÄÊý¾Ý¡£ÁíΪ£¬±ØÐëÌṩһÖÖͨ¹ý¶ÔÏóµÄÒýÓ÷½·¨¶ÔÏóÊý¾ÝµÄ·½·¨£¬±ÈÈç·½·¨ÇøÖеĶÔÏóµÄÒýÓã¬ËùÒÔÒ»¸ö¶ÔÏó±£´æµÄÊý¾ÝÖÐÍùÍùº¬ÓÐÒ»¸öijÖÖÐÎʽָÏò·½·¨ÇøµÄÖ¸Õë¡£
Ò»¸ö¿ÉÄܵĶѵÄÉè¼ÆÊǽ«¶Ñ·ÖΪÁ½¸ö²¿·Ö£ºÒýÓóغͶÔÏ󳨡£Ò»¸ö¶ÔÏóµÄÒýÓþÍÊÇÖ¸ÏòÒýÓóصı¾µØÖ¸Õ롣ÿһ¸öÒýÓóØÖеÄÌõÄ¿¶¼°üº¬Á½¸ö²¿·Ö£º ......
ʹÓÃWindows²Ù×÷ϵͳµÄÅóÓѶÔExcel£¨µç×Ó±í¸ñ£©Ò»¶¨²»»áİÉú£¬µ«ÊÇҪʹÓÃJavaÓïÑÔÀ´²Ù×ÝExcelÎļþ²¢²»ÊÇÒ»¼þÈÝÒ×µÄÊ¡£ÔÚWebÓ¦ÓÃÈÕÒæÊ¢ÐеĽñÌ죬ͨ¹ýWebÀ´²Ù×÷ExcelÎļþµÄÐèÇóÔ½À´Ô½Ç¿ÁÒ£¬Ä¿Ç°½ÏΪÁ÷ÐеIJÙ×÷ÊÇÔÚJSP»òServlet Öд´½¨Ò»¸öCSV £¨comma separated values£©Îļþ£¬²¢½«Õâ¸öÎļþÒÔMIME£¬text/csvÀàÐÍ·µ»Ø¸øä¯ÀÀÆ÷£¬½Ó×Åä¯ÀÀÆ÷µ÷ÓÃExcel²¢ÇÒÏÔʾCSVÎļþ¡£ÕâÑùÖ»ÊÇ˵¿ÉÒÔ·ÃÎʵ½ExcelÎļþ£¬µ«ÊÇ»¹²»ÄÜÕæÕýµÄ²Ù×ÝExcelÎļþ£¬±¾ÎĽ«¸ø´ó¼ÒÒ»¸ö¾ªÏ²£¬Ïò´ó¼Ò½éÉÜÒ»¸ö¿ª·ÅÔ´ÂëÏîÄ¿——Java Excel API£¬Ê¹ÓÃËü´ó¼Ò¾Í¿ÉÒÔ·½±ãµØ²Ù×ÝExcelÎļþÁË¡£
JAVA EXCEL API¼ò½é
Java ExcelÊÇÒ»¿ª·ÅÔ´ÂëÏîÄ¿£¬Í¨¹ýËüJava¿ª·¢ÈËÔ±¿ÉÒÔ¶ÁÈ¡ExcelÎļþµÄÄÚÈÝ¡¢´´½¨ÐµÄExcelÎļþ¡¢¸üÐÂÒѾ´æÔÚµÄExcelÎļþ¡£Ê¹ÓøÃAPI·ÇWindows²Ù×÷ϵͳҲ¿ÉÒÔͨ¹ý´¿JavaÓ¦ÓÃÀ´´¦ÀíExcelÊý¾Ý±í¡£ÒòΪÊÇʹÓÃJava±àдµÄ£¬ËùÒÔÎÒÃÇÔÚWebÓ¦ÓÃÖпÉÒÔͨ¹ýJSP¡¢ServletÀ´µ÷ÓÃAPIʵÏÖ¶ÔExcelÊý¾Ý±íµÄ·ÃÎÊ¡£
ÏÖÔÚ·¢²¼µÄÎȶ¨°æ±¾ÊÇV2.0£¬ÌṩÒÔϹ¦ÄÜ£º
· ´ÓExcel 95¡¢97¡¢2000µÈ¸ñʽµÄÎļþÖжÁÈ¡Êý¾Ý£»
· ¶ÁÈ¡Excel¹«Ê½£¨¿ÉÒÔ¶ÁÈ¡Excel 97ÒÔºóµÄ ......
ÔÚµ±½ñÕâ¸öʱ´ú,ÒªÏëÄܹ»ºÜºÃµÄÉú´æ,¾ÍµÃÓÐ×ã¹»µÃʵÁ¦,ÓÐÄܹ»¿¿µÄסµÄ¼¼Êõ,ÔÚ´óѧѧÁËÁ½Äê°ëµÄÈí¼þ¹¤³Ìרҵ,ÓÐÁ˺ܶàµÄÌå»á,ѧÁ˺ܶàûÓÐÓõĶ«Î÷,ÓÐһЩËäÈ»ÊǺÜÓÐÓÃ,µ±ÊÇÓÖ²»ÊÇÒ»Á½ÄêÄÚÄÜÓõÄÉϵÄ֪ʶ,ËùÒÔÎҾ͵Ã×Ôѧ,Ñ§Ê²Ã´ÄØ?ѧÓÐʹÓõö«Î÷,Äܹ»ÎªÈÕºóµÄ¹¤×÷ÓõÄÉϵÄ֪ʶ,Õâô³¤Ê±¼äµÄÌå»áºó,ÎÒ·¢ÏÖ»¹ÊÇJava±È½ÏµÄʵÓÃ,ÓкÜÉîµÄ·¢Õ¹.ÄÚÈݺܶà,ÏëѧºÃÒ²ÊǷdz£µÄÄÑ,µ«ÊǼÈÈ»ÎÒ×Ô¼ºÓÐÁËÕâ¸öÏë·¨,ÏëȥѧÕâ¸ö֪ʶ,ÎҾ͵Ŀ˷þÒ»ÇеÄÀ§ÄÑ,ÎÒҪΪÁ˽«À´,ΪÁËÎÒµÄÃ÷Ìì·Ü¶·.»¹ÊÇÄǾͻ°"ÏàÐÅ×Ô¼º,³äÂú¼¤Çé,ÓÂÓڷܶ·,×ßÇ¿ÎÒ֮·!".ÏàÐÅÃ÷Ìì»áÊÇÃÀºÃ¶ø²ÓÀõÄ! ......
Java 3DËäÈ»ÄÜÖ§³ÖÖÚ¶àµÄÍⲿ3DÄ£ÐÍÎļþ£¬µ«ÄÜÖ§³Ö±»Java 3DʹÓõÄÍⲿģÐÍÎļþ½öΪ.objºÍ.lwdÁ½ÖÖ£»·Ö±ð¶ÔÓ¦ObjectFileÀàºÍLw3dLoaderÀà¡£Ïà±È֮ϼ¸¿îÖ÷Á÷µÄ3D½¨Ä£Èí¼þ¶¼ÄÜÉú³É.obj¸ñʽµÄÎļþ£¬Òò´Ë±¾ÎÄÖ÷Òª½éÉÜʹÓÃObjectFileÀàÔØÈë.objÎļþµÄ·½·¨¡£
ObjectFileÀàÓÐÈý¸ö¹¹Ôì·½·¨£¬·Ö±ðΪ£º
ObjectFile()
ObjectFile(int flags)
ObjectFile(int flags, float radians)
ÆäÖÐflagsΪһ¸öÕûÐ͵ij£Á¿²ÎÊý£¬ÓÃÓÚ¾ö¶¨ÔØÈëµÄ3DÄ£ÐÍÒÔʲô·½Ê½Éú³É¡£
²ÎÊýradiansÓÃÓÚ¾ö¶¨ÔØÈëÄ£Ð͵ĿÉÏÔʾ°ë¾¶¡£
flags²ÎÊý¿ÉÔÚÒÔÏÂËĸöÖµÖ®¼äÈÎȡһ¸ö»òÕßÓÃÂß¼»ò£¨"|"£©½«¼¸¸ö²ÎÊý×éºÏʹÓá£
ObjectFile.RESIZE£ººöÂÔ±»ÔØÈëµÄÄ£ÐÍ´óС£¬Ö±½Ó°ÑÔØÈëµÄÄ£ÐÍ·ÅÔÚÒ»¸ö·¶Î§ÔÚ(1,1,1)µ½(-1,-1,-1)Ö®¼äµÄÁ¢·½Ìå¿Õ¼äÄÚ£¬²¢°Ñ×ø±êÔµãÉèΪ(0,0,0)¡£
ObjectFile.REVERSE£º·´×ªÔØÈëµÄÍⲿģÐÍ£¬¼´¿ÉÄÜ¿´Ä£Ð͵ĺóÃæ¡£
ObjectFile.TRIANGULATE£º½«Ä£Ð͵ÄÃæÒÔÈý½ÇÐη½Ê½ÏÔʾ£¬´Ë²ÎÊýÖ÷Òª±ãÓÚ¹Û²ìÄ£ÐͰ¼Í¹Ãæ¡£
ObjectFile.STRIPIFY£ºÒÔÄ£ÐÍÎļþÄÚÄ£Ð͵Äʵ¼ÊÇé¿öÏÔʾ£¬´Ë²ÎÊýÒ²ÊÇĬÈϲÎÊý¡£
µ±³õʼ»¯ÁËObjectFile¶ÔÏóºó¾Í¿ÉÒÔÓÃload·½·¨ÔØÈë.obj¸ñʽµÄÎļþ£¬Èç¹ûÄ£ÐÍÖÐÒѰüº¬ÁËÌùͼºÍ¹âÕյĻ°Ò²½«Ò»Æð ......
ÎÊÌâÃèÊö£º
´Óphp½çÃæinsertÊý¾Ýµ½mysql£¬Ö»ÄÜÊäÈëżÊý¸öºº×Ö²»ÄÜÊäÈëÆæÊý¸öºº×Ö£¬ÊäÈëÆæÊý¸öºº×ֺ󱨓Data too long for column ”´íÎ󣬲¢Ã»Óиü¸ÄÊý¾Ý¿âÊý¾Ý¡£µ½Êý¾Ý¿â²é¿´£¬·¢ÏÖºº×Ö¶¼ÊÇÂÒÂë¡£µ«ÊÇphp½çÃæÏÔʾºº×ÖÕý³££¨µ±È»ÏÔʾµÄ¶¼ÊÇżÊý¸öºº×Ö£¬ÆæÊý¸öºº×Ö¶¼Ã»ÓÐдÈëÊý¾Ý¿â£©¡£
½â¾ö˼·£º
1.¸ü¸Ämy.iniÎļþ£¬°Ñsql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”¸Ä³Ésql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”£¨¾ÍÊÇÈ¥µôSTRICT_TRANS_TABLES£©¡£ÖØÆômysql¡£
ÕâÑù×öµÄ½á¹ûÊÇ£¬²»»á±¨“Data too long for column ”£¬ÓÚÊÇÆæÊý¸öºº×Ö¾ÍÄÜ´æÈëÊý¾Ý¿â¡£µ«ÊÇphp½çÃæÏÔÊ¾ÆæÊý¸öºº×ֵĵط½³ö´í£¬¸ù¾Ý´íÎó¿ÉÒÔ·¢ÏÖÊǺº×Ö½âÎöʱ°Ñ²¿·Ö´úÂëÎóÈÏÒ»²¢½âÎöÁË£¬ËùÒÔphp½çÃæÏÔʾ²»Õý³£¡£Õâ˵Ã÷ÊǺº×Öת»»µÄ´íÎó(¶ÔÓÚºº×ÖUTF8ÔòÐèÒª3 Bytes¶øANSI/Unicode/UCS2±àÂë¶¼Ö»ÓÃ2 Bytes£¬´ËʱÊäÈ뺺×ֵĸöÊýΪ2¸öʱÊý¾Ý¿âÀïµÄÂÒÂëÊÇ3¸ö£¬ËµÃ÷1¸öÂÒÂëÊÇ2 Bytes£¬½âÎöµ½½çÃæÊ±Ã»ÓÐȱʧËùÒÔ¿ÉÒÔÕý³£ÏÔʾ£»¶øÊäÈ뺺×ֵĸöÊýΪ1¸öʱÊý¾Ý¿âÀïµÄÂÒÂëÊÇ1¸ö£¬ËµÃ÷±äÂÒÂëʱʧȥÁË1 Byte£¬½âÎöµ½½çÃæÊ±ÓÐȱʧËùÒ ......
ÎÊÌâÃèÊö£º
´Óphp½çÃæinsertÊý¾Ýµ½mysql£¬Ö»ÄÜÊäÈëżÊý¸öºº×Ö²»ÄÜÊäÈëÆæÊý¸öºº×Ö£¬ÊäÈëÆæÊý¸öºº×ֺ󱨓Data too long for column ”´íÎ󣬲¢Ã»Óиü¸ÄÊý¾Ý¿âÊý¾Ý¡£µ½Êý¾Ý¿â²é¿´£¬·¢ÏÖºº×Ö¶¼ÊÇÂÒÂë¡£µ«ÊÇphp½çÃæÏÔʾºº×ÖÕý³££¨µ±È»ÏÔʾµÄ¶¼ÊÇżÊý¸öºº×Ö£¬ÆæÊý¸öºº×Ö¶¼Ã»ÓÐдÈëÊý¾Ý¿â£©¡£
½â¾ö˼·£º
1.¸ü¸Ämy.iniÎļþ£¬°Ñsql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”¸Ä³Ésql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”£¨¾ÍÊÇÈ¥µôSTRICT_TRANS_TABLES£©¡£ÖØÆômysql¡£
ÕâÑù×öµÄ½á¹ûÊÇ£¬²»»á±¨“Data too long for column ”£¬ÓÚÊÇÆæÊý¸öºº×Ö¾ÍÄÜ´æÈëÊý¾Ý¿â¡£µ«ÊÇphp½çÃæÏÔÊ¾ÆæÊý¸öºº×ֵĵط½³ö´í£¬¸ù¾Ý´íÎó¿ÉÒÔ·¢ÏÖÊǺº×Ö½âÎöʱ°Ñ²¿·Ö´úÂëÎóÈÏÒ»²¢½âÎöÁË£¬ËùÒÔphp½çÃæÏÔʾ²»Õý³£¡£Õâ˵Ã÷ÊǺº×Öת»»µÄ´íÎó(¶ÔÓÚºº×ÖUTF8ÔòÐèÒª3 Bytes¶øANSI/Unicode/UCS2±àÂë¶¼Ö»ÓÃ2 Bytes£¬´ËʱÊäÈ뺺×ֵĸöÊýΪ2¸öʱÊý¾Ý¿âÀïµÄÂÒÂëÊÇ3¸ö£¬ËµÃ÷1¸öÂÒÂëÊÇ2 Bytes£¬½âÎöµ½½çÃæÊ±Ã»ÓÐȱʧËùÒÔ¿ÉÒÔÕý³£ÏÔʾ£»¶øÊäÈ뺺×ֵĸöÊýΪ1¸öʱÊý¾Ý¿âÀïµÄÂÒÂëÊÇ1¸ö£¬ËµÃ÷±äÂÒÂëʱʧȥÁË1 Byte£¬½âÎöµ½½çÃæÊ±ÓÐȱʧËùÒ ......
£¨1£©ÔÚÉè¼ÆÊý¾Ý¿â×ֶεÄʱºò£¬°ÑÐèÒª»ñÈ¡ÊÖ»úºÅµÄ×Ö¶ÎÉèÖÃΪint(11)£¬ÔÒâÊÇҪȡ11λÊýµÄ£¬½á¹û·¢ÏÖËùÓеÄÊÖ»úºÅÂ룬¶¼±ä³ÉÁË2147483647
£¬¶Ùʱ¾õµÃºÜÆæ¹Ö£¬ÒÔΪÊdzÌÐòÓÐÎÊÌ⣬×îºó·¢¾õÊÇÊý¾Ý¿âÉè¼ÆµÄÎÊÌâ¡£ÒòΪÓзûºÅÕûÊýµÄ×î´óֵΪ
2147483647£¬ËùÒÔ×îºó¾ö¶¨°ÑÊý¾Ý¿âµÄ½á¹¹±ä»¯Ï£¬°Ñint(11)±äΪchar(11)²Å¸ã¶¨¡£
£¨2£©Êý¾Ý¿âÖÐÓм¸¸ö×ֶεÄÖµ×ÜÊÇÓл»Ðзû´æÔÚ£¬Í¨¹ýphpmyadmin½øÐÐËÑË÷£¬½Ó×Åͨ¹ýupdate dbName set field = replace(field,"\n","")£¬Ìæ»»ÁË»»Ðзûºó£¬ÔÚ°ÑÊý¾Ýͨ¹ýCVSµ¼³öµÄʱºò£¬Êý¾ÝµÄÖµ»¹ÊÇ»»ÐÐÁË£¬°Ù˼²»µÃÆä½â¡£È»ºóÎÒÔÚ´òËãͨ¹ýsqlµ¼³ö²¿·ÖÊý¾Ý½øÐвâÊÔµÄʱºò£¬½á¹û·¢ÏÖÎÊÌâÁË£¬Òþ²ØµÄ»»ÐзûÊÇ\r£¬ËùÒÔµ±ÄãµÄ×Ö¶ÎÖµµÄ×îºóÒ»¸ö×Ö·ûÊÇ\rʱ£¬±ÈÈçÄãµÄfieldµÄÖµ¿´ÆðÀ´ÊÇ"abc"£¬£¬select * from dbName where field='abc'£¬Äã»á·¢¾õÔõôҲËÑË÷²»µ½£¬±ØÐëҪʹÓÃselect * from dbName where field like 'abc%'£¬²Å¿ÉÒÔÕÒµ½¡£Õâ¸öʱºòÄãÐèÒªÓÃ
update dbName set field = replace(field,"\r","")£¬È»ºóÄã¾Í¿ÉÒÔʹÓÃselect * from dbName where field='abc'ËÑË÷µ½ÏàÓ¦µÄ¼Ç¼ÁË¡£
......