The I18N question in HQL statement

最新推荐文章于 2022-01-18 20:29:39 发布

最新推荐文章于 2022-01-18 20:29:39 发布 · 93 阅读

文章标签：

#Hibernate #SQL

Hibernate 专栏收录该内容

1 篇文章

订阅专栏

在 Hibernate 3.0 中使用含有中文字符的 HQL 语句会导致转换错误，文章提供了一种解决方案，即使用占位符代替中文字符，并通过 find 方法传参获取正确数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In Hibernate 3.0, we can't use chinese character in HQL statement, if you do that, when The Hibernate convert HQL statement to Sql statement , The chinese character will be converted to ???, So you will get uncorrect data from database.
But we can do this, we use ? code to instead of chinese character, then use find(statement,arguments[]) to get data from database.for example:
String sql = "select user,org from HrUsers user,OrgPerson person,OrgOupersonrelation relation,OrgOu org where user.id = person.id and person.id = relation.Pguid and relation.OuGuid = org.id and user.usrName like ?"
this.getCommonDAO().find(sql,"%"+user.getUsrName()+"%");