本文讨论了如何在数据库中单独保存名字和姓氏的同时，在用户界面上将二者作为一个字段显示的方法。通过SQL和HQL示例介绍了如何实现这种字段合并。
some times, we want to consider two columns in db as one field in service, for example, we'll save first name and last name seperately in db, but in UI, we want to display them together.
In this case, we should consider the two columns as one, and in sql, we can do the query, such as:
select first_name + ' ' + last_name as name from user
In HQL, we can also do this, like:
select firstName + " " + lastName as name from user
In QBC, I'm not sure whether there is such functionality, but I'm afraid not
I'll do confirmation tomorrow.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
