当在 HQL 当中 使用 concat 函数 将数字与中文字符串进行连接时,会出现乱码问题:
解决办法:可以将 数字转换成 字符串数据类型 再与中文字符串连接,这样就OK。
示列代码如下:
String hql = "select A.id,A.projectNumber,A.name,A.contractAmount,A.assman," +
"(select code from BorrContractEntity where projectId=A.id)," +
"A.rateReal," +
"concat(cast(A.loanLimit as string),(case A.dateType when 'Y' then '年' " +
" when 'M' then '月' else '日' end))" +
" from ProjectEntity A where A.id='"+projectId+"'";