public List<RoadBasicInfo> findByOfficialGrade(String officialGrade) {
String hql = "select distinct new com.pengtu.entity.gl.RoadBasicInfo(roadName , substring(roadCode,0,length(roadCode)-6)) from RoadBasicInfo where officialGrade = '" + officialGrade + "'";
return this.find(hql);
}
Hql substring length
最新推荐文章于 2024-04-26 15:09:44 发布