由于java sql字符串中的单个quot,我得到了"无效字符常量",我需要双引号,我已经放入单引号
new StringBuffer("SELECT REPLACE(u.nombre,',',' ') as Organizacion, ")
.append(" CONCAT(' " ',REPLACE(s.direccion,',',' '),'"') as Street, '""' as Street2,")
java字符串必须转义引号:
.append(" CONCAT('"',REPLACE(s.direccion,',',' '),'"') as Street, '""' as Street2,")
您想在字符串中添加"
,但问题是您没有转义它,导致整个字符串中断。
您需要使用转义它,例如
" CONCAT('"',REPLACE(s.direccion,',',' '),'"') as Street, '""' as Street2,"