打开设计器,并连接到服务器
点击主工具条的【XDOC向导】按钮,打开向导,数据源类型选择“数据库”,点击【下一步】,如下图:
![](http://dl.iteye.com/upload/attachment/426882/086c4eeb-6853-35f7-a5b7-91be845507ff.png)
选择数据库连接“jdbc/orcl”,点击【下一步】,弹出查询设计器对话框,如下图:
![](http://dl.iteye.com/upload/attachment/426884/c634e656-3ae4-34f5-a858-30727f3f2e01.png)
选择scott模式下的dept表,拖拽到查询设计区内,如下图:
![](http://dl.iteye.com/upload/attachment/426886/60348269-c148-3c9e-8d3f-9cdf27845001.png)
点击【确定】,显示设计完成的SQL,如下图:
![](http://dl.iteye.com/upload/attachment/426888/aec7f8a7-0fe2-3589-bd37-b2bcc0ebcc4b.png)
点击【下一步】,进入显示方式,如下图:
![](http://dl.iteye.com/upload/attachment/426890/5ce57fb1-7d59-355d-ba34-7b4a8fc51a9d.png)
点击【下一步】,进入布局选项,如下图:
![](http://dl.iteye.com/upload/attachment/426892/796f7679-02e0-3efb-959c-ca39d40cc1c3.png)
选择“紫色”,模板点击【完成】,结束向导,如下图:
![](http://dl.iteye.com/upload/attachment/426894/ccdbe1da-f68a-3b4a-ad21-e5ed3ab481de.png)
点击【运行】,查看运行结果,如下图:
![](http://dl.iteye.com/upload/attachment/426896/c3026df9-c8de-3cb2-afc8-60589b687579.png)
修改文档属性,设置运行提示为:动态,如下图:
![](http://dl.iteye.com/upload/attachment/426898/0b152edc-0e83-3ae5-b68f-3f218c3aaaaf.png)
部署到服务器中,部署为“部门.xdoc”,在浏览器中查看运行结果,如下图:
![](http://dl.iteye.com/upload/attachment/426900/2c0a40a8-7a63-3420-8ba0-e8e7a66e3c39.png)