JDBC出现　"Unknown column 'xxx' in 'where clause' "

我的sql语句为

String Name = "123";    

String sql = "SELECT * FROM shops WHERE name="＋Name;
Statement statement = connection.createStatement();　//然后执行，报错

报错

"Unknown column 'xxx' in 'where clause' "

解决方案：更换Statement 为PreparedStatement，并使用setString(int i,String str)方法。

String sql = "SELECT * FROM shops WHERE name=?";
try {
    PreparedStatement ps = connection.prepareStatement(sql);
    ps.setString(1,Name);
    ResultSet rs = ps.executeQuery();