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)

相关推荐