代码完全没错,但是查询出来的char字段数据只取了第一个字节
改正如下:
String hql="SELECT DISTINCT a.Line_No,a.Line_name,a.Stop_No,b.StartTime,c.CarryPrice " +
"FROM tblLine a left join tblDispatch b on (b.line_No=a.line_No)" +
" left join tblCarryPrice c on (c.line_No=a.line_No) " +
"WHERE a.IsDelete = 0 AND a.Stop_No ='"+stopNo+"' OR a.Stop_No=''";
return super.getSession().createSQLQuery(hql)
.addScalar("Line_No", Hibernate.STRING)
.addScalar("Line_name", Hibernate.STRING)
.addScalar("Stop_No", Hibernate.STRING)
.addScalar("StartTime", Hibernate.STRING)
.addScalar("CarryPrice", Hibernate.STRING)
.list();
这样就可以了