³]­p¨Ï¥Î­ì¥Í XML ÅX°Êµ{¦¡ªº³øªí

­ì¥Í XML ÅX°Êµ{¦¡Á`Äý

ª`·N:    ¥Ø«e­ì¥Í XML ÅX°Êµ{¦¡¥u´£¨Ñ­^¤å¡Bªk¤å¡B¼w¤å©M¤é¤åªºª©¥»¡C¦p»Ý¦³Ãö¨ä¥L»y¨¥ª©¥»ªº¸ê°T¡A½Ð³y³X¡u¶}µo¤H­û°Ï°ì¡v¡Aºô§}¬°¡Ghttp://www.businessobjects.com/ipl/default.asp?destination=developerzone&language=EN&product=CRJavaProducts&edition=Professional&version=10.0&Partner=IBM

Crystal ²£«~ªº­ì¥Í XML ÅX°Êµ{¦¡·|Ū¨ú XML ¸ê®Æ¬y¡A¨Ã®Ú¾Ú¹ïÀ³ªºµ²ºc´y­z (XSD) ­åªR¨ä¤º®e¡A¥H­l¥Í¸ê®Æªº¶¥¼h¸ê®Æªíªí¥Üªk¡C·í±z«Ø¥ß³øªí®É¡ACrystal Reports «K·|¨Ï¥Î³o­Ó¶¥¼h¸ê®Æªíªí¥Üªk¡C

ª`·N:    ·í Crystal Reports ¨ú¥Î XML ¥»¨­®É¡A¶¥¼h¸ê®Æªíªí¥Üªk·|®Ú¾Ú¤º³¡¬d¸ß©w¸qª½±µ¹ïÀ³¦^ XML¡CXML ¥Ã»·¤£·|©î¸Ñ¦¨ÃöÁp¦¡¸ê®Æªí¼Ò«¬¡C

­åªR XML ¸ê®Æ¬y®É¡A±z¥²¶·«ü©w¨Ï¥Î XML ÅX°Êµ{¦¡ªºµ²ºc´y­z©Î¤å¥óÃþ«¬©w¸q (DTD)¡CÅX°Êµ{¦¡¨Ï¥Î¦¹¸ê®Æ¬y©Î DTD ¨Ó¨M©w¦p¦ó±N XML ¸ê®ÆÃþ«¬Âà´«¬° Crystal ¸ê®ÆÃþ«¬¡C¦p»ÝÃö©óµ²ºc´y­z¥H¤Î¸ê®ÆÃþ«¬Âà´«¤è¦¡ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´y­z¡C

¦p»ÝÃö©ó­ì¥Í XML ÅX°Êµ{¦¡ªº¸Ô²Ó¸ê°T¡A½Ð³y³X¡u¶}µo¤H­û°Ï°ì¡v¡Aºô§}¬°¡G

http://www.businessobjects.com/ipl/default.asp?destination=developerzone&language=EN&product=CRJavaProducts&edition=Professional&version=10.0&Partner=IBM

±z¥i¥H¦b³o­Óºô¯¸¤W§ä¨ì½d¨Ò©M¨ä¥L¸ê°T¡C¦p»Ý XML ªº¤@¯ëÁ`Äý¡A½Ð°Ñ¾\Crystal Reports ¨Ï¥Î«ü«n¡C

¤Jªù

±z¥²¶·¥ý³]©w CRDB_JavaServer.ini ÀɮסA¤~¯à¦b Crystal Reports ¨Ï¥Î­ì¥Í XML ÅX°Êµ{¦¡¡C¦p»Ý°Ñ¼Æªº§¹¾ã²M³æ¤Î¬ÛÃö»¡©ú¡A½Ð°Ñ¾\CRDB_JavaServer.ini °Ñ¼Æ°Ñ¦Ò¡C±z¥²¶·³]©wªº¥D­n°Ñ¼Æ¬° Path¡BClasspath ©M IORFileLocation¡C

ª`·N:    

XML ¸ê®Æ¨Ó·½¦s¨úÃþ«¬

·í±z¿ï¨ú XML ÅX°Êµ{¦¡¡AÂÇ¥H¦b Crystal Reports ¤¤«Ø¥ß·s³s½u®É¡A¥i¥H±q´X­Ó¥i¯àªº¸ê®Æ¨Ó·½Ãþ«¬¤¤¶i¦æ¿ï¾Ü¡C¥»¸`±N»¡©ú¨C­ÓÃþ«¬¡C¦p»ÝÁA¸Ñ³s½u®É©Ò­n§¹¦¨ªº¨BÆJ¡A½Ð°Ñ¾\³s½u¨ì XML ¸ê®Æ¨Ó·½¡C

¥»¾÷¸ê®Æ¨Ó·½

¥»¾÷¸ê®Æ¨Ó·½¬O«ü¦ì©ó¥»¾÷¹q¸£©Îºô¸ôºÏºÐ¾÷¤Wªº XML ÀɮסA±z¥i¥HÂǥѿé¤J¸ô®|¤ÎÀɮצWºÙ¨Ó©M¥¦¶i¦æ³s½u¡CXML ÅX°Êµ{¦¡¥iÅý±z¿é¤J§¹¾ãªº¸ô®|©MÀɮצWºÙ¡A©ÎªÌ¡A±z¤]¥i¥H¦b [¶}±Ò] ¹ï¸Ü¤è¶ô¤¤¶i¦æ·j´M¥H¿ï¨ú¸ÓÀɮסC¦pªG±z¦³ XML Àɮתºµ²ºc´y­z (XSD)¡A¤]¥i¥[¥H«ü©w¡C¦p»ÝÃö©óµ²ºc´y­z©M¨Ï¥Î¤èªkªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´y­z¡C

HTTP(S) ¸ê®Æ¨Ó·½

HTTP(S) ¸ê®Æ¨Ó·½¬O«ü¥i¥H±q Servlet¡BASP ­¶­±¡BJSP ­¶­±©Î¨ä¥L°ÊºA«Ø¥ßªººô­¶Ãþ«¬¨Ó¥[¥H¦s¨úªº XML ÀɮשΠXML ¸ê®Æ¬y¡C±z¥i¥H«ü©w HTTP ©Î HTTPS ªº URL µ¹³oÃþ¸ê®Æ¨Ó·½¡C¨Ï¥Î HTTPS ®É¡A±z¦b Crystal Reports ©Î Crystal Enterprise ¤¤¿é¤Jªº¨Ï¥ÎªÌ ID ¤Î±K½X±N·|¥Î¨Ó»P°ò¦ HTTP ´£¨ÑªÌ¶i¦æÅçÃÒ¡C

XML ÅX°Êµ{¦¡¥iÅý±z¥ý¿é¤J URL¡Aµy«á¦A¥[¤JÅçÃÒ¾ÌÃÒ¡C¦pªG±z¦³ XML ÀÉ®×©Î¸ê®Æ¬yªºµ²ºc´y­z (XSD)¡A´N¥i¥H«ü©wµ²ºc´y­z©M¥¦ªºÅçÃÒ¾ÌÃÒ¡C¦p»ÝÃö©óµ²ºc´y­z©M¨Ï¥Î¤èªkªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´y­z¡C

HTTP(S) ¸ê®Æ¨Ó·½¤]¤ä´© HTTP °Ñ¼Æ¡C¦p»Ý§ó¦h¸ê°T¡A½Ð°Ñ¾\HTTP °Ñ¼Æ¡C

Web ªA°È¸ê®Æ¨Ó·½

Web ªA°È¸ê®Æ¨Ó·½¥i¥H¬O¥»¾÷¹q¸£©Îºô¸ôºÏºÐ¾÷ (±z¥i¥H¿é¤J¸ô®|©MÀɮצWºÙ¨Ó³s±µ) ¤WªºªA°È¡A©Î¬O¥i±q Servlet ©Î°ÊºA«Ø¥ßªººô­¶¤¤¦s¨úªºªA°È¡C±z¥i¥H«ü©w HTTP ©Î HTTPS ªº URL µ¹³oÃþ¸ê®Æ¨Ó·½¡C¦^À³ XML Àɮתºµ²ºc´y­z¬O³z¹L Web ªA°È¬[ºc­l¥Íªº¡A¦Ó¤£¬O¤â°Ê«ü©wªº¡C

Web ªA°È¸ê®Æ¨Ó·½¬O¸g¥Ñ WSDL (Web ªA°È´y­z»y¨¥) ¨Ó¦s¨ú¡AWSDL ¬O´y­z Web ªA°Èªº¼Ð·Ç®æ¦¡¡C«ü©w WSDL ¤§«á¡AÅX°Êµ{¦¡´N·|Åý±z¿ï¨ú·Q­n¨Ï¥ÎªºªA°È¡B³s±µ°ð©M¤èªk¡C

µ²ºc´y­z

¨Ï¥Î XML ÅX°Êµ{¦¡®É¡A±z¥i¥H¿ï¾Ü«ü©wµ²ºc´y­z (XSD) ©Î¤å¥óÃþ«¬©w¸q (DTD)¡A©Î¬O¨Ï¥Î¤º´O©ó XML ¤å¥óªºµ²ºc´y­z¸ê°T¡Cµ²ºc´y­z¬O¥Î¨Ó¨M©w¦p¦ó¦b Crystal Reports ¤º§e²{ XML ¸ê®Æ¡C

ª`·N:    ·í±z«ü©w­n¥Î©ó XML Àɮתºµ²ºc´y­z®É¡A´N·|¨Ï¥Î«ü©wªºµ²ºc´y­z¡A¦Ó¤£¬O¨Ï¥Î¤º´O©ó XML ÀɮשΨ䥻¨­©Ò°Ñ¦Òªºµ²ºc´y­z¸ê°T¡C

¤U­±ªí®æÅã¥Ü­ì¥Í XML ÅX°Êµ{¦¡¦p¦ó±N XML ¸ê®ÆÃþ«¬¹ïÀ³¨ì Crystal ¸ê®ÆÃþ«¬¡C

XML Ãþ«¬Crystal Ãþ«¬

¦r¦ê

¦r¦ê

¥¬ªL

¥¬ªL

Decimal

¼Æ¦r

float

¼Æ¦r

Double

¼Æ¦r

duration

¦r¦ê (´Á¶¡¡G´Á¶¡)

dateTime

¤é´Á®É¶¡

®É¶¡

®É¶¡

¤é´Á

¤é´Á

gYearMonth

¤é´Á (¤ë¥÷²Ä¤@¤é)

gYear

¤é´Á (¦~«×²Ä¤@¤é)

gMonthDay

¤é´Á (¤µ¦~¤º)

gDay

¤é´Á (¥Ø«e¤ë/¦~¤º)

gMonth

¤é´Á (¤µ¦~¤º – ²Ä¤@¤é)

hexBinary

BLOB

base64Binary

BLOB

anyURI

¦r¦ê

QName

¦r¦ê

NOTATION

¦r¦ê (¼Ð°Oªk¡G¼Ð°Oªk)

normalizedString

¦r¦ê

token

¦r¦ê

»y¨¥

¦r¦ê

NMTOKEN

¦r¦ê

NMTOKENS

¦r¦ê

¦WºÙ

¦r¦ê

NCName

¦r¦ê

ID

¦r¦ê

IDREF

¦r¦ê

IDREFS

¦r¦ê

ENTITY

¦r¦ê

ENTITIES

¦r¦ê

Integer

¼Æ¦r

nonPositiveInteger

¼Æ¦r

negativeInteger

¼Æ¦r

long

¼Æ¦r

int

¼Æ¦r

short

¼Æ¦r

byte

¼Æ¦r

nonNegativeInteger

¼Æ¦r

unsignedLong

¼Æ¦r

unsignedInt

¼Æ¦r

unsignedShort

¼Æ¦r

unsignedByte

¼Æ¦r

positiveInteger

¼Æ¦r

anySimpleType

¦r¦ê

ª`·N:    ¦WºÙ»Ý°Ï¤À¤j¤p¼g¡C

XML ÅX°Êµ{¦¡·|³B²z XML ÄݩʡB©R¦WªÅ¶¡¡B¯S©w¸ê®ÆÃþ«¬©M¼Ð°O¡A¦p¤U­±ªí®æ©Ò¥Ü¡C

XMLÅX°Êµ{¦¡ªº¸ÑªR¤è¦¡

ÄÝ©Ê

Äݩʷ|¥]§t¦b¸ê®Æ¦æ¦WºÙ¤¤¡A¨Ã¥H @ ²Å¸¹¬°¦r­º (¨Ò¦p¡A¼Ð°O <a attrib="valueofattrib"> ·|Åܧó¦¨Äæ¦ì A@attrib)¡C

©R¦WªÅ¶¡

©R¦WªÅ¶¡·|¥]§t¦b¸ê®Æ¦æ¦WºÙ¤¤ (¨Ò¦p¡A¼Ð°O <abc:name> ·|Åܦ¨Äæ¦ì abc:name)¡C

½ÆÂø¸ê®ÆÃþ«¬

½ÆÂøÃþ«¬¤¸¯À¤£½×¬O§_¦³­«½Æ¤¸¯À¡A³£·|¸ÑªR¦¨ Crystal Reports ¤ºªº¸ê®Æªí¡C·í½ÆÂøÃþ«¬¶È¥]§t³æ¤@²³æÃþ«¬¤¸¯À®É¡AÄÝ©ó¨Ò¥~ª¬ªp¡F¦b¦¹ª¬ªp¤U¡A·|±N¤¸¯À·í§@¥]§t¥H <CR> ¤À¹jªº¤¸¯À­È²M³æªºªø¦r¦ê¶Ç¦^¡C

²M³æ¸ê®ÆÃþ«¬

²M³æ¸ê®ÆÃþ«¬¥Ã»·¸ÑªR¬°¦r¦êÃþ«¬¡C¦r¦ê±N¥]§t²M³æ¡C

Áp¶°¸ê®ÆÃþ«¬

Áp¶°¸ê®ÆÃþ«¬·|¶Ç¦^¥]§tÁp¶°¤º®eªº¦r¦ê¡C

²V¦X¸ê®ÆÃþ«¬

©w¸q¬° Mixed ªº¸ê®ÆÃþ«¬·|·í§@¥]§t¾ã­Ó¼Ð°O¤º®e (¥]¬A¤¸¯Àªº¦Û¦³¼Ð°O) ªº XML ¤ù¬q¶Ç¦^¡A¦p¦P³Æ§ÑÄæ¦ì¤@¯ë¡C

¥H processContents="skip" Äݩʩw¸qªºÃþ«¬

¥HÄÝ©Ê processContents="skip" ©w¸qªºÃþ«¬·|·í§@¥]§t¾ã­Ó¼Ð°O¤º®e (¥]¬A¤¸¯Àªº¦Û¦³¼Ð°O) ªº XML ¤ù¬q¶Ç¦^¡A¦p¦P³Æ§ÑÄæ¦ì¡C

