数据源已经建好。

6.测试
打开测试视图

输入两个参数,就getexcel的两个参数,第一个参数是文件名,第二个参数是sheet名,
输入:x1: c:/bea/weblogic81/samples/liquiddata/evalguide/excel/test.xls
x2:customers (要区分大小)
执行测试,

测试成功。
7.编译发布数据源。
然后编译整个应用程序,发布data service
发布成功可以在ldconsole里查看:

在bmp中测试data service
data service发布后,就可以在其它java程序中直接使用了。其步骤如下:
4.1添加dataservice控件

4.2 创建方法

4.3 控件生成

data service控件生成后就可以类似使用其它控件一样方便的使用了。
4.4 使用bmp测试
bmp流程如下:

部署应用程序,开始测试:

返回xml为:
<exc:excel xmlns:exc="http://www.bea.com/excel">
<cells>
<cell cellid="aaaa:0001">customer id</cell>
<cell cellid="aaab:0001">customer name</cell>
<cell cellid="aaac:0001">city</cell>
<cell cellid="aaad:0001">sales people id</cell>
<cell cellid="aaaa:0002">2001.0</cell>
<cell cellid="aaab:0002">hoffman</cell>
<cell cellid="aaac:0002">london</cell>
<cell cellid="aaad:0002">1001.0</cell>
<cell cellid="aaaa:0003">2002.0</cell>
<cell cellid="aaab:0003">alex</cell>
<cell cellid="aaac:0003">rome</cell>
<cell cellid="aaad:0003">1003.0</cell>
<cell cellid="aaaa:0004">2003.0</cell>
<cell cellid="aaab:0004">liu</cell>
<cell cellid="aaac:0004">san jose</cell>
<cell cellid="aaad:0004">1002.0</cell>
<cell cellid="aaaa:0005">2004.0</cell>
<cell cellid="aaab:0005">grass</cell>
<cell cellid="aaac:0005">berlin</cell>
<cell cellid="aaad:0005">1002.0</cell>
<cell cellid="aaaa:0006">2006.0</cell>
<cell cellid="aaab:0006">clements</cell>
<cell cellid="aaac:0006">london</cell>
<cell cellid="aaad:0006">1001.0</cell>
<cell cellid="aaaa:0007">2008.0</cell>
<cell cellid="aaab:0007">cisneros</cell>
<cell cellid="aaac:0007">san jose</cell>
<cell cellid="aaad:0007">1007.0</cell>
<cell cellid="aaaa:0008">2007.0</cell>
<cell cellid="aaab:0008">pereira</cell>
<cell cellid="aaac:0008">rome</cell>
<cell cellid="aaad:0008">1004.0</cell>
<cell cellid="aaaa:0009">14031.0</cell>
<cell cellid="aaab:0009"/>
<cell cellid="aaac:0009"/>
<cell cellid="aaad:0009"/>
<cell cellid="aaaa:0010"/>
<cell cellid="aaab:0010"/>
<cell cellid="aaac:0010"/>
<cell cellid="aaad:0010"/>
<cell cellid="aaaa:0011">amount of customer</cell>
<cell cellid="aaab:0011"/>
<cell cellid="aaac:0011">7.0</cell>
<cell cellid="aaad:0011"/>
<cell cellid="aaaa:0012">minimum of rating</cell>
<cell cellid="aaab:0012"/>
<cell cellid="aaac:0012">1001.0</cell>
<cell cellid="aaad:0012"/>
<cell cellid="aaaa:0013">maximum of rating</cell>
<cell cellid="aaab:0013"/>
<cell cellid="aaac:0013">1007.0</cell>
<cell cellid="aaad:0013"/>
<cell cellid="aaaa:0014">average of rating</cell>
<cell cellid="aaab:0014"/>
<cell cellid="aaac:0014">1002.8571428571429</cell>
<cell cellid="aaad:0014"/>
<cell cellid="aaaa:0015"/>
<cell cellid="aaab:0015"/>
<cell cellid="aaac:0015"/>
<cell cellid="aaad:0015"/>
</cells>
<row rowid="0001" rownumber="1">
<col columnid="aaaa" columnname="a">customer id</col>
<col columnid="aaab" columnname="b">customer name</col>
<col columnid="aaac" columnname="c">city</col>
<col columnid="aaad" columnname="d">sales people id</col>
</row>
<row rowid="0002" rownumber="2">
<col columnid="aaaa" columnname="a">2001.0</col>
<col columnid="aaab" columnname="b">hoffman</col>
<col columnid="aaac" columnname="c">london</col>
<col columnid="aaad" columnname="d">1001.0</col>
</row>
<row rowid="0003" rownumber="3">
<col columnid="aaaa" columnname="a">2002.0</col>
<col columnid="aaab" columnname="b">alex</col>
<col columnid="aaac" columnname="c">rome</col>
<col columnid="aaad" columnname="d">1003.0</col>
</row>
<row rowid="0004" rownumber="4">
<col columnid="aaaa" columnname="a">2003.0</col>
<col columnid="aaab" columnname="b">liu</col>
<col columnid="aaac" columnname="c">san jose</col>
<col columnid="aaad" columnname="d">1002.0</col>
</row>
<row rowid="0005" rownumber="5">
<col columnid="aaaa" columnname="a">2004.0</col>
<col columnid="aaab" columnname="b">grass</col>
<col columnid="aaac" columnname="c">berlin</col>
<col columnid="aaad" columnname="d">1002.0</col>
</row>
<row rowid="0006" rownumber="6">
<col columnid="aaaa" columnname="a">2006.0</col>
<col columnid="aaab" columnname="b">clements</col>
<col columnid="aaac" columnname="c">london</col>
<col columnid="aaad" columnname="d">1001.0</col>
</row>
<row rowid="0007" rownumber="7">
<col columnid="aaaa" columnname="a">2008.0</col>
<col columnid="aaab" columnname="b">cisneros</col>
<col columnid="aaac" columnname="c">san jose</col>
<col columnid="aaad" columnname="d">1007.0</col>
</row>
<row rowid="0008" rownumber="8">
<col columnid="aaaa" columnname="a">2007.0</col>
<col columnid="aaab" columnname="b">pereira</col>
<col columnid="aaac" columnname="c">rome</col>
<col columnid="aaad" columnname="d">1004.0</col>
</row>
<row rowid="0009" rownumber="9">
<col columnid="aaaa" columnname="a">14031.0</col>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c"/>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0010" rownumber="10">
<col columnid="aaaa" columnname="a"/>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c"/>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0011" rownumber="11">
<col columnid="aaaa" columnname="a">amount of customer</col>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c">7.0</col>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0012" rownumber="12">
<col columnid="aaaa" columnname="a">minimum of rating</col>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c">1001.0</col>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0013" rownumber="13">
<col columnid="aaaa" columnname="a">maximum of rating</col>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c">1007.0</col>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0014" rownumber="14">
<col columnid="aaaa" columnname="a">average of rating</col>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c">1002.8571428571429</col>
<col columnid="aaad" columnname="d"/>
</row>
<row rowid="0015" rownumber="15">
<col columnid="aaaa" columnname="a"/>
<col columnid="aaab" columnname="b"/>
<col columnid="aaac" columnname="c"/>
<col columnid="aaad" columnname="d"/>
</row>
</exc:excel>
闽公网安备 35060202000074号