java±¨±íJXLºÍPOI´òÓ¡ÉèÖÃ
JXLµÄ´òÓ¡ÉèÖÃÔÚjxl.SheetSettingsÕâ¸öÀàÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ý·½·¨Sheet£¨»òÕßWritableSheet£©#getSettings()»ñÈ¡¡£
1.Ò³Ãæ
1.1·½Ïò
SheetSetting#setOrientation(PageOrientation po)£»
²ÎÊý£º PageOrientation#LANDSCAPE ºáÏò´òÓ¡
PageOrientation# PORTRAIT ×ÝÏò´òÓ¡
1.2Ëõ·Å
1.2.1Ëõ·Å±ÈÀý(A) SheetSetting #setScaleFactor (int);°Ù·Ö±ÈÐÎʽ
1.2.2µ÷Õû(F)
Ò³¿í SheetSetting #setFitWidth(int);
Ò³¸ß SheetSetting #setFitHeight(int);
1.3Ö½ÕÅ´óС(Z) SheetSetting #setPaperSize (PaperSize);
Ö½ÕÅ´óСµÄ¶¨Òå˵Ã÷²Î¼ûPaperSizeÀàÖеij£Á¿¡£
1.4ÆðʼҳÂë(R) SheetSetting #setPageStrart(int);[ĬÈÏ״̬]
2Ò³Ãæ¾à
2.1ÉÏ(T) SheetSetting # setTopMargin (double);
2.2ÏÂ(B) SheetSetting # setBottomMargin (double);
2.3×ó(L) SheetSetting # setLeftMargin (double);
2.4ÓÒ(R) SheetSetting # setRightMargin (double);
2.5ҳü(A) SheetSetting #setHeaderMargin(double);
2.6Ò³½Å(F) SheetSetting #setFooterMargin(double);
2.7¾ÓÖз½Ê½
2.7.1ˮƽ(Z) SheetSetting # setHorizontalCentre (boolean);
2.7.2´¹Ö±(V) SheetSetting #setVerticallyCenter(boolean);
3ҳü/Ò³½Å
3.1ҳüSheetSetting # setHeader£¨HeaderFooter£©;
˵Ã÷:
¶ÔÓÚHeaderFooterµÄÉèÖã¬Ê×ÏÈÈ·¶¨Ò³Ã¼µÄλÖã¨×ó¡¢ÖС¢ÓÒ£©£¬Í¨¹ýHeaderFooter#getCentre()£¨»òÕßgetLeft()¡¢getRight()£©·½·¨»ñÈ¡HeaderFooter.ContentsÀ֮࣬ºó¶ÔÕâ¸öÀàµÄÊôÐÔ½øÐвÙ×÷¡£
ÏÂÃæ¼òµ¥½éÉܼ¸¸ö³£Ó÷½·¨£º
ÉèÖÃ×ֺţºContents#setFontSize(int)
ÉèÖÃ×ÖÌ壺Contents#setFontName(String)
ÉèÖÃÄÚÈÝ£ºContents# append£¨String£©£¬»¹ÓÐappendDate()µ±Ç°ÈÕÆÚµÈµÈ£¬¾ßÌå²Î¿¼ContentsÀà˵Ã÷
3.2Ò³½ÅSheetSetting # setFooter£¨HeaderFooter£©£»
˵Ã÷ͬÉÏ
4¹¤×÷±í
4.1´òÓ¡ÇøÓò
SheetSettings #setPrintArea(firstCol, firstRow, lastCol, lastRow)
4.2´òÓ¡±êÌâ
SheetSettings#setPrintTitles (
Ïà¹ØÎĵµ£º
ÉùÃ÷£º
ÒÔϵÄÀý×Ó²»Ò»¶¨ÕýÈ·£¬Ö»ÊÇΪÁËÑÝʾ´ó¸ÅµÄÁ÷³Ì¡£
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´ ......
ÓÐÁ½ÖÖ·½·¨£º
·½·¨Ò»£ºÓÃjava.util.DateÀàÀ´ÊµÏÖ£¬²¢½áºÏjava.text.DateFormatÀàÀ´ÊµÏÖʱ¼äµÄ¸ñʽ»¯£¬¿´ÏÂÃæ´úÂ룺
import java.util.*;
import java.text.*;
//ÒÔÏÂĬÈÏʱ¼äÈÕÆÚÏÔʾ·½Ê½¶¼ÊǺºÓïÓïÑÔ·½Ê½
//Ò»°ãÓïÑÔ¾ÍĬÈϺºÓï¾Í¿ÉÒÔÁË£¬Ê±¼äÈÕÆÚµÄ¸ñʽĬÈÏΪMEDIUM·ç¸ñ£¬±ÈÈ磺2008-6-16 20:54:53
//ÒÔÏÂÏÔʾµÄÈ ......
package fileIo;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
public&nb ......
Observer
Intent
Define a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and updated automatically.
How to
Subject
knows its observers. Any number of Observer objects may observe a subject.
provides an in ......
¹¤×÷ÒѾÓаëÄêÁË£¬Í»È»Ïëдµã¶«Î÷£¬´óѧµÄʱºò¾ÍÓÐдÈռǵÄϰ¹ß£¬µ«ÊÇ×Ô´ÓÈ¥Java06°àѧϰһֱµ½ÏÖÔÚ¹¤×÷£¬ÂýÂýµÄҲûÓÐʱ¼äȥдÈռǣ¬Ï£Íûͨ¹ýÕâÆªÎÄÕÂÄÜÈÃJava˽ÛÓµÄѧµÜѧÃÃÃÇ¿´ÁËÓÐËù°ïÖú¡£
ÏàÐźܶàͬѧºÜÎÒÒ»Ñù´óËĵÄʱºò¶¼±È½ÏÃÔ㣬ÓÈÆäÊÇÎÒ¶ÁµÄ¼ÆËã»úרҵ£¬ËµÊµ»°´óѧÀïѧµÄºÍÉç»áʵ¼ÊÐèÒªµÄ» ......