關(guān)于search 查詢女神信息代碼 問(wèn)題
else if(OPERATION_SEARCH.equals(in.toUpperCase())
||OPERATION_SEARCH.substring(0,1).equals(in.toUpperCase())
||OPERATION_SEARCH.equals(previous)){
previous =OPERATION_SEARCH;
//查找
List<Map<String,Object>> params=new ArrayList<Map<String,Object>> ();
Map<String,Object> param=new HashMap<String,Object>();
if(step==1){
System.out.println("請(qǐng)輸入的name：");
}else if(2==step){
param.put("name", in);
System.out.println("請(qǐng)輸入的關(guān)系：");
}else if(3==step){
param.put("rela", in);
System.out.println("請(qǐng)輸入的結(jié)果：");
}else if(4==step){
param.put("value", in);
params.add(param);
try {
List<Goddess> gs =action.query(params);
for(Goddess g:gs){
System.out.print(g.toString());
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(OPERATION_SEARCH.equals(previous)){
step++;
}
}
最后顯示結(jié)果
select * from imooc_goddess where 1=1 and null null 3
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null 3' at line 1
不知道最后sql為什么是null，不是傳了值嗎
2016-12-10
-Allen說(shuō)的方法是對(duì)的，親測(cè)可用
2016-09-20
我也出現(xiàn)了同樣的問(wèn)題，因?yàn)橐砑幼址?，但是就不能接受自己輸入的值?/p>
2016-08-06
造成前面兩個(gè)null的原因是下面這兩行要放在while循環(huán)外面，
List<Map<String,Object>> params=new ArrayList<Map<String,Object>> ();
Map<String,Object> param=new HashMap<String,Object>();
2016-08-06
param.put("name", "'"+in+"'");//加上一對(duì)單引號(hào)試試