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