![\"python](\"https:\/\/cdn-kb.worktile.com\/kb\/wp-content\/uploads\/2024\/04\/25101916\/c1ca0760-d765-4c01-90a0-592cdadf1817.webp\")
<\/p>\n<\/p>\n
Python\u8bbf\u95ee\u6570\u636e\u5e93\u8868\u7684\u6b65\u9aa4\u5305\u62ec\uff1a\u5b89\u88c5\u6570\u636e\u5e93\u9a71\u52a8\u3001\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u3001\u6267\u884cSQL\u67e5\u8be2\u3001\u5904\u7406\u67e5\u8be2\u7ed3\u679c\u3001\u5173\u95ed\u8fde\u63a5<\/strong>\u3002\u4ee5\u4e0b\u8be6\u7ec6\u63cf\u8ff0\u5176\u4e2d\u7684\u4e00\u4e2a\u6b65\u9aa4\u2014\u2014\u6267\u884cSQL\u67e5\u8be2\u3002<\/p>\n<\/p>\n \u5728Python\u4e2d\uff0c\u6267\u884cSQL\u67e5\u8be2\u662f\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u6838\u5fc3\u6b65\u9aa4\u3002\u901a\u8fc7\u4f7f\u7528\u6570\u636e\u5e93\u9a71\u52a8\u5e93\uff08\u5982PyMySQL\u3001psycopg2\u7b49\uff09\uff0c\u53ef\u4ee5\u5c06SQL\u8bed\u53e5\u53d1\u9001\u5230\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u901a\u5e38\uff0c\u4f60\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u6e38\u6807\u5bf9\u8c61\uff0c\u8c03\u7528\u5176execute()\u65b9\u6cd5\u6765\u6267\u884cSQL\u67e5\u8be2\u3002\u6267\u884c\u5b8c\u67e5\u8be2\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7fetchone()\u3001fetchall()\u7b49\u65b9\u6cd5\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u3002\u8fd9\u6837\uff0c\u4f60\u53ef\u4ee5\u83b7\u53d6\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u5e76\u5728Python\u4e2d\u8fdb\u884c\u8fdb\u4e00\u6b65\u5904\u7406\u3002<\/p>\n<\/p>\n \u5728\u4f7f\u7528Python\u8bbf\u95ee\u6570\u636e\u5e93\u4e4b\u524d\uff0c\u9996\u5148\u9700\u8981\u5b89\u88c5\u76f8\u5e94\u7684\u6570\u636e\u5e93\u9a71\u52a8\u3002\u4e0d\u540c\u7684\u6570\u636e\u5e93\u6709\u4e0d\u540c\u7684\u9a71\u52a8\u5305\uff0c\u4f8b\u5982\uff1a<\/p>\n<\/p>\n \u53ef\u4ee5\u901a\u8fc7 pip install psycopg2<\/p>\n <\/code><\/pre>\n<\/p>\n \u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u662f\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u7b2c\u4e00\u6b65\u3002\u4f60\u9700\u8981\u63d0\u4f9b\u6570\u636e\u5e93\u7684\u8fde\u63a5\u53c2\u6570\uff0c\u5982\u4e3b\u673a\u5730\u5740\u3001\u7aef\u53e3\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u548c\u6570\u636e\u5e93\u540d\u79f0\u3002\u4ee5\u4e0b\u662f\u4f7f\u7528\u4e0d\u540c\u9a71\u52a8\u5efa\u7acb\u8fde\u63a5\u7684\u793a\u4f8b\uff1a<\/p>\n<\/p>\n connection = pymysql.connect(<\/p>\n host='localhost',<\/p>\n user='your_username',<\/p>\n password='your_password',<\/p>\n database='your_database'<\/p>\n )<\/p>\n <\/code><\/pre>\n<\/p>\n connection = psycopg2.connect(<\/p>\n host='localhost',<\/p>\n user='your_username',<\/p>\n password='your_password',<\/p>\n dbname='your_database'<\/p>\n )<\/p>\n <\/code><\/pre>\n<\/p>\n connection = sqlite3.connect('your_database.db')<\/p>\n <\/code><\/pre>\n<\/p>\n \u5efa\u7acb\u8fde\u63a5\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7\u521b\u5efa\u6e38\u6807\u5bf9\u8c61\u6765\u6267\u884cSQL\u67e5\u8be2\u3002\u4ee5\u4e0b\u662f\u6267\u884c\u67e5\u8be2\u7684\u793a\u4f8b\uff1a<\/p>\n<\/p>\n sql = "SELECT * FROM your_table"<\/p>\n cursor.execute(sql)<\/p>\n results = cursor.fetchall()<\/p>\n <\/code><\/pre>\n<\/p>\n sql = "SELECT * FROM your_table"<\/p>\n cursor.execute(sql)<\/p>\n results = cursor.fetchall()<\/p>\n <\/code><\/pre>\n<\/p>\n sql = "SELECT * FROM your_table"<\/p>\n cursor.execute(sql)<\/p>\n results = cursor.fetchall()<\/p>\n <\/code><\/pre>\n<\/p>\n \u5904\u7406\u67e5\u8be2\u7ed3\u679c\u901a\u5e38\u6d89\u53ca\u904d\u5386\u67e5\u8be2\u7ed3\u679c\u96c6\u5e76\u8fdb\u884c\u76f8\u5e94\u7684\u64cd\u4f5c\u3002\u4ee5\u4e0b\u662f\u5904\u7406\u67e5\u8be2\u7ed3\u679c\u7684\u793a\u4f8b\uff1a<\/p>\n<\/p>\n print(row)<\/p>\n <\/code><\/pre>\n<\/p>\n \u5b8c\u6210\u67e5\u8be2\u548c\u5904\u7406\u540e\uff0c\u52a1\u5fc5\u5173\u95ed\u6e38\u6807\u548c\u8fde\u63a5\uff0c\u4ee5\u91ca\u653e\u8d44\u6e90\uff1a<\/p>\n<\/p>\n connection.close()<\/p>\n <\/code><\/pre>\n<\/p>\n \u5728\u5b9e\u9645\u5e94\u7528\u4e2d\uff0c\u6570\u636e\u5e93\u64cd\u4f5c\u53ef\u80fd\u4f1a\u51fa\u73b0\u5404\u79cd\u9519\u8bef\uff0c\u56e0\u6b64\u9700\u8981\u52a0\u5165\u9519\u8bef\u5904\u7406\u673a\u5236\u3002\u53ef\u4ee5\u4f7f\u7528try-except\u8bed\u53e5\u6765\u6355\u83b7\u548c\u5904\u7406\u5f02\u5e38\uff1a<\/p>\n<\/p>\n try:<\/p>\n connection = pymysql.connect(<\/p>\n host='localhost',<\/p>\n user='your_username',<\/p>\n password='your_password',<\/p>\n database='your_database'<\/p>\n )<\/p>\n cursor = connection.cursor()<\/p>\n sql = "SELECT * FROM your_table"<\/p>\n cursor.execute(sql)<\/p>\n results = cursor.fetchall()<\/p>\n for row in results:<\/p>\n print(row)<\/p>\n except pymysql.MySQLError as e:<\/p>\n print(f"Error: {e}")<\/p>\n finally:<\/p>\n cursor.close()<\/p>\n connection.close()<\/p>\n <\/code><\/pre>\n<\/p>\n \u9664\u4e86\u76f4\u63a5\u4f7f\u7528SQL\u67e5\u8be2\uff0cPython\u8fd8\u6709\u4e00\u4e9bORM\uff08\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\uff09\u6846\u67b6\uff0c\u5982SQLAlchemy\u548cDjango ORM\uff0c\u53ef\u4ee5\u66f4\u65b9\u4fbf\u5730\u64cd\u4f5c\u6570\u636e\u5e93\u3002<\/p>\n<\/p>\n engine = create_engine('mysql+pymysql:\/\/your_username:your_password@localhost\/your_database')<\/p>\n metadata = MetaData()<\/p>\n table = Table('your_table', metadata, autoload=True, autoload_with=engine)<\/p>\n with engine.connect() as connection:<\/p>\n result = connection.execute(table.select())<\/p>\n for row in result:<\/p>\n print(row)<\/p>\n <\/code><\/pre>\n<\/p>\n \u5982\u679c\u4f7f\u7528Django\u6846\u67b6\uff0c\u53ef\u4ee5\u5229\u7528\u5176\u5185\u7f6e\u7684ORM\uff1a<\/p>\n<\/p>\n results = YourModel.objects.all()<\/p>\n for row in results:<\/p>\n print(row)<\/p>\n <\/code><\/pre>\n<\/p>\n \u8bbf\u95ee\u6570\u636e\u5e93\u8868\u65f6\uff0c\u6027\u80fd\u4f18\u5316\u4e5f\u662f\u4e00\u4e2a\u91cd\u8981\u7684\u8003\u8651\u56e0\u7d20\u3002\u4ee5\u4e0b\u662f\u4e00\u4e9b\u5e38\u89c1\u7684\u4f18\u5316\u7b56\u7565\uff1a<\/p>\n<\/p>\n \u8bbf\u95ee\u6570\u636e\u5e93\u65f6\uff0c\u5b89\u5168\u6027\u4e5f\u662f\u5fc5\u987b\u5173\u6ce8\u7684\u65b9\u9762\u3002\u4ee5\u4e0b\u662f\u4e00\u4e9b\u5e38\u89c1\u7684\u5b89\u5168\u63aa\u65bd\uff1a<\/p>\n<\/p>\n \u901a\u8fc7\u4e00\u4e2a\u7b80\u5355\u7684\u793a\u4f8b\u9879\u76ee\uff0c\u5c55\u793a\u5982\u4f55\u7efc\u5408\u8fd0\u7528\u4e0a\u8ff0\u5185\u5bb9\u3002<\/p>\n<\/p>\n def fetch_data():<\/p>\n try:<\/p>\n connection = pymysql.connect(<\/p>\n host='localhost',<\/p>\n user='your_username',<\/p>\n password='your_password',<\/p>\n database='your_database'<\/p>\n )<\/p>\n cursor = connection.cursor()<\/p>\n sql = "SELECT * FROM your_table"<\/p>\n cursor.execute(sql)<\/p>\n results = cursor.fetchall()<\/p>\n for row in results:<\/p>\n print(row)<\/p>\n except pymysql.MySQLError as e:<\/p>\n print(f"Error: {e}")<\/p>\n finally:<\/p>\n cursor.close()<\/p>\n connection.close()<\/p>\n\u4e00\u3001\u5b89\u88c5\u6570\u636e\u5e93\u9a71\u52a8<\/h3>\n<\/p>\n
\n
PyMySQL<\/code>\u6216MySQL Connector\/Python<\/code><\/li>\npsycopg2<\/code><\/li>\npip<\/code>\u5b89\u88c5\u8fd9\u4e9b\u9a71\u52a8\uff0c\u4f8b\u5982\uff1a<\/p>\n<\/p>\npip install pymysql<\/p>\n\u4e8c\u3001\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5<\/h3>\n<\/p>\n
1. MySQL<\/h4>\n<\/p>\n
import pymysql<\/p>\n2. PostgreSQL<\/h4>\n<\/p>\n
import psycopg2<\/p>\n3. SQLite<\/h4>\n<\/p>\n
import sqlite3<\/p>\n\u4e09\u3001\u6267\u884cSQL\u67e5\u8be2<\/h3>\n<\/p>\n
1. MySQL<\/h4>\n<\/p>\n
cursor = connection.cursor()<\/p>\n2. PostgreSQL<\/h4>\n<\/p>\n
cursor = connection.cursor()<\/p>\n3. SQLite<\/h4>\n<\/p>\n
cursor = connection.cursor()<\/p>\n\u56db\u3001\u5904\u7406\u67e5\u8be2\u7ed3\u679c<\/h3>\n<\/p>\n
for row in results:<\/p>\n\u4e94\u3001\u5173\u95ed\u8fde\u63a5<\/h3>\n<\/p>\n
cursor.close()<\/p>\n\u516d\u3001\u9519\u8bef\u5904\u7406<\/h3>\n<\/p>\n
import pymysql<\/p>\n\u4e03\u3001\u4f7f\u7528ORM\u6846\u67b6<\/h3>\n<\/p>\n
1. SQLAlchemy<\/h4>\n<\/p>\n
from sqlalchemy import create_engine, Table, MetaData<\/p>\n2. Django ORM<\/h4>\n<\/p>\n
from myapp.models import YourModel<\/p>\n\u516b\u3001\u6027\u80fd\u4f18\u5316<\/h3>\n<\/p>\n
\n
\u4e5d\u3001\u5b89\u5168\u6027<\/h3>\n<\/p>\n
\n
\u5341\u3001\u793a\u4f8b\u9879\u76ee<\/h3>\n<\/p>\n
import pymysql<\/p>\n