A GUI Interface To Oracle?
Discussion
I need to knock up a Browser based GUI to an Oracle database.
The database will be quite small to include Usernames and the allocation of IP Addresses during call setup.
I will need to setup a reasonably complex heirarchy of IP Pools - and then assign Addresses from these pools to specific users.
Consequently I'm thinking some nice tree views of the group heirarchy would be good.
So what technology should I be looking at - ideally we'd like the GUI to be browser based. Target platfor is Linux for Oracle but the clients will likely be on Windoze boxes.
Any pointers to get me going?
many thanks
Ex
The database will be quite small to include Usernames and the allocation of IP Addresses during call setup.
I will need to setup a reasonably complex heirarchy of IP Pools - and then assign Addresses from these pools to specific users.
Consequently I'm thinking some nice tree views of the group heirarchy would be good.
So what technology should I be looking at - ideally we'd like the GUI to be browser based. Target platfor is Linux for Oracle but the clients will likely be on Windoze boxes.
Any pointers to get me going?
many thanks
Ex
size13 said:
PHP is about the easiest way you could go.
But you'll need the Oracle client installling on the server and php setup to access it.
I was thinking that - otherwise I guess I'm writing Applets to run on the client machine?
How does J2EE work?
best
Ex
>> Edited by TheExcession on Tuesday 1st February 13:58
Full blown J2EE is overkill. Could do it in Servlets/JSP, but then again, you could do it in PHP, Perl anything you like. Just depends what scripting language you're happiest with.
If you really want to use applets, you don't need to use J2EE on the back end, they could still talk to a PHP script or whatever.
If you really want to use applets, you don't need to use J2EE on the back end, they could still talk to a PHP script or whatever.
TheExcession said:Don't know the answer to that but if you've .NET experience and depending upon deployment requirements you could write a Windows client and using the zero-footprint installation technology...
Oh yeah, forgot to mention - I feckin hate writing HTML...
So are there any data aware controls that could be leveraged a bit like ASP.NET?
asp.net can talk to Oracle (stored procs) using odp.net as glue (this is a freebie download). MS's equivalent is ADO.net, haven't used that one though. You can do all your webby stuff in asp.net, and talk to database via web server directly. Oracle now includes native xmltype ideal for passing info back and forth between d/b and front end
Any of the langauages mentioned can do it - real question for you is which are you familiar with or have someone who knows the lang.
Java/JSP would be pretty easy but dones't do a lot for you in terms of automated controls unless you go find some 3rd party bits.
.NET - you can choose from VB/C# and the toolkit and dev env will do a lot of the config and deployment work for you.
Depending on the need for ease of maintenance I'd stear clear of Perl and PHP. Particularly if it's something that's going to be handed over to someone else to manage. Finding people to maintain them could be tricky (even though they're not hard).
I quite like the abstraction gained from SOAP and Web Services to keep you presentation and business layers separate. It also means that (if required in future) you can access the web services from pretty much anything and anywhere.
I prefer Java (coz it's not M$) but .Net is really very good and Visual Studio rocks.
Java/JSP would be pretty easy but dones't do a lot for you in terms of automated controls unless you go find some 3rd party bits.
.NET - you can choose from VB/C# and the toolkit and dev env will do a lot of the config and deployment work for you.
Depending on the need for ease of maintenance I'd stear clear of Perl and PHP. Particularly if it's something that's going to be handed over to someone else to manage. Finding people to maintain them could be tricky (even though they're not hard).
I quite like the abstraction gained from SOAP and Web Services to keep you presentation and business layers separate. It also means that (if required in future) you can access the web services from pretty much anything and anywhere.
I prefer Java (coz it's not M$) but .Net is really very good and Visual Studio rocks.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff