mysql sql 语句

之前"select count(*) from user where username="+username ;

一直报错，随便输入什么username，全部都报错，说没有对应的column，于是吧语句在mysql上敲，发现，要加如'';

"select count(*) from user where username='"+username + "'";