hi Jos,
thanks
i have to launch a database on www. for that i want that JDBC should be client interface interacting with pgsql database server on my system on user request. you plz tell me the following queries:
1. jdbc programming will be in JAVA, isnt it?
2. i have to make quey form or search page in HTML.
3. how would i connect user's query to my jdbc program in order to fetch something from database?
please make clear the basic architecture of this plan.
with warm regard
mamoon
Yep, jdbc programming is just Java programming. You connect to your database
by either loading your driver given the correct URL to your database, or your
use a DataSource object for that. Jdbc doesn't care where your database is
located as long as it can reach it through the supplied URL.
On the other hand, your database doesn't care where your query comes from
and how it was composed. Jdbc simply submits the sql statement and fetches
the results (if any).
If you want to compose a sql query using html forms, you're free to do so.
Given the short description you supplied I guess a Servlet container (TomCat?)
handles the submitted form, your business logic composes the query and
passes it on to the database; the results can be send back to the client in
html format.
kind regards,
Jos