java µ¼³öÊý¾Ýµ½excel Ö® WritableWorkbook
ËùÐèjarÎļþΪ jxl.jar ¿ÉÒÔÔÚ´Ë»ñÈ¡£º http://www.uushare.com/user/sudyguo/files/2209594
ÕâÖÖ·½·¨µ¼ÈëexcelЧÂʽϸߣ¬¿ÉÅúÁ¿µ¼³ö£» ¸ü¶à¸üÏêϸµÄÓ÷¨£¬¿ÉÒÔ¿´£º http://pcedu.pconline.com.cn/empolder/gj/java/0608/853669_1.html
ʵÀý£º
´Ë¶Î´úÂëÓÃÓÚÉú³ÉexcelÎļþ
*/
WritableWorkbook book= Workbook.createWorkbook(new File(application.getRealPath("/")+"price.xls"));
//Éú³ÉÃûΪ"µÚÒ»Ò³"µÄ¹¤×÷±í£¬²ÎÊý0±íʾÕâÊǵÚÒ»Ò³
WritableSheet sheet=book.createSheet("µÚÒ»Ò³",0);
//ÔÚLabel¶ÔÏóµÄ¹¹Ôì×ÓÖÐÖ¸Ãûµ¥Ôª¸ñλÖÃÊǵÚÒ»ÁеÚÒ»ÐÐ(0,0)
WritableFont font1= new WritableFont(WritableFont.TIMES,14,WritableFont.BOLD);
WritableCellFormat format1=new WritableCellFormat(font1);
format1.setAlignment(jxl.format.Alignment.CENTRE);//ÉèÖÃΪ¾ÓÖÐ
sheet.setColumnView(1,20);//ÉèÖõÚ1Áпí¶È£¬6cm×óÓÒ
sheet.mergeCells(0,0,7,0);
Label label=new Label(0,0,"ͳ¼Æ±¨±í",format1);
//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
sheet.addCell(label);
//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
WritableFont font2=new WritableFont(WritableFont.createFont("¿¬Ìå_GB2312"),10,WritableFont.NO_BOLD );
WritableCellFormat format2=new WritableCellFormat(font2);
format2.setAlignment(jxl.format.Alignment.CENTRE);//ÉèÖÃΪ¾ÓÖÐ
//ÉèÖñ߿ò
format2.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.NONE);
label=new Label(0,2,"񅧏",format2);
sheet.addCell(label);
label=new Label(1,2,"²É¼¯ÈÕÆÚ",format2);
sheet.addCell(label);
label=new Label(2,2,"²É¼¯µã",format2);
sheet.addCell(label);
label=new Label(3,2,"Æ·ÖÖ",format2);
sheet.addCell(label);
label=new Label(4,2,"ÖÖÀà",format2);
sheet.addCell(label);
label=new Label(5,2,"Æ·ÖÖ˵Ã÷",format2);
sheet.addCell(label);
label=new Label(6,2,"×î¸ß¼Û",format2);
sheet.addCell(label);
label=new Label(7,2,"×îµÍ¼Û",format2);
sheet.addCell(label);
label=new Label(8,2,"ƽ¾ù¼Û",format2);
sheet.addCell(label);
label=new Label(9,2,"״̬",format2);
sheet.addCell(label);
Ïà¹ØÎĵµ£º
ÔËÐÐÓ¦ÓóÌÐòÓëÔËÐÐweb³ÌÐòÔÀíÊÇÒ»Öµģ¬Ö»²»¹ýwebÓ¦ÓóÌÐòÒѾÔÚÆô¶¯Ê±½«³ÌÐòÔËÓõÄjar°üÉèÖõ½»·¾³±äÁ¿ÀӦÓóÌÐò¿ÉÒÔ×Ô¼ºÐ´¸öÅú´¦ÀíÀ´ÉèÖû·¾³±äÁ¿£º
java -classpath ./lib/application.jar;./lib/hibernate3.jar -Xms608m -Xmx608m com.zyj.application.StartUp
pause/exit
ÆäÖÐapplication.jarΪӦÓóÌÐòµÄjar° ......
1.1 ²»ÓÃnew¹Ø¼ü´Ê´´½¨ÀàµÄʵÀý
ÓÃnew¹Ø¼ü´Ê´´½¨ÀàµÄʵÀýʱ£¬¹¹Ô캯ÊýÁ´ÖеÄËùÓй¹Ô캯Êý¶¼»á±»×Ô¶¯µ÷Óᣵ«Èç¹ûÒ»¸ö¶ÔÏóʵÏÖÁËCloneable½Ó¿Ú£¬ÎÒÃÇ¿ÉÒÔµ÷ÓÃËüµÄclone()·½·¨¡£clone()·½·¨²»»áµ÷ÓÃÈκÎÀ๹Ô캯Êý¡£
ÔÚʹÓÃÉè¼ÆÄ£Ê½£¨Design Pattern£©µÄ³¡ºÏ£¬Èç¹ûÓÃFactoryģʽ´´½¨¶ÔÏó£¬Ôò¸ÄÓÃclone()·½·¨´´½¨Ðµ ......
½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
¹Ø¼ü×ÖÓֳƱ£Áô×Ö£¬ÊÇ Java ÓïÑԹ涨ÁËÌØ¶¨º¬ÒåµÄ±êʶ·û¡£Óû§Ö»Äܰ´ÕÕϵͳ¹æ¶¨µÄ·½Ê½Ê¹Ó㬲»ÄÜ×ÔÐж¨Òå¡£¹Ø¼ü×ÖÒ»ÂÉÓÃСд×Öĸ±íʾ¡£Java ÖеĹؼü×ÖÓÐ 50 ¸ö£¬°´ÓÃ;»®·ÖΪ£ºÊý¾ÝÀàÐÍ¡¢Óï¾ä¡¢ÐÞÊΡ¢·½·¨¡¢Àà¡¢ ......
¶¨Òå°´Öµ´«µÝºÍ°´ÒýÓô«µÝÕâÁ½¸öÊõÓïÊÇÖØÒªµÄ¡£
°´Öµ´«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊDzÎÊýµÄÒ»¸ö¸±±¾¡£Òò´Ë£¬Èç ¹ûº¯ÊýÐÞ¸ÄÁ˸òÎÊý£¬½ö¸Ä±ä¸±±¾£¬¶øÔʼֵ±£³Ö²»±ä¡£°´ÒýÓô«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊDzÎÊýµÄÄÚ´æµØÖ·£¬¶ø²»ÊDzÎÊýµÄ¸±±¾¡£Òò ´Ë£¬Èç¹ûº¯ÊýÐÞ¸ÄÁ˸òÎÊý£¬µ÷ ......
×î½ü²Î¼ÓÁ˼¸´ÎÃæÊÔ£¬·¢ÏÖ¹«Ë¾µÄ±ÊÊÔÌâÄ¿ÓÐһЩÏàËÆÖ®´¦£¬¾Í×ܽáһϣº
Ò»°ã»á´ÓÏÂÃæ¼¸¸ö·½Ã濼£¬²»¹ÜÊÇÃæÊÔC++,C#,java¶¼ÊÇ
Ê×ÏÈÊǹØÓڹؼü×ֺͱêʾ³£Á¿µÄ¿¼²ì
È»ºóÊǹØÓÚÀàºÍ½Ó¿ÚµÄÊÔÌâ
È»ºóÊǹØÓÚarray,ioºÍsocketµÄÊÔÌâ
È»ºóÊǹØÓÚÊý¾Ý¿âµÄ¸÷ÖÖsqlÓï¾äµÄ¿¼²ì
È»ºóÊÇÅÅÐò£¬°üÀ¨¿ìËÙÅÅÐò£¬²åÈëÅÅÐò£ ......