¥H processContents="lax" Äݩʩw¸qªºÃþ«¬

¥HÄÝ©Ê processContents="lax" ©w¸qªºÃþ«¬·|³z¹Lµ²ºc´y­z¶i¦æ¸ÑªR¡F¦pªGµLªk¥[¥H¸ÑªR¡A¸ê®Æ·|·í§@¥]§t¾ã­Ó¼ÐÅÒ¤º®e (¥]¬A¤¸¯Àªº¦Û¦³¼Ð°O) ªº XML ¤ù¬q¶Ç¦^¡A¦p¦P³Æ§ÑÄæ¦ì¡C

¿ï¾Ü¼Ð°O

·í¨Ï¥Î Choice ¼Ð°O®É¡A·|´£¨Ñ©Ò¦³²Õ¦XªºÁp¶°¡A¥H¤Î«ü¥Ü¸ô®|¿ï¾Üªº¦CÁ|¿ï¾ÜÄæ¦ì¡C

¤£§t¹ê»Ú­Èªº¼Ð°O

·í¼Ð°OÄÝ©ó²³æÃþ«¬¥B¤£§t¹ê»Ú­È®É¡A·|¶Ç¦^ NULL ­È¡C©Ò¦³¸ê®ÆÃþ«¬³£¥i¥H±µ¨ü NULL¡C

