使用外部程序控制 Oracle Forms
我在一家使用基于 Forms 的 Oracle 11i 的公司工作。许多员工抱怨数据输入冗余，我想编写一个程序来减轻一些痛苦，因为所有要求 IT 部门这样做的尝试都失败了。
问题是，由于 Oracle Forms 是基于 Java 的，因此没有 Windows 应用程序或基于 HTML 的表单那样的“控件”。有谁知道如何告诉 PC（仅作为示例）单击 RMA 创建表单上的编辑字段 3，然后输入数据？我能够以编程方式导航 Oracle 的唯一方法是使用热键，但它非常不可靠。
我不关心语言或学习新的应用程序来解决这个问题。我目前了解（初级到中级）Java、VB.NET，并将在学校学习 C++。是否有某种工具、桥梁、元素间谍可以让我向表单上的元素发送命令？
编辑
APC sez：Oracle Forms 通过 Web 作为 Java 小程序运行。我提到这一点是因为它可能与您的回答相关。
I work at a company that uses the Forms based Oracle 11i. A lot of employees complain of the redundancy of data entry and I want to write a program that will ease some of that pain since all attempts to ask IT to do it have failed.
The problem is, since Oracle Forms are Java based there are no "controls" as there would be on say a windows application or an HTML based form. Does anyone know of a way to tell the PC to (example only) click edit field 3 on the RMA creation form and then enter the data? The only way I can programmatically navigate Oracle is with hotkeys and it's very unreliable.
I'm not concerned about the language or learning a new application to resolve this issue. I currently know (elementary to Intermediate levels) Java, VB.NET and will be taking C++ in school. Is there a tool, bridge, element spy of some sort that will allow me to send commands to elements on the forms?
edit
APC sez: Oracle Forms over the web run as a Java applet. I mention this because it may be relevant to your responses.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我认为修改 Oracle Forms 屏幕本身会更容易。您可以将 PL/SQL 添加到触发器，这些触发器应该能够完成数据输入所需的大部分任务。
I would think that it would be easier to modify the Oracle Forms screens themselves. You can add PL/SQL to triggers that should be able to accomplish most anything you should need for data entry.
我不知道 Oracle Forms 是胖客户端安装的应用程序、纯 HTML 的 Web 应用程序还是使用 Java applet 运行的 Web 应用程序。以下是一些想法：
对于胖客户端 Windows 应用程序，WinBatch 在模拟用户交互方面做得很好。虽然我从未用它来控制网络应用程序，但它似乎能够做到这一点，只是需要稍微少一点精细控制。
对于测试 Web 应用程序，Selenium 和 HTMLUnit 是两个流行的模拟用户输入的框架。
I'm not familiar whether Oracle Forms is a thick-client installed application, a web application in pure HTML or a web application running withing a Java applet. Here are some thoughts:
For thick-client windows apps, WinBatch does a great job simulating user interaction. I have never used it for controlling web apps though but it seems like it would be able to do it, just with a bit less fine control.
For testing web apps, Selenium and HTMLUnit are two popular frameworks for simulating user input.
我认为您实际上应该能够使用本文档中描述的集成技术来做到这一点 将 Oracle Forms 集成到 Oracle ADF Faces。 Oracle Forms 11g 包含一个新的 JavaScript API，允许从包含的网页调用它。通过这个，您可以在 JS 中创建一些自动化任务流，并允许最终用户根据条件等选择它们。
I think that you should actually be able to do this with the integration techniques described in this doc Integrating Oracle Forms into Oracle ADF Faces. Oracle Forms 11g contains a new JavaScript API to allow calls into it from the containing webpage. Through this you could create some automated task flows in JS and allow the end user to select them based on criteria, etc.