³]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´yz (XSD) åªR¨ä¤º®e¡A¥Hl¥Í¸ê®Æªº¶¥¼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´yz©Î¤å¥óÃþ«¬©w¸q (DTD)¡CÅX°Êµ{¦¡¨Ï¥Î¦¹¸ê®Æ¬y©Î DTD ¨Ó¨M©w¦p¦ó±N XML ¸ê®ÆÃþ«¬Âà´«¬° Crystal ¸ê®ÆÃþ«¬¡C¦p»ÝÃö©óµ²ºc´yz¥H¤Î¸ê®ÆÃþ«¬Âà´«¤è¦¡ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´yz¡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ªº¥Dn°Ñ¼Æ¬° Path¡BClasspath ©M IORFileLocation¡C
ª`·N:
- ¦pªG¤£·Q¦b
CRDB_JavaServer.ini
Àɮפ¤¥]§t¸ô®|¸ê°T¡A«h³o¶µ¤u§@¥i¯àÁÙn¥]§t³]©w Java ¥Ø¿ýªºÀô¹ÒÅܼơC¦b³oºØ±¡ªp¤U¡A½Ð«Ø¥ß«ü¦V JDK ¦ì¸mªº JAVA_HOME Àô¹ÒÅܼơC - °w¹ï¨Ï¥Î¥ô¤@»y¨tªº¦w¸Ë¡A±z¥²¶·½T»{
CRDB_JavaServer.ini
Àɮפ¤ªº¸ô®|¸ê°T¡C¸ô®|¸ê°T¥²¶·¥¿½T²Å¦X CRDBXMLExternal.jar
©M CRDBJavaServer.jar
Àɮתº¹ê»Ú¦ì¸m¡C½d¨ÒÀɮצb¸ô®|¤¤¨Ï¥Î^¤å¸ê®Æ§¨¦WºÙ¡F±z¥i¯à»Ýn¥[¥H×§ï¡A¥H²Å¦X¹q¸£¤W¨Ï¥Îªº·í¦a»y¨t¤Æ¸ê®Æ§¨¦WºÙ¡C
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´yz (XSD)¡A¤]¥i¥[¥H«ü©w¡C¦p»ÝÃö©óµ²ºc´yz©M¨Ï¥Î¤èªkªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´yz¡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´yz (XSD)¡A´N¥i¥H«ü©wµ²ºc´yz©M¥¦ªºÅçÃÒ¾ÌÃÒ¡C¦p»ÝÃö©óµ²ºc´yz©M¨Ï¥Î¤èªkªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\µ²ºc´yz¡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´yz¬O³z¹L Web ªA°È¬[ºcl¥Íªº¡A¦Ó¤£¬O¤â°Ê«ü©wªº¡C
Web ªA°È¸ê®Æ¨Ó·½¬O¸g¥Ñ WSDL (Web ªA°È´yz»y¨¥) ¨Ó¦s¨ú¡AWSDL ¬O´yz Web ªA°Èªº¼Ð·Ç®æ¦¡¡C«ü©w WSDL ¤§«á¡AÅX°Êµ{¦¡´N·|Åý±z¿ï¨ú·Qn¨Ï¥ÎªºªA°È¡B³s±µ°ð©M¤èªk¡C
µ²ºc´yz
¨Ï¥Î XML ÅX°Êµ{¦¡®É¡A±z¥i¥H¿ï¾Ü«ü©wµ²ºc´yz (XSD) ©Î¤å¥óÃþ«¬©w¸q (DTD)¡A©Î¬O¨Ï¥Î¤º´O©ó XML ¤å¥óªºµ²ºc´yz¸ê°T¡Cµ²ºc´yz¬O¥Î¨Ó¨M©w¦p¦ó¦b Crystal Reports ¤º§e²{ XML ¸ê®Æ¡C
ª`·N: ·í±z«ü©wn¥Î©ó XML Àɮתºµ²ºc´yz®É¡A´N·|¨Ï¥Î«ü©wªºµ²ºc´yz¡A¦Ó¤£¬O¨Ï¥Î¤º´O©ó XML ÀɮשΨ䥻¨©Ò°Ñ¦Òªºµ²ºc´yz¸ê°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´yz¶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´yz³Ì¥~°¼ (®Ú) ¤¸¯À¬O¨Ó¦Û XSD ©Î DTD ®É¡A·|Åã¥Ü©Ò¦³¥i¯àªº®Ú¥Ø¿ý¡A¦Ó±z¥²¶·¿ï¨ú®Ú¥Ø¿ý°µ¬°¸ê®Æ³s½uªº¤@³¡¤À¡C
HTTP °Ñ¼Æ
·í±z¿ï¨ú HTTP(S) ¸ê®Æ¨Ó·½®É¡A¤]¥i¥H©w¸qn¶Ç»¼µ¹°ò¦ 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 °Ñ¼Æ
- ¦b [HTTP °Ñ¼Æ] µe±¤W¡A«ö¤@¤U [¥[¤JÄÝ©Ê]¡C
- ¦b [½s¿èÄÝ©ÊÈ] µe±¤Wªº [ÄÝ©Ê] Äæ¦ì¤¤¡A¿é¤J°Ñ¼Æªº¦WºÙ¡C
- ¦b [È] Äæ¦ì¤¤¡A¥H @Prompt ¨ç¦¡ªº§Î¦¡¿é¤J°Ñ¼Æ¤½¦¡¡C
°Ñ¼Æ¤½¦¡
°Ñ¼Æ¤½¦¡n¨Ï¥Î @Prompt ¨ç¦¡¨Ó«Ø¥ß¡C¦pªG±z·Qn¦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ӰѼƷ|´yz¨ç¦¡¶Ç¦^ªº¸ê®ÆÃþ«¬¡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³æ«hn¬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·QnªºÈ¡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 °µ¬°¸ê®Æ¨Ó·½
- ¦b Crystal Reports ªº [ÀÉ®×] ¥\¯àªí¤W¡A«ö¤@¤U [·s¼W]¡C
- «ö¤@¤U [¨Ï¥Î³øªíºëÆF]¡C
- ¦b [¿ï¾ÜºëÆF] ²M³æ¤¤«ö¤@¤U [¼Ð·Ç]¡AµM«á«ö¤@¤U [½T©w]¡C
- ¦b³øªí«Ø¥ßºëÆFªº [¸ê®Æ] µe±¤W¡A«ö¨â¤U [«Ø¥ß·s³s½u]¡C
- «ö¨â¤U [XML]¡C
·|¥X²{ [XML] ¹ï¸Ü¤è¶ô¡C
- ¿ï¾Ü XML ¸ê®Æ¨Ó·½¦s¨úÃþ«¬¡G
- ¥»¾÷¸ê®Æ¨Ó·½
¦p»ÝÃö©ó³oºØ¸ê®Æ¨Ó·½¦s¨úÃþ«¬ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\¥»¾÷¸ê®Æ¨Ó·½¡C
- HTTP(S) ¸ê®Æ¨Ó·½
¦p»ÝÃö©ó³oºØ¸ê®Æ¨Ó·½¦s¨úÃþ«¬ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\HTTP(S) ¸ê®Æ¨Ó·½¡C
- Web ªA°È¸ê®Æ¨Ó·½
¦p»ÝÃö©ó³oºØ¸ê®Æ¨Ó·½¦s¨úÃþ«¬ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\Web ªA°È¸ê®Æ¨Ó·½¡C
- ¨Ì·Ó¤U¦C¨ä¤¤¤@¸`ªº¨BÆJ¡A¥iÃѧOn³s½uªº XML ÀɮסG
³s½u¨ì¥»¾÷¸ê®Æ¨Ó·½
- ¦pªG¿ï¾Ü [¨Ï¥Î¥»¾÷¸ê®Æ¨Ó·½]¡A½Ð¿é¤J XML Àɮתº§¹¾ã¸ô®|©M¦WºÙ¡A©Î¨Ï¥ÎÄæ¦ì®ÇÃ䪺«ö¶s¥H·j´MÀɮסC
- ¦pªGn®M¥Îµ²ºc´yz¦Ü¿ï¨úªº XML ÀɮסA½Ð¿ï¾Ü [«ü©wµ²ºc´yzÀÉ®×]¡C
°£«D XML ÀÉ®×¥]§t¤º´Oªºµ²ºc´yz¸ê°T¡A§_«h±z¥²¶·¿ï¨ú³oÓ¿ï¶µ¨Ã«ü©wµ²ºc´yz¡C
ª`·N: µ²ºc´yz¦ì¸m©M¦WºÙªº©w¸q¡A¬O¦b¤U¤@Óµe±¤¤§¹¦¨¡C
- «ö¤@¤U [Next]¡C
®Ú¾Ú¤W¤@Ó¨BÆJªº¿ï¾Ü¡A·|Åã¥Ü¥i¥H«ü©wµ²ºc´yzªºµe±¡FY¤£«ü©w¡A´N«ö¤@¤U [§¹¦¨] «ö¶s¡C
- ¦pªGn«ü©wµ²ºc´yzÀɮסA½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´yz] ©Î [¨Ï¥Î HTTP(S) µ²ºc´yz]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
- ¦pªG¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´yz]¡A½Ð¿é¤Jµ²ºc´yzÀÉ®× (XSD) ªº§¹¾ã¸ô®|©M¦WºÙ¡A©Î¨Ï¥ÎÄæ¦ì®ÇÃ䪺«ö¶s¥H·j´MÀɮסC
- ¦pªG¿ï¾Ü [¨Ï¥Î HTTP(S) µ²ºc´yz]¡A½Ð¿é¤J«ü¦Vµ²ºc´yzÀÉ®× (XSD) ªº URL¡C
- «ö¤@¤U [¤U¤@¨B]¡AµM«á«ö¤@¤U [§¹¦¨]¡C
³s½u¨ì HTTP(S) ¸ê®Æ¨Ó·½
- ¦pªG¿ï¾Ü [¨Ï¥Î HTTP(S) ¸ê®Æ¨Ó·½]¡A½Ð¿é¤J«ü¦V XML Àɮתº URL¡C
±z¥i¥H¨Ï¥Î HTTP ©Î HTTPS ¨Ó©w¸q URL¡C
- ¦pªGn®M¥Îµ²ºc´yz¦Ü¿ï¨úªº XML ÀɮסA½Ð¿ï¾Ü [«ü©wµ²ºc´yzÀÉ®×]¡C
°£«D XML ÀÉ®×¥]§t¤º´Oªºµ²ºc´yz¸ê°T¡A§_«h±z¥²¶·¿ï¨ú³oÓ¿ï¶µ¨Ã«ü©wµ²ºc´yz¡C
ª`·N: µ²ºc´yz¦ì¸m©M¦WºÙªº©w¸q¡A¬O¦b±µ¤U¨Óªºµe±¤¤§¹¦¨¡C
- «ö¤@¤U [Next]¡C
- ¦p¦³¥²n¡A½Ð¿é¤JÅçÃÒ¸ê°T¡AµM«á¦A¦¸«ö¤@¤U [¤U¤@¨B]¡C
®Ú¾Ú¨BÆJ 2 ªº¿ï¾Ü¡A·|Åã¥Ü¥i¥H«ü©wµ²ºc´yzªºµe±©Î©w¸q HTTP °Ñ¼Æªºµe±¡C¦pªG±z¬Ý¨ì [HTTP °Ñ¼Æ] µe±¡A½Ð¸õ¨ì¨BÆJ 6¡C
- ¦pªGn«ü©wµ²ºc´yzÀɮסA½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´yz] ©Î [¨Ï¥Î HTTP(S) µ²ºc´yz]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
- ¦pªG¿ï¾Ü [¨Ï¥Î¥»¾÷µ²ºc´yz]¡A½Ð¿é¤Jµ²ºc´yzÀÉ®× (XSD) ªº§¹¾ã¸ô®|©M¦WºÙ¡A©Î¨Ï¥ÎÄæ¦ì®ÇÃ䪺«ö¶s¥H·j´MÀɮסC
- ¦pªG¿ï¾Ü [¨Ï¥Î HTTP(S) µ²ºc´yz]¡A½Ð¿é¤J«ü¦Vµ²ºc´yzÀÉ®× (XSD) ªº URL¡C
- ¦b [HTTP °Ñ¼Æ] µe±¤W¡A«Ø¥ß¾A¦X¥[¤J URL ªº°Ñ¼Æ¡A¥H¨î XML Àɮפº¶Ç¦^ªºµ²ªG¡C
- «ö¤@¤U [¥[¤JÄÝ©Ê] ¥H©w¸q·sªºÈ¡C·|¥X²{ [½s¿èÄÝ©ÊÈ] ¹ï¸Ü¤è¶ô¡C¨Ï¥Î³oÓ¹ï¸Ü¤è¶ô¨Ó©w¸q°Ñ¼Æ¦WºÙ©M¤½¦¡¡C¦p»ÝÃö©ó©w¸q°Ñ¼Æªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\«Ø¥ß XML ÅX°Êµ{¦¡ªº HTTP °Ñ¼Æ¡C
- «ö¤@¤U [½s¿è¼ÆÈ] ¥HÅܧó²{¦³°Ñ¼Æ¡C¦b«ö¤U³oÓ«ö¶s¤§«e¡A½Ð¥ý¿ï¨ún½s¿èªº°Ñ¼Æ¡C
- «ö¤@¤U [²¾°£ÄÝ©Ê] ¥H§R°£²{¦³°Ñ¼Æ¡C¦b«ö¤U³oÓ«ö¶s¤§«e¡A½Ð¥ý¿ï¨ún²¾°£ªº°Ñ¼Æ¡C
- ¦b [HTTP °Ñ¼Æ] µe±¤¤¿é¤J§¹²¦®É¡A½Ð«ö¤@¤U [§¹¦¨] ¡C
³s½u¨ì Web ªA°È¸ê®Æ¨Ó·½
- ¦pªG¿ï¾Ü [¨Ï¥Î Web ªA°È¸ê®Æ¨Ó·½]¡A½Ð«ö¤@¤U [¤U¤@¨B] ¥HÄ~Äò°õ¦æ¨BÆJ¡C
- ¦pªGn«ü©w Web ªA°ÈÀɮצì¸m¡A½Ð¿ï¾Ü [¨Ï¥Î¥»¾÷ WSDL] ©Î [¨Ï¥Î HTTP(S) WSDL]¡AµM«á§¹¦¨®ÇÃäªºÄæ¦ì¡C
- ¦pªG¿ï¾Ü [¨Ï¥Î¥»¾÷ WSDL]¡A½Ð¿é¤J Web ªA°ÈÀɮתº§¹¾ã¸ô®|©M¦WºÙ¡A©Î¨Ï¥ÎÄæ¦ì®ÇÃ䪺«ö¶s¥H·j´MÀɮסC
- ¦pªG¿ï¾Ü [¨Ï¥Î HTTP(S) WSDL]¡A½Ð¿é¤J«ü¦V Web ªA°ÈÀɮתº URL¡C
- «ö¤@¤U [Next]¡C
®Ú¾Ú¤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
- ¦p¦³¥²n¡A½Ð¿é¤JÅçÃÒ¸ê°T¡AµM«á«ö¤@¤U [¤U¤@¨B]¡C
- ¦b [Web ªA°È¡B³s±µ°ð©M¤èªk] µe±¤W¡A±q²M³æ¤¤¿ï¾ÜªA°È¡B³s±µ°ð©M¤èªk¡C
- «ö¤@¤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±zn¨Ï¥Îªºª©¥»¡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 ©ÎªÌ¡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²zn¨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±zn³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ºÙ¡CY¬O WebLogic¡A«h¬° weblogic.jndi.WLInitialContextFactory ¡CY¬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 °Ñ¼Æ·|«ü©wn¼ÒÀÀ¨ä¦æ¬°ªºÅX°Êµ{¦¡¡C®Ú¾Ú¹w³]¡A·|³]©w¼ÒÀÀ DB2 JDBC ÅX°Êµ{¦¡ªº¦æ¬°¡C¦pªG«O¯d³oÓ³]©w¡A¥Nªí±z·Qn±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´yzÀɮתº¹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´yzÀɪº¹w³]³s½u URL¡C³oÓ¹w³]È·|¦b±z«Ø¥ß¨Ï¥Î HTTP(S) ªº·s XML ¸ê®Æ³s½u®É¡AÅã¥Ü©ó Crystal Reports¡C |