Hql substring length

来源:互联网 发布:vue.js 开发工具 编辑:程序博客网 时间:2024/06/07 07:33
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);}

原创粉丝点击