StringBuilder builder = new StringBuilder("SELECT");
builder.append(" * ");
builder.append(" FROM ");
builder.append("tableName");
Sql sql = Sqls.create(builder.toString());
SimpleCriteria cri = Cnd.cri();
cri.where().and("cityId","=","939");
sql.setCondition(cri);
return sql; 

这样写了之候执行的sql语句还是 select * from tableName ,没有where cityId=939;这是为什么?