·íµLªk§PÂ_µ²ºc´y­z³Ì¥~°¼ (®Ú) ¤¸¯À¬O¨Ó¦Û XSD ©Î DTD ®É¡A·|Åã¥Ü©Ò¦³¥i¯àªº®Ú¥Ø¿ý¡A¦Ó±z¥²¶·¿ï¨ú®Ú¥Ø¿ý°µ¬°¸ê®Æ³s½uªº¤@³¡¤À¡C

HTTP °Ñ¼Æ

·í±z¿ï¨ú HTTP(S) ¸ê®Æ¨Ó·½®É¡A¤]¥i¥H©w¸q­n¶Ç»¼µ¹°ò¦ Servlet ©Î°ÊºA«Ø¥ßªººô­¶ªº HTTP °Ñ¼Æ¡C³o¨Ç°Ñ¼Æ·|´£¨Ñ¸ê°Tµ¹ Servlet ©Îºô­¶¡A¥H«K¶Ç¦^¥¿½Tªº XML ¸ê®Æ¬y¡C°Ñ¼Æ·|·í§@ªí³æÅܼƶǻ¼µ¹°ò¦³s½u¡Cªí³æÅܼƦWºÙ·|¹ïÀ³¨ì Crystal °Ñ¼Æ¦WºÙ (¨Ò¦p¡ACrystal {?REGION} °Ñ¼Æµ¥©óªí³æÅÜ¼Æ 'REGION')¡C

