hibernate自定义SQL

//修改

@Override

    public int update(RsAttr bean) {
        String hql = "update JC_CONTENT_ATTR t set t.attr_value = '即将到期' where t.content_id = ? and t.attr_name = ?";
         SQLQuery query = getSession().createSQLQuery(hql);
         query.setParameter(0, bean.getContent_id());
         query.setParameter(1, bean.getAttr_name());
         return query.executeUpdate();

    }

//查看

    @Override
    public List<RsAttr> findbynv(String attr_name, String attr_value) {
            String sql = "select * from JC_CONTENT_ATTR t where t.attr_name = ? and t.attr_value < ?";
            SQLQuery sqlQuery = getSession().createSQLQuery(sql);// SQLQuery是hibernate用于支持原生sql的接口类
            sqlQuery.setParameter(0, attr_name);
            sqlQuery.setParameter(1, attr_value);
            sqlQuery.addEntity(RsAttr.class);
            List<RsAttr> RsAttrList1 = (List<RsAttr>)sqlQuery.list();
            return RsAttrList1;
    }