{"id":177333,"date":"2020-10-27T05:17:37","date_gmt":"2020-10-26T21:17:37","guid":{"rendered":"http:\/\/4563.org\/?p=177333"},"modified":"2020-10-27T05:17:37","modified_gmt":"2020-10-26T21:17:37","slug":"%e5%a4%a7%e5%ae%b6%e5%b8%ae%e7%9c%8b%e7%9c%8b%e8%bf%99%e7%a7%8d-java-%e5%86%99-sql-%e7%9a%84%e4%bb%a3%e7%a0%81%e5%8f%af%e5%8f%96%e5%90%97","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=177333","title":{"rendered":"\u5927\u5bb6\u5e2e\u770b\u770b\u8fd9\u79cd Java \u5199 sql \u7684\u4ee3\u7801\u53ef\u53d6\u5417"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u5927\u5bb6\u5e2e\u770b\u770b\u8fd9\u79cd Java \u5199 sql \u7684\u4ee3\u7801\u53ef\u53d6\u5417               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : madworks <\/span>  <span><i><\/i> 2<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>@Override public DataListPage<lesson> getDataListPageByFirstClass(DataListParams dataListParams, String firstClass, String branchStoreId) {<\/lesson><\/p>\n<pre><code>    String mainStoreId = BusinessUtils.getMainStoreId(branchStoreId);      String listHql = CONSTRUCTOR             + \" FROM TCmsLesson cl, TCmsLessonStoreRel r\"             + \" WHERE cl.firstClass = :firstClass\"             + \" AND cl.isValid = 1\"             + \" AND cl.id = r.lessonId\"             + \" AND r.storeId in (:mainStoreId , :branchStoreId , '0000000')\";      String countHql = \"SELECT COUNT(cl.id) FROM\"             + \" TCmsLesson cl, TCmsLessonStoreRel r\"             + \" WHERE cl.firstClass = :firstClass\"             + \" AND cl.isValid = 1\"             + \" AND cl.id = r.lessonId\"             + \" AND r.storeId in (:mainStoreId , :branchStoreId , '0000000')\";      dataListParams.setDateParam(\"cl.createDate\");      return super.getDataListPageByHql(listHql, countHql, dataListParams, firstClass, mainStoreId, branchStoreId); }  private List&lt;T&gt; listDataByHql(String hql, DataListParams dataListParams, Object... values) {  if (StringUtils.isNotEmpty(dataListParams.getBeginTime())    &amp;&amp; StringUtils.isNotEmpty(dataListParams.getEndTime())) {   hql = hql + \" AND \" + dataListParams.getDateParam() + \" BETWEEN '\" + dataListParams.getBeginTime()     + \"' AND '\" + dataListParams.getEndTime() + \"'\";  } else if (StringUtils.isNotEmpty(dataListParams.getBeginTime())) {   hql = hql + \" AND \" + dataListParams.getDateParam() + \" &gt;= '\" + dataListParams.getBeginTime() + \"'\";  } else if (StringUtils.isNotEmpty(dataListParams.getEndTime())) {   hql = hql + \" AND \" + dataListParams.getDateParam() + \" &lt;= '\" + dataListParams.getEndTime() + \"'\";  }   if (StringUtils.isNotEmpty(dataListParams.getOrderBy())) {   hql = hql + \" ORDER BY \" + dataListParams.getOrderBy();  }   if (dataListParams.isDesc()) {   hql = hql + \" DESC\";  }   if (dataListParams.getPage() != null) {   return this.listByPage(hql, dataListParams.getPage(), values);  } else {   return dataListParams.getSize() == 0     ? this.listByParamsAndPosition(hql, dataListParams.getStartPosition(), values)     : this.listBySizeAndPosition(hql, dataListParams.getSize(), dataListParams.getStartPosition(),       values);  } } <\/code><\/pre>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>33<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"3924202\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Kirsk <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u7f57\u91cc\u516b\u55e6 \u76f4\u63a5\u5220\u6389 \u7c7b\u578b\u63a7\u5236\u5e94\u8be5\u5728\u903b\u8f91\u5c42 dao \u53ea\u8d1f\u8d23\u6267\u884c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924203\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : chendy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5f88\u6709\u6bc5\u529b<br \/>\u8bd5\u8bd5 Criteria \uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924204\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : geligaoli <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u7528\u5b57\u7b26\u4e32\u62fc sql \u7684\uff0c\u76f4\u63a5\u5f00                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924205\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : rodrick <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u867d\u7136\u5f88\u4e45\u4e0d\u641e java \u4f60\u8981\u5c0f\u9879\u76ee\u7b80\u5355 sql \u8fd9\u4e48\u641e\u641e\u5c31\u7b97\u4e86\uff0c\u6b63\u89c4\u9879\u76ee\u8fd9\u4e48\u641e\u4e0d\u8bf4\u522b\u7684\uff0c\u5199\u8d77\u6765\u4e0d\u7d2f\u4e48\uff0c\u770b\u7684\u90fd\u7d2f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924206\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : EscYezi <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4ee5\u540e\u7ef4\u62a4\u8d77\u6765\u5f88\u86cb\u75bc                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924207\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : wilsonWei <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5b57\u7b26\u4e32\u62fc\u63a5\u6709\u6ce8\u5165\u98ce\u9669\u5427\uff0c\u770b\u8d77\u6765\u4e5f\u4e0d\u6e05\u6670                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924208\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5982\u679c\u4e00\u6bb5\u4ee3\u7801\u8ba9\u4eba\u770b\u4e0b\u53bb\u7684\u6b32\u671b\u90fd\u6ca1\u6709,\u8fd8\u662f\u7b97\u4e86\u5427&#8230;.                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924209\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @THESDZ #7 \u7279\u522b\u590d\u6742\u7684\u4e1a\u52a1\u9664\u5916(\u9632\u6760)                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924210\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Resource <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u53ef\u53d6                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924211\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zouzou0208 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u6837\u62fc\u63a5\u5e76\u4e14\u4e0d\u505a\u4fdd\u62a4\u7684\u8bdd\u5f88\u5bb9\u6613\u6ce8\u5165\u7684\u3002\u5728 para \u91cc\u52a0\u4e2a or 1=1 \u540e\u9762\u5c31\u53ef\u4ee5\u52a0\u4e1c\u897f\u4e86\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924212\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : madworks <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @THESDZ \u6846\u67b6\u5c42\u9762\u5462\uff0c\u6211\u516c\u53f8\u7528\u7684\u4e00\u4e2a\u4e2d\u53f0\u7cfb\u7edf orm \u6846\u67b6\u91cc\u5c31\u662f sql \u62fc\u63a5\u7684\uff0c\u6570\u636e\u5c42\u6b21\u975e\u5e38\u591a                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924213\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zouzou0208 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @madworks \u90a3\u6837\u4e00\u822c\u90fd\u6709\u6b63\u5219\u6216\u8005\u5176\u4ed6\u7684\u4fdd\u62a4\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924214\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @madworks \u6846\u67b6\u5c42\u9762\u7684\u4e00\u822c\u662f\u57fa\u4e8e\u53cd\u5c04\u6216\u8005\u4ee3\u7406\u7b49,\u6bcf\u4e00\u4e2a\u65b9\u6cd5\u8fdb\u884c\u5c01\u88c5,\u67e5\u770b\u4e3b\u4f53\u903b\u8f91\u7684\u65f6\u5019,\u914d\u5408\u6ce8\u91ca(\u65b9\u6cd5\u4e0a\u7684 javadoc)\u770b\u8d77\u6765\u5e76\u4e0d\u4f1a\u96be\u53d7,\u800c\u4e0a\u9762\u7684\u4ee3\u7801,\u4ece\u5217\u540d\u5230\u8868\u540d\u90fd\u662f\u624b\u6572\u7684&#8230;.                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924215\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : supuwoerc <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4f5c\u4e3a\u524d\u7aef\u8def\u8fc7\uff0c\u521a\u5b66\u5b8c\u9884\u7f16\u8bd1 sql\uff0c\u8fd9\u6837\u62fc\u63a5\u5b57\u7b26\u4e32\u662f\u4e0d\u662f\u4f1a\u51fa\u73b0 sql \u6ce8\u5165\u7684\u95ee\u9898\uff0c\u800c\u4e14\u770b\u7740\u597d\u7d2f\u554a =\u3002=                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924216\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : madworks <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             ||@THESDZ \u8fd9\u79cd\u4ee3\u7801\u611f\u89c9 3,4 \u5e74\u524d hibernate \u8fd9\u6837\u5199\u7684\u5f88\u666e\u904d                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924217\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @madworks \u662f\u6307\u9898\u76ee\u4e2d\u7684\u4ee3\u7801?hibernate \u4e86\u89e3\u4e0d\u591a,\u4f46\u662f\u636e\u6211\u4e86\u89e3\u5b83\u7684\u76ee\u7684\u662f\u8ba9\u7a0b\u5e8f\u5458\u4e0d\u5199 sql,hibernate \u5e94\u8be5\u4e0d\u4f1a\u8fd9\u4e48\u5199,\u6700\u8d77\u7801\u4e1a\u52a1\u5185\u5bb9\u548c\u8f6c sql \u662f\u5206\u5f00\u8003\u8651\u7684,\u4e0d\u4f1a\u6839\u636e\u903b\u8f91\u62fc\u63a5 sql                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924218\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fallinlovewith <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u89c1\u8fc7\u7528 String sql = &#8221; &#8220;+ &#8221; &#8220;+ &#8220;&#8230;.&#8221;;<br \/>\u4e5f\u89c1\u8fc7 StringBuilder sb = new StringBuilder();<br \/>sb.append(&#8220;&#8221;)<br \/> .append(&#8220;&#8221;)<br \/> &#8230;&#8230;                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924219\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fengpan567 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u4e48\u62fc\u63a5\u4e0d\u6015 sql \u6ce8\u5165\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924220\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : buruliu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             hql \u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924221\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : doudou1523102 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u770b\u7684\u5934\u75db                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924222\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : joyhub2140 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5185\u90e8\u5c0f\u9879\u76ee\u8fd9\u6837\u5b50\u641e\u6ca1\u592a\u5927\u95ee\u9898\uff0c\u5546\u4e1a\u9879\u76ee\u8fd9\u6837\u5b50\uff0c\u65e9\u665a\u63a8\u5012\u91cd\u505a\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924223\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : lonelymarried <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6211\u521a\u5b66 java\uff0c\u5982\u679c\u590d\u6742\u7684\u67e5\u8be2\u4e0d\u8fd9\u6837\u5199\uff0c\u90a3\u4e48\u600e\u4e48\u5199\u5462\u3002\u5b66\u4e60\u4e00\u4e0b\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924224\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : la2la <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6211\u4eec\u516c\u53f8\u7684\u9879\u76ee\u90e8\u5206\u63a5\u53e3\u5c31\u662f\u8fd9\u4e48\u641e\u5f97\uff0c\u770b\u7684\u8111\u58f3\u75bc\u3002\u4f46\u662f\u9886\u5bfc\u90fd\u6ca1\u8bf4\u4ec0\u4e48\uff0c\u6211\u8fd8\u80fd\u505a\u5565\u5462                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924225\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : somefree <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u4e00\u770b\u90fd\u662f\u4e0a\u53e4\u65f6\u671f\u7684\u4ee3\u7801\u4e86, \u8ddf\u6211\u4ee5\u524d\u7684\u516c\u53f8\u4ee3\u7801\u6709\u7684\u4e00\u62fc                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924226\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fatpower <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u4e2a\u4e0d\u662f sql\uff0c\u662f hql \u3002<br \/>\u4e0a\u53e4\u65f6\u671f\u7684\u4ee3\u7801\u90fd\u8fd9\u6837                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924227\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : weizhen199 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4f60\u4eec\u4ed4\u7ec6\u770b\u770b\uff0c\u6211\u548b\u89c9\u5f97\u8fd9 sql \u53c2\u6570\u5316\u4e86\uff1f\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924228\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : madworks <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @weizhen199 \u4ec0\u4e48\u53eb sql \u53c2\u6570\u5316                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924229\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : a719031256 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4eba\u624d\u3002\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924230\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : dyeed <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @fatpower \u9700\u8981\u7ef4\u62a4\u4e1d\u4e1d\u8bf6\u5403\uff08 SSH \uff09\u7684\u6211 o(\u2565\ufe4f\u2565)o \u4e86\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924231\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : aguesuka <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u597d\u4e0d\u597d\u4e0d\u8bc4\u4ef7\uff0c\u7ed9\u51e0\u4e2a\u5efa\u8bae\u3002String hql=\u524d\u4e00\u53e5\u52a0\u4e0a \/\/ language=HQL (sql jpaql \u540c\u7406)\u3002\u53c2\u6570\u4f7f\u7528\u5192\u53f7\u52a0\u53c2\u6570\u540d\u7684\u683c\u5f0f\uff0c\u7136\u540e\u7528 setparammap \u6216\u8005 setpropsobject \u8bbe\u7f6e\u53c2\u6570\u7684\u503c\u3002\u53c2\u6570\u548c\u8fd4\u56de\u503c\u52a0\u4e0a\u6cdb\u578b\u3002 <br \/>java \u7684 orm \u5305\u62ec\u4e0d\u9650\u4e8e jpa mybatis springtemplate \u90fd\u4e0d\u548b\u5730\uff0c\u5728\u9762\u76f8\u5bf9\u8c61\u800c\u4e14\u81ea\u7701\u80fd\u529b\u8fd9\u4e48\u5f31\u7684\u8bed\u8a00\u91cc\u53d1\u660e\u4e00\u79cd\u4ee3\u66ff sql \u7684 dsl \u662f\u4e0d\u53ef\u80fd\u7684\u3002<br \/>\u6211\u80fd\u60f3\u5230\u7684\u6700\u597d\u529e\u6cd5\u662f\u6574\u5408\u9879\u76ee\u8bbe\u8ba1\u7684\u65f6\u5019\u4e0d\u8003\u8651 sql\uff0c\u4e13\u95e8\u62db\u8058\u4e00\u4e2a\u5b9e\u4e60\u751f\u6765\u5199 dao \u5c42\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924232\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : meepo3927 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u55ef\u2026\u2026 \u8fd9\u4e2a\u6362\u884c\u98ce\u683c\uff0c\u770b\u7740\u597d\u96be\u53d7                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924233\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : akira <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u53ef\u53d6\u3002 \u73b0\u5728\u5e94\u8be5\u90fd\u653e\u5f03\u8fd9\u79cd\u5199\u6cd5\u4e86\u5427\u3002 \u53ef\u7ef4\u62a4\u6027\u4e0d\u662f\u5f88\u597d                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3924234\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : jin7 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u770b\u7740\u9ebb\u70e6                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u5bb6\u5e2e\u770b\u770b\u8fd9\u79cd Java \u5199 sq&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/177333"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177333"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/177333\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=177333"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=177333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}