¦pªG¥H¦h­Ó¿ï¨ú­È¶Ç»¼©Ò¦³°Ñ¼Æ¡A´N·|°e¥X¦h­Ó¬Û¦P¦WºÙªºªí³æÅܼơC¨Ò¦p¡A½Ð¦Ò¼{¥H¤U½d¨Ò¡G

<p>¤°»ò¤f¨ý¾P°â¶q³Ì¤j¡H

<input type=checkbox name=flavor value=vanilla>Vanilla<br>

<input type=checkbox name=flavor value=strawberry>Strawberry<br>

<input type=checkbox name=flavor value=chocolate checked>Chocolate<br>

¦pªG±z¦P®É¿ï¨ú¥©§J¤O¤Î­»¯ó¡A´N·|°e¥X¨â­Ó¦WºÙ¬° flavor ªºªí³æÅܼơA¦U¦Û±a¦³ Vanilla (­»¯ó) ©M Chocolate (¥©§J¤O) ªº­È¡A¤@¦p GET ®æ¦¡¤Uªº "http://server/Servlet?flavor=Vanilla&flavor=Chocolate"¡C¦P¼Ëªº¡A¥]§t¸g¥Ñ Crystal Reports ¿ï¨úªº¡u­»¯ó¡v¤Î¡u¥©§J¤O¡v­Èªº {?flavor}¡A¤]·|«Ø¥ß¬Û¦Pªº URL ­n¨D¡C

«Ø¥ß XML ÅX°Êµ{¦¡ªº HTTP °Ñ¼Æ
  1. ¦b [HTTP °Ñ¼Æ] µe­±¤W¡A«ö¤@¤U [¥[¤JÄÝ©Ê]¡C
  2. ¦b [½s¿èÄݩʭÈ] µe­±¤Wªº [ÄÝ©Ê] Äæ¦ì¤¤¡A¿é¤J°Ñ¼Æªº¦WºÙ¡C
  3. ¦b [­È] Äæ¦ì¤¤¡A¥H @Prompt ¨ç¦¡ªº§Î¦¡¿é¤J°Ñ¼Æ¤½¦¡¡C
°Ñ¼Æ¤½¦¡

°Ñ¼Æ¤½¦¡­n¨Ï¥Î @Prompt ¨ç¦¡¨Ó«Ø¥ß¡C¦pªG±z·Q­n¦b XML ¸ê®Æ¬y¤¤±j¥[­­¨î¡A¦ý¤S¤£·Q¹w³]±ø¥óªº­È¡A¦¹®É³o­Ó¨ç¦¡·|«Ü¦³¥Î¡C

¨ç¦¡ªº»yªk¦p¤U¡G

@Prompt('message','type',[lov],[MONO|MULTI],[FREE|CONSTRAINED])

»yªk»¡©ú

'message'

³o­Ó°Ñ¼Æ¬O´£¥Ü°T®§ªº¤å¦r¡C¤å¦r¥²¶·¬A¦b³æ¤Þ¸¹¤¤ (¨Ò¦p¡A'½Ð¿ï¾Ü¦a°Ï'¡B'½Ð¬D¿ï´Á¶¡' ©Î '½Ð¿ï¾Ü³¯¦C«Ç')¡C·í³s½u§¹¦¨®É¡A³o¶µ¤å¦r´N·|¥X²{¦b´£¥Ü¤è¶ô¤¤¡C

'type'

³o­Ó°Ñ¼Æ·|´y­z¨ç¦¡¶Ç¦^ªº¸ê®ÆÃþ«¬¡C¥¦¥i¥H¬O¤U¦C¨ä¤¤¤@¶µ¡J

  • 'A' ªí¥Ü­^¼Æ¦r¦ê
  • 'N' ªí¥Ü¼Æ¦r
  • 'D' ªí¥Ü¤é´Á

«ü©wªº¸ê®ÆÃþ«¬¥²¶·¬A¦b³æ¤Þ¸¹¤¤¡C

lov

³o­Ó°Ñ¼Æ·|´£¨Ñ­È²M³æ (lov)¡C²M³æ¬O©T©wªº¡F¤]´N¬O¡A±z¬OÂǥѿé¤J­Ó§O­È¨Ó«Ø¥ß²M³æ¡C¨C­Ó­È³£¥²¶·¬A¦b³æ¤Þ¸¹¤¤¡A¨Ã¥B¥H³r¸¹¤À¹j¡A¾ã­Ó²M³æ«h­n¬A¦b¤j¬A¸¹¤¤¡C¨Ò¦p¡A{'Australia', 'France', 'Japan', 'United Kingdom', 'USA'}¡C³o¬O¤@­Ó¿ï¾Ü©Êªº°Ñ¼Æ¡C

MONO

¨Ï¥ÎªÌ¦b­È²M³æ¤¤¥u¯à¿ï¨ú¤@­Ó­È¡CMONO ¬O MONO|MULTI ³o¤@¹ï°Ñ¼Æªº¹w³]­È¡C³o¬O¤@­Ó¿ï¾Ü©Êªº°Ñ¼Æ¡C

MULTI

¨Ï¥ÎªÌ¥i¥H±q­È²M³æ¤¤¿ï¨ú¦h­Ó­È¡CMONO ¬O MONO|MULTI ³o¤@¹ï°Ñ¼Æªº¹w³]­È¡C³o¬O¤@­Ó¿ï¾Ü©Êªº°Ñ¼Æ¡C

