Unknown column 'jack' in 'where clause

 select * from users where nickname='"+nickname + "'";

为了避免出错，你可以使用:
String sql = "select * from users where nickname = ?";
ps.setString(1 , nickname);

上面2位的回答已经没什么要补充的了……