Java´úÂëÉú³ÉºÍ½âÎöxlsÎļþ
ʹÓÃpoiÀ´Éú³ÉxlsÎļþ£ºÒýÓõİüpoi-3.2.final.jar;
ÒªÁ˽âµÄÀàHSSFWorkbook,HSSFSheet,HSSFRow,HSSFCell
HSSFWorkbook workbook=new HSSFWorkbook();µÃµ½Ò»¸öExcelÎļþµÄÒýÓÃ
HSSFSheet sheet=workbook.createSheet();µÃµ½Ò»¸ösheet,»¹ÓÐHSSFSheet sheet=workbook.createSheet("sheet1");·½·¨¿ÉÒÔÉèÖÃSheetµÄÃû³Æ¡£
È»ºóÎÒÃÇ¿ÉÒԵõ½Ò»ÐÐHSSFRow row=sheet.createRow(rowNum);
×îºóÎÒÃÇ¿ÉÒԵõ½µÄÊÇHSSFCell cell=row.create(cellNum);ÔÚCellÖл¹ÓÐÒ»¸öÀàÐ͵ÄÎÊÌ⣬һ¶¨Òª×¢Òâ
ÏÂÃæÊÇÒ»¸ö´ÓÊý¾Ý¿âÀïÃæ¶ÁÈ¡Êý¾ÝÉú³ÉÎļþµÄ·½·¨
public void testQuery() {
Transaction tx = null;
tx = session.beginTransaction();
Query query = session.createQuery("from Tid");
List<Tid> list = query.list();
tx.commit();
int k = 0;
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("sheet1");
HSSFRow row = sheet.createRow(k);
k++;
//µÃµ½Ò»¸öHSSFCell¶ÔÏó
HSSFCell cell1 = row.createCell(0);
//Ê×ÏÈÒªÉèÖÃHSSFCellµÄÀàÐÍ£¬Ò»¹²ÓÐÎåÖÖCELL_TYPE_STRING,CELL_TYPE_NUMBERIC,CELL_TYPE_FORMULA,
//CELL_TYPE_BLANK,CELL_TYPE_BOOLEAN,CELL_TYPE_ERROR,¹²6ÖÖ
//¾ßÌå¿ÉÒԲ鿴Îĵµhttp://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html#getCellType()
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell1.setCellValue((new HSSFRichTextString("MER_NUM")));
HSSFCell cell2 = row.createCell(1);
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell2.setCellValue(new HSSFRichTextString("TML_NUM"));
HSSFCell cell3 = row.createCell(2);
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell3.setCellValue(new HSSFRichTextString("COUNTER_NUM"));
for (Iterator<Tid> it = list.iterator(); it.hasNext();) {
Tid tid = (Tid) it.next();
&nbs
Ïà¹ØÎĵµ£º
×î½ü²Î¼ÓÁ˼¸´ÎÃæÊÔ£¬·¢ÏÖ¹«Ë¾µÄ±ÊÊÔÌâÄ¿ÓÐһЩÏàËÆÖ®´¦£¬¾Í×ܽáһϣº
Ò»°ã»á´ÓÏÂÃæ¼¸¸ö·½Ã濼£¬²»¹ÜÊÇÃæÊÔC++,C#,java¶¼ÊÇ
Ê×ÏÈÊǹØÓڹؼü×ֺͱêʾ³£Á¿µÄ¿¼²ì
È»ºóÊǹØÓÚÀàºÍ½Ó¿ÚµÄÊÔÌâ
È»ºóÊǹØÓÚarray,ioºÍsocketµÄÊÔÌâ
È»ºóÊǹØÓÚÊý¾Ý¿âµÄ¸÷ÖÖsqlÓï¾äµÄ¿¼²ì
È»ºóÊÇÅÅÐò£¬°üÀ¨¿ìËÙÅÅÐò£¬²åÈëÅÅÐò£ ......
ËùÐè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Îļþ
*/
WritableWor ......
1£®ÈçºÎѧϰ³ÌÐòÉè¼Æ£¿
JAVAÊÇÒ»ÖÖÆ½Ì¨£¬Ò²ÊÇÒ»ÖÖ³ÌÐòÉè¼ÆÓïÑÔ£¬ÈçºÎѧºÃ³ÌÐòÉè¼Æ²»½ö½öÊÊÓÃÓÚJAVA£¬¶ÔC++µÈÆäËû³ÌÐòÉè¼ÆÓïÑÔÒ²Ò»Ñù¹ÜÓá£Óбà³Ì¸ßÊÖÈÏ
Ϊ£¬JAVAÒ²ºÃCÒ²ºÃûʲô·Ö±ð£¬ÄÃÀ´¾ÍÓá£ÎªÊ²Ã´ËûÃÇÄÜ´ïµ½Èç´Ë¾³½ç£¿ÎÒÏëÊÇÒòΪ±à³ÌÓïÑÔÖ®¼äÓй²Í¨Ö®´¦£¬Áì»áÁ˱à³ÌµÄ¾«Ë裬×ÔÈ»Äܹ»×öµ½Ò»Í¨°Ùͨ¡£
鍼 ......
×î½üÓиöÏîĿҪ²¿Êðµ½linuxÉÏ£¬ÔÚÍøÉϲéÁËЩ×ÊÁÏ£¬¼ÇϵãÓöµ½µÄÎÊÌ⣬ÒԱ㽫À´ÔÙÓá£
Ò»£ºjdk°²×°
1.ͨ¹ýchmod a+x jdk-1_5_x-rc-linux-i586-rpm.binÃüÁîʹÆä»ñµÃ¿ÉÖ´ÐÐȨÏÞ
2.ͨ¹ý rpm –ivh jdk-1_5_x-rc-linux-i586-rpm.binÀ´½øÐа²×°
3.°²×°Íê±Ï,JDK°²×°ÔÚ/usr/java/Ŀ¼ÏÂ
4.ÉèÖû·¾³±äÁ¿(дÈëvi/etc/ ......
J2ME£¬ÏÖ³ÆÎªJava ME(Java Platform, Micro Edition )ÊÇΪ»ú¶¥ºÐ¡¢Òƶ¯µç»°ºÍPDAÖ®ÀàǶÈëʽÏû·Ñµç×ÓÉ豸ÌṩµÄJavaÓïÑÔÆ½Ì¨£¬°üÀ¨ÐéÄâ»úºÍһϵÁбê×¼»¯µÄJava API¡£ËüºÍJava SE¡¢Java EEÒ»Æð¹¹³ÉJava¼¼ÊõµÄÈý´ó°æ±¾£¬²¢ÇÒͬÑùÊÇͨ¹ýJCP£¨Java Community Process£©Öƶ©µÄ¡£
Ŀǰ½×¶Î£¬Java ME×îÁ÷ÐеÄÓ¦ÓÃÊÇÓÎÏ·Èí¼þ¡£ÒòÎ ......