服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > JAVA > 新手入门 > 基础入门 > 查看文档

在adsp中配置excel作为数据源二(组图)


  数据源已经建好。
  
 在adsp中配置excel作为数据源二(组图)(图一)

  6.测试
  
  打开测试视图
  
 在adsp中配置excel作为数据源二(组图)(图二)


  输入两个参数,就getexcel的两个参数,第一个参数是文件名,第二个参数是sheet名,
  
  输入:x1: c:/bea/weblogic81/samples/liquiddata/evalguide/excel/test.xls
  
  x2:customers (要区分大小)
  
  执行测试,
  
 在adsp中配置excel作为数据源二(组图)(图三)

  测试成功。
  
  7.编译发布数据源。
  
  然后编译整个应用程序,发布data service
  
  发布成功可以在ldconsole里查看:
  
 在adsp中配置excel作为数据源二(组图)(图四)

  在bmp中测试data service
  
  data service发布后,就可以在其它java程序中直接使用了。其步骤如下:
  
  4.1添加dataservice控件
  
 在adsp中配置excel作为数据源二(组图)(图五)

  4.2 创建方法
  
 在adsp中配置excel作为数据源二(组图)(图六)

  4.3 控件生成
  
 在adsp中配置excel作为数据源二(组图)(图七)

  data service控件生成后就可以类似使用其它控件一样方便的使用了。
  
  4.4 使用bmp测试
  
  bmp流程如下:
  
 在adsp中配置excel作为数据源二(组图)(图八)

  部署应用程序,开始测试:
  
 在adsp中配置excel作为数据源二(组图)(图九)

  返回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>

扫描关注微信公众号