1.用Django里面的connection.py文件
from Django.db import connection
def test1(request):
cur = connection.cursor()
count = cur.execute('select * from bookinfo where id>%s;',(3,))#后面的括号是指参数列表
print(count)
for i in count :
print(i)
return HttpResponse('ok')
注意点:count这是一个可迭代对象
2.用ORM自带的raw
def test2(request):
aa = BookInfo.objects.raw('select * from bookinfo')
for i in aa:
print(i.bookname,i.publictime)
return HttpResponse('ok')
3.用pymysql
import pymysql
con = pymysql.connect(host='localhost',user='root',password='自己数据库的密码',database='自己船家女的数据库的名字',port = 3306,charset='utf8')
#创建一个游标
cur = con.cursor()
cur.execute('select * from aa')
con.commit()#提交
cur.close() # 关闭光标
con.close()#关闭连接