servlets - How can I add more than 1 filter to persistence manager query in Java Google App Engine? -


i'm using java servlets develop google app engine application. need write query more 1 condition in clause. commented out line below gives me query_parsing error. there way add more 1 condition in clause?

string query = "select " + human.class.getname(); query += " name == '" + request.getparameter("name") + "'"; //query += " , lastname == '" + request.getparameter("lastname") + "'"; list<human> humans = (list<human>) pm.newquery(query).execute(); 

i know possible jdo queries such below. however, version different. i'm using string object write query , execute persistence manager (please see above).

query query = pm.newquery(employee.class); query.setfilter("lastname == lastnameparam"); query.setordering("hiredate desc"); query.declareparameters("string lastnameparam"); 

in first code snippet, believe issue word 'and', should '&&'. have multiple filters, in second snippet, use '&&' operator.

string query = "select " + human.class.getname(); query += " name == '" + request.getparameter("name") + "'"; query += " && lastname == '" + request.getparameter("lastname") + "'"; list<human> humans = (list<human>) pm.newquery(query).execute(); 

or

query query = pm.newquery(employee.class); query.setfilter("lastname == lastnameparam && name == nameparam"); query.setordering("hiredate desc"); query.declareparameters("string lastnameparam"); query.declareparameters("string nameparam"); 

Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -