Database question about Java

[mmt4331]

I'm very new to Java (also to web design). I am just wondering how much database programming a java developer does and what type of database (ACCESS, Oracle, etc.) one usually use. Thx.

 

[jmwollny]

The amount of database programming depends on the application but it can be quite time-consuming and can involve a lot of 'donkey-work'. Database interaction requires the creation of specialised data access objects. These objects are responsible for firing the appropriate SQL statements at your database. A common approach is to create one data access object for each database table. The amount of work is then entirely dependent of the size of your database.

Regarding the database of choice. A lot of developers and web sites use mySql which is robust, fast, has a JDBC driver and best of all Free!!

If you wish to use Java to develop web sites check out "Beginning JSP Web Development". It is an excellent book, very easy to read and starts at the basics.

Good luck!

http://www.wrox.com/Books/Book_Details.asp?sub_section=1&isbn=1861002092&subject=Java&subject_id=13

 

[touco]

Hi,

Learn JDBC API, that's the answer of your question.
This API helps you communicate with whenever type of database you want (Access, MySQL, Oracle, PostgreSQL), but the database vendor must provide a jdbc driver so that you may use it.
Go to java.sun.com to know much more

Good luck,

Hamidou

 

[OttSens]

I'm finding out that it is more and more necessary
to know db admin stuff. (or have a good db admin)
Because you will quickly find that your work is
helped hugely by the db setup.