java´¦Àí Excel(POI°ü)
×î½üÔÚÔÛÃÇÕâ¸öÂÛ̳Àï×ÜÄÜ¿´¼û´ó¼ÒÌá³öÓÃjava´¦ÀíExcelµÄÎÊÌ⣬ÓÐʱ»¹Éæ¼°µ½Í¼ÐεÄÎÊÌ⣬
´ó¼Ò¿´ÁËÕâÆªÎÄÕºó£¬ÎÒÏëÒ»¶¨»á½â¾ö²»ÉÙÈ˵ÄÎÊÌ⣡
¿´µ½ÍøÉϺܶàÎÄÕ¶¼Ò»Ö±¶¼ÊÇ˵POIµÄAPI²»ÄÜ´¦ÀíͼÐΣ¬Ò²¾ÍÊDz»ÄÜÍùExcelÀïÃæ¼ÓÈëͼÐΡ£
µ«ÊÂʵÉÏ£¬POI3.0³öÀ´Ö®ºó£¬Õâ¸öÎÊÌâÒѾ½â¾ö£¡ËùÒÔ˵£¬ÍùExcelÀïÃæ¼ÓÈëͼÐβ»±ØÒ»¶¨ÇóÖúÓÚJAVA EXCEL APIÁË¡£
×î½üÔÚһλ´ïÈËµÄÆô·¢Ï£¬ÖÕÓÚ½â¾öÁËÕâ¸öÎÊÌ⣬¾Í´Ë£¬Ð´ÏÂÕâЩ£¬Èç¹ûÓÐÈË¿´µ½µÄ»°£¬Ò²Ï£ÍûÄܶÔËûÓеã°ïÖú°É¡£
´úÂ룺
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
BufferedImage bufferImg = ImageIO.read(new File("D:\\fruit.PNG"));
ImageIO.write(bufferImg,"PNG",byteArrayOut);
HSSFClientAnchor anchor =
new HSSFClientAnchor(5,0,500,122,(short) 0, 5,(short)10,15);
HSSFPatriarch patri = sheet.createDrawingPatriarch();
patri.createPicture(anchor ,
wb.addPicture(byteArrayOut.toByteArray(),
HSSFWorkbook.PICTURE_TYPE_PNG));
ByteArrayOutputStream outStream = new ByteArrayOutputStream();
wb.write(outStream);
ÉÏÃæ´úÂëÖ»ÊÇ´ó¸Å£¬µ«ÐèÒªÓõ½µÄÀà¶¼ÒѾÁгö¡£½ÓÏÂÀ´ÐèÒª×öµÄ¾ÍÊÇ°Ñ outStreamÊä³öµ½excelÎļþÖÐÈ¥ÁË¡£
¾ßÌåµÄÀàµÄdocument¿ÉÒÔÈ¥ÏÂÃæÍøÕ¾Éϲ鿴:
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
Ïà¹ØÎĵµ£º
¸ÄÒ»¸öÕâÑùµÄÌâÄ¿Õýʽ¸æËßÄ㣬ÎÒÖÕÓÚ¶¯ÊּǼһЩjavaµÄ±Ê¼ÇÁË¡£ÊµÔںܾÃûÓÐдjavaÁË¡£¹þ¹þ£¬²»ºÃÒâ˼£¬ÎªÁËflash ºǫ́ÓиöÖ§³Ö£¬java Õⲿ·Ö»¹ÊÇҪѧһµã£¬µ«²»ÊǺÜÖØµãѧ¡£Õⲿ·Ö¶«Î÷£¬ÎÒ²»ÊìϤ£¬Ò²ÔÚÂýÂý¼Ç¼¡£×Ô¼º¿´µÄ±Ê¼Ç£¬ËùÒÔÒªÊÇÄã²»ÊÇɵB£¬×îºÃ²»Òª¿´¡£
ÔÚ½ñÍíÁ·Ï°µÄʱºò£¬³¢ÊÔÈ¥Á¬½Ó¿É°®µÄ ......
ͨ³£Í¨¹ýrequest.getRemoteAddr()
È¡µÃ¿Í»§¶ËµÄIPµØÖ·£¬×ö¼øÈ¨ºÍУÑ飬Â߼ûÎÊÌ⣬ÄÇô¿Ï¶¨request.getRemoteAddr()³öÁËÎÊÌ⣬googleÏ£¬·¢ÏÖÓÐÈËÓöµ½ÀàËÆµÄÎÊÌâ¡£
×îÖÕ¶¨Î»Îªrequest.getRemoteAddr()ÕâÖÖ·½·¨Ôڴ󲿷ÖÇé¿ö϶¼ÊÇÓÐЧµÄ¡£µ«ÊÇÔÚͨ¹ýÁËApache,SquidµÈ·´Ïò´úÀíÈí¼þ¾Í²»ÄÜ»ñÈ¡µ½¿Í»§¶ËµÄÕæÊµIPµØÖ·ÁË¡£
......
¶îÍâJAR°ü£º
org.springframework.expression-3.0.1.RELEASE.jar
org.springframework.asm-3.0.1.RELEASE.jar
org.springframework.beans-3.0.1.RELEASE.jar
p:statementCacheSize="100"
<bean id="masterDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close"
p:driverClass="com.m ......
ÔÚ·Ö²¼Ê½·þÎñ¿ò¼ÜÖУ¬Ò»¸ö×î»ù´¡µÄÎÊÌâ¾ÍÊÇÔ¶³Ì·þÎñÊÇÔõôͨѶµÄ£¬ÔÚJavaÁìÓòÖÐÓкܶà¿ÉʵÏÖÔ¶³ÌͨѶµÄ¼¼Êõ£¬ÀýÈ磺RMI¡¢MINA¡¢ESB¡¢Burlap¡¢Hessian¡¢SOAP¡¢EJBºÍJMSµÈ£¬ÕâЩÃû´ÊÖ®¼äµ½µ×ÊÇЩʲô¹ØÏµÄØ£¬ËüÃDZ³ºóµ½µ×ÊÇ»ùÓÚʲôÔÀíʵÏÖµÄÄØ£¬Á˽âÕâЩÊÇʵÏÖ·Ö²¼Ê½·þÎñ¿ò¼ÜµÄ»ù´¡ÖªÊ¶£¬¶øÈç¹ûÔÚÐÔÄÜÉÏÓиߵÄÒªÇóµÄ»°£¬ÄÇÉ ......
×÷ÕߣºÐûÕ×Åô
------------------------------------------------------------------------------------------------------------------------------------------
¹¤×÷µÚÒ»²½£ºÊìϤMyEclipseµÄ»·¾³ÒÔ¼°Ö÷Òª¹¦ÄÜ¡£
¹¤×÷µÚ¶þ²½£º½¨Á¢Êý¾Ý¿âÁ¬½Ó
Êý¾Ý¿â£ºMySQL
1¡¢MySQLµÄÅäÖÃÓëÎÊÌâ½â¾ö
Ïê¼ûÎ ......