The I18N question in HQL statement

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

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

文章标签：

#Hibernate #SQL

Hibernate 专栏收录该内容

1 篇文章

订阅专栏

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

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()+"%");