创建一个简单的用户界面来访问Oracle数据库 [英] Creating a simple user interface to access an Oracle database

问题描述

这里是我有：
1）一个简单的sql文件给我，创建表和填充数据
2）一个简单的sql文件，包含PL / SQL程序我写了用于显示/操作表格

目标是创建某种用户界面，允许学生登录，查看其成绩单，退出课程等。 p>

我使用sqlplus。我有程序，做所有需要的显示/操作。我成功地用sqlplus创建一个简单的命令行UI，但是当我需要在一个循环中获得用户输入（允许他们看到任何数目的课程的课程信息，直到他们想返回主菜单）。经过研究，我得知这将是像PHP，C等的工作。不幸的是，我不熟练任何语言要求，并且设置扩展和这样被证明是非常复杂。

我有能力学习必要的技巧来完成这个，但我不知道去哪个方向。什么是最简单的实现一个简单的用户界面？我应该使用PHP吗？ C？ C ++？是否有某种程序可以自动创建简单的UI给定数据库数据？

解决方案

Oracle Apex完美适合您的情况。您可以轻松地创建基于Web的表单和报告，以执行所有CRUD操作。此外，您可以免费使用任何已授权的Oracle数据库： Oracle Application Express

Here is what I have: 1) a simple sql file given to me that creates tables and fills them with data 2) a simple sql file that contains PL/SQL procedures I've written for displaying/manipulating the tables

The goal is to create some sort of user interface that allows a student to login, view their transcript, withdraw from classes, etc.

I am using sqlplus. I have procedures that do all the required displaying/manipulating. I am successful at creating a simple command line UI with sqlplus, but the problem arrives when I need to get user input inside a loop (for allowing them to see course information for any number of courses until they wish to go back to the main menu). After doing research, I learned that this would be the job of something like PHP, C, etc. Unfortunately, I am not proficient in any language required, and setting up extensions and such have proven to be extremely complicated.

I am capable of learning the necessary techniques to complete this, but I do not know which direction to go in. What is easiest to implement a simple UI? Should I use PHP? C? C++? Is there some sort of program out there that automatically creates simple UIs given database data?

解决方案

Oracle Apex is perfect for your situation. You can easily create web based forms and reports to perform all CRUD operations. Plus, it's free to use with any licensed Oracle database: Oracle Application Express

这篇关于创建一个简单的用户界面来访问Oracle数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！