解决Unknown column '××' in 'where clause'问题


解决Unknown column '××' in 'where clause'问题

name是字符串类型 sql语句拼凑时需要' '

修改前:
String sql = "select * from igeekshop.user where name = " + name;
修改后:

String sql = "select * from igeekshop.user where name = '" + name + " '";