java中sql字符串的单引号的无效字符 [英] invalid charecter for single quotes for sql string in java

问题描述

由于java sql字符串中的单引号，我得到无效字符常量，我需要双引号，我已将其放在单引号中

I am getting the "Invalid character constant" due to single quot in java sql string, i need double quote which i have put in single quote

new StringBuffer("SELECT REPLACE(u.nombre,',',' ') as Organizacion,  ")
    .append(" CONCAT(' " ',REPLACE(s.direccion,',',' '),'"') as Street, '""' as Street2,")

推荐答案

你必须在java字符串文字中转义引号：

You have to escape quotes in java string literals :

.append(" CONCAT('\"',REPLACE(s.direccion,',',' '),'\"') as Street, '\"\"' as Street2,")

这篇关于java中sql字符串的单引号的无效字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！