67,513
社区成员
发帖
与我相关
我的任务
分享
Query query = session.createQuery("select new User"
+" (u.id,u.name,"
+"(case when u.code=1340 then 1 when u.code = 1345 then 2 else 0 end)"
+")"
+" from User u order by col_2_0_");
List list = query.list();
Query query = session.createQuery("select new User"
+" (u.id,u.name,"
+"(case when u.code=1340 then 1 when u.code = 1345 then 2 else 0 end)"
+ as c"
+")"
+" from User u order by c");
List list = query.list();
select u.id,u.name, (case when u.code=1340 then 1 when u.code = 1345 then 2 else 0 end) from User u order by u.code;
Query query = session.createQuery( "select new User "
+ " (u.id,u.name, "
+ "(case when u.code=1340 then 1 when u.code = 1345 then 2 else 0 end) "
+ ") "
+ " from User u order by u.code ");
List list = query.list();