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