JDBC code needed

I have the basic code to make a connection and select a query
constructed, however there are some additional methods I need to employ.
The database is for an online record store. I need to be able to search
for records by name of the musician, title of the song, and the name of
the song. The users need to be able to register with the site. Users who
have looged onto the site can add itmes to the shopping basket. Users
with items in their shopping basket can check out and make purchases. I
picked up a JDBC book that is pretty good but it doesn't have any
examples close to the methods I am asking for.

I have looked around the web for some good samples and did not find
what I needed. If anyone could share some snippets or send me a link to
a place that may have some I would appreciate it.

Thanks