com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

出现com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'jiang' in 'where clause错误。

原因在查找数据时语句写错：String sql = "select * from article where=" + "jiang"

如此写实际sql语句为select * from article where=jiang

而应该为select * from article where=‘jiang’

及应写为：String sql = "select * from article where=‘" + "jiang" + “’”

也可以写成String sql = "select * from article where=？“的形式。