Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Can HQL do this?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

ctaihua

Post subject: Can HQL do this?

Posted: Fri Dec 05, 2008 12:30 pm

Newbie

Joined: Tue Aug 08, 2006 2:56 am
Posts: 6

Hello, I have a SQL with the append data to the column like this...

For example, table Student with a "name" column

I want make this SQL
Select 'Student:' + st.name from Student.

the result will be like this

2 records founded with one column
Student: Philip
Student: John

Can I make HQL to do this(I have a Student class with name property)

Please help me

Thank you....
Philip

Top

mc1392

Post subject: append query

Posted: Fri Dec 05, 2008 4:37 pm

Beginner

Joined: Fri May 16, 2008 3:59 pm
Posts: 30

Code:

Query q = session.createQuery("select from table where name= :name");
q.setString("name",value);
List list = q.list();

P.S. I need 1 credit so I can post again!

Top

croudet

Post subject:

Posted: Fri Dec 05, 2008 5:36 pm

Regular

Joined: Mon Apr 19, 2004 6:54 pm
Posts: 79

Simply use the concat operator ||:

Code:

Select 'Student:' || st.name from Student

Christophe

Top

ctaihua

Post subject:

Posted: Fri Dec 05, 2008 8:38 pm

Newbie

Joined: Tue Aug 08, 2006 2:56 am
Posts: 6

Thanks a lot, this is very helpful.

Philip

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum