java - Eclipse SQLite multiple queries with Where clause -

hi trying use jtextfield box search values in sqlite database jtable created. far have code:

    textfieldsearchserver = new jtextfield();     textfieldsearchserver.addkeylistener(new keyadapter() {         @override         public void keyreleased(keyevent e) {              try {                 string query = "select * server sid = ?";                 preparedstatement pst = connection.preparestatement(query);                 pst.setstring(1, textfieldsearchserver.gettext());                 resultset rs = pst.executequery();                   servertable.setmodel(dbutils.resultsettotablemodel(rs));                 pst.close();               } catch (exception f) {                 f.printstacktrace();             }           }     }); 

this code allows me search 1 column of data , want search entire database. have tried using 'or' statement after , other alternatives nothing working. suggestions or fixes appreciated!

you should able use or. each item, need apply "set."

            string query = "select * server sid = ? "              + "or application = ?";             preparedstatement pst = connection.preparestatement(query);             pst.setstring(1, textfieldsearchserver.gettext());             pst.setstring(2, textfieldsearchserver.gettext());             resultset rs = pst.executequery(); 

i'm not allowed comment; option responding.