Member Avatar for Thendral

Hai..

I need to connect a database called "Postgresql" with a jsp code.
how it can be done?
I need the connection procedure for that.
plz reply me..

  • 3 Contributors
  • 4 Replies
  • 105 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for masijade

Read the JDBC tutorials at Sun, the JDBC documentation for the PostGreSQL Driver (once you download it), and the J2EE tutorial at Sun.

Member Avatar for Thendral

I have postgresql in my system.also i created schema and table there. i need the coding for connecting that database and my JSP program.

Member Avatar for masijade

And I pointed you to resources that will enable you to do that. The first one will teach you how to use JDBC. The second one will provide you the specifics (read Connection URL) for PostGreSQL, the third one will help you integrate that information into JSP (and hopefully you will do it in the proper manner and use a bean or JSTL tag for accessing the DB rather than a scriptlet).

Here are the three resources as links:

http://java.sun.com/docs/books/tutorial/jdbc/index.html
http://jdbc.postgresql.org/doc.html
http://java.sun.com/j2ee/1.4/docs/tutorial/doc/

I am not going to simply give you ready made code. Try it yourself, and if you have problems post your code here and we will help to correct it.

Member Avatar for jwenting

and learn proper separation of control. JSP are not meant for that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.