FREE

¨Ï¥ÎªÌ¥i¥H¿é¤J¦Û¤v·Q­nªº­È¡A©Î¬O±q­È²M³æ¤¤¿ï¨ú­È¡CFREE ¬O FREE|CONSTRAINED ³o¤@¹ï°Ñ¼Æªº¹w³]­È¡C³o¬O¤@­Ó¿ï¾Ü©Êªº°Ñ¼Æ¡C

CONSTRAINED

¨Ï¥ÎªÌ¥²¶·±q­È²M³æ¤¤¿ï¨ú­È¡CFREE ¬O FREE|CONSTRAINED ³o¤@¹ï°Ñ¼Æªº¹w³]­È¡C³o¬O¤@­Ó¿ï¾Ü©Êªº°Ñ¼Æ¡C

ª`·N:    ¹ï¨C¤@­Ó¿ï¾Ü©Ê°Ñ¼Æ¦Ó¨¥¡A¦pªG¬Ù²¤¤Þ¼Æ¡A¤´µM¥²¶·¿é¤J³r¸¹°µ¬°¤À¹j²Å¸¹¡C

³s½u¨ì XML ¸ê®Æ¨Ó·½

¿ï¾Ü XML °µ¬°¸ê®Æ¨Ó·½
  1. ¦b Crystal Reports ªº [ÀÉ®×] ¥\¯àªí¤W¡A«ö¤@¤U [·s¼W]¡C
  2. «ö¤@¤U [¨Ï¥Î³øªíºëÆF]¡C
  3. ¦b [¿ï¾ÜºëÆF] ²M³æ¤¤«ö¤@¤U [¼Ð·Ç]¡AµM«á«ö¤@¤U [½T©w]¡C
  4. ¦b³øªí«Ø¥ßºëÆFªº [¸ê®Æ] µe­±¤W¡A«ö¨â¤U [«Ø¥ß·s³s½u]¡C
  5. «ö¨â¤U [XML]¡C
  6. ·|¥X²{ [XML] ¹ï¸Ü¤è¶ô¡C

  7. ¿ï¾Ü XML ¸ê®Æ¨Ó·½¦s¨úÃþ«¬¡G
  8. ¨Ì·Ó¤U¦C¨ä¤¤¤@¸`ªº¨BÆJ¡A¥iÃѧO­n³s½uªº XML ÀɮסG
