關(guān)于or的問題
怎么將中間的and變?yōu)閛r，也就是變成選擇查詢
曉月殘楓
2016-04-21
1 回答
舉報
0/150
提交
取消
2016-04-22
Map<String, Object> pram=prams.get(0);
?? ??? ??? ??? ?sql.append(pram.get("name")+" "+pram.get("opr")+" "+pram.get("value")+" ");
?? ??? ??? ??? ?for(int i=1;i<prams.size();i++)
?? ??? ??? ??? ?{?? ?
?? ??? ??? ??? ??? ?pram=prams.get(i);
?? ??? ??? ??? ??? ?sql.append(pram.get("prep")+" "+pram.get("name")+" "+pram.get("opr")+" "+pram.get("value")+" ");
?? ??? ??? ??? ?}
/*************************************************************/
Map<String, Object> pram=new HashMap<String,Object>();
?? ??? ?pram.put("name","user");
?? ??? ?pram.put("opr", "=");
?? ??? ?pram.put("value", "'123456'");
?? ??? ?prams.add(pram);
?? ??? ?pram=new HashMap<String,Object>();
?? ??? ?pram.put("prep", "or");
?? ??? ?pram.put("name","passwd");
?? ??? ?pram.put("opr", "=");
?? ??? ?pram.put("value", "'123'");
?? ??? ?prams.add(pram);
?? ??? ?Action.search(prams);