解决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 + " '";