MySQL Query based on user input in Java -

i'm new sql , java , couldn't find fix problem. (closest thing: mysql query based on user input) have db full of shows/events , want users "search" event or show. user input name of show/event gui , want query return data associated user-input.

for example:

user searching artist zedd;

searchset = statement.executequery("select eventname,date shows artist      'zedd' "); 

the query fixed, can query modified search whatever user input?

something like:

string artist = "zeppelin" searchset = statement.executequery("select eventname,date shows artist "artist" "); 

thanks in advance help!

you should double check shows second column. i'm not sure can use column named date. anyway, should use preparedstatement like,

string sql = "select eventname, eventdate shows artist ?"; preparedstatement ps = null; resultset rs = null;  try {   ps = conn.preparestatement(sql);   ps.setstring(1, artist);   rs = ps.executequery();   while (rs.next()) {     string eventname = rs.getstring("eventname");     date eventdate = rs.getdate("eventdate");     // use columns in row here.   } } catch (exception e) {   e.printstacktrace(); } {   if (rs != null) {     try {       rs.close();     } catch (sqlexception e) {       e.printstacktrace();     }   }   if (ps != null) {     try {       ps.close();     } catch (sqlexception e) {       e.printstacktrace();     }   } }