关于sparksql 接参数的错误，大佬来看看啊

[toward_south]

今天写spark sql的时候

        String sex = "F";
        //创建临时视图
        sparkSession.read().jdbc(url, "user", properties).createOrReplaceTempView("user");
        Dataset<Row> user =  sparkSession.sql("select id,UserID,Gender,Age from user where Gender = " +sex);

想在 这条语句后面加个参数，但是发现 这个 sex 一直编译失败

21:43:01.340 [main] INFO org.apache.spark.sql.execution.streaming.state.StateStoreCoordinatorRef - Registered StateStoreCoordinator endpoint
21:43:03.844 [main] DEBUG org.apache.spark.sql.execution.SparkSqlParser - Parsing command: user
21:43:04.362 [main] DEBUG org.apache.spark.sql.execution.SparkSqlParser - Parsing command: select id,UserID,Gender,Age from user where Gender = F
21:43:04.877 [main] DEBUG org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveReferences - Resolving 'Gender to Gender#2
21:43:04.879 [main] DEBUG org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveReferences - Resolving 'F to 'F
21:43:04.913 [main] DEBUG org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveReferences - Resolving 'F to 'F

Exception in thread "main" org.apache.spark.sql.AnalysisException: cannot resolve '`F`' given input columns: [user.zipcode, user.Gender, user.Age, user.Occupation, user.UserID, user.id]; line 1 pos 53;
'Project ['id, 'UserID, 'Gender, 'Age]
+- 'Filter (Gender#2 = 'F)
   +- SubqueryAlias `user`
      +- Relation[id#0,UserID#1,Gender#2,Age#3,Occupation#4,zipcode#5] JDBCRelation(user) [numPartitions=1]

也就是说这个sex值能传进去，但是sql语句却编译失败，我个人猜想是少了那个双引号，但是怎么把双引号也拼接进去呢，或者有其他的解决办法，希望大牛能帮帮忙

[zijiang001]

where Gender = '" +sex + "'"); 字符串类型需要加上''

[心怀啊]

反斜杠加单引号或者双引号