{"id":1040,"date":"2014-07-29T20:41:18","date_gmt":"2014-07-29T12:41:18","guid":{"rendered":"http:\/\/www.menglanglang.cn\/?p=1040"},"modified":"2022-11-16T09:41:26","modified_gmt":"2022-11-16T01:41:26","slug":"mysql%e7%94%9f%e6%88%90%e8%87%aa%e5%8a%a8%e5%a2%9e%e9%95%bf%e5%ba%8f%e5%8f%b7","status":"publish","type":"post","link":"http:\/\/www.menglanglang.cn\/?p=1040","title":{"rendered":"MySQL\u751f\u6210\u81ea\u52a8\u589e\u957f\u5e8f\u53f7"},"content":{"rendered":"

Oracle \u6570\u636e\u5e93\u4e2d\u6709\u00a0ROWNUM \u8fd9\u4e2a\u529f\u80fd\uff0c\u67e5\u8be2 list \u540e\u751f\u6210\u5e8f\u53f7\uff0c\u5f88\u662f\u65b9\u4fbf\uff0c\u4f46 MySQL \u662f\u6a21\u62df\u4e86 Oracle \u548c SQL Server \u4e2d\u7684\u5927\u90e8\u5206\u529f\u80fd\uff0c\u53ef\u81ea\u52a8\u751f\u6210\u5e8f\u53f7\u5374\u5b9e\u73b0\u4e0d\u4e86\uff0c\u5f88\u662f\u86cb\u75bc\uff0c\u6ca1\u529e\u6cd5\uff0c\u6700\u540e\u53ea\u80fd\u5728 JS \u753b\u9762\u4e0a\u751f\u6210\u4e86\u3002<\/p>\n

\u8981\u60f3\u5728 MySQL \u4e2d\u76f4\u63a5\u7528 SQL \u67e5\u51fa\u81ea\u52a8\u589e\u52a0\u7684\u5e8f\u53f7\uff0c\u65b9\u6cd5\u5012\u662f\u6709\uff0c\u4e0d\u8fc7\u90fd\u5f97\u7ede\u5c3d\u8111\u6c41\u7684\u60f3\uff0c\u4e0d\u50cf Oracle \u7b49\uff0c\u4e00\u4e2a\u51fd\u6570\u5c31\u6b27\u4e86\uff01<\/p>\n

\u65b9\u6cd5\u4e00\uff1a\u5728\u7a0b\u5e8f\u4e2d\u5b9e\u73b0\u3002<\/strong><\/p>\n

\u53ef\u4ee5\u5728\u7a0b\u5e8f\u4ee3\u7801\u4e2d\uff0c\u5982 Java\u3001C\u3001PHP\u3001ASP\u3001JSP \u7b49\u4e2d\u81ea\u5df1\u6a21\u62df\u5199\uff0c\u4e5f\u5c31\u662f\u5b9a\u4e49\u4e00\u4e2a\u53d8\u91cf\uff0c\u5faa\u73af\u6574\u4e2a List\uff0c\u8ba9\u53d8\u91cf\u9012\u589e\u5373\u53ef\u3002\u6211\u8fd9\u91cc\u6700\u540e\u5b9e\u5728\u6ca1\u6cd5\uff0c\u5c31\u7528 JSP \u5728\u753b\u9762\u4e0a\u6a21\u62df\u51fa\u6765\u7684\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n

\n
\n
Code<\/strong>\u00a0\u00a0\u00a0View<\/a>Print<\/a><\/div>\n<\/div>\n
    \n
  1. <s:iterator\u00a0value=<\/span>\"#request.list\"<\/span>\u00a0<\/span>var<\/span>=<\/span>\"v\"<\/span>\u00a0status=<\/span>\"status\"<\/span>>\u00a0\u00a0<\/span><\/span><\/li>\n
  2. \u00a0\u00a0\u00a0\u00a0<tr>\u00a0\u00a0<\/span><\/li>\n
  3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td\u00a0align=\"center\"<\/span>>\u00a0\u00a0<\/span><\/span><\/li>\n
  4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0${status.index+1\u00a0}\u00a0\u00a0<\/span><\/li>\n
  5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/td>\u00a0\u00a0<\/span><\/li>\n
  6. \u00a0\u00a0\u00a0\u00a0<\/tr>\u00a0\u00a0<\/span><\/li>\n
  7. <\/s:iterator>\u00a0\u00a0<\/span><\/li>\n<\/ol>\n<\/div>\n

     <\/p>\n

    \u65b9\u6cd5\u4e8c\uff1a\u4f7f\u7528 MySQL \u53d8\u91cf\u3002<\/strong><\/p>\n

    \u6ce8\u610f\uff1a@rownum \u53d8\u91cf\u662f connection \u7ea7\u7684\uff0c\u518d\u6b21\u67e5\u8be2\u7684\u65f6\u5019\u9700\u8981\u521d\u59cb\u5316\uff0c\u5426\u5219\u5e8f\u53f7\u6bcf\u67e5\u8be2\u4e00\u6b21\uff0c\u4f1a\u5728\u524d\u4e00\u6b21\u7684\u57fa\u7840\u4e0a\u9012\u589e\uff0c\u6240\u4ee5\u9700\u8981\u00a0set @rownum=0\u3002<\/p>\n

    \n
    \n
    Code<\/strong>\u00a0\u00a0\u00a0View<\/a>Print<\/a><\/div>\n<\/div>\n
      \n
    1. SELECT<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
    2. \u00a0\u00a0@rownum:=@rownum+1\u00a0AS<\/span>\u00a0rownum,\u00a0\u00a0<\/span><\/span><\/li>\n
    3. \u00a0\u00a0info.*\u00a0\u00a0<\/span><\/li>\n
    4. FROM<\/span>\u00a0(<\/span>SELECT<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
    5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0@rownum:=0)\u00a0r,\u00a0\u00a0<\/span><\/li>\n
    6. \u00a0\u00a0(SELECT<\/span>\u00a0*\u00a0\u00a0<\/span><\/span><\/li>\n
    7. \u00a0\u00a0\u00a0FROM<\/span>\u00a0\u8868)\u00a0info\u00a0\u00a0<\/span><\/span><\/li>\n<\/ol>\n<\/div>\n

       <\/p>\n

      \u8fd8\u662f\u65e9\u4e9b\u51fa\u4e2a ROWNUM \u51fd\u6570\u7684\u597d\uff0c\u671f\u5f85\u4e2d\u2026\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"

      Oracle \u6570\u636e\u5e93\u4e2d\u6709\u00a0ROWNUM \u8fd9\u4e2a\u529f\u80fd\uff0c\u67e5\u8be2 list \u540e\u751f\u6210\u5e8f\u53f7\uff0c\u5f88\u662f\u65b9\u4fbf\uff0c\u4f46 MySQL \u662f\u6a21\u62df […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[800],"tags":[186,201,305,874],"class_list":["post-1040","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-201","tag-305","tag-874"],"_links":{"self":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/1040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1040"}],"version-history":[{"count":1,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/1040\/revisions"}],"predecessor-version":[{"id":5197,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/1040\/revisions\/5197"}],"wp:attachment":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1040"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}