jsp db query
Posted on 2005-04-22
I have a table called listFiles. There is a field called authorName in the table. The application is following.
In a html form, user select an author name, submit it into a jsp file. In the jsp file I used :
selectStmt=sqlConn.prepareStatement("SELECT fileName, authorName, submDate from listFiles WHERE authorName=?");
My question is: for example, the name user want to know is "abc", if the author "abc" has submitted a file before, there will be a query reqult.
but if the author "abc" hasn't submited a file, then there will not be a name called "abc" in the database. in this situation, how to do the query ?
Thanks for your reply.