{"id":200730,"date":"2020-11-21T18:03:03","date_gmt":"2020-11-21T10:03:03","guid":{"rendered":"http:\/\/4563.org\/?p=200730"},"modified":"2020-11-21T18:03:03","modified_gmt":"2020-11-21T10:03:03","slug":"%e5%8e%86%e7%bb%8f-3-%e5%b9%b4%ef%bc%8c%e7%bb%88%e4%ba%8e%e5%be%97%e4%bb%a5%e5%ae%9e%e7%8e%b0%e4%ba%86","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=200730","title":{"rendered":"\u5386\u7ecf 3 \u5e74\uff0c\u7ec8\u4e8e\u5f97\u4ee5\u5b9e\u73b0\u4e86"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u5386\u7ecf 3 \u5e74\uff0c\u7ec8\u4e8e\u5f97\u4ee5\u5b9e\u73b0\u4e86               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <span><i><\/i> 3<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u5199\u4e86 15 \u5e74\u7684\u7a0b\u5e8f\uff0c\u4eba\u5230\u4e2d\u5e74\u603b\u6709\u5f88\u591a\u8bdd\u8981\u8bf4\uff0c\u5343\u8a00\u4e07\u8bed\u5c3d\u5728\u9879\u76ee\u91cc\uff0c\u91cc\u9762\u6709\u6211\u60f3\u8bf4\u7684\u4e00\u5207\u3002<\/p>\n<p>\u9879\u76ee\u5730\u5740\uff1a https:\/\/github.com\/braisdom\/ObjectiveSql<\/p>\n<p>ObjectiveSQL \u662f\u6211\u6784\u60f3\u4e86\u5f88\u957f\u65f6\u95f4\uff0c\u5230\u5e95\u662f\u8ba9 Java \u50cf SQL \u4e00\u6837\u7f16\u7a0b\uff0c\u8fd8\u662f\u8ba9 SQL \u8ba9 Java \u4e00\u6837\u7f16\u7a0b\uff0c\u7ea0\u7ed3\u4e86\u5f88\u4e45\uff0c\u8fd8\u662f\u8ba9 Java \u66f4\u50cf SQL\uff0cJava \u7684\u8bed\u6cd5\u8868\u73b0\u529b\u4e0d\u591f\uff0c\u53ea\u80fd\u6269\u5c55 Javac\uff0c\u5b9e\u73b0\u4e86\u7b97\u6cd5\u8fd0\u7b97\uff0c\u6bd4\u8f83\u8fd0\u7b97\uff0c\u903b\u8f91\u8fd0\u7b97\u7b26\u91cd\u8f7d\uff0c\u5e76\u5c01\u88c5\u4e86\u5e38\u7528\u6570\u636e\u7684\u7684\u51fd\u6570\uff0c\u62bd\u8c61\u4e86 Expression\uff0c\u4f7f\u7684 Java \u975e\u5e38\u63a5\u7684 SQL\uff0c\u540c\u65f6\u4e5f\u5b9e\u73b0\u4e86\u7b80\u5355 SQL \u7f16\u7a0b\u7684\u4ee3\u7801\u751f\u6210\uff0c\u57fa\u672c\u4e0d\u9700\u8981\u5199\u4ee3\u7801\uff0c\u4e5f\u4e0d\u9700\u8981\u914d\u7f6e\u5c31\u80fd\u5b9e\u73b0\u7b80\u5355 SQL \u7684\u7f16\u7a0b\uff0c\u8bdd\u4e0d\u591a\u8bf4\uff0c\u5148\u770b\u793a\u4f8b\uff0c\u6709\u5174\u8da3\u53ef\u4ee5\u5230 github \u4e0a\u770b\u3002<\/p>\n<pre><code>Order.Table orderTable = Order.asTable(); Select select = new Select();  select.project(sum(orderTable.amount) \/ sum(orderTable.quantity) * 100)     .from(orderTable)     .groupBy(orderTable.productId); <\/code><\/pre>\n<pre><code>Member.Table member = Member.asTable(); Order.Table order = Order.asTable();  Select select = new Select();  select.from(order, member)         .where(order.memberId.eq(member.id)); select.project(member.no,         member.name,         member.mobile,         countDistinct(order.no).as(\"order_count\"),         sum(order.quantity).as(\"total_quantity\"),         sum(order.amount).as(\"total_amount\"),         min(order.salesAt).as(\"first_shopping\"),         max(order.salesAt).as(\"last_shopping\")); select.groupBy(member.no, member.name, member.mobile); <\/code><\/pre>\n<p>ObjectiveSQL is an ORM framework in Java base on ActiveRecord pattern, which encourages rapid development and clean, codes with the least, and convention over configuration.<\/p>\n<p>Features<\/p>\n<ul>\n<li>Dynamic code generation with JSR 269 for Java API of database access<\/li>\n<li>Full Java API of database access without coding<\/li>\n<li>Dynamically SQL programming with Java syntax, and very close to SQL syntax<\/li>\n<\/ul><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>100<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"4296894\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8865\u5145\u4e00\u4e0b\uff0c\u7b2c\u4e00\u6bb5 Java \u4ee3\u7801\u751f\u6210\u7684 SQL \u5982\u4e0b\uff1a<br \/>&#8220;`sql<br \/>SELECT<br \/> ((((SUM(`T0`.`amount` ) \/ SUM(`T0`.`quantity` ) )) * 100))<br \/>FROM<br \/> `orders` AS `T0`<br \/>GROUP BY<br \/> `T0`.`product_id`<br \/>&#8220;`                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296895\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u7b2c\u4e8c\u6bb5 Java \u4ee3\u7801\u751f\u6210\u7684 SQL \u5982\u4e0b\uff1a<br \/>SELECT<br \/> `T0`.`no` ,<br \/> `T0`.`name` ,<br \/> `T0`.`mobile` ,<br \/> COUNT(DISTINCT `T1`.`no` ) AS `order_count`,<br \/> SUM(`T1`.`quantity` ) AS `total_quantity`,<br \/> SUM(`T1`.`amount` ) AS `total_amount`,<br \/> MIN(`T1`.`sales_at` ) AS `first_shopping`,<br \/> MAX(`T1`.`sales_at` ) AS `last_shopping`<br \/>FROM<br \/> `orders` AS `T1`,<br \/> `members` AS `T0`<br \/>WHERE<br \/> (`T1`.`member_id` = `T0`.`id` )<br \/>GROUP BY<br \/> `T0`.`no` ,<br \/> `T0`.`name` ,<br \/> `T0`.`mobile`                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296896\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : 1194129822 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             mark, \u597d\u50cf mybatis \u4e5f\u6709\u52a8\u6001\u6784\u5efa SQL \u8bed\u53e5\u7684\u7c7b\u3002SQL \u8868\u8fbe\u529b\u5e76\u4e0d\u5f3a\uff0c\u8981\u4e0d\u662f\u5fae\u8f6f\u4e5f\u4e0d\u7528\u4e00\u76f4\u6269\u5c55 SQL \u8bed\u6cd5\u4e86\u3002java \u5c31\u662f java\uff0cSQL \u5c31\u662f SQL \u3002\u6ca1\u6709\u94f6\u5f39\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296897\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @1194129822 \u662f\u7684\uff0c\u6211\u5bf9\u6bd4\u8fc7\u5b83\u7684 DynamicSQLBuilder\uff0c\u5b83\u505a\u7684\u592a\u571f\u4e86\uff0c\u5927\u90fd\u6570\u90fd\u662f\u4ee5\u5b57\u7b26\u4e32\u7684\u5f62\u5f0f\u4f53\u73b0\uff0c\u6211\u7684\u6539\u8fdb\u6709\u4e09\u5757\uff1a<br \/>1 \uff09\u52a8\u6001\u4ee3\u7801\u751f\u6210\uff1a\u6a21\u578b\u4e2d\u7684\u6240\u6709\u5b57\u6bb5\u90fd\u4f1a\u88ab\u52a8\u6001\u751f\u6210\u4e00\u4e2a Order \u7684\u5185\u90e8\u7c7b Table \u4e2d\u7684\u5b57\u6bb5\u3002<br \/>2 \uff09\u7b97\u672f\u8fd0\u7b97\u3001\u6bd4\u8f83\u8fd0\u7b97\u7b26\u548c\u903b\u8f91\u8fd0\u7b97\u91cd\u8f7d\uff0c\u4e5f\u5c31\u662f\u8bf4 Java \u4e2d\u7684 +, -, * \/ , &gt;, &lt;, &amp;&amp;, || \u90fd\u4f1a\u8f6c\u6362\u6210 SQL \u8bed\u53e5\u4e2d\u7684\u8868\u8fbe\u5f0f\uff0c<br \/>3 \uff09\u6211\u5c01\u88c5\u4e86\u5e38\u7528\u6570\u636e\u5e93\u7684\u5e38\u7528\u51fd\u6570\uff0c\u4f8b\u5982\uff1acount, sum \u7b49\u6709\u4e0a\u5343\u4e2a\u7684\uff0c\u8fd9\u6837\u5c31\u4e0d\u4f1a\u51fa\u73b0\u5b57\u7b26<\/p>\n<p>\u4e0a\u8ff0\u505a\u6cd5\u7684\u597d\u5904\u662f\uff0c\u6700\u5927\u7a0b\u5ea6\u7684\u907f\u514d\u7684 SQL \u7684\u8bed\u6cd5\u9519\u8bef\uff0c\u52a8\u6001\u4ee3\u7801\u63d0\u793a\u548c\u5355\u5143\u6d4b\u8bd5\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296898\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : VHacker1989 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             querydsl mybatisplus \u90fd\u6709\u66f4\u597d\u7684\u5b9e\u73b0\uff0c\u7528\u9762\u5411\u5bf9\u8c61\u8bed\u8a00\u5b9e\u73b0\u8e69\u811a\u7684 dsl \u98ce\u683c api \u7b80\u76f4\u591a\u4f59\uff0c\u8fd8\u4e0d\u5982\u7b80\u5355\u67e5\u8be2 jpa\uff0c\u590d\u6742\u67e5\u8be2 sql \u9ad8\u4f4e\u642d\u914d                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296899\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @VHacker1989 <br \/>1 \uff09\u9996\u5148\u6211\u505a\u8fd9\u4e2a\u9879\u76ee\u524d\u80af\u5b9a\u662f\u770b\u8fc7 JOOQ, QueryDSL \u8fd9\u7c7b\u9879\u76ee\u7684\uff0c\u5b83\u6709\u81f4\u547d\u7f3a\u70b9\u5c31\u662f Java \u7684\u8868\u8fbe\u5f0f\u65e0\u6cd5 SQL \u8868\u8fbe\u5f0f\u91cd\u5408\uff0c\u8fd9\u4f1a\u5bfc\u81f4\u6240\u8c13\u7684 SQL Builder \u5728\u590d\u6742 SQL \u4e2d\u6839\u672c\u65e0\u6cd5\u4f7f\u7528\uff0c\u6211\u9879\u76ee\u91cc\u6709\u4e2a\u8ba1\u7b97\u540c\u73af\u6bd4\u7684\u7b80\u5355\u793a\u4f8b\uff0c\u6709\u5927\u91cf\u7684\u6570\u8fd0\u7b97\u548c\u903b\u8f91\u8fd0\u7b97\uff0c\u5982\u679c\u8fd0\u7b97\u7b26\u901a\u8fc7\u51fd\u6570\u7684\u5f62\u5f0f\u5b9e\u73b0\uff0c\u90a3\u6837\u7684\u4ee3\u7801\u6839\u672c\u65e0\u6cd5\u770b\u3002<br \/>2 \uff09\u6211\u7684\u9879\u76ee\u4e2d\u53c2\u8003\u4e86 Lombok \u7684\u52a8\u6001\u4ee3\u7801\u751f\u6210\uff0c\u80fd\u591f\u51cf\u5c11\u7edd\u5927\u90e8\u5206\u7684\u91cd\u590d\u4ee3\u7801\uff0c\u5b83\u4eec\u662f\u65e0\u6cd5\u505a\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296900\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @VHacker1989 \u50cf\u8fd9\u6837\u7684\u4ee3\u7801\uff1a\u201c sum(orderTable.amount) \/ sum(orderTable.quantity) * 100\u201d<br \/>\u4f60\u731c MyBatis, JOOQ, QueryDSL \u4f1a\u5199\u6210\u4ec0\u4e48\u6837\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296901\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e00\u95e8\u8bed\u8a00\uff0c\u5b83\u7684\u8bed\u6cd5\u8868\u73b0\u8fb9\u975e\u5e38\u91cd\u8981\uff0c\u80fd\u591f\u51c6\u786e\u7684\u63cf\u8ff0\u51fa\u4e1a\u52a1\u9886\u57df\u7684\u5173\u952e\u7279\u5f81\uff0c\u662f\u4e00\u6bb5\u4ee3\u7801\u53ef\u7ef4\u62a4\u6027\u7684\u91cd\u8981\u6807\u5fd7                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296902\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : mebtte <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             knex.js                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296903\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : shade <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8ddf APIJSON \u6bd4\u8f83\uff0c\u6709\u4ec0\u4e48\u4f18\u52bf\u5462\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296904\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : liuhan907 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u770b\u8d77\u6765\u597d\u50cf\u5c71\u5be8\u7248\u7684 entity framework \u554a\u3002\u8fd9\u4e2a\u4ec5\u9650\u67e5\u8be2\u4e48\uff0c\u662f\u5426\u652f\u6301\u81ea\u52a8 diff \u548c\u4fee\u6539\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296905\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @liuhan907 \u4ec0\u4e48\u53eb\u5c71\u5be8\u7248\uff0c\u76f8\u6bd4\u73b0\u6709\u7684 ORM \u6846\u67b6\uff0c\u4f18\u52bf\u4e3b\u8981\u4f53\u73b0\u5728\uff1a<br \/>1 \uff09\u52a8\u6001\u4ee3\u7801\u751f\u6210\uff0c\u7c7b\u4f3c Lombok<br \/>2 \uff09 Java \u8fd0\u7b97\u7b26\u91cd\u8f7d\uff0c\u9886\u5148\u4e8e\u73b0\u6709\u7684\u6240\u6709 ORM \u6846\u67b6<br \/>3 \uff09\u51fd\u6570\u5c01\u88c5\u662f\u53c2\u8003 JOOQ \u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296906\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @shade apijson \u597d\u50cf\u4e0d\u662f\u540c\u4e00\u7c7b\u4e1c\u897f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296907\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : chinvo <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom #12 \u4f60\u771f\u7684\u9700\u8981\u53bb\u4e86\u89e3\u4e0b LinQ \u548c Entity Framework\uff0c\u5f00\u9614\u4e0b\u773c\u754c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296908\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : AlexaZhou <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u770b\u7528\u6cd5\u6bd4 mybatis \u65b9\u4fbf\u591a\u4e86\uff0c\u652f\u6301\u4e00\u4e2a                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296909\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : oahebky <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5f88\u5389\u5bb3\uff0c\u6211\u505a\u4e0d\u51fa\u6765\uff1b<\/p>\n<p>\u4f46\u662f\u6211\u9009\u62e9 Python + SQLAlchemy                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296910\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : beyondex <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             Java \u505a\u5230\u8fd9\u6837\u5f88\u68d2\u4e86\uff0c\u53ef\u4ee5\u4e86\u89e3\u4e0b .NET Linq Queryable\uff0c\u8bed\u8a00\u7ea7\u652f\u6301\u7c7b\u4f3c sql \u8fd9\u6837\u7684\u5199\u6cd5\uff0c\u53ef\u4ee5\u89e3\u6790\u540e\u751f\u6210 sql \u3002<br \/>EntityFramework \u8fd8\u6709 \u4ece Java \u79fb\u690d\u8fc7\u6765\u7684 NHibernate \u90fd\u6709\u5bf9\u8fd9\u4e2a Linq Queryable \u7684\u5b9e\u73b0\uff0c\u5341\u5206\u4f18\u96c5\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296911\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : houzhen <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5938\u4e00\u4e0b\u4e5d\u725b\u903c\u5c31\u8fd9\u4e48\u96be\u4e48\uff0c\u592a\u5c4c\u4e86\u8001\u54e5\u3002\u4ee3\u8868\u6f2f\u6cb3\u4eba\u6c11\u652f\u6301\u4f60\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296912\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fiveelementgid <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             C#\u8def\u8fc7\uff0cLinq \u73a9\u5bb6\u7528 Entity Framework Core \u8868\u793a\u773c\u719f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296913\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : LancerComet <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u633a\u597d\u7684\uff0c\u611f\u89c9 LinqSql \u8fd9\u4e2a\u540d\u5b57\u66f4\u8d34\u5207                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296914\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : vone <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @liuhan907 <br \/>@chinvo <br \/>\u5f88\u660e\u663e\u4e3b\u6ca1\u63a5\u89e6\u8fc7 .NET \u751f\u6001\u3002Entity Framework \u5f88\u591a\u5e74\u524d\u5c31\u505a\u5230\u4e86\u4e3b\u60f3\u505a\u7684\uff0c\u4e0d\u4ec5\u63d0\u4f9b\u66f4\u50cf SQL \u7684 C# \uff0c\u540c\u65f6\u4e5f\u63d0\u4f9b\u7684\u4e00\u5957\u66f4\u50cf C# \u7684 SQL \u3002<\/p>\n<p>\u5047\u8bbe\u76ee\u6807 SQL \u4e3a\uff1a<br \/>SELECT TOP 10 OrderID, Freight FROM Orders ORDER BY Freight DESC<\/p>\n<p>\u5728 .NET (C#) \u4e2d\u4f7f\u7528\u5170\u59c6\u8fbe\u8868\u8fbe\u5f0f\u7684\u5199\u6cd5:<br \/>Orders.OrderByDescending (m =&gt; m.Freight).Select (m =&gt;new{OrderID = m.OrderID,Freight = m.Freight}).Take (10)<\/p>\n<p>\u5728 .NET (C#) \u4e2d LINQ \uff08\u7c7b SQL \uff09\u7684\u5199\u6cd5:<br \/>(from m in Orders orderby m.Freight descending select new { m.OrderID,m.Freight }).Take(10)<\/p>\n<p>\u8be6\u7ec6\u6587\u6863\uff1a<br \/>https:\/\/docs.microsoft.com\/zh-cn\/dotnet\/csharp\/programming-guide\/concepts\/linq\/basic-linq-query-operations                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296915\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : pagepancn <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e3a\u4f60\u7684\u6267\u884c\u529b\u548c\u6280\u672f\u80fd\u529b\u70b9\u8d5e\uff0c\u4f46\u662f\u771f\u7684\u7528\u5904\u4e0d\u5927\u3002\u7a0b\u5e8f\u5458\u601d\u7ef4\u554a\uff0c\u7f3a\u4e4f\u5546\u4e1a\u773c\u5149                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296916\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : laminux29 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             1.\u9898\u4e3b\u7684\u7cbe\u795e\u8fd8\u662f\u503c\u5f97\u8d5e\u626c\u7684\uff0c\u5f00\u6e90\u5c31\u662f\u9700\u8981\u8fd9\u79cd\u7cbe\u795e\uff0c\u4e0d\u7136\u5f00\u6e90\u754c\u5b8c\u86cb\u4e86\u3002<\/p>\n<p>2.\u505a\u5f00\u6e90\u6709\u4e24\u4e2a\u9ebb\u70e6\u7684\u5730\u65b9\uff0c\u7b2c\u4e00\u662f\u82b1\u4e86\u51e0\u5e74\u529f\u592b\u8f9b\u8f9b\u82e6\u82e6\u5b9e\u73b0\u4e86\u67d0\u4e2a\u529f\u80fd\uff0c\u7ed3\u679c\u5b98\u65b9\u6216\u522b\u7684\u7ec4\u7ec7\u66f4\u65b0\u4e00\u4e0b\u51fa\u4e86\u66f4\u597d\u7684\u7ec4\u4ef6\uff0c\u8fd9\u5c31\u5c34\u5c2c\u4e86\u3002\u7b2c\u4e8c\u662f\u5199\u4e4b\u524d\u6ca1\u6709\u53bb\u505a\u5927\u91cf\u7684\u8c03\u7814\uff0c\u6ca1\u6ce8\u610f\u5230\u5e02\u9762\u4e0a\u5df2\u7ecf\u6709\u4e86\u66f4\u597d\u7684\u5b9e\u73b0\uff0c\u6bd4\u5982\u5404\u5927\u8bed\u8a00\u7684 lambda \u8868\u8fbe\u5f0f\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296917\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : msg7086 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8868\u73b0\u529b\u662f\u786c\u4f24\u3002\u7528\u60ef Ruby \u7684\u8868\u793a\u8fd9\u4e9b\u7528 DSL \u5199\u5199\u771f\u662f\u5c0f\u83dc\u4e00\u789f\u2026\u2026Java \u7684\u8bdd\u53ef\u80fd\u4f1a\u96be\u4e0d\u5c11\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296918\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : kingfalse <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u559c\u6b22 Lombok,\u66f4\u4e0d\u559c\u6b22\u518d\u591a\u88c5\u4e00\u4e2a\u540c\u7c7b\u7684,\u597d\u5947\u4e24\u4e2a\u4f1a\u4e0d\u4f1a\u51b2\u7a81\u4ec0\u4e48\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296919\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : justin2018 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4ee5\u4e3a\u662f iOS \u7684 Objective-C                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296920\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @vone \u5144\u5f1f\u6211\u8fd8\u771f\u770b\u8fc7\uff0cEntity Framework \u9488\u5bf9 \u6bd4\u8f83\u8fd0\u7b97\u7b26\u548c\u903b\u8f91\u8fd0\u7b97\u7b26\u662f\u65e0\u6cd5\u652f\u6301\u7684\uff0c\u4f8b\u5982<\/p>\n<p>SELECT * FROM Orders WHERE OrderID &gt; 10 AND Freight = 1<\/p>\n<p>\u8fd9\u7c7b\u5199\u8d77\u6765\u592a\u590d\u6742\u4e86\u3002<\/p>\n<p>\u5728 ObjectiveSQL \u4e2d\uff0c\u7f3a\u5f88\u65b9\u4fbf\u3002<\/p>\n<p>select.where( order.orderId &gt; 10 &amp;&amp; order.freight.eq(1) )                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296921\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @kingfalse \u4e24\u8005\u4e0d\u4f1a\u51b2\u7a81\uff0cLombok \u6709\u4eba\u7231\uff0c\u6709\u4eba\u6068\uff0c\u5f88\u6b63\u5e38\u7684\uff0c\u5c31\u50cf Java \u4e00\u6837\uff0c\u4f60\u53ef\u4ee5\u7231\u4ed6\uff0c\u4e5f\u53ef\u4ee5\u6068\u4ed6\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296922\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : dick20cm <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8001\u54e5\u771f\u7684\u725b\u903c\uff01\uff01                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296923\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : cmlanche <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @pagepancn \u6211\u89c9\u5f97\u5f88\u597d                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296924\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zhuangzhuang1988 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u725b\u903c.                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296925\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : nannanziyu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom <br \/>LINQ \u91cc<br \/>Orders.Where(x=&gt;x.orderId &gt; 10 &amp;&amp; x.freight == 1)                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296926\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : huskar <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6211\u611f\u89c9\u8fd9\u79cd\u7279\u6027\u53ea\u6709\u5728\u8bed\u8a00\u5c42\u9762\u652f\u6301\u624d\u6709\u610f\u4e49\uff0c\u7b2c\u4e09\u65b9\u5e93\u5b9e\u73b0\u7684\u603b\u5f52\u5199\u8d77\u6765\u9ebb\u70e6\u3002\u3002\u3002\u5c31\u50cf\u5404\u79cd\u8bed\u8a00\u90fd\u6709\u7c7b\u4f3c\u8fd9\u79cd\u5e93\uff0c\u4f46\u5b9e\u9645\u7528\u7684\u591a\u7684\u53ea\u6709 c#\u7684 linq \u3002<br \/>\u4e4b\u524d\u521a\u5b66 kotlin \u7684\u65f6\u5019\u4e5f\u4eff\u7167 linq \u5199\u4e86\u4e00\u4e2a\u7c7b\u4f3c\u7684\u4e1c\u897f\uff0c\u5229\u7528 kotlin \u7684\u4e2d\u7f00\u8868\u8fbe\u5f0f\u80fd\u641e\u7684\u5f88\u50cf\u76f4\u63a5\u5199 sql\uff0c\u4f46\u5199\u5b8c\u540e\u81ea\u5df1\u4e5f\u4ece\u6765\u6ca1\u7528\u8fc7\u3002\u3002\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296927\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @nannanziyu \u5144\u5f1f\uff0c\u90a3\u662f\u5bf9\u5df2\u7ecf\u51fa\u6765\u7684\u6570\u636e\u8fdb\u884c\u8fc7\u6ee4\uff0c\u800c\u4e0d\u662f\u5728 SQL \u4e2d\u8fc7\u6ee4\u7684\uff0c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296928\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @huskar kotlin \u548c Scala \u5f88\u5bb9\u6613\u7684\uff0c\u8bed\u8a00\u81ea\u8eab\u5c31\u652f\u6301\u8fd0\u7b97\u7b26\u91cd\u8f7d\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296929\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : nannanziyu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom <br \/>\u4f60\u7684\u7406\u89e3\u662f\u9519\u8bef\u7684\uff0c\u4f60\u9700\u8981\u518d\u4e86\u89e3\u4e00\u4e0b linq                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296930\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : renyijiu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6709\u5b9e\u9645\u751f\u4ea7\u9879\u76ee\u4f7f\u7528\u7ecf\u9a8c\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296931\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : icew4y <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom \u4e3b\u5f88\u725b\uff0c\u4e0a\u6709\u4e9b\u5632\u8bbd\u7684\uff0c\u4f30\u8ba1\u90fd\u662f\u8c03\u5305\u4fa0                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296932\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : levon <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom \u5e76\u4e0d\u662f\u5bf9\u5df2\u7ecf\u8bfb\u51fa\u6765\u7684\u6570\u636e\u8fc7\u6ee4\uff0c\u8fd9\u4e9b\u6700\u540e\u90fd\u4f1a\u751f\u6210\u5bf9\u5e94\u7684 sql \u8bed\u53e5\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296933\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : beichenhpy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u652f\u6301                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296934\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @renyijiu \u73b0\u5728\u6709 4\uff0c5 \u4e2a\u516c\u53f8\u5728\u7528\uff0c\u6bd5\u7adf\u521a\u521a\u53d1\u5e03 2 \u4e2a\u6708\u5de6\u53f3\uff0c\u95ee\u9898\u80af\u5b9a\u6bd4\u8f83\u591a\uff0c\u6211\u4e5f\u4f1a\u53ca\u65f6\u4fee\u590d\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296935\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : avalon8 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e3a\u8001\u54e5\u70b9\u4e2a\u8d5e\uff0c\u725b\u903c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296936\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u793e\u533a\u7684\u5efa\u8bbe\u4e5f\u5728\u51c6\u5907\u4e2d\uff0c\u5e0c\u671b\u66f4\u591a\u5144\u5f1f\u53c2\u4e0e\u8fdb\u6765\uff0c\u540e\u9762\u6211\u4e5f\u5c06\u5185\u90e8\u7684\u6280\u672f\u539f\u7406\u6574\u7406\u5e76\u5206\u4eab\u51fa\u6765\u3002\u91cc\u9762\u7684\u9a9a\u64cd\u4f5c\u6bd4\u8f83\u591a\uff0c\u4e0d\u662f\u5f88\u5e38\u7528\uff0c\u7f3a\u5f88\u5b9e\u7528\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296937\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : mzlgx <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6709\u70b9\u610f\u601d                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296938\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fafa2npu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom \u9996\u5148\u9898\u4e3b\u771f\u7684\u5f88\u725b\u903c\u3002\u4f46\u662f\uff0cquerable \u7684 LINQ \u786e\u5b9e\u662f\u5728 SQL \u4e2d\u8fc7\u6ee4\u7684\uff0cEF \u4e2d\u6709\u4e2a lazy load\uff0c\u53ea\u6709\u5728 ToList()\u7b49\u9700\u8981\u53d6\u6570\u636e\u7684\u65f6\u5019\u624d\u4f1a\u771f\u6b63\u5728\u6570\u636e\u5e93\u7aef\u6267\u884c\u67e5\u8be2\u8bed\u53e5\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296939\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fafa2npu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u7ed9\u8001\u54e5\u70b9\u4e2a\u8d5e                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296940\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @fafa2npu \u6211\u4ed4\u7ec6\u7814\u7a76\u4e00\u4e0b LINQ\uff0c\u8981\u770b\u6700\u7ec8\u6267\u884c\u7684 SQL \u662f\u4ec0\u4e48\uff0c\u53ef\u4ee5\u53c2\u8003\u4e00\u4e0e\u5b83\u7684\u5b9e\u73b0\u539f\u7406\u3002\u5176\u5b9e\u52a8\u6001 SQL \u53ea\u662f\u5176\u4e2d\u4e00\u90e8\u5206\u7279\u6027                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296941\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : running17 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u70b9\u8d5e\uff0c\u725b\u903c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296942\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : abcbuzhiming <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u611f\u89c9\u6709\u70b9\u50cf Linq\uff0c\u4f46\u662f\u6211\u8981\u8bf4\u7684\u662f\uff0c\u8fd9\u6761\u8def\u5df2\u7ecf\u6709\u4eba\u8bd5\u9a8c\u8fc7\u4e86\uff0c\u4e0d\u592a\u5408\u9002\u2014\u2014\u6240\u6709\u50cf SQL \u7684\uff0c\u4e3a\u5565\u4e0d\u76f4\u63a5\u7528 SQL \uff1f\u8fd9\u5c31\u662f\u95ee\u9898\u7684\u6839\u6e90\uff0cSQL \u867d\u7136\u8868\u8fbe\u80fd\u529b\u4e00\u822c\uff0c\u4f46\u662f\u751f\u547d\u529b\u5f88\u5f3a\uff0c\u5f3a\u5230\u50cf\u5b83\u7684\u90fd\u6ca1\u71ac\u8fc7\u5b83                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296943\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @abcbuzhiming \u6211\u8981\u89e3\u51b3\u7684\u95ee\u9898\u5982\u4e0b\uff1a<br \/>1 \uff09\u91cd\u7528\u6027\uff0c\u4e00\u4e2a\u590d\u6742\u67e5\u8be2\u4e2d\u7ecf\u5e38\u4f1a\u591a\u6b21 JOIN \u540c\u4e00\u5f20\u8868\uff0c\u53ea\u6709\u5c11\u91cf\u53d8\u5316\uff0cSQL \u65e0\u6cd5\u89e3\u51b3\uff0c\u53ea\u901a\u8fc7\u901a\u8fc7\u8fc7\u7a0b\u5316\u7f16\u7a0b\u8bed\u8a00\u89e3\u51b3\uff0cJava \u53ea\u662f\u4e00\u79cd\u9009\u62e9\u800c\u5df2\u3002<br \/>2 \uff09\u52a8\u6001\u6027\uff0c\u4e00\u4e2a\u590d\u6742\u67e5\u8be2\u4e2d\u4f1a\u6839\u636e\u53c2\u6570\u4e0d\u4e00\u6837\uff0cJOIN \u4e0d\u540c\u7684\u8868 \/\u5b50\u67e5\u8be2\uff0c\u6295\u5f71\u4e0d\u540c\u7684\u5b57\u6bb5\uff0c\u5f53\u7136 Where \u540e\u7684\u8868\u8fbe\u5f0f\u4f1a\u6709\u8f83\u5927\u7684\u53d8\u5316\u3002<br \/>3 \uff09\u5355\u5143\u6d4b\u8bd5\uff0c\u4e00\u4e2a\u590d\u6742 SQL \u62c6\u5206\u6210\u591a\u4e2a\u8fc7\u7a0b\uff0c\u9488\u5bf9\u8fc7\u7a0b\u8fdb\u884c\u5355\u5143\u6d4b\u8bd5\uff0c\u800c\u4e0d\u662f\u4e00\u6761\u975e\u5e38\u590d\u6742\u7684 SQL \u8fdb\u884c\u6d4b\u8bd5                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296944\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : xiangwan <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @abcbuzhiming sql \u662f\u58f0\u660e\u5f0f\u8bed\u8a00\uff0c\u66f4\u5148\u8fdb<\/p>\n<p>@Braisdom jooq \u6a21\u4eff\u7684 linq                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296945\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @xiangwan jooq \u6211\u53c2\u8003\u8fc7\uff0c\u770b\u8fc7\u5b83\u7684\u4ee3\u7801\uff0c\u8bbe\u8ba1\u7406\u5ff5\u5f88\u597d\uff0c\u4f46\u7a0b\u5e8f\u8bbe\u8ba1\u4e00\u822c\uff0c\u4e0d\u591f\u7075\u6d3b\uff0c\u6700\u5173\u952e\u662f\u7684\u5b83\u7684\u4ee3\u7801\u9700\u8981\u624b\u52a8\u751f\u6210\uff0c\u6bcf\u6b21\u8c03\u6574\u5b8c\u4e4b\u540e\uff0c\u90fd\u5f97\u751f\u6210\u4e00\u4e0b\u4ee3\u7801\u624d\u80fd\u7f16\u8bd1\u901a\u8fc7\uff0c\u597d\u9ebb\u70e6\u3002<\/p>\n<p>SQL \u8bed\u8a00\u8bbe\u8ba1\u7684\u521d\u8877\u662f\u4e3a\u6570\u636e\u5206\u6790\u4eba\u5458\u63d0\u4f9b\u7684\u4e00\u79cd\u8bed\u8a00\uff0c\u6bd4\u8f83\u63a5\u8fd1\u81ea\u7136\u8bed\u8a00\uff0c\u4f46\u548c\u903b\u8f91\u578b\u7f16\u8bd1\u8bed\u8a00\u7ed3\u5408\u4e0d\u662f\u5f88\u53cb\u597d\uff0c<br \/>\u76ee\u524d\u6240\u6709\u903b\u8f91\u578b\u7f16\u7a0b\u8bed\u8a00\u91cc\uff0c\u90fd\u662f\u4ee5\u5b57\u7b26\u4e32\u7684\u5f62\u5f0f\u5b58\u5728\u3002<\/p>\n<p>\u5176\u5b9e\u56de\u5f52\u672c\u8d28\uff0cJava \u8bed\u8a00\u662f\u4e00\u95e8\u9ad8\u5ea6\u62bd\u8c61\u7684\u8bed\u8a00\uff0c\u5b83\u53ef\u4ee5\u89e3\u91ca\u4e00\u5207\u77e5\u8bc6\u9886\u57df\uff0c\u6570\u636e\u5e93\u53ea\u662f\u4e00\u4e2a\u9886\u57df\u800c\u5df2\uff0c\u5982\u679c\u6ca1\u6709 SQL \u4f60\u4f1a\u600e\u4e48\u8bbe\u8ba1\uff0c\u600e\u4e48\u6837\u7528\u9762\u5411\u5bf9\u8c61\u7684\u65b9\u5f0f\u8bbe\u8ba1\u6570\u636e\u5e93\u7684\u8bbf\u95ee\u3002<\/p>\n<p>\u7b2c\u4e00\u6027\u539f\u7406\uff0c\u6211\u8bbe\u8ba1\u65f6\uff0c\u5148\u53c2\u8003\u73b0\u6709\u7684\u77e5\u8bc6\uff0c\u7136\u540e\u518d\u5fd8\u6389\u6240\u6709\u7684\u77e5\u8bc6\uff0c\u5b83\u539f\u672c\u5e94\u8be5\u600e\u4e48\u6837\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296946\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Betsy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5370\u8c61\u4e2d calcite-linq4j \u8c8c\u4f3c\u4e5f\u5b9e\u73b0\u4e86\u8fd9\u6837\u73a9\u6cd5\uff0c\u8001\u54e5\u8fd9\u4e2a\u9879\u76ee\u8ddf\u90a3\u4e2a\u6709\u5565\u4e0d\u4e00\u6837\u7684\u5730\u65b9\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296947\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Betsy Calcite \u5728\u6211\u4eec\u516c\u53f8\u91cc\u7528\u4e86\uff0clinq4j \u548c\u6211\u7684\u5dee\u522b\u5f88\u5927\u7684\uff0c\u5b83\u53ea\u662f Java8 Stream \u4e2d\u7684\u6269\u5c55\uff0c\u53ea\u662f\u5bf9\u5185\u5b58\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u8fc7\u6ee4\u548c\u8ba1\u7b97\uff0cCalcite \u672c\u8d28\u4e0a\u662f\u4e00\u4e2a\u5173\u7cfb\u6570\u636e\u5e93\u7684\u8ba1\u7b97\u5f15\u64ce\uff0c\u505a\u7684\u5f88\u4e0d\u9519\uff0c\u540e\u9762\u6211\u4e5f\u4f1a\u96c6\u6210\u8fdb\u6211\u7684\u9879\u76ee\uff0c\u5b9e\u73b0\u5f02\u6784\u6570\u636e\u6e90\u7684\u8ba1\u7b97\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296948\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : dswyzx <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6211\u8fd8\u662f\u559c\u6b22\u81ea\u5df1\u638c\u63a7 sql \u8bed\u53e5\uff0c\u8bf4\u5b9e\u5728\u7684\uff0c\u901a\u8fc7 linq \u53bb\u89c4\u8303\u4ee5\u8fbe\u5230\u8fd0\u884c\u65f6\u62a5\u9519\uff0c\u6216\u600e\u4e48\u6837\u7684\u597d\u5904\u3002\u5728\u6211\u7684\u72ed\u9698\u7406\u89e3\u91cc\uff0c\u4e3a\u4f55\u4e0d\u53bb\u638c\u63e1\u597d\u597d\u5199 sql \u7684\u80fd\u529b\uff0c\u751a\u81f3\u8fd8\u53ef\u4ee5\u8ba9\u516c\u53f8\u7684 dba \u6765\u4e3b\u52a8\u4f18\u5316\u8fd9\u4e2a\u4e1c\u897f\u3002\u6709\u4eba\u53ef\u4ee5\u8fa9\u8bba\u4e00\u4e8c\u5417                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296949\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : comsweetcs <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u9996\u5148\u4e3a\u4e3b\u7684\u6280\u672f\u70b9\u8d5e\u3002\u4f46\u6211\u771f\u662f\u8ba8\u538c SQL\uff0cSQL \u8c03\u8bd5\u8d77\u6765\u6ca1\u4ee3\u7801\u76f4\u89c2\uff0c\u6211\u5c31\u662f\u505a\u6570\u636e\u5f00\u53d1\u7684\uff0c\u611f\u89c9\u5199\u4ee3\u7801\u63a7\u5236\u7c92\u5ea6\u66f4\u597d\uff0c\u4e2a\u4eba\u89c9\u5f97\u540e\u7aef\u4e0d\u53ef\u80fd\u6f14\u53d8\u6210\u8fd9\u79cd\u65b9\u5f0f\uff0c\u8fc7\u4e8e\u6b7b\u677f\uff0c\u4e0d\u591f\u7075\u6d3b\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296950\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @dswyzx DBA \u548c\u7a0b\u5e8f\u5458\u7684\u804c\u8d23\u4e0d\u4e00\u6837\uff0c\u9762\u5bf9\u7684\u95ee\u9898\u57df\u4e5f\u4e0d\u4e00\u6837\u3002<br \/>DBA\uff1a\u901a\u5e38\u9762\u5bf9\u7684\u662f\u9759\u6001\u95ee\u9898\uff0c\u8003\u8651\u7684\u573a\u666f\u4e5f\u6bd4\u8f83\u5355\u4e00\uff0c\u7528 SQL \u4f5c\u4e3a\u5de5\u5177\u662f\u6bd4\u8f83\u5408\u9002\uff0c\u65e0\u8bba\u662f\u4f18\u5316\uff0c\u8fd8\u662f\u7ef4\u62a4 SQL \u53ef\u80fd\u662f\u6700\u4ef7\u7684\u9009\u62e9\uff0c\u5c31\u50cf\u811a\u672c\u578b\u8bed\u8a00\u662f \u8fd0\u7ef4\u5de5\u7a0b\u5e08\u7684\u6700\u7231\u3002<\/p>\n<p>\u7a0b\u5e8f\u5458\uff1a\u901a\u8fc7\u9762\u5bf9\u7684\u662f\u52a8\u6001\u95ee\u9898\uff0c\u4e00\u6bb5\u542b\u6709 SQL \u548c Java \u7684\u4ee3\u7801\u903b\u8f91\u9700\u8981\u6ee1\u8db3\u5f88\u591a\u573a\u666f\uff0c\u5404\u79cd\u5947\u602a\u7684\u4f7f\u7528\u65b9\u5f0f\uff0cSQL \u7684\u6784\u9020\u8fc7\u7a0b\u4e5f\u975e\u5e38\u590d\u6742\uff0c\u6b64\u65f6 SQL \u8bed\u6cd5\u903b\u8f91\u548c\u8868\u73b0\u529b\u5c31\u591f\u7528\u4e86\uff0c\u5982\u679c\u662f\u7eaf\u7cb9\u7684\u5b57\u7b26\u4e32\u62fc\u63a5\uff0c\u4e5f\u4f1a\u8ba9\u7a0b\u5e8f\u5458\u5d29\u6e83\uff0c\u7b80\u5355\u7684\u8fd8\u597d\uff0c\u771f\u590d\u6742\u8d77\u6765\u89e3\u51b3 Bug \u7684\u6210\u672c \u5c31\u5f88\u9ad8\u4e86\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296951\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @comsweetcs \u601d\u8003\u7684\u89d2\u5ea6\u4e0d\u4e00\u6837\uff0c\u5904\u7406\u7684\u95ee\u9898\u57df\u4e0d\u4e00\u6837\uff0c\u5bf9\u5de5\u5177\u7684\u9009\u62e9\u5c31\u4f1a\u4e0d\u540c\uff0c\u6211\u4eec\u9700\u8981\u66f4\u5ba2\u89c2\u7684\u5206\u6790                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296952\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : dingyaguang117 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8d5e \u50cf sqlalchemy                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296953\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Pursue9 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             .net \u8fd9\u8fb9\u5df2\u7ecf\u4e0d\u5199 sql \u5f88\u591a\u5e74\u4e86\uff0cEFcore \u5df2\u7ecf\u5b8c\u5168\u6ee1\u8db3\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u9700\u8981\uff0c\u751f\u6210\u7684 sql \u4e5f\u53ef\u4ee5\u8bb0\u5f55\u5728\u65e5\u5fd7\u91cc<br \/>\u5b8c\u5168\u4e0d\u5199 SQL \u7684 orm \u662f\u53ef\u884c\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296954\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Pursue9 \u8ba4\u53ef\u4f60\u7684\u60f3\u6cd5\uff0c\u6570\u636e\u5206\u6790\u53ea\u662f\u4e00\u4e2a\u95ee\u9898\u57df\uff0cSQL \u53ea\u662f\u4e00\u4e2a\u534f\u8bae\uff0c\u6211\u4eec\u8bbf\u95ee\u7f51\u7edc\u65f6\uff0c\u5b8c\u5168\u4e0d\u77e5\u9053\u5b83\u5e95\u5c42\u7684\u7ed3\u6784\uff0c\u6211\u4eec\u5728\u505a HTTP \u5e94\u7528\u65f6\uff0c\u57fa\u672c\u4e5f\u4e0d\u4f1a\u63a5\u89e6 HTTP \u534f\u8bae\u672c\u8eab\uff0c\u7edf\u8ba1\u548c\u5206\u6790\u6570\u636e\u7406\u8bba\u4e0a\u4e5f\u5e94\u8be5\u4e00\u6837\u7684\u65b9\u5f0f\u8fdb\u884c\u6f14\u8fdb\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296955\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Lemeng <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8d5e\uff0c\u5b66\u4e60\u5b66\u4e60\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296956\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : beginor <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             linq \u5728 .net \u4e0a\u5b58\u5728\u597d\u591a\u5e74\u4e86\uff0c \u8fd9\u662f\u4e0d\u4e89\u7684\u4e8b\u5b9e\uff0c \u5728\u5f88\u591a\u573a\u666f\u4e0b\u786e\u5b9e\u6bd4\u624b\u5199 SQL \u65b9\u4fbf\u3002<\/p>\n<p>\u5728 .net \u4e2d\u6709\u8868\u8fbe\u5f0f\u6811\u7684\u6982\u5ff5\uff0c \u901a\u8fc7\u5206\u6790\u4ee3\u7801\u4e2d\u7684\u8868\u8fbe\u5f0f\u6811\uff0c \u52a8\u6001\u7684\u8f6c\u6362\u6210 SQL \u8868\u8fbe\u5f0f\uff0c \u751a\u81f3\u662f\u4e0d\u540c\u6570\u636e\u5e93\u7684\u65b9\u8a00\uff0cNHibernate \u53ef\u4ee5\u8bf4\u662f\u5178\u8303\uff0c \u8fd9\u5927\u6982\u662f\u4e3a\u4ec0\u4e48 NHibernate \u4ecd\u5728\u6d3b\u8dc3\u5f00\u53d1\u7684\u539f\u56e0\u5427\u3002<\/p>\n<p>\u5f53\u5e74\uff0c .net \u5e73\u53f0\u4e0a\u4e5f\u6709 mybatis.net \uff0c \u4f46\u662f\u57fa\u4e8e linq \u7684\u67e5\u8be2\u6d41\u884c\u4e4b\u540e\uff0c \u8fd9\u79cd\u624b\u5199 SQL \u7684\u534a\u81ea\u52a8\u6846\u67b6\u5c31\u9010\u6e10\u6ca1\u843d\u4e86\u3002<\/p>\n<p>\u5f53\u7136\uff0c \u5b8c\u5168\u4e0d\u5199 SQL \u4e5f\u662f\u4e0d\u53ef\u80fd\u7684\uff0c \u6bd5\u7adf SQL \u662f\u57fa\u7840\uff0c \u5f88\u591a\u590d\u6742\u7684\u67e5\u8be2\u4e5f\u7528 SQL \u6765\u5b9e\u73b0\u6700\u9ad8\u6548\u3002<\/p>\n<p>\u51e1\u662f\u90fd\u6709\u4e2a\u4e8c\u516b\u539f\u5219\uff0c \u4e0d\u5fc5\u6c42\u5168\u8d23\u5907\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296957\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fangcan <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u725b\u76ae \u70b9\u8d5e                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296958\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @beginor \u662f\u7684\uff0cSQL \u5386\u53f2\u5df2\u7ecf\u5f88\u957f\uff0c\u65b0\u578b\u6280\u672f\u5b8c\u5168\u66ff\u4ee3\uff0c\u53ef\u80fd\u9700\u8981\u5f88\u957f\u7684\u65f6\u95f4\uff0c\u751a\u81f3\u9700\u8981\u7684\u662f\u4e00\u4ee3\u4eba\u3002<br \/>\u6211\u4eec\u7684\u8111\u5b50\u91cc\u8981\u6709\u4e24\u4e2a\u4e16\u754c\uff0c\u4e00\u4e2a\u662f\u5ba2\u89c2\u5b58\u5728\u7684\u4e16\u754c\uff0c\u4e00\u4e2a\u662f\u6211\u4eec\u4e3b\u89c2\u8ba4\u4e3a\u7684\u4e00\u79cd\u4e16\u754c\uff08\u4e5f\u5c31\u662f\u4e16\u754c\u5e94\u8be5\u600e\u4e48\u6837\uff09\u3002<\/p>\n<p>\u6709\u65f6\u4e3b\u89c2\u8ba4\u4e3a\u7684\u4e16\u754c\u91cc\u6709\u4e00\u4e9b\u6b63\u786e\u7684\u4e8b\u60c5\uff0c\u5ba2\u89c2\u4e16\u754c\u91cc\u4e0d\u4e00\u5b9a\u63a5\u53d7\uff0c\u968f\u7740\u6280\u672f\u7684\u8fdb\u6b65\uff0c\u6709\u53ef\u80fd\u88ab\u8d85\u8d8a\uff0c\u4e5f\u6709\u53ef\u80fd\u5728\u82e5\u5e72\u540e\u6210\u4e3a\u4e3b\u6d41\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296959\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : beginor <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u4e2a\u4e5f\u53ef\u4ee5\u53c2\u8003\u4e00\u4e0b\uff0chttps:\/\/github.com\/my2iu\/Jinq                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296960\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @beginor Jinq \u548c ObjectiveSQL \u6709\u70b9\u7c7b\u4f3c\uff0c\u4f46\u8fd8\u662f\u6709\u672c\u8d28\u7684\u533a\u522b\uff0c<br \/>1 \uff09 Jinq \u7684\u8868\u8fbe\u5f0f\u4f9d\u7136\u662f Java \u57fa\u7840\u8868\u8fbe\u5f0f\u5f62\u5f0f\uff0c\u4e5f\u5c31\u662f\u53ea\u80fd\u6309 Java \u89c4\u8303\u8fdb\u884c\u8868\u8fbe\u5f0f\u8ba1\u7b97\uff0c\u4f46\u5728 SQL \u4e2d\u901a\u5e38\u4f1a\u9047\u5230\u51fd\u6570\u8c03\u7528\u540e\u7684\u8868\u8fbe\u5f0f\u8ba1\u7b97<br \/>2 \uff09 Select \u548c Where \u662f\u901a\u8fc7 lambda \u89e3\u6790\u5b9e\u73b0\uff0c\u4ee3\u7801\u8868\u73b0\u529b\u5dee\u592a\u591a\u4e86                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296961\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : tikazyq <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u662f\u8981\u8ddf Entity Framework \u4e00\u8f83\u9ad8\u4e0b\u4e48                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296962\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zhangysh1995 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u70b9\u4e86\uff0c\u652f\u6301\u4e00\u4e0b\uff01                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296963\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Cbdy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5f88\u5389\u5bb3\u3002<br \/>\u8bf4\u8bf4\u6211\u7684\u770b\u6cd5\uff0c\u4f60\u7684\u76ee\u7684\u662f\u7c7b\u578b\u5b89\u5168\uff08\u57fa\u4e8e Java \u7684\u7c7b\u578b\u7cfb\u7edf\uff09\uff0c\u4f60\u5c1d\u8bd5\u8fbe\u5230\u8fd9\u4e2a\u76ee\u7684\u7684\u65b9\u6cd5\u662f\u8bbe\u8ba1\u4e00\u4e2a\u57fa\u4e8e Java \u7684 DSL \u3002<br \/>\u4f46\u662f\uff08\u6211\u8981\u6cfc\u4e00\u4e0b\u51b7\u6c34\uff09\uff0cSQL \u5c31\u662f SQL\uff0c\u4f60\u7684 SQL \u751f\u6210\u5668\u518d\u7cbe\u5999\uff0c\u8fd8\u662f\u4e0d\u5982\u76f4\u63a5\u5199 SQL \u6765\u5f97\u7b80\u6d01\u6709\u529b\u3002<br \/>\u6211\u5c31\u4e0d\u559c\u6b22\u4ec0\u4e48 Linq \u3001JOOQ\uff0c\u8fd9\u4e9b\u4e1c\u897f\u90fd\u662f\u8131\u88e4\u5b50\u653e\u5c41\uff0c\u5343\u65b9\u767e\u8ba1\u8981\u7528\u4ee3\u7801\u53bb\u751f\u6210 SQL \u8bed\u53e5\uff0c\u800c\u4e0d\u662f\u76f4\u63a5\u5199 SQL \u3002<br \/>\u4e00\u65b9\u9762\uff0c\u5199 SQL \u662f\u5fc5\u8981\u7684\u5de5\u4f5c\uff0c\u6700\u7ec8\u8c03\u4f18\u7684\u65f6\u5019\u3001Troubleshooting \u7684\u65f6\u5019\u8fd8\u4e0d\u662f\u8981\u53bb\u770b SQL \uff1f\u7c7b\u578b\u4e0d\u5b89\u5168\u7684 SQL \u5f80\u5f80\u5728\u5199\u4ee3\u7801\u7684\u65f6\u5019\u5c31\u4f1a\u53d1\u73b0\uff0c\u8fd9\u4e2a\u95ee\u9898\u4e5f\u4e0d\u662f\u5199 SQL \u9762\u4e34\u7684\u4e3b\u8981\u77db\u76fe\u3002\u66f4\u591a\u7684\uff0cSQL \u4e5f\u662f\u4e00\u95e8\u4e45\u7ecf\u8003\u9a8c\u7684\u201c\u8bed\u8a00\u201d\uff0c\u4e5f\u6709\u4e30\u5bcc\u7684\u9759\u6001\u68c0\u67e5\u5de5\u5177\u3002<br \/>\u6211\u652f\u6301 SQL \u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296964\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Cbdy \u5176\u5b9e\u5f88\u591a\u4eba\u90fd\u6709\u4f60\u8fd9\u6837\u7684\u60f3\u6cd5\uff0c\u6211\u524d\u671f\u9047\u5230\u5f88\u591a\u8fd9\u6837\u7684\u60f3\u6cd5\u6765\u6311\u6218 ObjectiveSQL\uff0c\u559c\u6b22\u4e0e\u4e0d\u559c\u6b22\u662f\u5f88\u4e3b\u89c2\u7684\uff0c\u6211\u4e5f\u4e0d\u53c2\u4e0e\u8fd9\u6837\u7684\u4e89\u8bba\uff0c\u5c31\u50cf\u4e89\u8bba\u54ea\u79cd\u7f16\u7a0b\u8bed\u8a00\u597d\u4e00\u6837<\/p>\n<p>\u6211\u4eec\u9700\u8981\u66f4\u5ba2\u89c2\u4e00\u70b9\u770b\uff0c\u6709\u7684\u516c\u53f8 SQL \u591a\uff0c\u6709\u7684\u516c\u53f8 SQL \u5c11\uff0c\u6709\u7684\u590d\u6742\uff0c\u6709\u7684\u76f8\u5bf9\u7b80\u5355\uff0c\u8fd9\u6837\u7684\u80cc\u666f\u4e0b\u5728\u9009\u62e9\u5de5\u5177\u65f6\u5c31\u4f1a\u6709\u4e0d\u540c\u7684\u60f3\u6cd5\u3002<\/p>\n<p>\u6211\u662f\u7ecf\u5386\u8fc7\u4e00\u4e2a\u9879\u76ee\u4e2d\u5b58\u5728 500 &#8211; 1000 \u6761\u957f\u5ea6\u8d85\u8fc7 400 \u884c\u7684 SQL\uff0c\u5e73\u5747\u6bcf\u4e2a SQL \u9700\u8981 JOIN 20 \u5f20\u8868\u6216\u5b50\u67e5\u8be2\uff08\u6709\u8f83\u591a\u91cd\u590d\uff09\uff0c\u5728\u8fd9\u6837\u7684\u573a\u666f\u4e0b SQL \u7684\u7ef4\u62a4\u6210\u672c\uff0c\u4fee\u590d Bug \u7684\u6210\u672c\uff0c\u5355\u5143\u6d4b\u8bd5\u7684\u6210\u672c\u662f\u5de8\u5927\u7684\u3002<\/p>\n<p>\u8fd9\u4e9b\u7ecf\u5386\u5bfc\u81f4\u4e86\u6211\u7684\u9879\u76ee\u7684\u51fa\u73b0\uff0c\u5f53\u7136 @Cbdy \u4f60\u53ef\u80fd\u6709\u4e0d\u4e00\u6837\u7684\u80cc\u666f\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296965\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Cbdy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom \u786e\u5b9e\u53ef\u80fd\u5b58\u5728\u4f60\u8bf4\u7684\u60c5\u51b5\uff0c\u90a3\u79cd\u60c5\u51b5\u65e0\u8bba\u7528\u4ec0\u4e48\u5de5\u5177\u90fd\u662f\u5f88\u590d\u6742\u7684\uff0c\u56e0\u4e3a\u6570\u636e\u5b58\u6210\u8fd9\u6837\uff0c\u5df2\u7ecf\u6709\u4e00\u4e2a\u590d\u6742\u5ea6\u5728\u4e86\u3002\u6211\u89c9\u5f97\u8981\u63a7\u5236\u8fd9\u4e2a\u590d\u6742\u5ea6\u7684\u8bdd\uff0c\u5e94\u8be5\u4ece\u6570\u636e\u89d2\u5ea6\u51fa\u53d1\u3002<\/p>\n<p>\u8fd9\u79cd\u573a\u666f\u57fa\u672c\u662f OLAP \u6216\u8005\u51fa\u62a5\u8868\u5427\uff0c\u5982\u679c\u662f\u8fd9\u6837\uff0c\u53ef\u4ee5\u8003\u8651\u62bd\u53d6\u6570\u636e\u5230\u5bbd\u8868\uff0c\u6216\u8005\u66f4\u7075\u6d3b\u7684\u975e\u5173\u7cfb\u5b58\u50a8                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296966\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : uptonking <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u867d\u7136\u6709\u5f88\u591a\u8d28\u7591\uff0c\u6211\u8fd8\u662f\u89c9\u5f97\u4e3b\u5f88\u5389\u5bb3\uff0c\u5f00\u6e90\u5c31\u662f\u8981\u7ecf\u5f97\u8d77\u68c0\u9a8c\uff0c\uff0c\uff0c\u53ef\u4ee5\u53c2\u8003\u4e0b\u5927\u5bb6\u63d0\u5230\u7684\u4f18\u79c0\u65b9\u6848\uff0c\u7136\u540e\u5438\u6536\u4e00\u90e8\u5206\u5230 objectiveSQL\uff0c\u628a README \u6216\u9879\u76ee\u4e3b\u9875\u5199\u8be6\u7ec6\u70b9                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296967\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Cbdy \u5f88\u591a\u5e94\u7528\u90fd\u4f1a\u6709\u62a5\u8868\u7684\uff0c\u53ea\u662f\u591a\u5c11\u7684\u95ee\u9898\uff0cJava \u7684\u4ee3\u7801\u53ef\u4ee5\u6210\u5343\u4e0a\u4e07\u884c\uff0c\u6709\u8bed\u6cd5\u5c42\u7ed3\u6784\u5316\u7684\u5f62\u5f0f\u8fdb\u884c\u7ba1\u7406\uff0c\u540c\u6837\u4e5f\u5b58\u5728\u5f88\u591a\u6a21\u5f0f\u548c\u89c4\u8303\uff0c\u8fd9\u5757\u5728 SQL \u4e0a\u5c31\u5f88\u5c11\u4e86\uff0cSQL \u7684\u5de5\u7a0b\u5316\u80fd\u529b\u8fdc\u8fdc\u4e0d\u5982 Java \u3002<\/p>\n<p>\u6240\u4ee5\u901a\u8fc7 Java \u7684\u5f62\u5f0f\u53bb\u5199 SQL \u662f\u5f88\u5fc5\u8981\u7684\uff0c\u4f46 SQL \u5df2\u7ecf\u8bde\u751f\u4e86\u5f88\u591a\u5e74\uff0c\u800c\u4e14\u88ab\u5f88\u591a\u4eba\u6240\u63a5\u53d7\uff0c\u5982\u679c\u8bbe\u8ba1\u4e00\u5957\u5168\u65b0\u7684\u8bed\u6cd5\u6a21\u5f0f\uff0c\u5927\u4f17\u5f88\u96be\u63a5\u53d7\uff0c\u8fd9\u6837\u9879\u76ee\u7684\u751f\u547d\u529b\u4e5f\u4e0d\u5f3a\uff0c\u6240\u4ee5\u6211\u5c3d\u53ef\u80fd\u7684\u8ba9 Java \u4ee3\u7801\u63a5\u8fd1 SQL\uff0c\u7b26\u5408\u5927\u4f17\u7684\u5473\u53e3\uff0c\u54c8\u54c8\u3002<\/p>\n<p>\u201cDynamically SQL programming with Java syntax, and very close to SQL syntax\u201d<\/p>\n<p>\u6211\u4e4b\u524d\u8bbe\u8ba1\u8fc7\u4e00\u4e2a\u8bed\u8a00\uff0c\u6211\u79f0\u5b83\u4e3a JDS(Java Database Script) \u540e\u6765\u653e\u5f03\u4e86\uff0c\u5728\u6211\u7684 github \u4e5f\u6709\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296968\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @uptonking \u662f\u7684\uff0c\u53ea\u6709\u7ecf\u5f97\u8d77\u5927\u5bb6\u6311\u6218\u7684\u9879\u76ee\u624d\u6709\u751f\u547d\u529b\uff0c\u603b\u662f\u9760\u4eba\u6276\u80af\u5b9a\u957f\u4e0d\u5927\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296969\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Cbdy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom Java \u662f\u901a\u7528\u8bed\u8a00\uff0cSQL \u662f\u9886\u57df\u7279\u5b9a\u8bed\u8a00\uff0c\u628a Java \u548c SQL \u8fdb\u884c\u6bd4\u8f83\u8fd8\u662f\u86ee\u602a\u7684\u3002\u5982\u679c\u8981\u8bf4\u4ed6\u4eec\u4e4b\u95f4\u7684\u5173\u7cfb\uff0cSQL \u53ef\u4ee5\u6210\u4e3a Java \u80fd\u529b\u7684\u5ef6\u4f38\uff0c\u672c\u8eab\u548c Java \u4e0d\u77db\u76fe\u3002\u8bd5\u56fe\u7528 Java \u89e3\u51b3\u6240\u6709\u95ee\u9898\u624d\u662f\u6bd4\u8f83\u5947\u602a\u7684\u505a\u6cd5\u3002\u51b5\u4e14\u5f88\u591a\u6570\u636e\u5e93\u90fd\u6709\u4e13\u6709\u7684\u8bed\u6cd5\uff0c\u51fd\u6570\u5e93\uff0c\u7528\u7684\u65f6\u5019\u9694\u7740\u4e00\u5c42\u201c\u901a\u7528\u201d\u7684\u5c01\u88c5\uff0c\u53ef\u80fd\u4f1a\u5f88\u9e21\u808b\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296970\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : mumubin <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u81ea\u5df1\u505a\u51fa\u6765\u8fd9\u4e2a\u5de5\u5177\uff0c\u8001\u54e5\u8fd8\u662f\u5f88\u503c\u5f97\u80af\u5b9a\u7684\u3002\u4e0d\u8fc7\u4f5c\u4e3a\u7a0b\u5e8f\u5458\u6211\u8fd8\u662f\u559c\u6b22\u76f4\u63a5\u5199 sql\uff0c\u53ca\u5176\u8ba8\u538c\u975e sql \u7684 orm \u3002\u6240\u4ee5\u6211\u8fd8\u662f\u6700\u559c\u6b22 mybatis \u3002\u7ef4\u62a4\u4e00\u4e2a django \u9879\u76ee\uff0c\u81ea\u5e26 orm \u4e2d\u7684\u5751\u70b9\u4e0d\u5c11\uff0c\u800c\u4e14 slow sql \u90fd\u633a\u96be\u5b9a\u4f4d\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296971\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Cbdy \u8981\u4ece\u4e0d\u540c\u7684\u89d2\u5ea6\u53bb\u7406\u89e3 SQL\uff0cSQL \u5176\u5b9e\u548c HTTP\uff0cSMTP \u8fd9\u7c7b\u534f\u8bae\u4e00\u6837\uff0c\u53ea\u4e0d\u8fc7 SQL \u662f\u89e3\u51b3 Java \u4e0e\u6570\u636e\u5e93\u4ea4\u4e92\u7684\u4e00\u79cd\u534f\u8bae\uff0c\u6211\u76f8\u4fe1\u4f60\u4e0d\u4f1a\u624b\u52a8\u7f16\u7801\u53bb\u5b9e\u73b0 HTTP\uff0cSMTP \u8fd9\u7c7b\u534f\u8bae\u7684\uff0c\u90fd\u662f\u901a\u8fc7\u66f4\u9ad8\u5c42\u7684\u5c01\u88c5\u53bb\u8bbf\u95ee\uff0c\u5f53\u7136\u5982\u679c\u505a\u66f4\u5e95\u7684\u7f16\u7801\uff0c\u8fd8\u662f\u4f1a\u6d89\u53ca\u7684\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296972\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @mumubin \u5f88\u591a\u4eba\u90fd\u6709\u4f60\u8fd9\u6837\u7684\u60f3\u6cd5\uff0cslow sql \u4e5f\u662f\u6211\u4e0b\u4e00\u9636\u6bb5\u9700\u8981\u89e3\u51b3\u7684\uff0c\u5982\u679c\u901a\u8fc7\u5355\u5143\u6d4b\u8bd5\u6392\u67e5\u4e00\u90e8\u5206\u5e38\u89c1\u7684\u95ee\u9898\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296973\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Cbdy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom SQL \u662f Query DSL\uff0cHTTP \u8fd9\u79cd\u4e8b Application layer communication protocol\uff0c\u4ed6\u4eec\u7684\u590d\u6742\u5ea6\u3001\u62d3\u5c55\u6027\u3001\u548c\u89e3\u51b3\u7684\u95ee\u9898\u662f\u4e0d\u540c\u7684\uff0c\u600e\u4e48\u80fd\u6df7\u4e3a\u4e00\u8c08                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296974\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : heiheidewo <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u725b\u903c\uff0c\u957f\u89c1\u8bc6\u4e86                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296975\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : felixcode <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5982\u679c\u8981\u9488\u5bf9\u6570\u636e\u5e93\u505a sql \u4f18\u5316\u80fd\u505a\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296976\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Cbdy \u4f60\u8bf4\u7684\u5f88\u5bf9\uff0cSQL \u7684\u590d\u6742\u5ea6\u76f8\u6bd4\u5176\u5b83\u662f\u9ad8\u51fa\u5f88\u591a\uff0c\u4f46\u4ece\u62bd\u8c61\u7684\u89d2\u5ea6\u53bb\u770b\uff0c\u5b83\u5c31\u662f\u4e00\u79cd\u534f\u8bae\uff0c\u53ea\u4e0d\u8fc7\u8fd9\u79cd\u534f\u8bae\u627f\u8f7d\u4e86\u8f83\u591a\u5173\u7cfb\u578b\u6570\u636e\u7684\u8ba1\u7b97\u903b\u8f91\u548c\u7edf\u8ba1\u65b9\u5f0f\u800c\u5df2\u3002<\/p>\n<p>\u6211\u53ea\u662f\u505a\u4e86\u4e00\u4e2a\u7c7b\u6bd4\uff0c\u4f20\u8f93\u5c42\u534f\u8bae\u66f4\u591a\u662f\u5b9a\u4e49\u7ed3\u6784\uff0c\u5176\u5185\u5b58\u7684\u903b\u8f91\u66f4\u591a\u662f\u7531\u7a0b\u5e8f\u63a7\u5236\u7684\u3002<\/p>\n<p>\u6570\u636e\u5e93\u8bbe\u8ba1\u7684\u521d\u8877\u5c31\u662f\u4e3a\u4e86\u5c01\u88c5\u6570\u636e\u7684\u8ba1\u7b97\u903b\u8f91\uff0c\u964d\u4f4e\u5916\u90e8\u5e94\u7528\u7a0b\u5e8f\u7684\u590d\u6742\u5ea6\uff0c\u63d0\u4f9b\u7b80\u5355\u7684\u4ea4\u4e92\u534f\u8bae\u5b9e\u73b0\u6570\u636e\u8ba1\u7b97\uff0c\u4f46\u968f\u7740\u6570\u636e\u7edf\u8ba1\u65b9\u5f0f\u7684\u53d1\u5c55\uff0c\u95ee\u9898\u9886\u57df\u7684\u590d\u6742\u5ea6\u53d8\u5316\uff0c\u4f20\u7edf\u7684\u65b9\u5f0f\u7f16\u5199 SQL \u5df2\u7ecf\u5f88\u96be\u6ee1\u8db3\u5206\u6790\u9700\u6c42\u4e86\uff0c\u53ea\u5c31\u9700\u8981\u903b\u8f91\u578b\u7f16\u7a0b\u8bed\u8a00\u63d0\u4f9b\u5c01\u88c5\uff0c\u9690\u85cf\u590d\u6742\u7684\u6784\u9020\u8fc7\u7a0b\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296977\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @felixcode \u4f60\u8bf4\u7684\u5176\u5b9e\u4e00\u4e2a SQL \u6027\u80fd\u6d4b\u8bd5\u5f15\u64ce\uff0c\u5b8c\u5168\u505a\u5230\u5f88\u96be\uff0c\u6bd5\u7adf\u573a\u666f\u592a\u590d\u6742\uff0c\u4f46\u968f\u7740\u4e0d\u65ad\u7684\u8fed\u4ee3\uff0c\u80fd\u591f\u907f\u514d\u5927\u91cf SQL \u7684\u9519\u8bef\uff0c\u8fd9\u662f\u6211\u4e0b\u4e00\u9636\u6bb5\u5de5\u4f5c\u7684\u91cd\u70b9\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296978\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : vipcc <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             .net core \u4e2d\u7684 ef core +linq\uff0c\u8001\u54e5\u53ef\u4ee5\u770b\u4e00\u770b<br \/>\u73b0\u5728\u90fd\u662f\u5f00\u6e90\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296979\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @vipcc \u611f\u8c22\uff0c\u6211\u4f1a\u53c2\u8003\u4e00\u4e0b\uff0c\u524d\u9762\u5df2\u7ecf\u6709\u597d\u51e0\u4f4d\u5144\u5f1f\u4ecb\u7ecd\u4e86\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296980\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : felixcode <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4f60\u505a\u7684\u4e1c\u897f\u53ef\u80fd\u6bd4\u8f83\u6709\u7528\uff0c\u4f46\u4f60\u5bf9 SQL \u8bed\u8a00\u7684\u7406\u89e3\u5c40\u9650\u6027\u592a\u5927\u4e86\u3002<\/p>\n<p>\u7ed3\u5408 dbms \u7684\u5177\u4f53\u5b9e\u73b0\uff0csql \u4ece\u9876\u5c42\u7684\u63cf\u8ff0\u5230\u5e95\u5c42\u7684\u63a7\u5236\u90fd\u662f\u80fd\u505a\u7684\uff0c\u4f60\u505a\u4e00\u5c42\u7ffb\u8bd1\u540e\uff0c\u727a\u7272\u4e86 sql \u8bed\u8a00\u7684\u5f88\u591a\u7279\u6027\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296981\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Cbdy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4f20\u7edf\u7684\u65b9\u5f0f\u7f16\u5199 SQL \u5df2\u7ecf\u5f88\u96be\u6ee1\u8db3\u5206\u6790\u9700\u6c42\u4e86\uff0c\u53ea\u5c31\u9700\u8981\u903b\u8f91\u578b\u7f16\u7a0b\u8bed\u8a00\u63d0\u4f9b\u5c01\u88c5\uff0c\u9690\u85cf\u590d\u6742\u7684\u6784\u9020\u8fc7\u7a0b<\/p>\n<p>\u96be\u9053\u4e0d\u662f data flow \u3001data structure \u8bbe\u8ba1\u6709\u95ee\u9898\u5417\uff1f                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296982\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : beginor <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e3b\u7684\u8fd9\u4e2a\u9879\u76ee\u975e\u5e38\u6709\u610f\u4e49\uff0cJava \u786e\u5b9e\u6ca1\u6709\u5f3a\u5927\u7684\uff0c\u5e7f\u4e3a\u4eba\u77e5\u5e76\u4e14\u6df1\u5165\u4eba\u5fc3\u7684\u7c7b\u4f3c\u4e8e Linq2SQL \u7684 ORM \u6846\u67b6\uff0c \u4f46\u662f Linq2SQL \u7684\u529f\u80fd\u5728 .Net \u5e73\u53f0\u4e0a\u5df2\u7ecf\u6df1\u5165\u4eba\u5fc3\uff0c \u88ab\u7edd\u5927\u591a\u6570\u4eba\u6240\u63a5\u53d7\u3002<\/p>\n<p>\u5728 .Net \u5e73\u53f0\u7684\u521a\u521a\u5f00\u59cb\u51fa\u73b0 Linq2SQL \u7684\u529f\u80fd\u7684\u65f6\u5019\uff0c \u5f88\u591a\u4eba\u4e5f\u662f\u7c7b\u4f3c\u7684\u6cfc\u51b7\u6c34\u3002 \u4f46\u662f Linq2SQL \u786e\u5b9e\u6210\u529f\u7684\u63d0\u5347\u4e86\u8bb8\u591a .Net \u5f00\u53d1\u8005\u7684\u751f\u4ea7\u529b\u3002 <\/p>\n<p>\u6211\u662f\u505a .Net \u51fa\u8eab\uff0c \u6700\u8fd1\u51e0\u5e74\u4e5f\u63a5\u89e6\u8fc7\u4e00\u4e9b Java \u7684\u9879\u76ee\uff0c \u4e24\u4e2a\u5e73\u53f0\u90fd\u4e86\u89e3\u4e00\u4e9b\uff0c \u4e5f\u53ef\u4ee5\u8bf4\u662f\u6df1\u6709\u611f\u89e6\u3002<\/p>\n<p>\u4e0d\u8fc7\u8fd9\u79cd\u9879\u76ee\u6700\u597d\u6709\u5927\u516c\u53f8\u53c2\u4e0e\u63a8\u5e7f\uff0c \u5355\u7eaf\u4e2a\u4eba\u63a8\u5e7f\u4f1a\u5f88\u96be\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296983\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : optional <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u9694\u58c1\u6709\u4e2a ktorm\uff0c\u867d\u7136\u4e0d\u662f java \u4f46\u662f\u53ef\u4ee5\u4e00\u8d77\u7528\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296984\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : hangs <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Braisdom \u8bf7\u6559\u4e24\u70b9<\/p>\n<p>1. \u63d2\u4ef6\u662f\u5fc5\u987b\u88c5\u7684\u5417\uff0c\u8fd8\u662f\u5f15\u5165\u5bf9\u5e94\u7684 maven \u4f9d\u8d56\u5373\u53ef\u3002<\/p>\n<p>2. \u5728\u7b80\u5355 ORM \u4e0d\u6d89\u53ca\u590d\u6742\u8ba1\u7b97\u7684\u60c5\u51b5\u4e0b\uff0cmybatis \u3001hibernate \u548c\u60a8\u8fd9\u4e2a\u6846\u67b6\u4f18\u52a3\u52bf\u5206\u522b\u662f\u54ea\u4e9b\u5462                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296985\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Tlin <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd9\u4e9b\u90fd\u662f\u4ec0\u4e48\u4eba\u554a \u90a3\u4e48\u5389\u5bb3\u5417<br \/>\u770b\u6765\u6211\u4e0d\u6562\u53d1\u8a00\u4e86\u2026\u2026\u2026\u2026\u2026\u2026<\/p>\n<p>\u771f\u5389\u5bb3\u554a\uff01                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296986\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : xrr2016 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u770b\u8d77\u6765\u50cf\u4e00\u79cd ORM\uff0c\u7c7b\u4f3c\u4e8e https:\/\/www.prisma.io \u8fd9\u4e2a\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296987\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : WhoMercy <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u611f\u8c22\u3001\u6536\u85cf\u3002<\/p>\n<p>\u4e0b\u6b21\u505a\u7ec3\u624b\u9879\u76ee\u518d\u6765\u8bd5\u8bd5\u8001\u54e5\u8fd9\u4e2a\u6846\u67b6\u3002                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296988\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : bojue <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Tlin \u4f60\u4e0d\u662f\u4e00\u4e2a\u4eba\uff0c\u6280\u672f\u80d6\u6ca1\u8fd9\u4e2a\u5b9e\u529b                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296989\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @beginor \u975e\u5e38\u8ba4\u53ef\u4f60\u7684\u8bf4\u6cd5\uff0c\u6ca1\u6709\u5927\u516c\u53f8\u7684\u80cc\u4e66\uff0c\u9879\u76ee\u5f88\u96be\u8d77\u6765\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296990\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @hangs \u5144\u5f1f\uff0c\u63d2\u4ef6\u662f\u5fc5\u987b\u7684\uff0c\u7531\u4e8e IntelliJ IDEA \u7684 Java \u8bed\u6cd5\u68c0\u6d4b\u592a\u4e25\u8c28\uff0c\u6211\u5df2\u7ecf\u63d0\u4e86 issue \u7ed9\u4ed6\u4eec\u4e86\uff0c\u8bf4\u662f\u4f1a\u6709\u6539\u8fdb\uff0c\u6211\u662f\u81ea\u52a8\u751f\u6210 java \u4ee3\u7801\uff0c\u6ca1\u6709 IDE \u7684\u652f\u6301\u5f88\u96be\u5b8c\u6210\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296991\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Cbdy \u95ee\u9898\u9886\u57df\u7684\u590d\u6742\u5ea6\u662f\u65e0\u6cd5\u907f\u514d\u7684\uff0c\u6240\u4ee5\u9700\u8981\u901a\u8fc7 Java \u53bb\u907f\u514d\u590d\u6742\u5ea6\u7684\u8513\u5ef6                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296992\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @hangs \u5982\u679c\u4e0d\u6d89\u53ca\u590d\u6742 SQL\uff0c\u4f60\u53ef\u53c2\u8003\u4e00\u4e0b\u6211 git \u6587\u6863\u91cc\u7684\u63cf\u8ff0\uff0c\u81ea\u52a8\u4ee3\u7801\u751f\u6210\u76f8\u6bd4\u5176\u5b83 ORM\uff0c\u4f18\u52bf\u81ea\u5df2\u4f53\u4f1a\u4e00\u4e0b\uff0c\u6211\u8bf4\u518d\u8bf4\u4e5f\u4e0d\u6ca1\u6709\u8bf4\u670d\u529b\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"4296993\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : Braisdom <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @zhangysh1995 \u611f\u8c22\u652f\u6301                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u5386\u7ecf 3 \u5e74\uff0c\u7ec8\u4e8e\u5f97\u4ee5\u5b9e\u73b0\u4e86 \u8cc7\u6df1&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\/200730"}],"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=200730"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/200730\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=200730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=200730"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=200730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}