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
Ïà¹ØÎĵµ£º
java.util Öеļ¯ºÏÀà°üº¬ Java ÖÐijЩ×î³£ÓõÄÀà¡£ ×î³£Óõļ¯ºÏÀàÊÇ List ºÍ Map¡£ List µÄ¾ßÌåʵÏÖ°üÀ¨ ArrayList ºÍ Vector£¬ËüÃÇÊǿɱä´óСµÄÁÐ±í£¬±È½ÏÊʺϹ¹½¨¡¢´æ´¢ºÍ²Ù×÷ÈκÎÀàÐͶÔÏóµÄÔªËØÁÐ±í¡£ List ÊÊÓÃÓÚ°´ÊýÖµË÷Òý·ÃÎÊÔªËØµÄÇéÐΡ£
Map ÌṩÁËÒ»¸ö¸üͨÓõÄÔªËØ´æ´¢·½·¨¡£ Map ¼¯ºÏÀàÓÃÓÚ´æ´¢ÔªËØ ......
ËùÓеijÌÐò¿ª·¢Êֲᶼ°üº¬Á˸÷ÖÖ¹æÔò¡£Ò»Ð©Ï°¹ß×ÔÓɳÌÐòÈËÔ±¿ÉÄܶÔÕâЩ¹æÔòºÜ²»ÊÊÓ¦£¬µ«ÊÇÔÚ¶à¸ö¿ª·¢ÈËÔ±¹²Í¬Ð´×÷µÄÇé¿öÏ£¬ÕâЩ¹æÔòÊDZØÐèµÄ¡£Õâ²»½ö½ö
ÊÇΪÁË¿ª·¢Ð§ÂÊÀ´¿¼ÂÇ£¬¶øÇÒÒ²ÊÇΪÁ˺óÆÚά»¤¿¼ÂÇ¡£
ÃüÃû¹æ·¶
¶¨ÒåÕâ¸ö¹æ·¶µÄÄ¿µÄÊÇÈÃÏîÄ¿ÖÐËùÓеÄÎĵµ¶¼¿´ÆðÀ´ÏñÒ»¸öÈËдµÄ£¬Ôö¼Ó¿É¶ÁÐÔ£¬¼õÉÙÏîÄ¿×éÖ ......
1¡¢ ¶ÔÏóµÄ³õʼ»¯
(1) ·Ç¾²Ì¬¶ÔÏóµÄ³õʼ»¯
ÔÚ´´½¨¶ÔÏóʱ£¬¶ÔÏóËùÔÚÀàµÄËùÓÐÊý¾Ý³ÉÔ±»áÊ×ÏȽøÐгõʼ»¯¡£
»ù±¾ÀàÐÍ£ºintÐÍ£¬³õʼ»¯Îª0¡£
Èç¹ûΪ¶ÔÏó£ºÕâЩ¶ÔÏó»á°´Ë³Ðò³õʼ»¯¡£
¡ùÔÚËùÓÐÀà³ÉÔ±³õʼ»¯Íê³ÉÖ®ºó£¬²Åµ÷Óñ¾ÀàµÄ¹¹Ôì·½·¨´´½¨¶ÔÏó¡£
¹¹Ôì·½·¨µÄ×÷ÓþÍÊdzõʼ»¯ ......
ÏàÐÅ´ó¼ÒƽʱÅöµ½¹ýһЩÔÚJAVAÖжÔͼÏñ½øÐд¦ÀíµÄÐèÇ󣬱ÈÈçÐèÒª¶ÔÉÏ´«µÄͼƬ¼ÓÉÏ×Ô¼ºµÄÇ©Ãû»òͼ±ê£¬»òÕßÉú³ÉºÍ½âÎö¶¯Ì¬µÄGIFͼƬ£¬ÒÔ¼°´¦ÀíPSDÎļþͼÏñÐÅÏ¢¡£±¾ÎľÍJAVAÔÚͼÏñ´¦ÀíÖÐһЩ»ù±¾Ó¦ÓýøÐÐÁ˽éÉÜ¡£Ï£Íûͨ¹ýÄܹ»¶Ô´ó¼ÒÔÚÒÔºóµÄͼÏñ´¦ÀíÖÐÓÐЩ°ïÖú¡£
Ò»¡¢¶ÔÒ»¸öÏÖÓеÄͼƬ½øÐÐÎ ......