sql语句如下:
stmt.executeQuery("select * from user where name = " + name);
报错如下:
Unknown column 'name' in 'where clause'
原因:列名出错,拼凑sql语句时对字符类型数据没有用引号引起来
解决如下:
stmt.executeQuery("select * from user where name = '" + name + "'");
sql语句如下:
stmt.executeQuery("select * from user where name = " + name);
报错如下:
Unknown column 'name' in 'where clause'
原因:列名出错,拼凑sql语句时对字符类型数据没有用引号引起来
解决如下:
stmt.executeQuery("select * from user where name = '" + name + "'");