org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select uid from user where username=SyusukeFuji]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column ‘xxx' in 'where clause'
这个问题遇到过好多次了
每次解决了之后过一段时间之后又会错,所以这次记录一下
首先我的语句是
String sql ="select uid from user where username="+username;
但是username是一个varchar类型的值
所以必须用引号括起来
即使用
String sql ="select uid from user where username="+ "'" +username+"'";
这样问题就解决了