mysql like 查询有单引号的处理办法。org.hibernate.QueryException: expecting ''', found '<EOF>' [SELECT DISTINCT

最新推荐文章于 2022-02-17 11:53:19 发布

huaism

最新推荐文章于 2022-02-17 11:53:19 发布

阅读量9.6k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/huaishuming/article/details/48000755

版权

mysql 专栏收录该内容

23 篇文章 1 订阅

订阅专栏

org.hibernate.QueryException: expecting ''', found '<EOF>' [SELECT DISTINCT D FROM XXX ]

原因就是有单引号，然后 sql语句加上 \' 转义字符。或用 2个单引号。''

在hibernate的查询中不能用 \’ , 可以用'' 代替。

即：

'%"+StringEscapeUtils.escapeSql(_mediaName)+"%'

Open Declaration String org.apache.commons.lang.StringEscapeUtils.escapeSql(String str)



Escapes the characters in a String to be suitable to pass to an SQL query.

For example, 

statement.executeQuery("SELECT * FROM MOVIES WHERE TITLE='" + 
   StringEscapeUtils.escapeSql("McHale's Navy") + 
   "'");

At present, this method only turns single-quotes into doubled single-quotes ("McHale's Navy" => "McHale''s Navy"). It does not handle the cases of percent (%) or underscore (_) for use in LIKE clauses.

see http://www.jguru.com/faq/view.jsp?EID=8881
Parameters:
str the string to escape, may be null
Returns:
a new String, escaped for SQL, null if null string input