{"id":1533,"date":"2024-05-20T05:34:01","date_gmt":"2024-05-20T05:34:01","guid":{"rendered":"https:\/\/www.nicekj.com\/?p=1533"},"modified":"2024-05-20T05:34:18","modified_gmt":"2024-05-20T05:34:18","slug":"aigcquanxinlingyuwutansuorengongzhinengshengchengdaimazaishangyeying","status":"publish","type":"post","link":"https:\/\/www.nicekj.com\/aigcquanxinlingyuwutansuorengongzhinengshengchengdaimazaishangyeying.html","title":{"rendered":"\u3010AIGC\u3011\u5168\u65b0\u9886\u57df\uff01(\u4e94)\uff1a\u63a2\u7d22\u4eba\u5de5\u667a\u80fd\u751f\u6210\u4ee3\u7801\u5728\u5546\u4e1a\u5e94\u7528\u4e2d\u7684\u6f5c\u529b\uff01"},"content":{"rendered":"

\u524d\u8a00<\/h1>\n

\u2002\u2002\u2002\u2002\u8fd1\u671f\uff0cGPTs \u5e94\u7528\u5546\u5e97<\/strong>\u6b63\u5f0f\u53d1\u5e03\uff0c\u4e3a\u5e7f\u5927\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e00\u4e2a\u5de8\u5927\u7684\u5546\u673a\u3002\u5728\u8fd9\u4e2a\u65b0\u7684\u4eba\u5de5\u667a\u80fd\u751f\u6210\u4ee3\u7801\uff08AIGC\uff09\u65b9\u5411\u4e2d\uff0c\u6709\u8bb8\u591a\u4ee4\u4eba\u5174\u594b\u7684\u53d1\u5c55\uff0c\u7279\u522b\u662f\u5728\u4e0eAI\u7535\u5546\u9886\u57df\u7684\u7ed3\u5408\u4e0a\u3002\u672c\u6587\u5c06\u63a2\u8ba8AIGC<\/strong>\u5728\u5546\u4e1a\u5e94\u7528<\/strong>\u4e2d\u7684\u6f5c\u529b\uff0c\u4ee5\u53ca\u5982\u4f55\u5229\u7528Python<\/code>\u3001LangChain<\/code>\u3001Flask<\/code>\u3001Copilt<\/code>\u7b49\u5de5\u5177\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\uff0c\u5e76\u8ba9\u4efb\u4f55\u4eba\u90fd\u80fd\u8f7b\u677e\u62e5\u6709\u6570\u636e\u5206\u6790\u7684\u80fd\u529b\u3002<\/p>\n

\u6b63\u6587<\/h1>\n

AIGC\u4e0eAI\u7535\u5546\u7684\u7ed3\u5408<\/h2>\n

\u2002\u2002\u2002\u2002GPTs \u5e94\u7528\u5546\u5e97\u7684\u6b63\u5f0f\u53d1\u5e03<\/code>\u6807\u5fd7\u7740AIGC\u5728\u5546\u4e1a\u9886\u57df\u7684\u5d2d\u9732\u5934\u89d2\u3002\u5728\u63a2\u7d22\u8fd9\u4e2a\u65b0\u9886\u57df\u7684\u5546\u673a\u65f6\uff0c\u6211\u4eec\u5e94\u8be5\u5bfb\u627e\u90a3\u4e9b\u62e5\u6709AIGC\u601d\u7ef4\u7684\u516c\u53f8\uff0c\u5c24\u5176\u662f\u5728AI\u7535\u5546\u9886\u57df\u3002AI\u7535\u5546\u53ef\u4ee5\u901a\u8fc7\u5c06\u4eba\u5de5\u667a\u80fd\u4e0e\u5546\u4e1a\u8fd0\u8425\u76f8\u7ed3\u5408\uff0c\u63d0\u4f9b\u66f4\u667a\u80fd\u3001\u4e2a\u6027\u5316\u7684\u8d2d\u7269\u4f53\u9a8c\uff0c\u4e3a\u4f01\u4e1a\u548c\u6d88\u8d39\u8005\u521b\u9020\u66f4\u591a\u4ef7\u503c\u3002<\/p>\n

Python\u4e0eAIGC\u5de5\u5177\u7684\u7ed3\u5408<\/h2>\n

\u2002\u2002\u2002\u2002\u5728AIGC\u65b9\u5411\u4e2d\uff0cPython<\/code>\u4ecd\u7136\u662f\u4e00\u4e2a\u4e0d\u53ef\u6216\u7f3a\u7684\u5de5\u5177\u3002LangChain<\/code>\u548c\u540e\u7aefAPI Flask<\/code>\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u529f\u80fd\uff0c\u4f7f\u5176\u80fd\u591f\u66f4\u8f7b\u677e\u5730\u4e0eAIGC\u6280\u672f\u96c6\u6210\u3002\u8fd9\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u66f4\u591a\u7075\u6d3b\u6027\u548c\u521b\u9020\u529b\uff0c\u4f7f\u4ed6\u4eec\u80fd\u591f\u66f4\u597d\u5730\u5229\u7528AIGC\u5728\u4e0d\u540c\u9886\u57df\u7684\u6f5c\u529b\u3002<\/p>\n

\u751f\u6210\u4ee3\u7801\u4e0e\u5f00\u53d1\u63d0\u6548<\/h2>\n

\u2002\u2002\u2002\u2002Copilt<\/code>\u7b49\u5de5\u5177\u5728\u751f\u6210\u4ee3\u7801\u65b9\u9762\u53d6\u5f97\u4e86\u663e\u8457\u7684\u8fdb\u5c55\u3002\u901a\u8fc7AIGC\u6280\u672f\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u66f4\u9ad8\u6548\u5730\u751f\u6210\u4ee3\u7801\uff0c\u63d0\u9ad8\u5f00\u53d1\u901f\u5ea6\u3002\u7279\u522b\u662f\u5728SQL\u7684\u751f\u6210\u548c\u5206\u6790\u65b9\u9762\uff0cCopilt\u7684\u5e94\u7528\u4e3a\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u66f4\u591a\u53ef\u80fd\u6027\uff0c\u4f7f\u5176\u80fd\u591f\u66f4\u597d\u5730\u5e94\u5bf9\u590d\u6742\u7684\u6570\u636e\u5904\u7406\u9700\u6c42\u3002<\/p>\n

AIGC\u4e0e\u81ea\u7136\u8bed\u8a00\u5904\u7406\u7684\u7ed3\u5408<\/h2>\n

\u2002\u2002\u2002\u2002AIGC\u4e0d\u4ec5\u4ec5\u5c40\u9650\u4e8e\u751f\u6210\u4ee3\u7801\uff0c\u5728\u81ea\u7136\u8bed\u8a00\u5904\u7406<\/code>\u65b9\u9762\u4e5f\u6709\u7740\u5e7f\u9614\u7684\u5e94\u7528\u524d\u666f\u3002SQL\u5df2\u7ecf\u4e0d\u518d\u662f\u67e5\u8be2\u6216\u6570\u636e\u5206\u6790\u7684\u552f\u4e00\u9009\u62e9\uff0cAIGC\u5728\u81ea\u7136\u8bed\u8a00\u5904\u7406\u65b9\u9762\u7684\u80fd\u529b\u4f7f\u5f97\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u81ea\u7136\u8bed\u8a00\u63d0\u51fa\u95ee\u9898\u3002ChatGPT\u7b49\u81ea\u7136\u8bed\u8a00\u5904\u7406\u5de5\u5177\u80fd\u591f\u7406\u89e3\u7528\u6237\u7684\u9700\u6c42\uff0c\u5e76\u751f\u6210\u76f8\u5e94\u7684SQL\u67e5\u8be2\uff0c\u4f7f\u65b0\u624b\u7528\u6237\u4e5f\u80fd\u5feb\u901f\u4e0a\u624b\u5b66\u4e60\u6570\u636e\u5206\u6790\u6280\u80fd\u3002<\/p>\n

\u65b0\u7684\u6570\u636e\u5e93\u67e5\u8be2\u8303\u5f0f<\/h2>\n

\u2002\u2002\u2002\u2002\u968f\u7740AIGC\u6280\u672f\u7684\u4e0d\u65ad\u53d1\u5c55\uff0c\u51fa\u73b0\u4e86\u65b0\u7684\u6570\u636e\u5e93\u67e5\u8be2\u8303\u5f0f<\/code>\u3002\u7528\u6237\u53ea\u9700\u901a\u8fc7\u63d0\u95ee\uff0cAIGC\u5c31\u80fd\u591f\u5229\u7528\u81ea\u7136\u8bed\u8a00\u5904\u7406\u80fd\u529b\u751f\u6210SQL\u67e5\u8be2\uff0c\u7136\u540e\u81ea\u52a8\u6267\u884c\u5e76\u8fd4\u56de\u6570\u636e\u67e5\u8be2\u7ed3\u679c\u3002\u8fd9\u5c31\u5f62\u6210\u4e86\u4e00\u79cd\u65b0\u7684AI\u5e94\u7528\uff0c\u4e5f\u53ef\u4ee5\u79f0\u4e4b\u4e3aAI Agent<\/code>\u3002\u6839\u636e\u7528\u6237\u7684\u9700\u6c42\uff0cAIGC\u53ef\u4ee5\u751f\u6210json\u6216\u56fe\u8868\uff0c\u4e3a\u7528\u6237\u63d0\u4f9b\u66f4\u76f4\u89c2\u3001\u6613\u61c2\u7684\u6570\u636e\u5206\u6790\u7ed3\u679c\uff0c\u8ba9\u4efb\u4f55\u4eba\u90fd\u80fd\u62e5\u6709\u6570\u636e\u5206\u6790\u7684\u80fd\u529b\u3002<\/p>\n

\u5b9e\u4f8b<\/h2>\n

\u2002\u2002\u2002\u2002\u8bf4\u4e86\u90a3\u4e48\u591a\uff0c\u8fdc\u4e0d\u5982\u6211\u4eec\u76f4\u63a5\u8bd5\u4e00\u8bd5\uff01\u8ba9\u6211\u4eec\u770b\u770b\u4e0b\u9762\u7684\u4f8b\u5b50<\/code>\u3002<\/p>\n

<\/div>
python<\/span>
\u590d\u5236\u4ee3\u7801<\/div><\/div><\/div># sqlite --- \u4e00\u4e2a\u8f7b\u91cf\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff0c\u5927\u4f6c\u4e00\u822c\u5728\u6d4b\u8bd5\u4ea7\u54c1\u60f3\u6cd5\u7684\u65f6\u5019\u7528\u5b83<\/span><\/span>\n# \u672c\u5730\u6570\u636e\u5e93 python\u81ea\u5e26<\/span><\/span>\nimport<\/span> sqlite3<\/span>\n# \u6570\u636e\u5e93\u8fde\u63a5\u53e5\u67c4<\/span><\/span>\nconn = sqlite3.connect('FlowerShop.db'<\/span>)<\/span>\n# \u6e38\u6807<\/span><\/span>\ncursor = conn.cursor()<\/span>\n# \u6267\u884csql sqlite\u5b8c\u5168\u652f\u6301sql\u4e09\u5927\u8303\u5f0f<\/span><\/span>\ncursor.execute('''<\/span><\/span>\n  CREATE TABLE FLOWERS(<\/span>\n    ID INTEGER PRIMARY KEY,<\/span>\n    Name TEXT NOT NULL,<\/span>\n    Type TEXT NOT NULL,<\/span>\n    Source TEXT NOT NULL,<\/span>\n    PurchasePrice REAL,<\/span>\n    SalePrice REAL,<\/span>\n    StockQuantity INTEGER,<\/span>\n    SoldQuantity INTEGER,<\/span>\n    ExpiryDate DATE,<\/span>\n    Description TEXT,<\/span>\n    EntryDate DATE DEFAULT CURRENT_DATE<\/span>\n  );<\/span>\n''')<\/span>\n# \u7ed9\u4e00\u4e9b\u5047\u6570\u636e<\/span><\/span>\n# \u5047\u6570\u636e\u6307\u7684\u662f\u5728\u5f00\u53d1\u548c\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\u4f7f\u7528\u7684\u865a\u6784\u6570\u636e\uff0c\u7528\u4e8e\u6a21\u62df\u771f\u5b9e\u6570\u636e\u7684\u7279\u5f81\u548c\u7ed3\u6784\u3002<\/span><\/span>\n# \u8fd9\u4e9b\u6570\u636e\u901a\u5e38\u662f\u4e3a\u4e86\u6d4b\u8bd5\u8f6f\u4ef6\u7684\u529f\u80fd\u3001\u6027\u80fd\u548c\u7a33\u5b9a\u6027\u800c\u521b\u5efa\u7684\uff0c\u4ee5\u4fbf\u5728\u6ca1\u6709\u771f\u5b9e\u6570\u636e\u7684\u60c5\u51b5\u4e0b\u8fdb\u884c\u6d4b\u8bd5\u548c\u5f00\u53d1\u3002<\/span><\/span>\n# \u5047\u6570\u636e\u901a\u5e38\u5305\u62ec\u5404\u79cd\u7c7b\u578b\u7684\u6570\u636e\uff0c\u5982\u59d3\u540d\u3001\u5730\u5740\u3001\u65e5\u671f\u3001\u6570\u5b57\u7b49\uff0c\u4ee5\u53ca\u4e00\u4e9b\u968f\u673a\u751f\u6210\u7684\u6570\u636e\uff0c\u4ee5\u4fbf\u6a21\u62df\u771f\u5b9e\u73af\u5883\u4e2d\u7684\u6570\u636e\u60c5\u51b5\u3002<\/span><\/span>\n# \u5728\u5f00\u53d1\u548c\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\uff0c\u5047\u6570\u636e\u53ef\u4ee5\u5e2e\u52a9\u5f00\u53d1\u4eba\u5458\u548c\u6d4b\u8bd5\u4eba\u5458\u5feb\u901f\u6784\u5efa\u6d4b\u8bd5\u73af\u5883\uff0c\u8fdb\u884c\u6d4b\u8bd5\u548c\u8c03\u8bd5\uff0c\u800c\u4e0d\u5fc5\u4f9d\u8d56\u4e8e\u771f\u5b9e\u6570\u636e\u3002<\/span><\/span>\nflowers = [ <\/span>\n('Rose'<\/span>, 'Flower'<\/span>, 'France'<\/span>, 1.2<\/span>, 2.5<\/span>, 100<\/span>, 10<\/span>, '2023-12-31'<\/span>, 'A beautiful red rose'<\/span>), <\/span>\n('Tulip'<\/span>, 'Flower'<\/span>, 'Netherlands'<\/span>, 0.8<\/span>, 2.0<\/span>, 150<\/span>, 25<\/span>, '2024-12-31'<\/span>, 'A colorful tulip'<\/span>), <\/span>\n('Lily'<\/span>, 'Flower'<\/span>, 'China'<\/span>, 1.5<\/span>, 3.0<\/span>, 80<\/span>, 5<\/span>, '2023-12-31'<\/span>, 'An elegant white lily'<\/span>), <\/span>\n('Daisy'<\/span>, 'Flower'<\/span>, 'USA'<\/span>, 0.7<\/span>, 1.8<\/span>, 120<\/span>, 15<\/span>, '2023-12-31'<\/span>, 'A cheerful daisy flower'<\/span>), <\/span>\n('Orchid'<\/span>, 'Flower'<\/span>, 'Brazil'<\/span>, 2.0<\/span>, 4.0<\/span>, 50<\/span>, 2<\/span>, '2023-12-31'<\/span>, 'A delicate purple orchid'<\/span>)<\/span>\n]<\/span>\n# \u628a\u5047\u6570\u636e\u63d2\u5165\u6570\u636e\u5e93<\/span><\/span>\nfor<\/span> flower in<\/span> flowers:<\/span>\n  cursor.execute('''<\/span><\/span>\n    INSERT INTO Flowers(Name, Type, Source, PurchasePrice, SalePrice, StockQuantity, SoldQuantity, ExpiryDate, Description ) <\/span>\n    VALUES(?,?,?,?,?,?,?,?,?);               <\/span>\n  ''', flower)<\/span>\n# \u63d0\u4ea4\u8fd9\u6b21\u4e8b\u52a1<\/span><\/span>\nconn.commit()<\/span>\n# \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5 \u4e3a\u4e86\u5e76\u53d1 \u51cf\u5c11\u7ebf\u7a0b\u6570<\/span><\/span>\nconn.close()<\/span>\n<\/code><\/pre>\n
<\/div>
python<\/span>
\u590d\u5236\u4ee3\u7801<\/div><\/div><\/div># text2SQL<\/span><\/span>\n# \u5b89\u88c5openai<\/span><\/span>\n!pip install openai==0.28<\/span>.1<\/span><\/span>\n# \u5b89\u88c5AI\u5e94\u7528\u5f00\u53d1\u6846\u67b6<\/span><\/span>\n!pip install langchain<\/span>\n# \u5b89\u88c5\u4e86langchain-experimental\u5305\uff0c\u8be5\u5305\u5305\u542b\u4e86\u4e00\u4e9b\u6700\u65b0\u7684\u5b9e\u9a8c\u6027\u529f\u80fd\u548c\u5de5\u5177<\/span><\/span>\n!pip install langchain-experimental<\/span>\n<\/code><\/pre>\n
<\/div>
python<\/span>
\u590d\u5236\u4ee3\u7801<\/div><\/div><\/div># langchain \u5c06LLM\u548c\u7528\u6237\u95f4chain\u8d77\u6765 \u8fde\u6570\u636e\u5e93<\/span><\/span>\n# langchain \u6709\u4e00\u4e2a\u6a21\u5757\u53ebutilities \u5de5\u5177\u5e93<\/span><\/span>\nfrom<\/span> langchain.utilities import<\/span> SQLDatabase<\/span>\n# \u5927\u6a21\u578b\u6a21\u5757<\/span><\/span>\nfrom<\/span> langchain.llms import<\/span> OpenAI<\/span>\nfrom<\/span> langchain_experimental.sql import<\/span> SQLDatabaseChain<\/span>\n# \u62ff\u5230\u6570\u636e\u5e93\u5bf9\u8c61<\/span><\/span>\ndb = SQLDatabase.from_uri(\"sqlite:\/\/\/FlowerShop.db\"<\/span>)<\/span>\n# \u8fd4\u56deOpenAI\u5b9e\u4f8b<\/span><\/span>\nllm = OpenAI(temperature=0<\/span>, verbose=True<\/span>, api_key='\u4f60\u7684api_key'<\/span>)<\/span>\n# \u5c06\u6570\u636e\u5e93\u5bf9\u8c61\u548cOpenAI\u5b9e\u4f8b\u901a\u8fc7SQLDatabaseChain\u8fdb\u884c\u94fe\u5f0f\u8fde\u63a5<\/span><\/span>\n# \u901a\u8fc7`db_chain.run`\u65b9\u6cd5\uff0c\u7528\u6237\u53ef\u4ee5\u5411\u94fe\u53d1\u9001\u4e00\u4e2a\u81ea\u7136\u8bed\u8a00\u67e5\u8be2\uff1a\"\u6709\u591a\u5c11\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\uff1f\"\u3002<\/span><\/span>\n# `response`\u5c06\u8fd4\u56de\u7531\u5927\u578b\u8bed\u8a00\u6a21\u578b\u751f\u6210\u7684\u67e5\u8be2\u7ed3\u679c\uff0c\u5e76\u901a\u8fc7`print`\u8bed\u53e5\u8f93\u51fa<\/span><\/span>\ndb_chain = SQLDatabaseChain.from_llm(llm, db, verbose=True<\/span>)<\/span>\nresponse = db_chain.run(\"\u6709\u591a\u5c11\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\uff1f\"<\/span>)<\/span>\nprint<\/span>(response)<\/span>\n<\/code><\/pre>\n
\u2002\u2002\u2002\u2002\u8ba9\u6211\u4eec\u770b\u770b\u8fd4\u56de\u7684\u7ed3\u679c\uff1a<\/p>\n
\n
\"image.png\"<\/figure>\n<\/p>\n
    \n
  1. Entering new SQLDatabaseChain chain...<\/code>\uff1a\u8fd9\u662f\u4e00\u4e2a\u63d0\u793a\uff0c\u8868\u793a\u4e00\u4e2a\u65b0\u7684SQLDatabaseChain<\/code>\u94fe\u5373\u5c06\u5f00\u59cb\u6267\u884c\u3002<\/li>\n
  2. \u6709\u591a\u5c11\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1<\/code>\uff1a\u8fd9\u662f\u7528\u6237\u63d0\u51fa\u7684\u81ea\u7136\u8bed\u8a00\u67e5\u8be2\uff0c\u5373\u201c\u6709\u591a\u5c11\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\u201d\u3002<\/li>\n
  3. SQLQuery: SELECT COUNT(DISTINCT Name) FROM FLOWERS<\/code>\uff1a\u8fd9\u662fSQLDatabaseChain<\/code>\u6839\u636e\u7528\u6237\u7684\u81ea\u7136\u8bed\u8a00\u67e5\u8be2\u751f\u6210\u7684\u76f8\u5e94SQL\u67e5\u8be2\u3002\u5728\u8fd9\u91cc\uff0c\u5b83\u7edf\u8ba1\u4e86FLOWERS<\/code>\u8868\u4e2d\u4e0d\u540c\u9c9c\u82b1\u7684\u6570\u91cf\u3002<\/li>\n
  4. SQLResult: [(5,)]<\/code>\uff1a\u8fd9\u662fSQL\u67e5\u8be2\u7684\u7ed3\u679c\uff0c\u8868\u660e\u5728\u6570\u636e\u5e93\u4e2d\u67095\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\u3002<\/li>\n
  5. Answer: 5<\/code>\uff1a\u8fd9\u662f\u6700\u7ec8\u7684\u56de\u7b54\uff0c\u8868\u793a\u5728\u6570\u636e\u5e93\u4e2d\u67095\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\u3002<\/li>\n
  6. Finished chain.<\/code>\uff1a\u8fd9\u4e5f\u662f\u63d0\u793a\uff0c\u8868\u793a\u6574\u4e2aSQLDatabaseChain<\/code>\u94fe\u7684\u6267\u884c\u5df2\u7ecf\u5b8c\u6210\u3002\n\u2002\u2002\u2002\u2002\u540c\u6837\u7684\u65b9\u6cd5\u6211\u4eec\u53ef\u4ee5\u968f\u610f\u5730\u8fdb\u884c\u5404\u79cd\u5404\u6837\u7684\u63d0\u95ee\uff1a<\/li>\n<\/ol>\n
    <\/div>
    python<\/span>
    \u590d\u5236\u4ee3\u7801<\/div><\/div><\/div>response = db_chain.run(\"\u54ea\u79cd\u9c9c\u82b1\u7684\u5b58\u8d27\u6570\u91cf\u6700\u5c11\uff1f\"<\/span>)<\/span>\nprint<\/span>(response)<\/span>\n<\/code><\/pre>\n
    \n
    \"image.png\"<\/figure>\n<\/p>\n
    <\/div>
    python<\/span>
    \u590d\u5236\u4ee3\u7801<\/div><\/div><\/div>response = db_chain.run(\"\u5e73\u5747\u9500\u552e\u4ef7\u683c\u662f\u591a\u5c11\uff1f\"<\/span>)<\/span>\nprint<\/span>(response)<\/span>\n<\/code><\/pre>\n
    \n
    \"image.png\"<\/figure>\n\n\u2002\u2002\u2002\u2002\u8fd9\u6837\u7b80\u5355\u76f4\u63a5\u7684\u63d0\u95ee\uff0c\u4f8b\u5982\u201c\u6709\u591a\u5c11\u79cd\u4e0d\u540c\u7684\u9c9c\u82b1\u201d\uff0c\u5c55\u73b0\u4e86AIGC\uff08\u4eba\u5de5\u667a\u80fd\u751f\u6210\u4ee3\u7801\uff09\u7684\u5f3a\u5927\u4e4b\u5904\u3002\u901a\u8fc7\u7ed3\u5408\u81ea\u7136\u8bed\u8a00\u5904\u7406\u548c\u6570\u636e\u5e93\u67e5\u8be2\uff0c\u7528\u6237\u53ef\u4ee5\u4ee5\u4e00\u79cd\u81ea\u7136\u800c\u76f4\u63a5\u7684\u65b9\u5f0f\u63d0\u51fa\u95ee\u9898\uff0c\u800c\u4e0d\u5fc5\u6df1\u5165\u4e86\u89e3SQL\u8bed\u6cd5\u6216\u6570\u636e\u5e93\u7ed3\u6784\u3002\u8fd9\u79cd\u7b80\u5355\u76f4\u63a5\u7684\u63d0\u95ee\u65b9\u5f0f\u4f7f\u5f97\u4efb\u4f55\u4eba\u90fd\u80fd\u591f\u8f7b\u677e\u5730\u4e0e\u6570\u636e\u5e93\u8fdb\u884c\u4ea4\u4e92\uff0c\u83b7\u53d6\u9700\u8981\u7684\u4fe1\u606f\u3002<\/p>\n
    \u2002\u2002\u2002\u2002\u5728\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d\uff0clangchain<\/code>\u6846\u67b6\u7684\u7075\u6d3b\u6027\u5f97\u4ee5\u4f53\u73b0\uff0c\u5b83\u5c06\u5927\u578b\u8bed\u8a00\u6a21\u578b\uff08LLM\uff09<\/code>\u548c\u6570\u636e\u5e93\u901a\u8fc7\u94fe\u5f0f\u8fde\u63a5\uff0c\u4f7f\u5f97\u7528\u6237\u80fd\u591f\u4ee5\u81ea\u7136\u8bed\u8a00\u5f62\u5f0f\u63d0\u95ee\uff0c\u800c\u6846\u67b6\u5219\u8d1f\u8d23\u5c06\u95ee\u9898\u7ffb\u8bd1\u6210\u76f8\u5e94\u7684SQL\u67e5\u8be2\uff0c\u5e76\u5c06\u7ed3\u679c\u8fd4\u56de\u7ed9\u7528\u6237\u3002\u8fd9\u79cd\u4ea4\u4e92\u65b9\u5f0f\u4e0d\u4ec5\u63d0\u9ad8\u4e86\u7528\u6237\u4f53\u9a8c\uff0c\u4e5f\u4f7f\u5f97\u4eba\u5de5\u667a\u80fd\u5728\u6570\u636e\u67e5\u8be2\u548c\u5206\u6790\u65b9\u9762\u7684\u5e94\u7528\u66f4\u52a0\u666e\u53ca\u3002<\/p>\n
    \u2002\u2002\u2002\u2002\u56e0\u6b64\uff0c\u901a\u8fc7\u8fd9\u79cd\u7b80\u5355\u76f4\u63a5\u7684\u63d0\u95ee\u65b9\u5f0f\uff0cAIGC\u4e0d\u4ec5\u8ba9\u5f00\u53d1\u8005\u66f4\u5bb9\u6613\u6784\u5efa\u667a\u80fd\u5e94\u7528\uff0c\u4e5f\u8ba9\u666e\u901a\u7528\u6237\u80fd\u591f\u8f7b\u677e\u5730\u5229\u7528\u4eba\u5de5\u667a\u80fd\u7684\u529b\u91cf\u8fdb\u884c\u6570\u636e\u67e5\u8be2\uff0c\u62d3\u5bbd\u4e86\u4eba\u4eec\u4e0e\u6280\u672f\u4e92\u52a8\u7684\u53ef\u80fd\u6027\u3002\u8fd9\u79cd\u7b80\u4fbf\u7684\u4ea4\u4e92\u65b9\u5f0f\u65e0\u7591\u4e3a\u4eba\u5de5\u667a\u80fd\u5728\u5404\u4e2a\u9886\u57df\u7684\u666e\u53ca\u5960\u5b9a\u4e86\u66f4\u52a0\u5e7f\u6cdb\u7684\u57fa\u7840\u3002<\/p>\n
    \u7ed3\u8bed<\/h1>\n
    \u2002\u2002\u2002\u2002\u5728AIGC\u4e0e\u5546\u4e1a\u5e94\u7528\u7684\u7ed3\u5408\u4e2d\uff0c\u6211\u4eec\u770b\u5230\u4e86\u65e0\u9650\u7684\u53ef\u80fd\u6027\u3002\u901a\u8fc7\u5c06AIGC\u6280\u672f\u4e0e\u4e0d\u540c\u9886\u57df\u7684\u5de5\u5177\u7ed3\u5408\uff0c\u6211\u4eec\u53ef\u4ee5\u521b\u9020\u51fa\u66f4\u52a0\u667a\u80fd\u3001\u9ad8\u6548\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u4e3a\u4f01\u4e1a\u548c\u4e2a\u4eba\u5e26\u6765\u66f4\u591a\u7684\u4ef7\u503c\u3002\u672a\u6765\uff0c\u968f\u7740AIGC\u6280\u672f\u7684\u4e0d\u65ad\u53d1\u5c55\uff0c\u6211\u4eec\u76f8\u4fe1\u4f1a\u770b\u5230\u66f4\u591a\u521b\u65b0\u7684\u5e94\u7528\u573a\u666f\uff0c\u63a8\u52a8\u4eba\u5de5\u667a\u80fd\u5728\u5546\u4e1a\u9886\u57df\u7684\u5e7f\u6cdb\u5e94\u7528\uff01\u5982\u679c\u5bf9\u6587\u7ae0\u611f\u5174\u8da3\u7684\u8bdd\uff0c\u8fd8\u5e0c\u671b\u80fd\u7ed9\u535a\u4e3b\u4e00\u4e2a\u514d\u8d39\u7684\u5c0f\u5fc3\u5fc3\u2661\u5440~<\/p>","protected":false},"excerpt":{"rendered":"
    \u8fd1\u671f\uff0cGPTs \u5e94\u7528\u5546\u5e97\u6b63\u5f0f\u53d1\u5e03\uff0c\u4e3a\u5e7f\u5927\u5f00\u53d1\u8005\u63d0\u4f9b\u4e86\u4e00\u4e2a\u5de8\u5927\u7684\u5546\u673a\u3002\u5728\u8fd9\u4e2a\u65b0\u7684\u4eba\u5de5\u667a\u80fd\u751f\u6210\u4ee3\u7801\uff08AIGC\uff09\u65b9\u5411\u4e2d\uff0c\u6709\u8bb8\u591a\u4ee4\u4eba\u5174\u594b\u7684\u53d1\u5c55\uff0c\u7279\u522b\u662f\u5728\u4e0eAI\u7535\u5546\u9886\u57df\u7684\u7ed3\u5408\u4e0a\u3002<\/p>\n","protected":false},"author":1,"featured_media":10964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rank_math_title":"","rank_math_description":"","rank_math_focus_keyword":"","views":"3","footnotes":""},"categories":[3],"tags":[128,129,136,126,127],"collection":[],"class_list":["post-1533","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fenlei2","tag-128","tag-129","tag-136","tag-gpt","tag-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/posts\/1533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/comments?post=1533"}],"version-history":[{"count":0,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/posts\/1533\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/media\/10964"}],"wp:attachment":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/media?parent=1533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/categories?post=1533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/tags?post=1533"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/collection?post=1533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}