SELECT tcwz FROM biao t order by cast(t.tcwz as INTEGER); 使用hql语句,如下 。。。+ order by cast(t.tcwz as int);