如果‘小美’是想通過(guò)鍵盤(pán)輸入,那需要怎么解決呢?
Scanner input =new Scanner(System.in);
String in=input.next();
param.put("value",in);
運(yùn)行結(jié)果為:select * from imooc_goddess where 1=1 and user_name = ss ? 就提示錯(cuò)誤:Unknown column 'ss' in 'where clause'
Scanner input =new Scanner(System.in);
String in=input.next();
param.put("value",in);
運(yùn)行結(jié)果為:select * from imooc_goddess where 1=1 and user_name = ss ? 就提示錯(cuò)誤:Unknown column 'ss' in 'where clause'
2016-08-06
舉報(bào)
2016-08-06
我懂了,通過(guò)param.put("value","'"+in+"'"); 這種方式即可