python django 增删改查操作 数据库Mysql
下面介绍一下django增删改查操作：
1、view.py
#-*-coding:utf-8-*-
from__future__importunicode_literals
fromdjango.httpimportHttpResponse
frompolls.modelsimportTest
fromdjango.shortcutsimportrender
#Createyourviewshere.
#解决乱码
importsys
reload(sys)
sys.setdefaultencoding('utf-8')
#数据库操作
deftestdb(request):
test1=Test(name='温鸿雨2')
test1.save()
returnHttpResponse("数据添加成功！
")
#查询数据库
defselectDB(request):
#通过objects这个模型管理器的all()获得所有数据行，相当于SQL中的SELECT*FROM
list=Test.objects.all()
returnvalue=[]
forvinlist:
returnvalue.append(v.name)
printv.name
print"++++++++++++获取单个对象++++++++++++++++++"
#获取单个对象
response1=Test.objects.filter(id=1)
printresponse1
forv1inresponse1:
returnvalue2="id:",v1.id,"姓名：",v1.name
printreturnvalue2
print"++++++++++++限制返回的数据相当于SQL中的OFFSET0LIMIT2;++++++++++++++++++"
response2=Test.objects.order_by('name')[0:2]
returnvalue3={}
forv2inresponse2:
returnvalue3[v2.id]=v2.name
printreturnvalue3.items()
print"+++++++++++输出结果：++++++++++++++++++++++++++++++"
returnHttpResponse(returnvalue3.items())
#修改数据可以使用save()或update():
defupdateDB(request):
#修改其中一个id=1的name字段，再save，相当于SQL中的UPDATE
test1=Test.objects.get(id=1)
test1.name='Google'
test1.save()
#另外一种方式
#Test.objects.filter(id=1).update(name='Google')
#修改所有的列
#Test.objects.all().update(name='Google')
returnHttpResponse("更新数据成功")
defdeleteDB(request):
#删除id=1的数据
test1=Test.objects.get(id=3)
test1.delete()
returnHttpResponse("删除数据成功")
2、urls.py
"""pythondjangoURLConfiguration
The`urlpatterns`listroutesURLstoviews.Formoreinformationpleasesee:
https://docs.djangoproject.com/en/1.11/topics/http/urls/
Examples:
Functionviews
1.Addanimport:frommy_appimportviews
2.AddaURLtourlpatterns:url(r'^$',views.home,name='home')
Class-basedviews
1.Addanimport:fromother_app.viewsimportHome
2.AddaURLtourlpatterns:url(r'^$',Home.as_view(),name='home')
IncludinganotherURLconf
1.Importtheinclude()function:fromdjango.conf.urlsimporturl,include
2.AddaURLtourlpatterns:url(r'^blog/',include('blog.urls'))
"""
fromdjango.conf.urlsimporturl
fromdjango.contribimportadmin
fromBlogDjangoimportviews
frompollsimportviewsaspollsviews,search,search2
urlpatterns=[
url(r'^admin/',admin.site.urls),
url(r'^hello/+\d',views.hello),
url(r'^base/',views.base),
url(r'^testdb$',pollsviews.testdb),
url(r'^querydb$',pollsviews.selectDB),
url(r'^updateDB$',pollsviews.updateDB),
url(r'^deleteDB$',pollsviews.deleteDB),
]
3、models.py
#-*-coding:utf-8-*- from__future__importunicode_literals fromdjango.dbimportmodels #Createyourmodelshere. classTest(models.Model): name=models.CharField(max_length=20)
以上这篇pythondjango增删改查操作数据库Mysql就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持毛票票。