bug---sql查询中文/Unknown column ‘xxx’ in ‘where clause

错误描述

如果下面两种查询弄错了就会出现错误：
Unknown column ‘xxx’ in ‘where clause

mysql查询的关键字是字符串

变量

 sql  = "select * from stu where  major='"+major+"'"; // 设置sql语句

普通字符串

 sql  = "select * from stu where  major='字符'"

mysql查询的关键字为int

 sql  = "select * from stu where  major=123"