Database

[Peter Ellis]

Hi

does anyone know the best way to go about creating a database application? I
know quite alot of sql and have access to an oracle server so if i could use
that then it would be great but i don't know if i can or how to do it

if anyone has any advice on what would be the best way to do this then i'd
be really grateful

Steve

[Anthony Borla]

Peter,

"Peter Ellis" <pe********@blu eyonder.co.uk> wrote in message
news:v3******** ********@news-binary.blueyond er.co.uk...

Does anyone know the best way to go about creating a
database application?

I know quite alot of sql and have access to an Oracle server
so if i could use that then it would be great but i don't know
if i can or how to do it

If anyone has any advice on what would be the best way to
do this then i'd be really grateful

You could start by checking out the following tutorial:

http://java.sun.com/docs/books/tutorial/jdbc/index.html

I'm sure you'll find the required information, or suitable pointers to it,
there :)

I hope this helps.

Anthony Borla

[Peter Ellis]

thanks for the help, thats exactly what i was after

"Anthony Borla" <aj*****@bigpon d.com> wrote in message
news:rG******** ************@ne ws-server.bigpond. net.au...

Peter,

"Peter Ellis" <pe********@blu eyonder.co.uk> wrote in message
news:v3******** ********@news-binary.blueyond er.co.uk...

Does anyone know the best way to go about creating a
database application?

I know quite alot of sql and have access to an Oracle server
so if i could use that then it would be great but i don't know
if i can or how to do it

If anyone has any advice on what would be the best way to
do this then i'd be really grateful

You could start by checking out the following tutorial:

http://java.sun.com/docs/books/tutorial/jdbc/index.html

I'm sure you'll find the required information, or suitable pointers to it,
there :)

I hope this helps.

Anthony Borla

[simon]

To develop a database application, first thing first, you have to start with
the database design. That means what tables do you need? What fields do you
need? How are the tables related to each others (i.e. create the
Entity-Relationship Diagrams)? Create the schema in your Oracle database.
Draw up the data-flow diagrams and process-flow diagrams. Think about what
processings are needed, and what can be done in PL/SQL stored procedures.
So on and so on.

You see, the actual coding, whether it is in Java or C++ or whatever, should
be after all of the above are done. For a database application, the
database design is utmost important. I don't care how great your Java code
is, it is meaningless if the database tables are poorly designed.

Hope this helps.

simon.