servlet and database

[Rahul Sudip Bose]

how can i make my servlet access a database and print/store a table from it. Can you suggest any websites/books with a simple example that does this and nothing else ?

[amit punekar]

Hi,
You need to learn JDBC and establish a JDBC connection from a servlet(in its simplest form or else use separate Data Access layer to do this).
Using this java.sql.Connection, you can interact with Database from DDL and DML queries.

Another option is to use some framework like iBatis to access the Database. That might be the next step once you are done working with plain JDBC Connection.

Regds,
amit

[Rahul Sudip Bose]

amit punekar wrote:Hi,
You need to learn JDBC and establish a JDBC connection from a servlet(in its simplest form or else use separate Data Access layer to do this).
Using this java.sql.Connection, you can interact with Database from DDL and DML queries.

Any website/book where i can get some simple examples for that ?

[Bear Bibeault]

Moved to the JDBC forum.

[Paul Sturrock]

Have a look at our FAQs, there are a bunch of resources in there. You should also have a look at the JDBC tutorial.

[Rahul Sudip Bose]

Paul Sturrock wrote:Have a look at our FAQs, there are a bunch of resources in there. You should also have a look at the JDBC tutorial.

ok, reading...will get back here later...