sql和hql查询数据
String hql = "select productModel,producedQuantity,checkQuantity,ngQuantity,okQuantity,sizeQuantity,passRate,dpmoData,upRate,downDpmo from GoalPlusEntityData w where w.checkYear=? and w.checkMonth=? ";
return find(hql, checkYear,checkMonth);
String sql = "select id from IQC_PRODUCT_BOM r where r.code = ? ";
List<?> list = productBomDao.getSession().createSQLQuery(sql)
.setParameter(0,bomInformations.getIqcInfoCode())
.list();
赞 (0)