³s½u¨ì¥»¾÷¸ê®Æ¨Ó·½
  1. ¦pªG¿ï¾Ü [¨Ï¥Î¥»¾÷¸ê®Æ¨Ó·½]¡A½Ð¿é¤J XML Àɮתº§¹¾ã¸ô®|©M¦WºÙ¡A©Î¨Ï¥ÎÄæ¦ì®ÇÃ䪺«ö¶s¥H·j´MÀɮסC
  2. ¦pªG­n®M¥Îµ²ºc´y­z¦Ü¿ï¨úªº XML ÀɮסA½Ð¿ï¾Ü [«ü©wµ²ºc´y­zÀÉ®×]¡C
  3. °£«D XML ÀÉ®×¥]§t¤º´Oªºµ²ºc´y­z¸ê°T¡A§_«h±z¥²¶·¿ï¨ú³o­Ó¿ï¶µ¨Ã«ü©wµ²ºc´y­z¡C

    ª`·N:    µ²ºc´y­z¦ì¸m©M¦WºÙªº©w¸q¡A¬O¦b¤U¤@­Óµe­±¤¤§¹¦¨¡C

  4. «ö¤@¤U [Next]¡C
  5. ®Ú¾Ú¤W¤@­Ó¨BÆJªº¿ï¾Ü¡A·|Åã¥Ü¥i¥H«ü©wµ²ºc´y­zªºµe­±¡F­Y¤£«ü©w¡A´N«ö¤@¤U [§¹¦¨] «ö¶s¡C

  6. ¦pªG­n«ü©wµ²ºc´y­zÀɮסA½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´y­z] ©Î [¨Ï¥Î HTTP(S) µ²ºc´y­z]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
  7. «ö¤@¤U [¤U¤@¨B]¡AµM«á«ö¤@¤U [§¹¦¨]¡C
³s½u¨ì HTTP(S) ¸ê®Æ¨Ó·½
  1. ¦pªG¿ï¾Ü [¨Ï¥Î HTTP(S) ¸ê®Æ¨Ó·½]¡A½Ð¿é¤J«ü¦V XML Àɮתº URL¡C
  2. ±z¥i¥H¨Ï¥Î HTTP ©Î HTTPS ¨Ó©w¸q URL¡C

  3. ¦pªG­n®M¥Îµ²ºc´y­z¦Ü¿ï¨úªº XML ÀɮסA½Ð¿ï¾Ü [«ü©wµ²ºc´y­zÀÉ®×]¡C
  4. °£«D XML ÀÉ®×¥]§t¤º´Oªºµ²ºc´y­z¸ê°T¡A§_«h±z¥²¶·¿ï¨ú³o­Ó¿ï¶µ¨Ã«ü©wµ²ºc´y­z¡C

    ª`·N:    µ²ºc´y­z¦ì¸m©M¦WºÙªº©w¸q¡A¬O¦b±µ¤U¨Óªºµe­±¤¤§¹¦¨¡C

  5. «ö¤@¤U [Next]¡C
  6. ¦p¦³¥²­n¡A½Ð¿é¤JÅçÃÒ¸ê°T¡AµM«á¦A¦¸«ö¤@¤U [¤U¤@¨B]¡C
  7. ®Ú¾Ú¨BÆJ 2 ªº¿ï¾Ü¡A·|Åã¥Ü¥i¥H«ü©wµ²ºc´y­zªºµe­±©Î©w¸q HTTP °Ñ¼Æªºµe­±¡C¦pªG±z¬Ý¨ì [HTTP °Ñ¼Æ] µe­±¡A½Ð¸õ¨ì¨BÆJ 6¡C

  8. ¦pªG­n«ü©wµ²ºc´y­zÀɮסA½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´y­z] ©Î [¨Ï¥Î HTTP(S) µ²ºc´y­z]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
  9. ¦b [HTTP °Ñ¼Æ] µe­±¤W¡A«Ø¥ß¾A¦X¥[¤J URL ªº°Ñ¼Æ¡A¥H­­¨î XML Àɮפº¶Ç¦^ªºµ²ªG¡C
  10. ¦b [HTTP °Ñ¼Æ] µe­±¤¤¿é¤J§¹²¦®É¡A½Ð«ö¤@¤U [§¹¦¨] ¡C
³s½u¨ì Web ªA°È¸ê®Æ¨Ó·½
  1. ¦pªG¿ï¾Ü [¨Ï¥Î Web ªA°È¸ê®Æ¨Ó·½]¡A½Ð«ö¤@¤U [¤U¤@¨B] ¥HÄ~Äò°õ¦æ¨BÆJ¡C
  2. ¦pªG­n«ü©w Web ªA°ÈÀɮצì¸m¡A½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷ WSDL] ©Î [¨Ï¥Î HTTP(S) WSDL]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
  3. «ö¤@¤U [Next]¡C
  4. ®Ú¾Ú¤W¤@­Ó¨BÆJªº¿ï¾Ü¡A·|Åã¥Ü¥i¥H«ü©w Web ªA°È¡B³s±µ°ð©M¤èªkªºµe­±¡A©ÎÅã¥Ü¥i¥H©w¸q Web ªA°È URL ÅçÃÒªºµe­±¡C¦pªG±z¬Ý¨ì [Web ªA°È¡B³s±µ°ð©M¤èªk] µe­±¡A½Ð¸õ¨ì¨BÆJ 5¡C

  5. ¦p¦³¥²­n¡A½Ð¿é¤JÅçÃÒ¸ê°T¡AµM«á«ö¤@¤U [¤U¤@¨B]¡C
  6. ¦b [Web ªA°È¡B³s±µ°ð©M¤èªk] µe­±¤W¡A±q²M³æ¤¤¿ï¾ÜªA°È¡B³s±µ°ð©M¤èªk¡C
  7. «ö¤@¤U [Finish]¡C

·í±z¬Ý¨ì±q XML ¸ê®Æ¨Ó·½«Ø¥ßªº¸ê®Æªí®É¡A´N¥i¥H¥Î¥¦¨Ó«Ø¥ß Crystal ³øªí¡F«Ø¥ß¤è¦¡¦p¦P±z¨Ï¥Î¥ô¦ó¨ä¥L¸ê®Æ¨Ó·½¤@¼Ë¡C¦p»ÝÃö©ó«Ø¥ß Crystal ³øªíªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\¡mCrystal Reports ¨Ï¥Î«ü«n¡n¡C

CRDB_JavaServer.ini °Ñ¼Æ°Ñ¦Ò

Åã¥Ü¦b CRDB_JavaServer.ini ¤¤ªº°Ñ¼Æ¬O¨Ì¾Ú±z©Ò¦w¸ËªºÅX°Êµ{¦¡¦Ó©w¡C¨Ò¦p¡A¦pªG¨S¦³¦w¸Ë­ì¥Í XML ÅX°Êµ{¦¡¡A[CRDB_XML] °Ñ¼Æ´N¤£·|Åã¥Ü¡C¦b³Ì¨Îª¬ªp¤U¡ACRDB_JavaServer.ini ÀÉ®×·|¥]§t©Ò¦³³o¨Ç°Ñ¼Æ¡G

°Ñ¼Æ¦WºÙ»¡©ú

¸ô®|

Path °Ñ¼Æ­È¥]§t Java ¥i°õ¦æÀɪº¥Ø¿ý¡C¦pªG¦w¸Ë¤F¦h­Ó Java Runtime Environment ª©¥»¡A«h³o­Ó°Ñ¼Æ·|«ü¦V±z­n¨Ï¥Îªºª©¥»¡A¨Ò¦p¡G

PATH=C:\apps\j2sdk1.4.2\bin

©ÎªÌ¡A¤]¥i¥H±N¸ô®|¸ê°T³]©w¬°¨Ï¥ÎªÌ©Î¨t²ÎÀô¹ÒÅܼơC¦b³oºØª¬ªp¤U¡A¦pªG JAVA_HOME ¬O©w¸q¬°ÅܼơA«h¥i¥H¨Ì·Ó¥H¤U½d¨Ò¨Ï¥Î ${JAVA_HOME}¡G

PATH=${JAVA_HOME}\bin

Classpath

