Cisco Service Control Management Suite Collection Manager 锟斤拷锟絒锟経锟終锟紺锟絟 Rel. 3.1

锟斤拷锟教復偱偼丄锟絝锟絒锟絕锟絰锟絒锟絏锟狡楢锟斤拷锟斤拷锟斤拷锟介偨锟竭傦拷 Cisco Service Control Management Suite锟絠SCMS锟絡Collection Manager锟絠CM锟絡锟教愝掞拷锟紷锟紸CM 锟教婡锟絓锟斤拷锟絞锟斤拷锟斤拷锟斤拷锟介偨锟竭偺僨锟絒锟絕锟絰锟絒锟絏锟紺锟斤拷锟絫锟斤拷锟絏锟絞锟斤拷锟絅锟絗锟斤拷锟教巊锟絧锟斤拷@锟缴偮傦拷锟侥愶拷锟斤拷锟斤拷锟杰傦拷锟紹

Oracle 锟斤拷锟絒锟経锟教僋锟紺锟絙锟絅锟絏锟絕锟絒锟絞锟終锟紺锟絟

CM 锟狡偲傦拷锟斤拷 Oracle 锟絝锟絒锟絕锟絰锟絒锟絏锟斤拷锟絞锟絧锟斤拷锟斤拷蓚蛠AOracle 锟斤拷锟絎锟絁锟斤拷锟斤拷锟� IP 锟紸锟絟锟斤拷锟絏锟斤拷|锟絒锟絞锟饺偳偺婏拷{锟絀锟饺愙戯拷锟絧锟斤拷锟斤拷锟絒锟絕锟斤拷蠉X锟斤拷锟斤拷K锟絭锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟教愝掞拷蠉X锟酵晄锟絭锟脚傦拷锟紹锟斤拷锟教庤弴锟脚偼丄锟終锟絭锟饺曄峏锟缴偮傦拷锟侥愶拷锟斤拷锟斤拷锟侥傦拷锟杰傦拷锟紹

1. CM 锟斤拷锟斤拷锟絪锟斤拷锟教応崌锟酵丄CM 锟斤拷锟絶锟斤拷锟杰傦拷锟紹

2. Oracle 锟斤拷锟絞锟絧锟斤拷锟斤拷鎮わ拷锟� JDBC 锟紸锟絖锟絭锟絕锟斤拷輶鑲碉拷軅锟斤拷B

a. 锟絜锟絃锟絏锟絞锟紾锟絝锟紹锟絕锟脚僼锟紷锟紺锟斤拷 ~scmscm/cm/config/jdbcadapter.conf 锟斤拷锟絁锟斤拷锟杰傦拷锟紹

b. 锟絏锟絞锟斤拷锟斤拷锟絆 db_template_dir 锟斤拷锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

锟斤拷锟教僗锟絞锟斤拷锟斤拷锟絆锟缴偼丄Sybase 锟斤拷 Oracle 锟斤拷 1 锟铰傦拷锟铰丄锟斤拷锟絭 2 锟铰偺峴锟斤拷锟杰傑傦拷膫锟斤拷軅锟斤拷B锟絝锟絫锟紿锟斤拷锟絞锟脚偼丄 Oracle 锟絪锟斤拷锟絉锟斤拷锟斤拷锟絞锟斤拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷B

c. Oracle 锟絪锟斤拷锟絉锟斤拷锟斤拷锟絞锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

d. Sybase 锟絪锟斤拷锟絉锟斤拷锟斤拷锟絞锟斤拷锟斤拷锟杰傦拷锟紹

e. 锟较峏锟斤拷蹜锟斤拷锟斤拷軅锟斤拷B

锟斤拷锟斤拷蛠A锟饺夛拷锟教僐锟絒锟絟锟絫锟斤拷锟絆锟斤拷锟斤拷锟絞锟脚昞锟斤拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷i锟较峏锟斤拷j锟紹

#db_template_dir = dbpacks/sybase
db_template_dir = dbpacks/oracle/9204e/

3. Oracle 锟斤拷锟絞锟絧锟斤拷锟斤拷鎮わ拷锟� Topper/Aggregator锟絠TA锟絡锟紸锟絖锟絭锟絕锟斤拷輶鑲碉拷軅锟斤拷B

a. 锟絜锟絃锟絏锟絞锟紾锟絝锟紹锟絕锟脚僼锟紷锟紺锟斤拷 ~scmscm/cm/config/taadapter.conf 锟斤拷锟絁锟斤拷锟杰傦拷锟紹

b. 锟絏锟絞锟斤拷锟斤拷锟絆 db_template_dir 锟斤拷锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

c. Oracle 锟絪锟斤拷锟絉锟斤拷锟斤拷锟絞锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

d. Sybase 锟絪锟斤拷锟絉锟斤拷锟斤拷锟絞锟斤拷锟斤拷锟杰傦拷锟紹

e. 锟较峏锟斤拷蹜锟斤拷锟斤拷軅锟斤拷B

锟斤拷锟斤拷蛠A锟饺夛拷锟教僐锟絒锟絟锟絫锟斤拷锟絆锟斤拷锟斤拷锟絞锟脚昞锟斤拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷i锟较峏锟斤拷j锟紹

#db_template_dir = dbpacks/sybase
db_template_dir = dbpacks/oracle/9204e/

4. 锟絝锟絒锟絕锟絰锟絒锟絏锟节戯拷锟絧锟斤拷锟斤拷锟絒锟絕锟斤拷輶鑲碉拷軅锟斤拷B

a. 锟絜锟絃锟絏锟絞锟紾锟絝锟紹锟絕锟脚僼锟紷锟紺锟斤拷 ~scmscm/cm/config/dbpacks/oracle/9204e/dbinfo.vm 锟斤拷锟絁锟斤拷锟杰傦拷锟紹

b. 锟饺夛拷锟教峴锟斤拷蠉X锟斤拷锟侥愝掞拷饠綁f锟斤拷锟斤拷锟杰傦拷锟紹

#set ($dbinfo.options.host = "localhost")
#set ($dbinfo.options.port = "1521")
#set ($dbinfo.options.user = "pqb_admin")
#set ($dbinfo.options.password = "pqb_admin")
#set ($dbinfo.options.sid = "apricot")

锟絠锟斤拷锟絡 dbinfo.vm 锟絫锟紷锟紺锟斤拷锟酵僔锟紽锟斤拷锟絏锟絅锟斤拷锟絭锟絞锟脚偼傦拷锟斤拷軅锟斤拷锟紹锟絴锟斤拷锟絟锟絃锟斤拷锟絠#锟絡锟酵愰尵锟教堦晹锟脚傦拷锟斤拷A锟絉锟斤拷锟斤拷锟絞锟絃锟斤拷锟脚偼傦拷锟斤拷軅锟斤拷锟紹

锟街楢锟斤拷锟斤拷p锟斤拷锟斤拷锟絒锟絕锟酵庯拷锟教偲傦拷锟斤拷艂锟斤拷B

锟絴 Oracle 锟斤拷锟紺锟斤拷锟絏锟絞锟絒锟斤拷锟斤拷锟疥偨锟絵锟絍锟斤拷锟教儂锟絏锟絞锟斤拷锟杰傦拷锟斤拷 IP 锟紸锟絟锟斤拷锟絏

锟絴 Oracle 锟絋锟絒锟給锟斤拷锟揭傦拷锟襟偗傦拷锟侥傦拷锟斤拷|锟絒锟絞锟教斣嶏拷

锟絴 Oracle 锟缴懳傦拷锟侥擣锟截傦拷锟介偨锟竭偺冿拷锟絒锟経锟斤拷锟斤拷锟斤拷褍p锟絏锟斤拷锟絒锟絟

锟絴 CM 锟脚巊锟絧锟斤拷锟斤拷锟斤拷 Oracle SID锟絠锟絋锟絒锟絩锟絏 ID锟絡

c. 锟较峏锟斤拷蹜锟斤拷锟斤拷軅锟斤拷B

5. CM 锟斤拷锟絅锟斤拷锟斤拷锟杰傦拷锟紹

Velocity Template Language

JDBC 锟紸锟絖锟絭锟絕锟絫锟斤拷锟絒锟斤拷锟斤拷锟絒锟絅锟斤拷 Velocity Template Language锟絠VTL锟絡锟脚婰锟絨锟斤拷锟疥偨锟絵锟絅锟斤拷锟斤拷锟絞锟絧锟斤拷锟侥丄锟絝锟絒锟絕锟絰锟絒锟絏锟絋锟絒锟給锟缴搉锟斤拷锟斤拷閭凤拷讉膫锟� SQL 锟絉锟絒锟絟锟金惗愶拷锟斤拷锟杰傦拷锟紹锟饺夛拷锟教僙锟絅锟絍锟斤拷锟斤拷锟脚偼丄锟斤拷锟斤拷锟絭锟斤拷锟絑锟絏锟金惂屼偡锟介偨锟竭偵巊锟絧锟斤拷锟斤拷锟絉锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟缴偮傦拷锟侥愶拷锟斤拷锟斤拷锟杰傦拷锟紹

Apache Jakarta Project 锟教堦晹锟脚傦拷锟斤拷 VTL 锟教婏拷锟絊锟饺嶲锟狡愶拷蓚聜锟斤拷膫蛠AWeb 锟絋锟紺锟絞http://jakarta.apache.org/velocity/vtl-reference-guide.html 锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

锟饺夛拷锟教昞锟酵丄VTL 锟絓锟斤拷锟斤拷锟饺扨锟缴愶拷锟斤拷锟斤拷锟斤拷锟斤拷锟教偱傦拷锟紹

锟絓6-1 VTL 锟絓锟斤拷锟教奣锟絭
锟絝锟紹锟斤拷锟絅锟絜锟紹锟絬	锟絓锟斤拷锟斤拷	锟节揑
#foreach	#foreach ($item in $collection) item is $item #end	锟絉锟斤拷锟絅锟絍锟斤拷锟斤拷锟紸锟絲锟斤拷A锟杰傦拷锟酵儅锟絙锟絭锟缴懳傦拷锟侥忥拷锟斤拷锟金斀曪拷锟斤拷锟杰傦拷锟紹
#if ... #else ... #elseif	#if ($order.total == 0) No charge #end	锟斤拷锟斤拷锟絏锟絜锟絒锟絞锟斤拷锟斤拷锟絞
#parse	#parse("header.vm")	锟絯锟借偝锟疥偨锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟斤拷锟絒锟絟锟斤拷锟斤拷褖锟酵傦拷锟侥丄锟斤拷锟斤拷锟斤拷锟疥偨锟給锟酵偵庯拷鑽烇拷輦軅锟斤拷B
#macro	#macro(currency $amount) ${formatter.currency($amount)} #end	锟絍锟斤拷锟斤拷锟絝锟紹锟斤拷锟絅锟絜锟紹锟絬锟斤拷锟斤拷褧K锟絭锟饺傦拷锟阶偰偺僷锟斤拷锟斤拷锟絒锟絕锟斤拷锟絗锟斤拷锟杰傦拷锟紹锟斤拷锟绞偼丄锟斤拷锟狡偱傦拷锟教僥锟斤拷锟絭锟斤拷锟絒锟絞锟脚巊锟絧锟斤拷锟斤拷陯囷拷蓧锟斤拷邆锟斤拷锟杰傦拷锟紹
#include	#include("disclaimer.txt")	锟絯锟借偝锟疥偨锟絫锟紷锟紺锟斤拷锟斤拷锟斤拷锟教傑傑丄锟斤拷锟斤拷锟斤拷锟疥偨锟給锟酵偵娷傔傑傦拷锟紹
#set	#set ($customer = ${order.customer})	锟絉锟斤拷锟絜锟絃锟絏锟絞锟絀锟絬锟絎锟紽锟絅锟絞锟缴抣锟斤拷锟斤拷锟借摉锟侥傑傦拷锟紹锟絉锟斤拷锟絜锟絃锟絏锟絞锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟斤拷锟捷傦拷锟饺傦拷锟疥崌锟酵丄锟絣锟斤拷锟角夛拷锟斤拷锟斤拷軅锟斤拷B锟絉锟斤拷锟絜锟絃锟絏锟絞锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟斤拷锟捷傦拷锟斤拷陯囷拷蛠A锟絣锟斤拷锟絬锟斤拷锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹
#stop	#if ($debug) #stop #end	锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟斤拷锟斤拷锟絶锟斤拷锟杰傦拷锟紹

锟絝锟絒锟絕锟絰锟絒锟絏锟絉锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷

锟絝锟絒锟絕锟絰锟絒锟絏锟紸锟絅锟絑锟絏锟絫锟斤拷锟絒锟斤拷锟斤拷锟絒锟絅锟斤拷锟斤拷锟斤拷锟斤拷陯囷拷A锟脚忥拷锟缴岋拷锟斤拷锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟斤拷 main.vm 锟脚傦拷锟紹锟斤拷锟教僼锟紷锟紺锟斤拷锟缴偼丄锟終锟絭锟饺傦拷锟阶偰偺僨锟絒锟絕锟絰锟絒锟絏 SQL 锟斤拷`锟杰傦拷锟酵掞拷`锟缴懳傦拷锟斤拷|锟紺锟斤拷锟絕锟斤拷锟絠锟絒锟斤拷锟斤拷膫锟斤拷軅锟斤拷B锟斤拷锟教僼锟紷锟紺锟斤拷锟教岋拷锟斤拷锟疥強锟酵丄CM 锟脚巊锟絧锟斤拷锟斤拷锟� dbpack 锟缴傦拷锟斤拷膶锟斤拷軅锟杰傦拷锟紹dbpack 锟酵丄锟斤拷锟斤拷虄f锟絒锟絕锟絰锟絒锟絏锟紺锟斤拷锟絏锟絞锟斤拷锟絒锟絍锟斤拷锟斤拷锟缴娭楢锟斤拷锟斤拷锟紸锟教僐锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟脚傦拷锟紹锟絠锟斤拷锟教僐锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟缴娭楢锟矫傦拷锟斤拷陚斤拷j锟紸锟絖锟絭锟絕锟斤拷 dbpack 锟斤拷I锟斤拷锟斤拷锟杰傦拷锟紹锟斤拷锟狡傦拷锟轿丄锟斤拷锟缴庯拷锟斤拷 jdbcadapter.conf 锟絫锟紷锟紺锟斤拷锟教堦晹锟酵丄Oracle dbpack 锟狡楢锟絞锟斤拷锟斤拷鎮わ拷蓛A锟絖锟絭锟絕锟斤拷輶鑲碉拷軅锟斤拷B

db_template_dir = dbpacks/oracle/9204e/
db_template_file = main.vm

锟絠锟斤拷锟絡锟絝锟紹锟斤拷锟絅锟絞锟斤拷锟教応強锟酵丄锟斤拷锟紺锟斤拷锟斤拷 CM 锟捷掞拷f锟紹锟斤拷锟絅锟絞锟斤拷锟絠锟绞忥拷锟� ~scmscm/cm/config 锟絡锟缴懳傦拷锟侥戯拷锟轿揑锟缴夛拷锟竭傦拷锟斤拷軅锟�

锟捷掞拷锟斤拷锟斤拷W锟斤拷锟絒锟斤拷锟斤拷锟斤拷锟斤拷蓚蛠A main.vm 锟絫锟紷锟紺锟斤拷锟斤拷锟斤拷锟教戯拷锟教僼锟紷锟紺锟斤拷锟斤拷锟絴锟紺锟斤拷锟絞锟斤拷锟杰傦拷锟紹锟斤拷锟斤拷锟斤拷锟紸锟斤拷锟絎锟斤拷锟絒锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟缴昁锟絭锟饺傢偗锟脚偼傦拷锟斤拷軅锟斤拷锟紹锟斤拷锟教僼锟紷锟紺锟斤拷锟缴偼擟锟接偺掞拷`锟斤拷锟絠锟絒锟斤拷锟紸锟絏锟絅锟斤拷锟絭锟絞锟斤拷锟饺偳偱丄锟斤拷锟狡偱巊锟絧锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹锟疥晹锟教掞拷`锟斤拷 JDBC锟紸锟絖锟絭锟絕锟教擄拷锟斤拷蓭g锟絧锟斤拷锟斤拷閭斤拷邅A锟終锟絳锟脚傦拷锟紹锟斤拷锟教昞锟缴丄锟斤拷锟斤拷锟教掞拷`锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

锟絓6-2 锟終锟絳 VM 锟斤拷`
锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷	锟終锟絳锟教掞拷`
$table.sql.dropTable $table.sql.createTable $table.sql.createIndexes $table.sql.insert $table.sql.metaDataQuery	锟斤拷锟斤拷锟教愝掞拷蛠A锟絜锟絒锟絬锟斤拷锟斤拷锟狡偵丄锟絯锟斤拷虖锟斤拷锟斤拷蓱蝹锟斤拷锟� SQL 锟教愶拷锟斤拷锟斤拷@锟金惂屼偟锟杰傦拷锟紹
$dbinfo.driverjarfile $dbinfo.driver	JDBC 锟絟锟斤拷锟紺锟給锟教応強锟斤拷锟斤拷褍N锟斤拷锟絏锟斤拷
$dbinfo.cmdSeparator	锟斤拷锟斤拷锟斤拷 SQL 锟絏锟絜锟絒锟絞锟斤拷锟斤拷锟絞锟斤拷锟斤拷貍閭斤拷邆蓭g锟絧锟斤拷锟斤拷锟絧锟絕锟絒锟斤拷
$dbinfo.url $dbinfo.connOptions	锟絝锟絒锟絕锟絰锟絒锟絏锟缴愙戯拷锟斤拷锟介偨锟竭傦拷 URL锟紸锟斤拷锟斤拷褦C锟接偺愙戯拷锟絭锟斤拷锟絧锟絜锟紹

VTL 锟斤拷蛢R锟斤拷锟絜锟絃锟絏锟絞锟缴娷傑傦拷锟� CM 锟捷掞拷锟絓锟斤拷锟絀锟絬锟絎锟紽锟絅锟絞锟教傦拷锟斤拷锟教傦拷锟斤拷锟铰傦拷锟酵丄锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟脚巊锟絧锟脚傦拷锟斤拷鎮わ拷蓚葌锟斤拷膫锟斤拷軅锟斤拷B锟斤拷锟斤拷锟教僆锟絬锟絎锟紽锟絅锟絞锟缴偮傦拷锟侥偼丄锟斤拷锟教僙锟絅锟絍锟斤拷锟斤拷锟脚愶拷锟斤拷锟斤拷锟杰傦拷锟紹

･锟絉锟斤拷锟絜锟絃锟絏锟絞锟絀锟絬锟絎锟紽锟絅锟絞

･锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟教愝掞拷

锟絉锟斤拷锟絜锟絃锟絏锟絞锟絀锟絬锟絎锟紽锟絅锟絞

VM 锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟斤拷锟絒锟絟锟斤拷锟侥丄CM 锟絉锟斤拷锟絴锟絒锟絣锟斤拷锟絞锟絠TA 锟杰傦拷锟斤拷 JDBC 锟紸锟絖锟絭锟絕锟紸锟絏锟絅锟斤拷锟絭锟絞锟饺偳乯锟脚夛拷蛡锟斤拷锟絆锟缴丄锟斤拷锟斤拷 Java 锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟絞锟絧锟斤拷锟侥夛拷蛢R锟斤拷锟絜锟絃锟絏锟絞锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

･ tables 锟絀锟絬锟絎锟紽锟絅锟絞

･ dbinfo 锟絀锟絬锟絎锟紽锟絅锟絞

･ tools 锟絀锟絬锟絎锟紽锟絅锟絞

tables 锟絀锟絬锟絎锟紽锟絅锟絞

tables 锟絀锟絬锟絎锟紽锟絅锟絞锟酵丄锟絝锟絒锟絕锟絰锟絒锟絏锟缴奿锟絒锟斤拷锟斤拷K锟絭锟斤拷锟斤拷锟斤拷 RDR 锟教峔锟斤拷锟紸锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟教峔锟斤拷锟狡傦拷锟教奿锟絒锟疥強锟紸锟斤拷锟斤拷锟� CM 锟脚巊锟絧锟脚傦拷锟介偦锟教戯拷锟教僨锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟教峔锟斤拷锟饺偳丄锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟缴娭楢锟斤拷锟斤拷f锟絒锟絕锟絰锟絒锟絏锟捷掞拷蓚聜锟斤拷膼锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟教僆锟絬锟絎锟紽锟絅锟絞锟酵丄CM 锟脚巊锟絧锟斤拷锟斤拷锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟斤拷1锟铰傦拷锟絜锟絪锟脚昞锟斤拷锟絲锟斤拷艂锟斤拷B锟絜锟絜锟絒锟絬锟斤拷锟教峴锟缴偼丄锟斤拷锟教忥拷锟斤拷锟絠锟絒锟脚傦拷锟杰傦拷锟絠锟疥晹锟教僥锟絒锟絬锟斤拷锟缴娭楢锟斤拷锟饺傦拷锟斤拷锟节傦拷锟斤拷锟斤拷軅锟斤拷j锟紹

･锟絖锟斤拷锟斤拷

･锟斤拷锟斤拷锟斤拷

･锟斤拷锟教僥锟絒锟絬锟斤拷锟缴娭楢锟絫锟斤拷锟斤拷陚� RDR 锟絕锟絆

･锟斤拷锟疥偧锟疥師锟教戯拷锟斤拷锟斤拷锟斤拷锟铰丄锟斤拷锟教僥锟絒锟絬锟斤拷锟斤拷锟教僼锟紹锟絒锟斤拷锟絟锟杰傦拷锟酵僇锟斤拷锟斤拷锟教冿拷锟絏锟絞

锟絴锟絫锟紹锟絒锟斤拷锟絟 ID

锟絴锟絫锟紹锟絒锟斤拷锟絟锟斤拷

锟絴锟絫锟紹锟絒锟斤拷锟絟锟脚桳锟教僞锟紺锟絭

锟絴锟斤拷锟絉锟絗锟斤拷锟教僼锟紹锟絒锟斤拷锟絟锟絀锟絭锟絍锟斤拷锟斤拷

･锟斤拷锟疥偧锟疥師锟教戯拷锟斤拷锟斤拷锟斤拷锟铰丄锟斤拷锟教僥锟絒锟絬锟斤拷锟教僀锟斤拷锟絝锟絙锟絅锟絏锟斤拷锟絏锟絞

锟絴锟紺锟斤拷锟絝锟絙锟絅锟絏锟斤拷

锟絴锟紺锟斤拷锟絝锟絙锟絅锟絏锟絫锟斤拷锟絁锟斤拷锟斤拷锟斤拷

锟絴锟斤拷锟絉锟絗锟斤拷锟教僀锟斤拷锟絝锟絙锟絅锟絏锟絀锟絭锟絍锟斤拷锟斤拷

tables 锟絀锟絬锟絎锟紽锟絅锟絞锟教擄拷锟絜锟酵丄锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟斤拷锟絒锟絟锟斤拷锟斤拷苽锟斤拷蓲锟斤拷讉锟斤拷锟紸锟斤拷锟届偡锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹 tables 锟絀锟絬锟絎锟紽锟絅锟絞锟酵丄锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟脚桳锟斤拷 XML 锟絉锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟斤拷锟絞锟絧锟斤拷锟侥忥拷锟斤拷锟斤拷軅锟斤拷B 锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟教愝掞拷锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

dbinfo 锟絀锟絬锟絎锟紽锟絅锟絞

dbinfo 锟絀锟絬锟絎锟紽锟絅锟絞锟酵丄锟絝锟絒锟絕锟絰锟絒锟絏锟节戯拷锟斤拷锟絁锟斤拷锟狡傦拷锟缴巊锟絧锟斤拷锟斤拷锟絧锟斤拷锟斤拷锟絒锟絕锟紸锟絞锟絧锟斤拷锟斤拷锟� SID 锟斤拷X锟絃锟絒锟絵锟饺偳丄锟絝锟絒锟絕锟絰锟絒锟絏锟脚桳锟教愝掞拷蓚聜锟斤拷膼锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟教僆锟絬锟絎锟紽锟絅锟絞锟缴偼丄锟絝锟絒锟絕锟絰锟絒锟絏锟脚桳锟教愝掞拷I锟絭锟絍锟斤拷锟斤拷锟斤拷锟桔庯拷锟斤拷锟斤拷軅锟斤拷B锟桔庯拷锟斤拷锟斤拷锟斤拷锟酵丄锟斤拷锟教偲傦拷锟斤拷艂锟斤拷B

･锟斤拷锟教僨锟絒锟絕锟絰锟絒锟絏锟教僪锟斤拷锟紺锟給锟狡傦拷锟侥巊锟絧锟斤拷锟斤拷锟� JDBC 锟絅锟斤拷锟絏锟斤拷

･锟絟锟斤拷锟紺锟給锟斤拷锟絠锟絒锟斤拷锟疥偨 JAR 锟絫锟紷锟紺锟斤拷锟教栵拷锟絆

･ JDBC URL 锟狡傦拷锟侥昞锟斤拷锟疥偨锟絝锟絒锟絕锟絰锟絒锟絏锟教応強

･锟紽锟截僨锟絒锟絕锟絠锟斤拷锟絒锟経锟斤拷锟斤拷褍p锟絏锟斤拷锟絒锟絟锟絡锟饺偳偺庯拷锟絉锟絗锟斤拷锟斤拷 JDBC 锟节戯拷锟絀锟絭锟絍锟斤拷锟斤拷

tools 锟絀锟絬锟絎锟紽锟絅锟絞

tools 锟絀锟絬锟絎锟紽锟絅锟絞锟酵丄锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟絁锟斤拷锟斤拷锟斤拷陯囷拷锟紸锟絉锟斤拷锟絜锟絃锟絏锟絞锟絝锟絒锟絕锟絓锟斤拷锟金憖嶌偡锟斤拷陯囷拷蓶饤聝锟斤拷[锟絜锟紹锟斤拷锟絜锟紹锟斤拷锟絓锟絙锟絟锟斤拷锟斤拷锟斤拷锟铰傦拷锟杰傓僐锟斤拷锟絜锟絠锟脚傦拷锟紹

锟絀锟絬锟絎锟紽锟絅锟絞锟教冿拷锟絓锟絙锟絟锟斤拷 $tools.method(arg1, ..., argN) 锟狡傦拷锟侥屇傃弌锟斤拷锟斤拷锟狡傦拷锟脚傦拷锟杰傦拷锟紹 method 锟酵冿拷锟絓锟絙锟絟锟斤拷锟脚傦拷锟紹

锟斤拷锟教昞锟缴丄锟杰傑傦拷膫锟斤拷閮侊拷\锟絙锟絟锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

锟絓6-3 tools 锟絀锟絬锟絎锟紽锟絅锟絞锟教冿拷锟絓锟絙锟絟锟絋锟絭
锟斤拷锟絓锟絙锟絟锟斤拷锟狡堬拷	锟紷锟絓
getTableByName (allTables, name)	锟絖锟斤拷锟斤拷锟斤拷 name 锟缴懳夛拷锟斤拷锟斤拷f锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟斤拷锟給锟斤拷锟杰傦拷锟紹
getTableByDbTabName (allTables, name)	锟斤拷锟斤拷锟斤拷锟斤拷 name 锟缴懳夛拷锟斤拷锟斤拷f锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟斤拷锟給锟斤拷锟杰傦拷锟紹
assignParams (sql, list_of_args)	sql 锟斤拷锟斤拷锟斤拷锟斤拷虌^锟解晞锟斤拷锟斤拷锟斤拷锟紸锟斤拷锟斤拷锟斤拷艜\锟斤拷锟斤拷锟� list_of_args 锟絧锟斤拷锟斤拷锟絒锟絕锟斤拷锟教楢锟斤拷锟絭锟絝锟脚抲锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹锟斤拷锟教冿拷锟絓锟絙锟絟锟酵丄锟絰锟絒锟絏锟狡傦拷锟斤拷 JDBC Prepared Statement 锟斤拷锟斤拷锟斤拷锟斤拷g锟絧锟斤拷锟斤拷 SQL 锟絵锟斤拷X锟絜锟絒锟絞锟斤拷锟斤拷锟絞锟斤拷锟届惉锟斤拷锟斤拷e锟斤拷锟絭锟斤拷锟絒锟絞锟脚嶏拷苽锟斤拷膫锟斤拷锟疥崌锟缴栶棫傦拷锟杰傦拷锟紹
collapseWhitespace()	锟斤拷锟斤拷锟教楢锟斤拷锟絏锟統锟絒锟絏锟斤拷锟斤拷锟斤拷锟斤拷葌閭凤拷讉膫虄C锟斤拷锟絏锟絕锟斤拷锟絏锟斤拷 1 锟铰偺僗锟統锟絒锟絏锟缴曄婏拷锟斤拷锟侥丄锟芥摢锟斤拷锟斤拷褨锟斤拷锟斤拷虄X锟統锟絒锟絏锟斤拷锟巾彍锟斤拷锟杰傦拷锟紹锟斤拷锟教冿拷锟絓锟絙锟絟锟酵丄锟斤拷锟饺傦拷锟狡傦拷 1 锟铰偺怴锟終锟絪锟狡戯拷锟教僗锟統锟絒锟絏锟斤拷锟斤拷锟斤拷锟杰傑傦拷膫锟斤拷锟� SQL 锟斤拷锟終锟絭锟饺僨锟絒锟絕锟絰锟絒锟絏锟脚曋楋拷锟脚傦拷锟絠Sybase 锟斤拷 Oracle 锟酵傦拷锟疥偑锟絪锟絭锟脚傦拷锟絡锟紹

锟斤拷锟斤拷锟教僣锟絒锟斤拷锟教巊锟絧锟斤拷蓚聜锟斤拷膫蛠A 锟絏锟絅锟斤拷锟絭锟絞锟脚傦拷 JDBC 锟絫锟斤拷锟絒锟斤拷锟斤拷锟絒锟絅锟教巊锟絧锟紷锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟教愝掞拷

锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟缴娭楢锟斤拷锟介偡锟阶偰偺愝掞拷蛠A锟斤拷锟教嶏拷锟节傦拷锟絠锟絒锟斤拷锟疥偨锟斤拷锟斤拷虄t锟紷锟紺锟斤拷锟絠 tables.xml 锟絡锟斤拷锟脚峴锟斤拷锟杰傦拷锟紹

･锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷锟教栵拷锟絆锟斤拷锟斤拷褍o锟絒锟絎锟斤拷锟斤拷

･锟絜锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟教栵拷锟絆锟狡僾锟斤拷锟絧锟絜锟紹锟紸锟斤拷锟缴丄锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟缴奿锟絒锟斤拷锟斤拷锟紸锟絭锟斤拷锟絇锟絒锟絍锟斤拷锟斤拷 RDR 锟教峔锟斤拷

･锟絜锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟街楢:

锟絴锟絜锟絒锟絬锟斤拷锟斤拷锟斤拷锟� RDR 锟絫锟紹锟絒锟斤拷锟絟锟教栵拷锟絆锟斤拷锟斤拷褜艞L锟教僞锟紺锟絭

锟絴锟絜锟絒锟絬锟斤拷锟紺锟斤拷锟絝锟絙锟絅锟絏锟教栵拷锟絆锟斤拷锟斤拷褍v锟斤拷锟絧锟絜锟紹

锟斤拷锟教忥拷锟酵丄锟斤拷蓛R锟斤拷锟絜锟絃锟絏锟絞锟斤拷锟斤拷蛡锟斤拷锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷 tables 锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷莻輱锟斤拷迯陯囷拷蓭g锟絧锟斤拷锟斤拷軅锟斤拷B tables 锟絀锟絬锟絎锟紽锟絅锟絞锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

锟斤拷茥锟�

main.vm 锟絫锟紷锟紺锟斤拷锟缴偼丄锟斤拷锟絎锟斤拷锟絒锟斤拷锟斤拷锟斤拷锟絋锟絴锟絒锟絞锟斤拷锟介偨锟竭偵戯拷锟斤拷 VM 锟絫锟紷锟紺锟斤拷锟教嶲锟狡傦拷锟杰傑傦拷膫锟斤拷軅锟斤拷i 锟絝锟絒锟絕锟絰锟絒锟絏锟絉锟斤拷锟絫锟紹锟組锟斤拷锟斤拷锟絒锟絍锟斤拷锟斤拷锟絫锟紷锟紺锟斤拷锟斤拷锟絈锟狡乯锟紹锟斤拷锟絆锟斤拷锟斤拷锟絆锟缴岋拷锟竭傦拷锟侥傦拷锟斤拷 VM_global_library.vm 锟絫锟紷锟紺锟斤拷锟斤拷锟斤拷锟斤拷锟紸锟斤拷锟斤拷锟教戯拷锟教僼锟紷锟紺锟斤拷锟斤拷锟酵擟锟接偱傦拷锟紹锟斤拷`锟斤拷锟終锟絭锟饺傦拷锟阶偰偺儅锟絅锟斤拷锟斤拷锟斤拷锟教僼锟紷锟紺锟斤拷锟缴奿锟絒锟斤拷锟侥丄锟絵锟絅锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷蓛锟斤拷[锟絟锟斤拷锟斤拷锟芥偆锟缴傦拷锟斤拷K锟絭锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟教擄拷锟绞側僼锟紷锟紺锟斤拷锟教徻嵶偵偮傦拷锟侥偼丄锟絯 Velocity User Guide 锟絰锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

锟饺夛拷锟教僒锟斤拷锟絭锟斤拷锟酵丄Oracle 锟絑锟絙锟絞锟紸锟絙锟絭锟斤拷 main.vm 锟教僐锟斤拷锟絜锟斤拷锟絚锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟教偱傦拷锟紹

#parse ('dbinfo.vm')
#foreach ($table in $tables)
#set ($table.sql.dropTable = "#parse ('drop_table.vm')")
#set ($table.sql.createTable = "#parse ('create_table.vm')")
#set ($table.sql.createIndexes = "#parse ('create_indexes.vm')")
#set ($table.sql.insert = "#parse ('insert.vm')")
#set ($table.sql.metaDataQuery = "#parse ('metadata.vm')")
#end

锟斤拷锟教僒锟斤拷锟絭锟斤拷锟脚偼丄锟終锟絳锟教僨锟絒锟絕锟絰锟絒锟絏锟斤拷锟斤拷锟� SQL 锟斤拷`锟絠锟絓6-2 锟絡锟斤拷锟绞乆锟教僼锟紷锟紺锟斤拷锟缴堏擄拷锟斤拷锟斤拷膫锟斤拷膩A #parse 锟絝锟紹锟斤拷锟絅锟絜锟紹锟絬锟斤拷锟絞锟絧锟斤拷锟侥冿拷锟絒锟絟锟斤拷锟斤拷褖锟酵傦拷锟斤拷軅锟斤拷B

锟斤拷锟教僙锟絅锟絍锟斤拷锟斤拷锟脚偼丄Oracle dbpack 锟斤拷锟教奺锟絫锟紷锟紺锟斤拷锟教擄拷锟絜锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹锟斤拷`锟教堦晹锟脚偼丄
VM_global_library.vm 锟絫锟紷锟紺锟斤拷锟缴掞拷`锟斤拷锟疥偨锟絵锟絅锟斤拷锟斤拷锟絞锟絧锟斤拷锟杰傦拷锟紹锟斤拷锟教僼锟紷锟紺锟斤拷锟缴偼丄锟斤拷锟阶偰偺僥锟斤拷锟絭锟斤拷锟絒锟絞锟脚巊锟絧锟斤拷锟斤拷閭凤拷讉膫虄}锟絅锟斤拷锟斤拷`锟斤拷锟絠锟絒锟斤拷锟斤拷K锟絭锟斤拷锟斤拷锟斤拷軅锟斤拷B

･锟絵锟絅锟斤拷锟教掞拷`

･ dbinfo 锟教愝掞拷

･ SQL 锟教掞拷`

锟絵锟絅锟斤拷锟教掞拷`

锟斤拷锟缴丄锟脚桳锟教僞锟紺锟絭锟斤拷 SQL 锟絕锟紺锟絭锟皆偺儅锟絙锟絪锟斤拷锟絆锟教掞拷`锟斤拷A锟斤拷锟斤拷褍锟斤拷X锟絞锟斤拷锟教楢锟斤拷锟斤拷锟斤拷v锟絝锟皆偵僇锟斤拷锟絵锟斤拷}锟斤拷锟� optcomma 锟絵锟絅锟斤拷锟饺偳偺冿拷锟絒锟絜锟紹锟斤拷锟絜锟紹锟絵锟絅锟斤拷锟教掞拷`锟絋锟斤拷锟絭锟斤拷锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹

#macro (optcomma)#if ($velocityCount >1),#end#end
#macro (sqltype $field)
#set ($maxStringLen = 2000)
#if ($field.type == "INT8") integer
#elseif ($field.type == "INT16") integer
#elseif ($field.type == "INT32") integer
#elseif ($field.type == "UINT8") integer
#elseif ($field.type == "UINT16") integer
#elseif ($field.type == "UINT32") integer
#elseif ($field.type == "REAL") real
#elseif ($field.type == "BOOLEAN") char(1)
#elseif ($field.type == "STRING") varchar2(#if($field.size <= $maxStringLen)$field.size #else $maxStringLen #end)
#elseif ($field.type == "TEXT") long
#elseif ($field.type == "TIMESTAMP") date
#end
#end

dbinfo 锟教愝掞拷

锟饺夛拷锟教僐锟絒锟絟锟絋锟斤拷锟絭锟斤拷锟脚偼丄URL 锟斤拷锟斤拷褠趹锟斤拷I锟絭锟絍锟斤拷锟斤拷锟絠锟紽锟截梡锟絡锟斤拷锟紹锟斤拷虝K锟絳锟絫锟紹锟絒锟斤拷锟絟锟脚傦拷锟紹

锟絉锟絒锟絟锟教嬻敀峴锟酵丄锟角傒傗偡锟斤拷锟斤拷锟紸锟杰傦拷锟斤拷锟狡偱愝掞拷蠉X锟斤拷锟斤拷锟解偡锟斤拷锟斤拷锟介偨锟竭偵丄锟絉锟絒锟絟锟斤拷锟铰暿偺僼锟紹锟絒锟斤拷锟絟锟缴曪拷锟斤拷锟斤拷锟斤拷锟斤拷虃艂锟斤拷B

#set ($dbinfo.driver = "oracle.jdbc.OracleDriver")
#set ($dbinfo.driverjarfile = "ojdbc14.jar")
#set ($dbinfo.options.host = "localhost")
#set ($dbinfo.options.port = "1521")
#set ($dbinfo.options.user = "pqb_admin")
#set ($dbinfo.options.password = "pqb_admin")
#set ($dbinfo.options.sid = "apricot")
#set ($dbinfo.url = "jdbc:oracle:thin:@$dbinfo.options.host:$dbinfo.options.port:$dbinfo.options.sid")
#set ($dbinfo.connOptions.user = $dbinfo.options.user)
#set ($dbinfo.connOptions.password = $dbinfo.options.password)
## the vendor-specific piece of SQL that will return the current
## date and time:
#set ($dbinfo.options.getdate = "sysdate")

SQL 锟教掞拷`

･锟絬drop table锟絭锟教僐锟絒锟絟

･锟絬create table锟絭锟教僐锟絒锟絟

･锟絬create indexes锟絭锟教僐锟絒锟絟

･锟絬insert锟絭锟教僐锟絒锟絟

･锟斤拷锟絕锟絝锟絒锟絕锟絅锟紾锟斤拷锟絒锟教僐锟絒锟絟

锟絬drop table锟絭锟教僐锟絒锟絟

锟斤拷锟教僒锟斤拷锟絭锟斤拷锟絉锟絒锟絟锟酵丄锟绞忥拷锟� SQL 锟絓锟斤拷锟斤拷锟絞锟絧锟斤拷锟侥僥锟絒锟絬锟斤拷锟斤拷锟巾彍锟斤拷锟杰傦拷锟紹

drop table $table.dbtabname

锟絬create table锟絭锟教僐锟絒锟絟

锟斤拷锟教僒锟斤拷锟絭锟斤拷锟絉锟絒锟絟锟酵丄锟绞忥拷锟� SQL 锟絓锟斤拷锟斤拷锟絞锟絧锟斤拷锟侥僥锟絒锟絬锟斤拷锟斤拷锟届惉锟斤拷锟杰傦拷锟紹锟絜锟絒锟絬锟斤拷锟届惉锟絧锟教擄拷锟斤拷葍f锟紹锟斤拷锟絅锟絜锟紹锟絬锟斤拷锟終锟絭锟狡側傦拷C锟接偺僇锟絏锟絕锟絵锟紺锟結锟较傒僨锟絒锟絕锟絰锟絒锟絏锟捷掞拷蛠A锟斤拷锟教掞拷`锟斤拷锟絞锟絧锟斤拷锟侥庯拷锟斤拷锟脚傦拷锟杰傦拷锟紹锟斤拷锟狡傦拷锟轿丄锟斤拷锟界偐锟教堬拷觽锟� tablespace 锟斤拷锟缴僥锟絒锟絬锟斤拷锟斤拷锟届惉锟斤拷锟斤拷锟斤拷A锟絜锟絒锟絬锟斤拷锟斤拷锟絧锟絒锟絜锟紹锟絍锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷鎮わ拷蓙A锟斤拷锟教掞拷`锟斤拷蠉X锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹

create table $table.dbtabname (
#foreach ($field in $table.fields)
#optcomma()$field.name #sqltype($field)
#if ("$!field.options.notnull" == "true")
not null
#end
#end)

锟絬create indexes锟絭锟教僐锟絒锟絟

锟斤拷锟教僐锟絒锟絟锟酵丄锟绞忥拷锟� SQL 锟絓锟斤拷锟斤拷锟絞锟絧锟斤拷锟侥僀锟斤拷锟絝锟絙锟絅锟絏锟斤拷锟届惉锟斤拷锟杰傦拷锟紹锟紺锟斤拷锟絝锟絙锟絅锟絏锟届惉锟絧锟教擄拷锟斤拷葍f锟紹锟斤拷锟絅锟絜锟紹锟絬锟斤拷锟終锟絭锟狡側傦拷C锟接偺僇锟絏锟絕锟絵锟紺锟結锟较傒僨锟絒锟絕锟絰锟絒锟絏锟捷掞拷蛠A锟斤拷锟教掞拷`锟斤拷锟絞锟絧锟斤拷锟侥庯拷锟斤拷锟脚傦拷锟杰傦拷锟紹锟斤拷锟狡傦拷锟轿丄锟斤拷锟界偐锟教堬拷觽锟� tablespace 锟斤拷锟缴僀锟斤拷锟絝锟絙锟絅锟絏锟斤拷锟届惉锟斤拷锟斤拷鎮わ拷蓙A锟斤拷锟教掞拷`锟斤拷蠉X锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹

#foreach ($index in $table.indexes)
create index $index.name on $table.dbtabname ($index.columns)
#end

锟絬insert锟絭锟教僐锟絒锟絟

锟斤拷锟教僐锟絒锟絟锟酵丄锟絜锟絒锟絬锟斤拷锟絓锟斤拷锟缴懳夛拷锟斤拷锟斤拷 JDBC Prepared Statement 锟紺锟絝锟紹锟絀锟斤拷锟斤拷锟届惉锟斤拷锟杰傦拷锟紹

insert into ${table.dbtabname} (
#foreach ($field in $table.fields)
#optcomma()${field.name}
#end)
values (
#foreach ($field in $table.fields)
#optcomma()?
#end)

锟斤拷锟絕锟絝锟絒锟絕锟絅锟紾锟斤拷锟絒锟教僐锟絒锟絟

锟斤拷锟教僐锟絒锟絟锟酵丄锟絜锟絒锟絬锟斤拷锟教冿拷锟絕锟絝锟絒锟絕锟絠锟絁锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷褍^锟紺锟絭锟絡锟斤拷锟芥摼锟斤拷锟介偨锟竭偵巊锟絧锟斤拷锟斤拷锟絍锟斤拷锟絭锟斤拷锟饺僋锟紾锟斤拷锟絒锟斤拷锟絗锟斤拷锟杰傦拷锟紹锟斤拷虒锟斤拷蕛Z锟絙锟絞锟斤拷邆锟斤拷N锟紾锟斤拷锟絒锟斤拷锟絞锟絧锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹

select * from ${table.dbtabname} where 1=0

锟絜锟絏锟絞锟斤拷锟斤拷褍f锟給锟絙锟絆

锟絝锟絒锟絕锟絰锟絒锟絏锟教堬拷A锟教僥锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟届惉锟斤拷锟斤拷陯囷拷蓙A锟斤拷蛯锟斤拷蕚饞紣趲Q锟狡偱傦拷锟斤拷茣謼锟斤拷艂锟斤拷B锟斤拷锟教婡锟絓锟斤拷锟斤拷锟斤拷锟斤拷锟介偨锟竭偵丄JDBC 锟紸锟絖锟絭锟絕锟斤拷 CM 锟斤拷锟紺锟斤拷锟絏锟絅锟斤拷锟絭锟絞 ~scmscm/cm/bin/cm 锟缴傦拷閽硷拷趯膫褟o锟斤拷锟斤拷锟絋锟絴锟絒锟絞锟斤拷锟侥傦拷锟杰傦拷锟紹

锟斤拷锟教傛偆锟饺屇傃弌锟斤拷锟教堬拷蕧\锟斤拷锟酵丄锟斤拷锟教偲傦拷锟斤拷艂锟斤拷B

~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter argument

argument 锟酵丄锟斤拷锟教僙锟絅锟絍锟斤拷锟斤拷锟脚愶拷锟斤拷锟斤拷锟斤拷锟絫锟斤拷锟絆锟斤拷 1 锟铰偱傦拷锟紹锟斤拷锟教冿拷锟絁锟絡锟結锟斤拷锟酵丄CM 锟斤拷锟斤拷锟届偟锟侥傦拷锟介偐锟角傦拷锟斤拷锟缴娭學锟饺傦拷锟絞锟絧锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹

锟杰傦拷锟紸锟斤拷锟教僙锟絅锟絍锟斤拷锟斤拷锟缴婰锟节傦拷锟疥偨锟絅锟紾锟斤拷锟絒锟斤拷锟斤拷褝X锟絍锟教庯拷锟絪锟斤拷锟絓锟絙锟絟锟斤拷锟絞锟絧锟斤拷锟斤拷苼A锟斤拷锟届拞锟教僨锟絒锟絕锟絰锟絒锟絏锟缴懳傦拷锟斤拷e锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟绞傦拷锟絜锟絏锟絞锟脚傦拷锟杰傦拷锟紹

･锟斤拷锟斤拷锟斤拷虊锟斤拷

･锟斤拷锟絊锟絝锟給锟絙锟絆锟斤拷锟教庢摼

锟斤拷锟斤拷锟斤拷虊锟斤拷

锟斤拷锟阶偰偺曪拷锟斤拷锟斤拷蛠A锟絉锟斤拷锟絜锟絃锟絏锟絞锟絊锟教傦拷锟終锟截側応崌锟紸VTL 锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟狡傦拷锟侥夛拷蛡艂锟斤拷軅锟斤拷B锟斤拷蛯锟斤拷蕚蛠A锟絎锟斤拷锟給锟酵偵昞锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟斤拷锟斤拷锟斤拷锟酵傦拷锟斤拷蓚蛠A-parse 锟絫锟斤拷锟絆锟斤拷锟絯锟借偟锟侥丄锟紸锟絖锟絭锟絕锟斤拷锟侥傃弌锟斤拷锟杰傦拷锟紹锟斤拷锟缴丄锟斤拷锟斤拷锟斤拷锟斤拷聜锟斤拷锟斤拷锟斤拷軅锟斤拷i锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷 锟脚庯拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷j锟紹

$ ~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter -parse 'xxx'

xxx

$ ~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter -parse '$dbinfo.url'

jdbc:oracle:thin:@localhost:1521:apricot

$ ~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter -parse '$tools.getTableByName($tables, "LUR").sql.createTable'

create table RPT_LUR (

TIME_STAMP date

,RECORD_SOURCE integer

,LINK_ID integer

,GENERATOR_ID integer

,SERVICE_ID integer

,CONFIGURED_DURATION integer

,DURATION integer

,END_TIME integer

,UPSTREAM_VOLUME integer

,DOWNSTREAM_VOLUME integer

,SESSIONS integer

)

锟斤拷锟絊锟絝锟給锟絙锟絆锟斤拷锟教庢摼

锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟缴傦拷锟斤拷膷鞇拷锟斤拷陚� tables 锟斤拷锟斤拷锟� dbinfo 锟絓锟斤拷锟教傦拷锟阶偰偺擄拷锟絜锟教僟锟斤拷锟絭锟斤拷\锟斤拷锟斤拷锟斤拷蓚蛠A -debug 锟絫锟斤拷锟絆锟斤拷锟絞锟絧锟斤拷锟杰傦拷锟紹锟斤拷锟教僼锟斤拷锟絆锟斤拷锟絞锟絧锟斤拷锟斤拷苼A锟斤拷锟斤拷锟教峔锟斤拷锟教傦拷锟阶偰偺僼锟紹锟絒锟斤拷锟絟锟紸锟絭锟斤拷锟絧锟絜锟紹锟紸锟斤拷锟斤拷褍I锟絭锟絍锟斤拷锟斤拷锟教徻嵶傦拷锟絎锟斤拷锟給锟酵偵弌锟酵傦拷锟斤拷軅锟斤拷B

锟絏锟絅锟斤拷锟絭锟絞锟脚傦拷 JDBC 锟絫锟斤拷锟絒锟斤拷锟斤拷锟絒锟絅锟教巊锟絧锟紷

锟紺锟接傦拷 SQL 锟絉锟絵锟斤拷锟絟锟斤拷锟絝锟絒锟絕锟絰锟絒锟絏锟缴戯拷锟組锟斤拷锟侥庯拷锟絪锟斤拷锟斤拷锟斤拷A锟届惉锟斤拷锟疥偨锟絝锟絒锟絕锟斤拷\锟斤拷锟斤拷锟斤拷锟借偡锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟紹锟斤拷锟教曪拷@锟酵丄锟斤拷锟絀锟缴僨锟絒锟絕锟絰锟絒锟絏锟斤拷锟斤拷锟斤拷锟絜锟絠锟斤拷锟絏锟斤拷锟斤拷锟斤拷A锟絝锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟教擄拷锟絜锟斤拷锟斤拷锟絡锟絕锟斤拷锟斤拷锟斤拷A锟角夛拷锟教僨锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟斤拷锟角楋拷锟斤拷锟斤拷陯囷拷葌莻蓶饤聜锟斤拷苽锟斤拷锟斤拷锟杰傦拷锟紹

update 锟斤拷锟斤拷锟斤拷锟斤拷锟絪锟斤拷锟斤拷蓚蛠A -executeUpdate 锟絫锟斤拷锟絆锟斤拷锟絯锟借偟锟侥傾锟絖锟絭锟絕锟斤拷锟侥傃弌锟斤拷锟杰傦拷锟紹锟絅锟紾锟斤拷锟絒锟斤拷锟斤拷锟絪锟斤拷锟侥丄锟斤拷锟绞傦拷\锟斤拷锟斤拷锟斤拷蓚蛠A -executeQuery 锟絫锟斤拷锟絆锟斤拷锟絯锟借偟锟侥傾锟絖锟絭锟絕锟斤拷锟侥傃弌锟斤拷锟杰傦拷锟紹

･ SCE 锟斤拷锟皆懷僆锟絫锟絑锟絙锟絞锟教昞锟斤拷锟斤拷锟斤拷褠輶锟絋锟斤拷锟絭锟斤拷

SCE 锟斤拷锟皆懷僆锟絫锟絑锟絙锟絞锟教昞锟斤拷锟斤拷锟斤拷褠輶锟絋锟斤拷锟絭锟斤拷

锟斤拷锟斤拷 update 锟斤拷锟斤拷锟教僒锟斤拷锟絭锟斤拷锟酵丄Service Control Engine锟絠SCE锟絡锟斤拷锟皆懷僆锟絫锟絑锟絙锟絞锟捷掞拷锟桔庯拷锟斤拷锟斤拷f锟絒锟絕锟絰锟絒锟絏锟絜锟絒锟絬锟斤拷锟斤拷锟教抣锟斤拷锟絭锟斤拷锟絆锟斤拷锟斤拷锟脚曄峏锟斤拷锟斤拷锟紷锟斤拷锟斤拷锟斤拷锟侥傦拷锟杰傦拷锟紹锟斤拷锟教僥锟絒锟絬锟斤拷锟教栵拷锟絆锟酵丄锟绞忥拷 JCONF_SE_TZ_OFFSET 锟脚傦拷锟紹锟絜锟絒锟絬锟斤拷锟缴暿偺栵拷锟絆锟斤拷锟斤拷锟借摉锟侥傦拷锟侥傦拷锟斤拷聰\锟斤拷锟斤拷锟斤拷锟介偨锟竭丄锟斤拷锟斤拷锟脚偼榑锟斤拷锟斤拷 TZ 锟脚屇傃傑傦拷锟紹 tables.xml 锟絫锟紷锟紺锟斤拷锟教冿拷锟絏锟絞锟斤拷锟絈锟狡傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

锟絜锟絒锟絬锟斤拷锟教桳锟斤拷锟斤拷锟脚忥拷锟缴妋锟紽锟斤拷锟侥傦拷锟斤拷X锟絍锟斤拷锟斤拷K锟絭锟斤拷锟饺傦拷锟芥偆锟缴丄锟絜锟絒锟絬锟斤拷锟斤拷锟巾彍锟斤拷锟侥傦拷锟斤拷i锟絜锟絒锟絬锟斤拷锟斤拷锟斤拷锟捷傦拷锟饺傦拷锟疥崌锟教僄锟斤拷锟絒锟絏锟絜锟絒锟絕锟絏锟酵栵拷锟斤拷锟斤拷锟杰傦拷锟絡锟紸锟絜锟絒锟絬锟斤拷锟斤拷锟侥嶌惉锟斤拷锟紸锟終锟截側抣锟斤拷}锟斤拷軅锟斤拷B锟絜锟絒锟絬锟斤拷锟缴偼僞锟紺锟斤拷锟絏锟絕锟斤拷锟絭锟絁锟斤拷锟斤拷锟斤拷锟杰傑傦拷膫锟斤拷閭斤拷邅A锟絝锟絒锟絕锟絰锟絒锟絏锟斤拷锟教岋拷锟捷擄拷t锟斤拷锟芥摼锟斤拷锟斤拷K锟絭锟斤拷锟斤拷锟斤拷軅锟斤拷B锟斤拷锟教忥拷锟斤拷锟酵奺锟絝锟絒锟絕锟絰锟絒锟絏锟絰锟斤拷锟絖锟絒锟脚屌桳锟饺傦拷锟竭丄锟斤拷锟教楋拷艂蛢e锟斤拷锟絭锟斤拷锟絒锟絞锟斤拷锟脚掞拷`锟斤拷锟疥偨锟捷掞拷蟼輦锟� getdate 锟斤拷锟斤拷锟斤拷锟侥傃弌锟斤拷锟侥傦拷锟杰傦拷锟紹

锟絚锟絒锟斤拷 assignParams 锟斤拷锟斤拷锟� getTableByName 锟教巊锟絧锟紷锟缴掞拷锟接傦拷锟侥丄SQL 锟金惗愶拷锟斤拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟紹

#! /bin/bash
this=$0
tableName=TZ
usage () {
cat <<EOF
Usage:
$this --status - show currently configured TZ offset
$this --offset=N - set the offset to N minutes (-1440 <= N <= 1440)
$this --help - print this message
EOF
}
query () {
~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter -executeQuery "$*"
}
update () {
~/cm/bin/cm invoke com.cisco.scmscm.adapters.jdbc.JDBCAdapter -executeUpdate "$*"
}
get_tz () {
query 'select * from $tools.getTableByName($tables, "TZ").dbtabname'
}
set_tz () {
update '$tools.getTableByName($tables, "TZ").sql.dropTable'
update '$tools.getTableByName($tables, "TZ").sql.createTable'
update '$tools.assignParams($tools.getTableByName($tables, "TZ").sql.insert, [$dbinfo.options.getdate, '$1'])'
}
case $1 in
--status)
get_tz
;;
--help)
usage
exit 0
;;
--offset=*)
n=$(echo $1 | egrep 'offset=[-]?[0-9]+$' | sed 's/.*=//')
if [ "$n" ]; then
if [ "$n" -ge -1440 -a "$n" -le 1440 ]; then
set_tz $n &>/dev/null
ok=1
fi
fi
if [ ! "$ok" ]; then
usage
exit 2
fi
get_tz
;;
*)
usage
exit 3
;;
esac

锟斤拷锟絪锟斤拷锟斤拷锟絅锟紾锟斤拷锟絒锟缴傦拷锟斤拷臅詡锟斤拷陚斤拷锟紸锟教岋拷锟绞偼丄锟終锟截側僇锟斤拷锟斤拷锟街僢锟絖锟絒锟斤拷锟絞锟絧锟斤拷锟侥丄锟絓锟絗锟斤拷锟脚昗锟斤拷锟給锟酵偵昞锟斤拷锟斤拷锟斤拷軅锟斤拷B

Oracle 锟教僗锟絇锟絒锟斤拷锟絩锟斤拷锟絜锟紹锟缴娭傦拷锟斤拷q锟斤拷锟絞

锟斤拷锟斤拷2锟铰偺僙锟絅锟絍锟斤拷锟斤拷锟脚偼丄CM 锟脚偺僨锟絒锟絕锟絰锟絒锟絏锟斤拷锟斤拷锟教僗锟絇锟絒锟斤拷锟絩锟斤拷锟絜锟紹锟斤拷锟斤拷锟竭傦拷锟紷锟斤拷锟斤拷锟斤拷锟杰傦拷锟紹锟斤拷锟斤拷锟教曪拷@锟斤拷 Oracle 锟斤拷锟絃锟脚傦拷锟斤拷A锟斤拷锟教婡锟絓锟斤拷锟斤拷锟斤拷锟铰擻锟脚傦拷锟介偙锟狡傦拷锟斤拷锟斤拷锟絇锟饺傦拷q锟斤拷锟絞锟狡傦拷锟侥庯拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷B

･锟絁锟絏锟絕锟斤拷锟絜锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟教巊锟絧锟紷

･锟絜锟絒锟絬锟斤拷锟絧锟絒锟絜锟紹锟絍锟斤拷锟絡锟斤拷锟絆锟教巊锟絧锟紷

锟絁锟絏锟絕锟斤拷锟絜锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟教巊锟絧锟紷

锟斤拷锟斤拷锟教僥锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟斤拷锟届惉锟斤拷锟斤拷膫锟斤拷膩A锟斤拷锟斤拷锟教娫傦拷 CM 锟絜锟絒锟絬锟斤拷锟斤拷z锟組锟斤拷锟斤拷苽锟斤拷軅锟斤拷B锟斤拷锟斤拷锟斤拷葤P锟缴峴锟斤拷锟缴偼丄 tables.xml 锟絫锟紷锟紺锟斤拷锟斤拷锟教奺锟絜锟絒锟絬锟斤拷锟缴懳傦拷锟侥巊锟絧锟斤拷锟斤拷e锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟斤拷锟絯锟借偟锟杰傦拷锟紹1 锟铰偺僥锟絒锟絬锟斤拷锟缴懳傦拷锟侥丄锟斤拷`锟酵庯拷锟教傛偆锟缴側傦拷軅锟斤拷i锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷 锟絉锟絒锟絟锟缴掞拷锟节傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟絡锟紹

锟斤拷锟教僒锟斤拷锟絭锟斤拷锟脚偼丄锟紺锟斤拷锟絝锟絙锟絅锟絏锟斤拷锟斤拷褍e锟絒锟絬锟斤拷锟斤拷锟教偺傦拷锟竭偵丄锟終锟絭锟饺僥锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟絠 tspace1 锟斤拷锟斤拷锟� tspace2 锟絡锟斤拷锟角夛拷锟斤拷锟斤拷膫锟斤拷軅锟斤拷BCM 锟斤拷锟教僆锟絭锟絍锟斤拷锟斤拷锟斤拷 tablespace 锟缴堄栵拷锟酵愝掕偝锟斤拷膫锟斤拷軅锟斤拷锟紹锟紺锟接偺怴锟斤拷锟斤拷锟絀锟絭锟絍锟斤拷锟斤拷锟斤拷锟斤拷锟絞锟絧锟脚傦拷锟杰傦拷锟紹锟接栵拷锟酵丄锟絜锟斤拷锟絭锟斤拷锟絒锟絞锟脚偺嶏拷锟斤拷處g锟絧锟紷锟缴婏拷脗锟斤拷膶锟斤拷鑲碉拷軅锟斤拷B

锟斤拷锟斤拷锟斤拷锟絜锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟斤拷锟缴僥锟絒锟絬锟斤拷锟斤拷锟届惉锟斤拷锟斤拷蓚蛠A create_table.vm 锟斤拷锟斤拷锟教傛偆锟缴曄峏锟斤拷锟杰傦拷锟紹

锟狡庯拷锟教僥锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟斤拷锟缴僀锟斤拷锟絝锟絙锟絅锟絏锟斤拷锟届惉锟斤拷锟斤拷蓚蛠A create_indexes.vm 锟斤拷锟斤拷锟教傛偆锟缴曄峏锟斤拷锟杰傦拷锟紹

#foreach ($index in $table.indexes)
create index $index.name on $table.dbtabname ($index.columns)
#if ("$!index .options.tablespace" != "") TABLESPACE $index.options.tablespace #end #end

锟絜锟絒锟絬锟斤拷锟絧锟絒锟絜锟紹锟絍锟斤拷锟絡锟斤拷锟絆锟教巊锟絧锟紷

锟絋锟絇锟绞偱擄拷锟斤拷虄e锟絒锟絬锟斤拷锟缴冿拷锟絒锟斤拷锟斤拷锟絆锟絧锟絒锟絜锟紹锟絍锟斤拷锟絡锟斤拷锟絆锟斤拷锟斤拷锟斤拷锟斤拷锟介偨锟竭偵丄锟絆锟教僙锟絅锟絍锟斤拷锟斤拷锟教楋拷虃鎮わ拷锟� tables.xml 锟絫锟紷锟紺锟斤拷锟斤拷锟缴丄锟絜锟絒锟絬锟斤拷锟絧锟斤拷 partitioned 锟絀锟絭锟絍锟斤拷锟斤拷锟斤拷锟届惉锟斤拷锟介偙锟狡傦拷锟脚傦拷锟杰傦拷锟絠锟絁锟絏锟絕锟斤拷锟絜锟絒锟絬锟斤拷锟絏锟統锟絒锟絏锟教巊锟絧锟紷锟斤拷锟絈锟狡乯锟紹锟斤拷锟教岋拷A锟斤拷锟教傛偆锟斤拷 create_table.vm 锟絉锟絒锟絟锟斤拷菈锟斤拷锟斤拷軅锟斤拷i锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷 锟絉锟絒锟絟锟缴掞拷锟节傦拷锟侥傦拷锟斤拷锟斤拷锟斤拷锟絡锟紹

create table $table.dbtabname (
#foreach ($field in $table.fields)
#optcomma()$field.name #sqltype($field)
#if ("$!field.options.notnull" == "true")
not null
#end
#end) #if ("$!table.options.partitioned" != "") partition by range (timestamp) (partition week_1 values less than (to_date ('01-JAN-2005 00:00:00','DD-MON-YYYY HH24:MI:SS')), partition week_2 values less than (to_date ('08-JAN-2005 00:00:00','DD-MON-YYYY HH24:MI:SS')) partition week_3 values less than (to_date ('15-JAN-2005 00:00:00','DD-MON-YYYY HH24:MI:SS')) partition week_4 values less than (to_date ('22-JAN-2005 00:00:00','DD-MON-YYYY HH24:MI:SS')) ); #end

Oracle 锟脚偼庯拷锟皆嬶拷锟紼锟缴旓拷钀旓拷\锟斤拷锟斤拷锟絯锟斤拷艂锟斤拷葌锟斤拷锟斤拷邅A锟絜锟絒锟絬锟斤拷锟斤拷锟届惉锟斤拷锟斤拷苽锟斤拷蓲l锟斤拷g锟捷嶏拷锟睫昁锟絭锟斤拷锟斤拷锟斤拷軅锟斤拷B

cron 锟絎锟斤拷锟絬锟斤拷锟届惉锟斤拷锟侥丄锟斤拷锟絋锟絧锟絒锟絜锟紹锟絍锟斤拷锟斤拷锟斤拷锟斤拷锟絒锟斤拷锟斤拷锟絆锟斤拷锟斤拷i锟矫傦拷锟絧锟絒锟絜锟紹锟絍锟斤拷锟斤拷锟斤拷锟巾彍锟斤拷锟侥丄锟絍锟斤拷锟斤拷锟絧锟絒锟絜锟紹锟絍锟斤拷锟斤拷锟斤拷锟届惉锟斤拷锟斤拷j锟斤拷锟狡傦拷锟脚傦拷锟杰傦拷锟紹锟斤拷锟斤拷 cron 锟絎锟斤拷锟絬锟酵丄JDBC 锟紸锟絖锟絭锟絕锟斤拷 CLI锟絠锟絉锟絵锟斤拷锟絟锟斤拷锟紺锟斤拷锟紺锟斤拷锟絕锟絒锟絫锟紽锟紺锟絏锟絡锟斤拷锟侥傃弌锟斤拷锟絠锟絏锟絅锟斤拷锟絭锟絞锟脚傦拷 JDBC 锟絫锟斤拷锟絒锟斤拷锟斤拷锟絒锟絅锟教巊锟絧锟紷锟斤拷锟絈锟狡乯锟紸锟終锟截傦拷 alter table drop partition 锟斤拷锟斤拷锟� alter table add partition SQL 锟絉锟絵锟斤拷锟絟锟斤拷锟斤拷锟絪锟斤拷锟斤拷X锟絅锟斤拷锟絭锟絞锟斤拷锟斤拷锟絪锟斤拷锟杰傦拷锟紹


		嬈庬暿僜儕儏乕僔儑儞 \| 僱僢僩儚乕僉儞僌僜儕儏乕僔儑儞 \| 惢昳 & 僜儕儏乕僔儑儞 \| 峸擖曽朄 \| 僥僋僯僇儖僒億乕僩 \| 僩儗乕僯儞僌 & 僀儀儞僩 \| 僷乕僩僫乕 \| 僔僗僐僔僗僥儉僘儂乕儉 \| 儘僌僀儞 \| 儐乕僓乕搊榐 \| 僼傿乕僪僶僢僋 \| 僿儖僾 © 1992-2008 Cisco Systems, Inc. All rights reserved. 偛棙梡忦審 \| 僾儔僀僶僔乕僗僥乕僩儊儞僩 \| 僋僢僉乕億儕僔乕 \| 僔僗僐偺彜昗

Oracle 锟斤拷锟絒锟経锟教僋锟紺锟絙锟絅 锟絏锟絕锟絒锟絞 锟終锟紺锟絟