django执行sql

Django与MySQL交互示例

最新推荐文章于 2025-09-13 23:06:41 发布

weixin_30920597

最新推荐文章于 2025-09-13 23:06:41 发布

阅读量74

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：http://www.cnblogs.com/lajiao/p/8910579.html

http://docs.30c.org/djangobook2/chapter10/
def first_names(self, last_name):
cursor = connection.cursor()
cursor.execute("""
SELECT DISTINCT first_name
FROM people_person
WHERE last_name = %s""", [last_name])
return [row[0] for row in cursor.fetchone()]

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql', #引擎
'NAME': 'coin_02', # 库名
'USER': 'root', # 用户名
'PASSWORD': '123456', # 密码
'HOST': '127.0.0.1', # 地址
'PORT': '3306', # 端口
},
'test':{
'ENGINE': 'django.db.backends.mysql', #引擎
'NAME': 'test', # 库名
'USER': 'root', # 用户名
'PASSWORD': '123456', # 密码
'HOST': '127.0.0.1', # 地址
'PORT': '3306', # 端口
},

  官方文档;http://docs.30c.org/djangobook2/chapter05
        from django.shortcuts import render_to_response
import MySQLdb

def book_list(request):
    db = MySQLdb.connect(user='me', db='mydb', passwd='secret', host='localhost')
    cursor = db.cursor()
    cursor.execute('SELECT name FROM books ORDER BY name')
    names = [row[0] for row in cursor.fetchall()]
    db.close()
    return render_to_response('book_list.html', {'names': names})

https://docs.djangoproject.com/en/2.0/topics/db/sql/
SQL语句 cursor.execute()使用占位符"%s"，而不是直接在SQL中添加参数。如果您使用这种技

def GetList(request):
    from .conn_mysql import transaction,connections
    with connections['test'].cursor() as c:
        c.execute("select * from duanzi WHERE id=%s;",[2])
        # cursor.execute("select * from duanzi",[])
        # cursor.execute("insert into duanzi(content,createtime) VALUES ('aa','1518186153')",[])
        # transaction.commit_unless_managed()

        row=c.fetchone()
        # transaction.set_dirty()
        # cursor.close()
    return HttpResponse(row)

转载于:https://www.cnblogs.com/lajiao/p/8910579.html