JDBC SQL组装 显示标识符无效

  StringBuilder sql = new StringBuilder()
     .append(" SELECT                                            ")
     .append("     COUNT(*)                                      ")
     .append(" FROM                                              ")
     .append("     t_mall_settle_rent                            ")
     .append(" WHERE                                             ")
     .append("     settle_month <to_char(sysdate,'yyyymm')       ")
     .append(" AND pay_status ='disable'     AND settle_type= '"+settleType+"'    ");

 

settle_type  是String 类型

 

 

 

所以 settle_type=  '    "+settleType+"    '    oracle 没有转化，所以在此外层加一个单引号