Classpath °Ñ¼Æ­È¥]§t¥H¤U .jar ÀɮתºÃþ§O¸ô®|²M³æ¡G

  • CRDBJavaServer.jar
  • ©Ò¦³¸ê®Æ®w±MÄݪº JDBC ÅX°Êµ{¦¡ .jar ÀÉ®×

    ¨Ò¦p¡A¹ï©ó Oracle JDBC ÅX°Êµ{¦¡¦Ó¨¥¡Aojdbc14.jar ªºÃþ§O¸ô®|´N¬O¥²­nªº¡C

©ÎªÌ¡A¤]¥i¥H±NÃþ§O¸ô®|¸ê°T³]©w¬°¨Ï¥ÎªÌ©Î¨t²ÎÀô¹ÒÅܼơC¦pªG¨S¦³©w¸q³o­ÓÅܼơA«h¥¦·|µ¥¦P©ó CLASSPATH=${CLASSPATH}¡C

Àô¹ÒÅܼÆÁÙ¥i¥H¥]§t¦b²V¦X¸ô®|¤¤¡A¦p¥H¤U½d¨Ò©Ò¥Ü¡G

classpath=c:\java\lib\xerces.jar;${CommonProgramFiles}"/Crystal Decisions/2.5/bin/CRDBJavaServer.jar";${CLASSPATH}

ª`·N:    ¨Ï¥Î¨ã¦³ªø¸ê®Æ§¨ªºÃþ§O¸ô®|©M (©Î) ¥]§tªÅ®æªºÀɮצWºÙ®É¡A½Ð½T©w¥¦­Ì³£¬A¦b¤Þ¸¹¤º¡C¨Ò¦p¡A"C:\Program Files\Common Files\Crystal Decisions\2.5\bin\CRDBJavaServer.jar"¡C

IORFileLocation

IORFileLocation °Ñ¼Æ­È´£¨Ñ¼È¦s¥Ø¿ý¡A¨Ñ JDBC ÅX°Êµ{¦¡¨Ï¥Î¡C³o­Ó¦ì¸m¥²¶·¦s¦b¡A¥B¥i¥Ñ¨t²Î¦s¨ú¡A§_«hÅX°Êµ{¦¡«KµLªk¹B§@¡C

JavaServerTimeout

JavaServerTimeout °Ñ¼Æ«ü©w Java ¦øªA¾¹¦b¦Û¦æÃö³¬¤§«e¡A·|«ùÄò³B²z­n¨D¦h¤[ªº®É¶¡¶q¤W­­¡C¹w³]­È¬° 1800 ¬í (30 ¤ÀÄÁ)¡C

JVMMaxHeap

JVMMaxHeap °Ñ¼Æ«ü©w JVM ¥i¥H¬° Java ¦øªA¾¹ªº°õ¦æ©Ò°t¸mªº³Ì¤j°ïÅ|ªÅ¶¡¶q¡C®Ú¾Ú¹w³]¡A³o­Ó°Ñ¼Æ¬O³]©w¬° 64 MB ªº°ïÅ|¡C¦pªG»Ý­n³B²z¤j¶q¸ê®Æ¡A½Ð±N³o­Ó¼Æ¦rÅܧ󬰸û¤jªº­È¡C

JVMMinHeap

JVMMinHeap °Ñ¼Æ«ü©w JVM ¥i¥H¬° Java ¦øªA¾¹ªº°õ¦æ©Ò°t¸mªº³Ì¤p°ïÅ|ªÅ¶¡¶q¡C®Ú¾Ú¹w³]¡A³o­Ó°Ñ¼Æ¬O³]©w¬° 32 MB ªº°ïÅ|¡C

CacheRowSetSize

CacheRowSetSize °Ñ¼Æ«ü©w§Ö¨ú©ó°O¾ÐÅ骺¸ê®Æ¦C¼Æ¡C®Ú¾Ú¹w³]¡A¦¹°Ñ¼Æ·|³]©w¬° 100 ¦C¡C

JDBCURL

JDBCURL °Ñ¼Æ­È¬O¹w³]ªº JDBC ³s½u URL¡A·|¦b±z«Ø¥ß·sªº JDBC ¸ê®Æ³s½u®ÉÅã¥Ü©ó Crystal Reports¡C³s½u URL ªº½T¤Á®æ¦¡»P¸ê®Æ®wÅX°Êµ{¦¡¦³Ãö¡A¦Ó¥B¬O¥Ñ¸ê®Æ®wÅX°Êµ{¦¡¼t°Ó©Ò´£¨Ñ¡C

¨Ò¦p¡AOracle JDBC ÅX°Êµ{¦¡ªº³s½u URL ¬°¡G

jdbc:oracle:thin:@<hostname>:<port>:<sid>

¨ä¤¤¡G

  • <hostname> ¬O±z­n³s±µ¨ìªº¦øªA¾¹ TCP/IP ¦ì§}©Î TCP/IP ¥D¾÷¦WºÙ¡C
  • <port> ¬O TCP/IP ³s±µ°ðªº¸¹½X¡C
  • <sid> ¬O Oracle ¸ê®Æ®w ID¡C

JNDIURL

JNDIURL °Ñ¼Æ­È¬O¹w³]ªº JNDI ³s½u URL¡A·|¦b±z«Ø¥ß·sªº JNDI ¸ê®Æ³s½u®ÉÅã¥Ü©ó Crystal Reports¡C³s½u URL ªº½T¤Á®æ¦¡»P¸ê®Æ®wÅX°Êµ{¦¡¦³Ãö¡A¦Ó¥B¬O¥Ñ¸ê®Æ®wÅX°Êµ{¦¡¼t°Ó©Ò´£¨Ñ¡C

JDBCUserName

JDBCUserName ¬O¹w³]ªº¨Ï¥ÎªÌ ID¡A·|¦b±z«Ø¥ß·sªº JDBC ¸ê®Æ³s½u®ÉÅã¥Ü©ó Crystal Reports¡CJDBC ÅX°Êµ{¦¡·|§Q¥Î¨Ï¥ÎªÌ ID ³s±µ¨ì¸ê®Æ®w¡C

JDBCDriverName

JDBCDriverName ¬O JDBC ÅX°Êµ{¦¡ªº¹w³]§¹¾ãÃþ§O¦WºÙ¡A·|¦b±z«Ø¥ß·sªº JDBC ¸ê®Æ³s½u®ÉÅã¥Ü©ó Crystal Reports¡C

¨Ò¦p¡AOracle JDBC ÅX°Êµ{¦¡ªº§¹¾ãÃþ§O¦WºÙ¬°¡G

oracle.jdbc.driver.OracleDriver

JNDIUserName

JNDIUserName ¬O¹w³]ªº¨Ï¥ÎªÌ ID¡A·|¦b±z«Ø¥ß·sªº JNDI ¸ê®Æ³s½u®ÉÅã¥Ü©ó Crystal Reports¡CJDBC ÅX°Êµ{¦¡·|§Q¥Î¨Ï¥ÎªÌ ID ³s±µ¨ì¸ê®Æ®w¡C

JNDIConnectionFactory

JNDIConnectionFactory °Ñ¼Æ¬O JNDI ¦øªA¾¹³s½u¨ÑÀ³°Óªº¦WºÙ¡C­Y¬O WebLogic¡A«h¬° weblogic.jndi.WLInitialContextFactory¡C­Y¬O WebSphere¡A«h¬° com.ibm.websphere.naming.WsnInitialContextFactory¡C

JNDIInitContext

JNDIInitContext °Ñ¼Æ¬O¦b JNDI ¦øªA¾¹¤W´M§ä JNDI ¤º®eªº°_ÂI¡C¨Ò¦p¡A±z¥i¥H°w¹ï WebLogic ³]©w JNDIInitContext=/¡C°Ñ¼Æ·|±q¾ðª¬µ²ºcªº³»ºÝ¶}©l·j´M¡C¦pªG¤w¦b³o­Ó¸`ÂI¤¤«Ø¥ß³s½u¡A¥i¥H°w¹ï WebSphere ±N³o­Ó°Ñ¼Æ³]©w¬° cell/nodes/localhost/servers/server1/jdbc¡C

