<\/p>\n
1.Monitor\u5bf9\u8c61<\/p>\n
private String name;
\nprivate String max=”0″;
\nprivate String min=”0″;
\nprivate Double avage;
\n\/** 0-1 **\/
\nprivate Long section1;
\n\/** 1-2 **\/
\nprivate Long section2;
\n\/** 2-3 **\/
\nprivate Long section3;
\n\/** 3-4 **\/
\nprivate Long section4;
\n\/** 4-5 **\/
\nprivate Long section5;
\n\/** 5-6 **\/
\nprivate Long section6;
\n\/** 6-7 **\/
\nprivate Long section7;
\n\/** 7-8 **\/
\nprivate Long section8;
\n\/** 8-9 **\/
\nprivate Long section9;
\n\/** 9-10 **\/
\nprivate Long section10;<\/p>\n
private Set<BeanMItem> items=new HashSet<BeanMItem>();<\/p>\n
<\/p>\n
2.BeanMItem\u5bf9\u8c61<\/p>\n
private String companyName;
\nprivate String failureRate;<\/p>\n
private BeanMonitor monitor;<\/p>\n
<\/p>\n
3.\u83b7\u53d6\u5f53\u524d\u6700\u65b0\u7684Monitor\u5bf9\u8c61\u5e76\u83b7\u53d6\u5176\u4e2d\u7684\u89c2\u6d4b\u6761\u76ee\u7684\u6700\u5927\u503c,\u6700\u5c0f\u503c\u548c\u5e73\u5747\u503c,\u4ee5\u53ca\u5bf9\u5e94\u7684\u533a\u95f4\u6570\u91cf<\/p>\n
a.left join<\/p>\n
b.group by<\/p>\n
c.MAX,MIN,AVG<\/p>\n
d.sum(case when boolean then 1 else 0 end)<\/p>\n
QueryResult qr = new QueryResult<BeanMonitor>();<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,22,31],"tags":[],"class_list":["post-313","post","type-post","status-publish","format-standard","hentry","category-hibernate","category-jpa","category-sql"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=313"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/313\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} String entityname = getEntityName(this.entityClass);
\nQuery query = em.createQuery(\"select new BeanMonitor(o.id,o.name,MAX(items.failureRate),MIN(items.failureRate),avg(items.failureRate)<\/span>,\"
\n+ \"sum(case when items.failureRate < 10 then 1 else 0 end)<\/span>,\"
\n+ \"sum(case when (items.failureRate >= 10 and items.failureRate < 20) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 20 and items.failureRate < 30) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 30 and items.failureRate < 40) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 40 and items.failureRate < 50) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 50 and items.failureRate < 60) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 60 and items.failureRate < 70) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 70 and items.failureRate < 80) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 80 and items.failureRate < 90) then 1 else 0 end),\"
\n+ \"sum(case when (items.failureRate >= 90) then 1 else 0 end)) from \" + entityname + \" o left join o.items as items<\/span> \" + (wherejpql == null || \"\".equals(wherejpql.trim()) ? \"\" : \"where \" + wherejpql) +\" group by<\/span> o.id \" +buildOrderby(orderby));
\nsetQueryParams(query, queryParams);
\nif (firstResult != -1 && maxresult != -1)
\nquery.setFirstResult(firstResult).setMaxResults(maxresult);
\nqr.setResultlist(query.getResultList());<\/code><\/p>\n
\n