Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÀûÓÃJAVA¶ÁÈ¡EXCELÎļþ


1 ´ÓExcelÎļþ¶ÁÈ¡Êý¾Ý±í
Java Excel API¼È¿ÉÒÔ´Ó±¾µØÎļþϵͳµÄÒ»¸öÎļþ(.xls)£¬Ò²¿ÉÒÔ´ÓÊäÈëÁ÷ÖжÁÈ¡ExcelÊý¾Ý±í¡£¶ÁÈ¡ExcelÊý¾Ý±íµÄµÚÒ»²½ÊÇ´´½¨Workbook(ÊõÓ¹¤×÷±¡)£¬ÏÂÃæµÄ´úÂëÆ¬¶Î¾ÙÀý˵Ã÷ÁËÓ¦¸ÃÈçºÎ²Ù×÷£º
import java.io.*;
import jxl.*;
try
{
//¹¹½¨Workbook¶ÔÏó, Ö»¶ÁWorkbook¶ÔÏó
    //Ö±½Ó´Ó±¾µØÎļþ´´½¨Workbook
//´ÓÊäÈëÁ÷´´½¨Workbook
    InputStream is = new FileInputStream(sourcefile);
    jxl.Workbook rwb = Workbook.getWorkbook(is);
}
catch (Exception e)
{
    e.printStackTrace();
}
Ò»µ©´´½¨ÁËWorkbook£¬ÎÒÃǾͿÉÒÔͨ¹ýËüÀ´·ÃÎÊExcel Sheet(ÊõÓ¹¤×÷±í)¡£
//»ñÈ¡µÚÒ»ÕÅSheet±í
Sheet rs = rwb.getSheet(0);
ÎÒÃǼȿÉÄÜͨ¹ýSheetµÄÃû³ÆÀ´·ÃÎÊËü£¬Ò²¿ÉÒÔͨ¹ýϱêÀ´·ÃÎÊËü¡£Èç¹ûͨ¹ýϱêÀ´·ÃÎʵϰ£¬Òª×¢ÒâµÄÒ»µãÊÇϱê´Ó0¿ªÊ¼£¬¾ÍÏñÊý×éÒ»Ñù¡£
Ò»µ©µÃµ½ÁËSheet£¬ÎÒÃǾͿÉÒÔͨ¹ýËüÀ´·ÃÎÊExcel Cell(ÊõÓµ¥Ôª¸ñ)¡£²Î¿¼ÏÂÃæµÄ´úÂëÆ¬¶Î£º//»ñÈ¡µÚÒ»ÐУ¬µÚÒ»ÁеÄÖµ,ÁкÅÔÚÇ°Ãæ,ÐкÅÔÚºóÃæ
Cell c00 = rs.getCell(0, 0);
String strc00 = c00.getContents();
//»ñÈ¡µÚÒ»ÐУ¬µÚ¶þÁеÄÖµ
Cell c10 = rs.getCell(1, 0);
String strc10 = c10.getContents();
//»ñÈ¡µÚ¶þÐУ¬µÚ¶þÁеÄÖµ
Cell c11 = rs.getCell(1, 1);
String strc11 = c11.getContents();
System.out.println("Cell(0, 0)" + " value : " + strc00 + "; type : " + c00.getType());
System.out.println("Cell(1, 0)" + " value : " + strc10 + "; type : " + c10.getType());
System.out.println("Cell(1, 1)" + " value : " + strc11 + "; type : " + c11.getType());
Èç¹û½ö½öÊÇÈ¡µÃCellµÄÖµ£¬ÎÒÃÇ¿ÉÒÔ·½±ãµØÍ¨¹ýgetContents()·½·¨£¬Ëü¿ÉÒÔ½«ÈκÎÀàÐ͵ÄCellÖµ¶¼×÷Ϊһ¸ö×Ö·û´®·µ»Ø¡£Ê¾Àý´úÂëÖÐCell(0, 0)ÊÇÎı¾ÐÍ£¬Cell(1, 0)ÊÇÊý×ÖÐÍ£¬Cell(1,1)ÊÇÈÕÆÚÐÍ£¬Í¨¹ýgetContents()£¬ÈýÖÖÀàÐ͵ķµ»ØÖµ¶¼ÊÇ×Ö·ûÐÍ¡£
Èç¹ûÓÐÐèÒªÖªµÀCellÄÚÈݵÄÈ·ÇÐÀàÐÍ£¬APIÒ²ÌṩÁËһϵÁеķ½·¨¡£²Î¿¼ÏÂÃæµÄ´úÂëÆ¬¶Î£ºString strc00 = null;
double strc10 = 0.00;
Date strc11 = null;
Cell c00 = rs.getCell(0, 0);
Cell c10 = rs.getCell(1, 0);
Cell c11 = rs.getCell(1, 1);
if(c00.getType() == CellType.LABEL)
{
LabelCell labelc00 = (LabelCell)c00;
str


Ïà¹ØÎĵµ£º

ÓÃJavaʵÏÖFTP·þÎñÆ÷

FTP(File Transfer Protocol Îļþ´«ÊäЭÒé)ÊÇInternet ÉÏÓÃÀ´´«ËÍÎļþµÄЭÒé¡£ÔÚInternetÉÏͨ¹ýFTP ·þÎñÆ÷¿ÉÒÔ½øÐÐÎļþµÄÉÏ´«(Upload)»òÏÂÔØ(Download)¡£FTPÊÇʵʱÁª»ú·þÎñ£¬ÔÚʹÓÃËü֮ǰ±ØÐëÊǾßÓи÷þÎñµÄÒ»¸öÓû§(Óû§ÃûºÍ¿ÚÁî)£¬¹¤×÷ʱ¿Í»§¶Ë±ØÐëÏȵǼµ½×÷Ϊ·þÎñÆ÷Ò»·½µÄ¼ÆËã»úÉÏ£¬Óû§µÇ¼ºó¿ÉÒÔ½øÐÐÎļþËÑË÷ºÍÎļþ´« ......

javaѧϰ±Ê¼Çstruts action³õʼ»¯Ê±¼äºÍ´ÎÊý

´ó¼Ò¶¼ÖªµÀ actionÅäÖÃÔÚstruts-config.xmlÖУ¬¶østruts-config.xmlÊÇÔÚtomcatÆô¶¯Ê±¶ÁÈ¡µÄÄÇactionÊDz»ÊÇÔÚÕâ¸öʱºò³õʼ»¯µÄ
ÎÒÃÇ¿ÉÒÔÔÚactionÀàÀï½øÐвâÊÔ ÔÚ¹¹Ô캯ÊýÀï´òÓ¡Ò»¾ä»° ¾­²âÊÔactionÊÇÔÚµ÷ÓÃactionʱ³õʼ»¯£¬²¢ÇÒ¶à´Îµ÷ÓÃÖ»³õʼ»¯Ò»´Î£¬
ÕâÒ²¾ÍÊÇËùÓеÄÇëÇó¹²ÏíactionʵÀý
ËùÒÔactionÊÇÏ̲߳»°²È«µÄ£¬ ......

Java web ѧϰ±Ê¼Ç

 
---09 11 29---
Servlet&ServletÈÝÆ÷:
Java Servlet(Java·þÎñÆ÷С³ÌÐò)ÊÇÒ»¸ö»ùÓÚJava¼¼ÊõµÄС³ÌÐò,
ÔËÐÐÔÚ·þÎñÆ÷¶Ë,ÓÉServletÈÝÆ÷Ëù¹ÜÀí,ÓÃÓÚÉú³É¶¯Ì¬µÄÄÚÈÝ.
ServletÊÇÆ½Ì¨¶ÀÁ¢µÄJavaÀà,ËùÒÔ±àдһ¸öServletʵ¼ÊÉϾÍÊǰ´
ÕÕservlet¹æ·¶±àдһ¸öJavaÀà.
ServletÈÝÆ÷Ò²½Ð×öServletÒýÇæ,ÊÇweb·þÎñÆ÷»òÓ¦Óà ......

javaÒì³£´¦Àí»úÖÆ

ת×Ôhttp://hi.baidu.com/oyamao/blog/item/bcc75d5128468868843524eb.html
Òì³£´¦ÀíÊdzÌÐòÉè¼ÆÖÐÒ»¸ö·Ç³£ÖØÒªµÄ·½Ã棬ҲÊdzÌÐòÉè¼ÆµÄÒ»´óÄѵ㣬´ÓC¿ªÊ¼£¬ÄãÒ²ÐíÒѾ­ÖªµÀÈçºÎÓÃif...else...À´¿ØÖÆÒì³£ÁË£¬Ò²ÐíÊÇ×Ô·¢µÄ£¬È»¶øÕâÖÖ¿ØÖÆÒ쳣ʹ¿à£¬Í¬Ò»¸öÒì³£»òÕß´íÎóÈç¹û¶à¸öµØ·½³öÏÖ£¬ÄÇôÄãÿ¸öµØ·½¶¼Òª×öÏàͬ´¦Àí£¬¸Ð¾õÏൠ......

Java»ñÈ¡ÇëÇó¿Í»§¶ËµÄÕæÊµIPµØÖ·

 ÔÚJSPÀ»ñÈ¡¿Í»§¶ËµÄIPµØÖ·µÄ·½·¨ÊÇ£ºrequest.getRemoteAddr()£¬ÕâÖÖ·½·¨Ôڴ󲿷ÖÇé¿ö϶¼ÊÇÓÐЧµÄ¡£µ«ÊÇÔÚͨ¹ýÁËApache,SquidµÈ·´Ïò´úÀíÈí¼þ¾Í²»ÄÜ»ñÈ¡µ½¿Í»§¶ËµÄÕæÊµIPµØÖ·ÁË¡£
Èç¹ûʹÓÃÁË·´Ïò´úÀíÈí¼þ£¬½«http://192.168.1.110:2046/ µÄURL·´Ïò´úÀíΪhttp://www.xxx.com/ µÄURLʱ£¬ÓÃrequest.getRemoteAddr()·½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