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

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ÈëÃÅ

 Javaѧϰ´ÓÈëÃŵ½¾«Í¨ 
Ò»¡¢ JDK (Java Development Kit) 
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......

JAVAÃæÊÔÒ»

 ÏÂÒÔjavaΪÀý×Ó˵Ã÷һЩ×Ô¼ºÓöµ½µÄ£º
·ÃÎÊ¿ØÖÆ:
private ˽ÓеÄ
protected Êܱ£»¤µÄ
public ¹«¹²µÄ
Àà¡¢·½·¨ºÍ±äÁ¿ÐÞÊηû
abstract ÉùÃ÷³éÏó
class Àà
extends À©ÔÊ,¼Ì³Ð
final ÖÕ¼«,²»¿É¸Ä±äµÄ
implementsʵÏÖ
interface ½Ó¿Ú
native ±¾µØ
new ÐÂ,´´½¨
static ¾²Ì¬ 
strictfp Ñϸñ,¾«×¼
synchr ......

JavaÍøÂçÁÄÌì·þÎñÆ÷¶Ë

//JavaÍøÂçÁÄÌì·þÎñÆ÷
import java.io.*;
import java.awt.*;
import java.net.*;
import java.util.*;
import java.awt.event.*;
public class ServerFrame extends Frame implements ActionListener{
int ScreenWidth,ScreenHeight;
Button CloseServer;
TextArea ServerStatus;
ServerThread ......

javaÖÐʹÓÃÕýÔò±í´ïʽ

 ×ª×Ô£ºhttp://student.csdn.net/space.php?uid=52781&do=blog&id=15267&cid=50252
javaÖÐʹÓÃÕýÔò±í´ïʽ
¼ÆËã»úרҵ±ÏÒµ»òÕßʹÓùýUnix¡¢PerlµÈ²úÆ·µÄ¶ÁÕßÒ»¶¨¶ÔÕýÔò±í´ïʽÓÐÒ»¶¨µÄÓ¡Ïó,¼´Ê¹Ã»ÓнӴ¥¹ýÕýÔò±í´ïʽҲ²»Òª±»ËüµÄÍâòËùÏŵ¹¡£ËäÈ»×öµ½¾«Í¨ÕýÔò±í´ïʽ±È½ÏÄÑ£¬µ«ÊÇÄܹ»ÕÆÎÕËüµÄ»ù±¾Ó¦ÓÃÈ´ÊÇ· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