怎么在sql语句的String里定义变量

Question

如String hql ="from Book as book where book.bookNo = [变量]"
Query query = session.createQuery(hql);
字符串hql该怎么写呢？

Answer 1

declare 变量名 varchar(255); #非数字变量
declare 变量名 int; #数字变量
select * from book where book.bookNo = 变量名；