Java help

[MarcoRyan]

I've got a client/server database application which I am creating for college. I'm practically done with it. DB connection works perfectly, querries, etc.

1 of my functions require me to add a movie to the db. This includes Movie Name, description and GenreID. I need to check with the database if the genreID exists before adding the movie. And if it does not exist, display an error.

I've been trying non-stop the whole day to try and fix this problem. Anyone got any idea of what method I can use to check this?

thanks

PS. Project is due first thing tomorrow morning

 

[office politics]

are you running sql queries?

select genreid from tablename where genreid = 'Genreid'

search for your genreid in the recordset and if it's not found, display the error