hibernate原生sql，返回新对象

@Repository
public class OutputFromDbDao extends AbstractDaoImpl<OutputFromDbModel, String> implements IOutputFromDbDao {
	@Override
	public List<OutputFromDbModel> getByQuery() {
		List<OutputFromDbModel> outputModelList = new ArrayList<OutputFromDbModel>();
		Session session = null;
		try {

			//获取系统session
			session = this.getSession();
			String sql = "select w.id,w.billid,t.goodsName....c.tradeCountry..."
				   + "from TransportModel t,WayBill w inner join ConstantCommonCode c on w.tradeCountry = c.id where t.shipmentNumber = w.id";
			SQLQuery query = session.createSQLQuery(sql);

			//设置字段类型
			query.addScalar("id", StandardBasicTypes.STRING);
			query.addScalar("billid", StandardBasicTypes.STRING);
			query.addScalar("makeBillDate", StandardBasicTypes.DATE);

			.......
			Iterator results = query.list().iterator();
			while (results.hasNext()) {
				int i = 0;
				Object[] rows = (Object[]) results.next();

				//新对象赋值
				OutputFromDbModel outModel = new OutputFromDbModel();
				outModel.setBillId((String) rows[i++]);
				outModel.setBillCode((String) rows[i++]);
				outModel.setMakeBillDate((Date) rows[i++]);
				.....
				outputModelList.add(outModel);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return outputModelList;
	}

}