GenericJDBCDriverBehavior

¦pªG©Ò¨Ï¥Îªº¬Oªx¥Î JDBC ÅX°Êµ{¦¡¡A¦Ó«D¯S©wªºÅX°Êµ{¦¡¡A«h GenericJDBCDriverBehavior °Ñ¼Æ·|«ü©w­n¼ÒÀÀ¨ä¦æ¬°ªºÅX°Êµ{¦¡¡C®Ú¾Ú¹w³]¡A·|³]©w¼ÒÀÀ DB2 JDBC ÅX°Êµ{¦¡ªº¦æ¬°¡C¦pªG«O¯d³o­Ó³]©w¡A¥Nªí±z·Q­n±NÃþ¦ü DB2 JDBC ÅX°Êµ{¦¡ªº¥\¯à¶}©ñµ¹¨Ï¥ÎªÌ¨Ï¥Î¡C¦³®Ä­È¬° DB2¡BSQLServer ©M Oracle¡C

PREREADNBYTE

PREREADNBYTE °Ñ¼Æ¬O¥Î¨Ó¨M©w¦b¨C¦¸¶i¦æÅÞ¿èŪ¨ú®É¡A±q XML ¤å¥óŪ¨ú¦h¤Ö¦ì¤¸²Õ¡C³o­Ó°Ñ¼Æ¥i¥Î¨Ó§ïµ½®Ä²v¨ÃÁ×§K¤@¦¸Åª¨ú¤@­Ó¦ì¤¸²Õ¡F³o»P°Ï¶ôŪ¨ú¤j¤p¬Û¦P¡C¤j¤p¤£¯à¤Ó¤p (¦Ü¤Ö¬° 4096)¡C³]©w¹L°ªªº­È·|¼vÅT°O¾ÐÅ骺¥Îªk¡C®Ú¾Ú¹w³]¡A³o­Ó°Ñ¼Æ¬O³]©w¬° 5000¡C

XMLLOCALURL

XMLLOCALURL °Ñ¼Æ­È¬O¥»¾÷ XML Àɮתº¹w³]³s½u URL¡C³o­Ó¹w³]­È·|¦b±z«Ø¥ß·sªº XML ¸ê®Æ³s½u®É¡AÅã¥Ü©ó Crystal Reports¡C

SCHEMALOCALURL

SCHEMALOCALURL °Ñ¼Æ­È¬O¥»¾÷µ²ºc´y­zÀɮתº¹w³]³s½u URL¡C³o­Ó¹w³]­È·|¦b±z«Ø¥ß·sªº XML ¸ê®Æ³s½u®É¡AÅã¥Ü©ó Crystal Reports¡C

XMLHTTPURL

XMLHTTPURL °Ñ¼Æ­È¬O HTTP XML Àɮתº¹w³]³s½u URL¡C³o­Ó¹w³]­È·|¦b±z«Ø¥ß¨Ï¥Î HTTP(S) ªº·s XML ¸ê®Æ³s½u®É¡AÅã¥Ü©ó Crystal Reports¡C

SCHEMAHTTPURL

SCHEMAHTTPURL °Ñ¼Æ­È¬O HTTP µ²ºc´y­zÀɪº¹w³]³s½u URL¡C³o­Ó¹w³]­È·|¦b±z«Ø¥ß¨Ï¥Î HTTP(S) ªº·s XML ¸ê®Æ³s½u®É¡AÅã¥Ü©ó Crystal Reports¡C



Business Objects
http://www.taiwan.businessobjects.com/
¤ä´©ªA°È
http://www.businessobjects.com/services/support/