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
Post a Comment