{"id":1288,"date":"2017-08-20T02:51:05","date_gmt":"2017-08-19T18:51:05","guid":{"rendered":"http:\/\/www.yueguangzu.net\/?p=1288"},"modified":"2017-09-09T12:41:03","modified_gmt":"2017-09-09T04:41:03","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93models","status":"publish","type":"post","link":"http:\/\/www.yueguangzu.net\/?p=1288","title":{"rendered":"[Django\u7cfb\u5217]5.\u6570\u636e\u5e93models"},"content":{"rendered":"

ORM (\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04-Object Relational Mapping)<\/span><\/h3>\n
\u53ef\u4ee5\u9762\u5411\u5bf9\u8c61\u7f16\u7a0b\u8bed\u8a00\u91cc\u4e0d\u540c\u7c7b\u578b\u7cfb\u7edf\u7684\u6570\u636e\u4e4b\u95f4\u7684\u8f6c\u6362.<\/h5>\n
\u6a21\u578bmodel\u4e0e\u6570\u636e\u5e93<\/h5>\n

<\/span><\/span><\/p>\n

model\u901a\u5e38\u4f4d\u4e8eapp\/models.py<\/h5>\n

1.\u65b0\u5efa\u4e00\u4e2aBook,Author\u7684\u6a21\u578b<\/span><\/h4>\n
#models.py<\/span>\r\n# -*- coding: utf-8 -*-<\/span>\r\nfrom<\/span> __future__<\/span> import<\/span> unicode_literals<\/span>\r\nfrom<\/span> django<\/span>.db<\/span> import<\/span> models<\/span>\r\n\u200b\r\nclass<\/span> Book<\/span>(models<\/span>.Model<\/span>): \u00a0  #\u521b\u5efa\u4e00\u4e2aBook\u7684\u6a21\u578b,\u91cc\u9762\u5305\u542bisbn,name,price\u4e09\u4e2a\u5b57\u6bb5<\/span>\r\n \u00a0  isbn<\/span>=models<\/span>.IntegerField<\/span>() \u00a0 #\u6574\u578b<\/span>\r\n \u00a0  name<\/span>=models<\/span>.CharField<\/span>(max_length<\/span>=100<\/span>)  #\u5b57\u7b26\u4e32\u578b,\u6700\u5927\u957f\u5ea6100<\/span>\r\n \u00a0  price<\/span>=models<\/span>.FloatField<\/span>() \u00a0 #\u5b57\u7b26\u4e32\u7c7b\u578b<\/span>\r\n \u00a0  def<\/span> __unicode__<\/span>(self<\/span>): \u00a0 #\u5b9a\u4e49\u6210\u5458\u65b9\u6cd5unicode,\u5f53\u51fd\u6570\u5b9e\u4f8b\u5316\u65f6,\u6253\u5370\u8fd4\u56de\u63cf\u8ff0<\/span>\r\n \u00a0 \u00a0 \u00a0  return<\/span> self<\/span>.name<\/span>\r\n\u200b\r\nclass<\/span> Author<\/span>(models<\/span>.Model<\/span>):\r\n \u00a0  name<\/span>=models<\/span>.CharField<\/span>(max_length<\/span>=30<\/span>)\r\n \u00a0  age<\/span>=models<\/span>.IntegerField<\/span>()\r\n \u00a0  def<\/span> __unicode__<\/span>(self<\/span>):\r\n \u00a0 \u00a0 \u00a0  return<\/span> self<\/span>.name<\/span><\/pre>\n
\u521b\u5efa\u672c\u5730\u6620\u50cf\u6587\u4ef6“<\/h5>\n
\u9700\u8981\u6ce8\u610f\u7684\u662f,\u6267\u884c\u6b64\u9879\u64cd\u4f5c,\u5fc5\u987b\u5148\u5c06\u5e94\u7528\u6dfb\u52a0\u5230\u5bf9\u5e94\u7684settings.py\u7684install_app\u5217\u8868<\/span><\/p>\n
#settings.py<\/span>\r\nINSTALLED_APPS<\/span> = [\r\n \u00a0  'django.contrib.admin'<\/span>,\r\n \u00a0  'django.contrib.auth'<\/span>,\r\n \u00a0  'django.contrib.contenttypes'<\/span>,\r\n \u00a0  'django.contrib.sessions'<\/span>,\r\n \u00a0  'django.contrib.messages'<\/span>,\r\n \u00a0  'django.contrib.staticfiles'<\/span>,\r\n \u00a0  'book'<\/span>, \u00a0  #\u4e0d\u6dfb\u52a0\u7684\u6570,\u65e0\u6cd5\u521b\u5efa\u6539\u5e94\u7528\u7684\u6620\u5c04<\/span>\r\n]<\/pre>\n
\u5f00\u59cb\u521b\u5efapython manage.py makemigrations<\/code><\/span><\/h4>\n
>><\/span>python<\/span> manage<\/span>.py<\/span> makemigrations<\/span>\r\n\u6267\u884c\u6548\u679c<\/span>\r\nMigrations<\/span> for<\/span> 'book'<\/span>:\r\n  book<\/span>\\<\/span>migrations<\/span>\\000<\/span>1<\/span>_initial<\/span>.py<\/span>\r\n \u00a0  -<\/span> Create<\/span> model<\/span> Author<\/span>\r\n \u00a0  -<\/span> Create<\/span> model<\/span> Book<\/span><\/pre>\n
\u6620\u5c04\u672c\u5730\u6587\u4ef6\u5230\u6570\u636e\u5e93python manage.py migrate<\/code><\/span><\/h5>\n
>><\/span>python<\/span> manage<\/span>.py<\/span> migrate<\/span>\r\n\u6267\u884c\u6548\u679c<\/span>\r\nOperations<\/span> to<\/span> perform<\/span>:\r\n  Apply<\/span> all<\/span> migrations<\/span>: admin<\/span>, auth<\/span>, book<\/span>, contenttypes<\/span>, sessions<\/span>\r\nRunning<\/span> migrations<\/span>:\r\n  Applying<\/span> contenttypes<\/span>.0001<\/span>_initial<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0001<\/span>_initial<\/span>... OK<\/span>\r\n  Applying<\/span> admin<\/span>.0001<\/span>_initial<\/span>... OK<\/span>\r\n  Applying<\/span> admin<\/span>.0002<\/span>_logentry_remove_auto_add<\/span>... OK<\/span>\r\n  Applying<\/span> contenttypes<\/span>.0002<\/span>_remove_content_type_name<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0002<\/span>_alter_permission_name_max_length<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0003<\/span>_alter_user_email_max_length<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0004<\/span>_alter_user_username_opts<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0005<\/span>_alter_user_last_login_null<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0006<\/span>_require_contenttypes_0002<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0007<\/span>_alter_validators_add_error_messages<\/span>... OK<\/span>\r\n  Applying<\/span> auth<\/span>.0008<\/span>_alter_user_username_max_length<\/span>... OK<\/span>\r\n  Applying<\/span> book<\/span>.0001<\/span>_initial<\/span>... OK<\/span> \u00a0 \u00a0  #\u5982\u679c\u524d\u9762\u6ca1\u6709\u6dfb\u52a0INSTALLED_APPS,\u662f\u4e0d\u4f1a\u6709\u8fd9\u4e2a\u8868\u7684\u8bb0\u5f55<\/span>\r\n  Applying<\/span> sessions<\/span>.0001<\/span>_initial<\/span>... OK<\/span><\/pre>\n
\u4ee5\u4e0a\u6b65\u9aa4\u5b8c\u6210\u540e,\u6570\u636e\u5e93\u5c31\u6210\u529f\u521b\u5efa\u597d\u4e86.<\/h5>\n
2.python manage.py shell \u64cd\u4f5c\u6570\u636e\u5e93<\/h4>\n
python manage.py shell<\/code><\/span><\/h3>\n
Python<\/span> 2.7.13<\/span> (v2<\/span>.7.13<\/span>:a06454b1afa1<\/span>, Dec<\/span> 17<\/span> 2016<\/span>, 20<\/span>:42<\/span>:59<\/span>) [MSC<\/span> v<\/span>.1500<\/span> 32<\/span> bit<\/span> (Intel<\/span>)] on<\/span> win32<\/span>\r\nType<\/span> \"help\"<\/span>, \"copyright\"<\/span>, \"credits\"<\/span> or<\/span> \"license\"<\/span> for<\/span> more<\/span> information<\/span>.\r\n(InteractiveConsole<\/span>)<\/pre>\n
2.1\u521b\u5efa\u4e00\u6761\u8bb0\u5f55<\/h5>\n
Author.objects.create(name=\"yangfan\",age=25)<\/code><\/span><\/h5>\n
>>Author.objects.create(name=\"yangfan\",age=25)\r\n<<\/span>Author:<\/span> yangfan<\/span>><\/span> \r\n######\u9047\u5230\u91cd\u590d\u4f9d\u7136\u662f\u53ef\u4ee5\u63d2\u5165\r\n >>> Author.objects.create(name=\"yangfan\",age=25)\r\n<<\/span>Author:<\/span> yangfan<\/span>><\/span><\/pre>\n
\u4f46\u662f\u7531\u4e8e\u8fd9\u79cd\u65b9\u5f0f\u521b\u5efa\u7684\u8bb0\u5f55,\u540d\u5b57\u76f8\u540c\u65f6,\u4e0d\u4f1a\u68c0\u6d4b\u62a5\u9519,\u6240\u4ee5\u5f80\u5f80\u4f7f\u7528<\/h5>\n
Author.objects.get_or_create(name=\"fusheng\",age=29)<\/code><\/span><\/h5>\n
\u8fdb\u884c\u521b\u5efa<\/h5>\n
>>> Author.objects.get_or_create(name=\"fusheng\",age=29)\r\n(<<\/span>Author:<\/span> fusheng<\/span>><\/span>, True)\r\n>>> Author.objects.get_or_create(name='Fusheng',age=29)\r\n(<<\/span>Author:<\/span> Fusheng<\/span>><\/span>, True)\r\n\u200b\r\n >>> Author.objects.get_or_create(name=\"fusheng\",age=29) #\u5982\u679c\u68c0\u6d4b\u5230\u91cd\u590d,\u5219\u8fd4\u56de\u9519\u8bef.\u4e0d\u518d\u7ee7\u7eed\u63d2\u5165\u6570\u636e\r\n(<<\/span>Author:<\/span> fusheng<\/span>><\/span>, False)<\/pre>\n
2.2\u67e5\u8be2\u6570\u636e<\/h5>\n
get()\u65b9\u5f0f<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.get<\/span>(name<\/span>=\"fusheng\"<\/span>)\r\n<<\/span>Author<\/span>: fusheng<\/span>><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.get<\/span>(name<\/span>=\"fusheng\"<\/span>).name<\/span>\r\nu'fusheng'<\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.get<\/span>(name<\/span>=\"fusheng\"<\/span>).age<\/span>\r\n29<\/span><\/pre>\n
\u9700\u8981\u6ce8\u610f\u7684\u662f,get()\u53ea\u80fd\u83b7\u53d6\u5355\u6761\u8bb0\u5f55,\u5982\u679c\u5bf9\u8c61\u7684\u8bb0\u5f55\u6570\u5927\u4e8e1,\u5219\u4f1a\u8fd4\u56de\u5982\u4e0b\u9519\u8bef<\/h5>\n
>><\/span>Author<\/span>.objects<\/span>.get<\/span>(name<\/span>=\"yangfan\"<\/span>)\r\n#\u9519\u8bef\u63d0\u793a:\u83b7\u53d6\u591a\u4e8e1\u6761\u8bb0\u5f55,\u6240\u4ee5\u8fd9\u4e2a\u65f6\u5019<\/span>\r\nMultipleObjectsReturned<\/span>: get<\/span>() returned<\/span> more<\/span> than<\/span> one<\/span> Author<\/span> --<\/span> it<\/span> returned<\/span> 2<\/span>!<\/span><\/pre>\n
\u4e3a\u4e86\u89e3\u51b3\u4e0a\u8ff0\u95ee\u9898,\u53ef\u4ee5\u4f7f\u5458\u5de5<\/h5>\n
filter()\u65b9\u5f0f<\/h5>\n
\u8fd4\u56de\u7684\u662f\u4e00\u4e2aqueryset\u5bf9\u8c61,\u662f\u4e00\u4e2a\u5217\u8868,\u81ea\u7136\u53ef\u4ee5\u5207\u7247<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='yangfan'<\/span>)\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>]><\/span>\r\n#\u5f53\u7136\u4e5f\u53ef\u4ee5\u4f7f\u7528\u5207\u7247\u7684\u65b9\u5f0f<\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='yangfan'<\/span>)[0<\/span>]\r\n<<\/span>Author<\/span>: yangfan<\/span>><\/span><\/pre>\n
2.3\u8fc7\u6ee4\u67e5\u8be2\u7684\u5bf9\u8c61<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__exact<\/span>='fusheng'<\/span>) #\u4e25\u683c\u5339\u914d\u67e5\u8be2,\u5339\u914d\u5230fusheng\u8fd4\u56de\u7ed3\u679c<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__iexact<\/span>='fusheng'<\/span>)#\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u67e5\u8be2<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__contains<\/span>='sheng'<\/span>) #\u6a21\u7cca\u67e5\u8be2,\u5305\u542bsheng\u5b57\u7b26\u4e32\u7684\u5bf9\u8c61\u90fd\u80fd\u88ab\u67e5\u8be2\u51fa\u6765,\u7c7b\u4f3clike<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__regex<\/span>='sheng$'<\/span>) \u00a0 #\u6b63\u5219\u5339\u914d\u65b9\u5f0f\u67e5\u8be2,\u4ee5sheng\u7ed3\u5c3e\u7684\u7ed3\u679c\u90fd\u80fd\u88ab\u67e5\u8be2<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__iregex<\/span>='^fu'<\/span>) \u00a0  #\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u7684\u6b63\u5219\u5339\u914d\u67e5\u8be2<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span><\/pre>\n
2.4\u6392\u9664,\u6392\u5e8f\u8fde\u9501\u67e5\u8be2<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.exclude<\/span>(name<\/span>='fusheng'<\/span>)  #\u6392\u9664name='fusheng'\u7684\u8bb0\u5f55<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n\u200b\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__regex<\/span>='u'<\/span>).exclude<\/span>(name__contains<\/span>=\"fan\"<\/span>) #\u6392\u9664name\u4e2d\u5305\u542bu,\u4e14\u4e0d\u5305\u542bfan\u7684\u8bb0\u5f55<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n\u200b\r\n>><\/span> Author<\/span>.objects<\/span>.order_by<\/span>('name'<\/span>)  #\u6309name\u7684ascii\u7801\u987a\u5e8f\u8fdb\u884c\u987a\u5e8f\u6392\u5e8f,\u6240\u4ee5\u5927\u5199\u5b57\u6bcd\u9760\u524d<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: Fusheng<\/span>><\/span>, <<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.order_by<\/span>('-name'<\/span>) #\u6309name\u7684ascii\u7801\u987a\u5e8f\u8fdb\u884c\u5012\u5e8f\u6392\u5e8f<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name__contains<\/span>='n'<\/span>).order_by<\/span>('-name'<\/span>) #\u67e5\u8be2name\u4e2d\u5305\u542bn\u7684\u8bb0\u5f55\u6309name\u5012\u5e8f\u6392\u5217<\/span>\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: fusheng<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>]><\/span><\/pre>\n
2.5\u66f4\u65b0<\/h5>\n
save()\u6cd5<\/h5>\n
\u6ce8\u610f:\u53ea\u80fd\u4f7f\u7528get()\u83b7\u53d6\u5bf9\u8c61<\/h5>\n
>>><\/span> p<\/span>=Author<\/span>.objects<\/span>.get<\/span>(name<\/span>='Fusheng'<\/span>) #\u83b7\u53d6\u5bf9\u8c61\u8d4b\u503c\u7ed9p<\/span>\r\n>>><\/span> p<\/span>.age<\/span>\r\n31<\/span>\r\n>>><\/span> p<\/span>.age<\/span>=18<\/span>\r\n>>><\/span> p<\/span>.save<\/span>()<\/pre>\n
\u8fd9\u79cd\u65b9\u6cd5\u7b49\u4e8e\u6267\u884c\u4e86,\u628a\u6240\u6709\u7684\u5b57\u6bb5\u90fd\u66f4\u65b0\u4e00\u904d<\/h5>\n
Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='Fusheng'<\/span>).update<\/span>(age<\/span>='29'<\/span>,age<\/span>='Fusheng'<\/span>)<\/pre>\n
update()\u65b9\u6cd5<\/h5>\n
\u6ce8\u610f:\u53ea\u80fd\u4f7f\u7528filter()\u65b9\u6cd5\u83b7\u53d6queryset\u5bf9\u8c61<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='Fusheng'<\/span>)[0<\/span>].age<\/span>\r\n18<\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='Fusheng'<\/span>).update<\/span>(age<\/span>='29'<\/span>)  #\u4f7f\u7528update\u8fdb\u884c\u4fee\u6539<\/span>\r\n1<\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='Fusheng'<\/span>)[0<\/span>].age<\/span>\r\n29<\/span><\/pre>\n
2.6\u5220\u9664delete()<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='Fusheng'<\/span>)[0<\/span>].age<\/span>\r\n29<\/span>\r\n>>><\/span> Author<\/span>.objects<\/span>.filter<\/span>(name<\/span>='yangfan'<\/span>)[0<\/span>].delete<\/span>()\r\n(1<\/span>, {u'book.Author'<\/span>: 1<\/span>}) #\u8fd4\u56de\u64cd\u4f5c\u7684\u8bb0\u5f55\u6570<\/span>\r\n#\u5220\u9664\u5168\u8868\u64cd\u4f5c<\/span>\r\n>><\/span>Author<\/span>.objects<\/span>.all<\/span>().delete<\/span>()<\/pre>\n
\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u65b9\u5f0f\u5220\u9664<\/h5>\n
>>><\/span> p<\/span>=Author<\/span>.objects<\/span>.get<\/span>(name<\/span>='Fusheng'<\/span>)\r\n>>><\/span> p<\/span>.delete<\/span>()<\/pre>\n
\u4f5c\u4e1a<\/h2>\n
\u8f93\u5165127.0.0.1:8000\/books\/python\/?name=”zhangsan”&age=40\u6216127.0.0.1:8000\/books\/python\/zhangsan\/40\u628a\uff08”zhangsan”,40\uff09\u8bb0\u5f55\u5199\u5165\u6570\u636e\u5e93,\u7136\u540e\u901a\u8fc7python manage.py shell\u53bb\u68c0\u67e5\u662f\u5426\u6210\u529f\uff1f<\/h4>\n
#urls.py<\/span>\r\nfrom<\/span> django<\/span>.conf<\/span>.urls<\/span> import<\/span> url<\/span>\r\nfrom<\/span> django<\/span>.contrib<\/span> import<\/span> admin<\/span>\r\nfrom<\/span> book<\/span> import<\/span> views<\/span>\r\nurlpatterns<\/span> = [\r\n \u00a0  url<\/span>(r'^admin\/'<\/span>, admin<\/span>.site<\/span>.urls<\/span>),\r\n \u00a0  url<\/span>(r'^book\/(?P<bn>\\w+)\/$'<\/span>, views<\/span>.book<\/span>),\r\n \u00a0  url<\/span>(r'^book\/(?P<a>\\w+)\/(?P<b>\\d+)\/$'<\/span>, views<\/span>.book1<\/span>),\r\n]<\/pre>\n
# -*- coding: utf-8 -*-<\/span>\r\nfrom<\/span> __future__<\/span> import<\/span> unicode_literals<\/span>\r\n\u200b\r\nfrom<\/span> django<\/span>.shortcuts<\/span> import<\/span> render<\/span>\r\nfrom<\/span> models<\/span> import<\/span> Author<\/span>\r\n# Create your views here.<\/span>\r\ndef<\/span> book<\/span>(request<\/span>,bn<\/span>):\r\n \u00a0  name<\/span>=request<\/span>.GET<\/span>.get<\/span>('name'<\/span>)\r\n \u00a0  age<\/span>=request<\/span>.GET<\/span>.get<\/span>('age'<\/span>)\r\n \u00a0  if<\/span> name<\/span> or<\/span> age<\/span>:\r\n \u00a0 \u00a0 \u00a0  Author<\/span>.objects<\/span>.create<\/span>(name<\/span>=name<\/span>,age<\/span>=age<\/span>)\r\n \u00a0  a<\/span>=Author<\/span>.objects<\/span>.all<\/span>()\r\n \u00a0  return<\/span> render<\/span>(request<\/span>,'book_name.html'<\/span>,{'book_name'<\/span>:bn<\/span>,'a'<\/span>:a<\/span>,'name'<\/span>:name<\/span>,'age'<\/span>:age<\/span>})\r\ndef<\/span> book1<\/span>(request<\/span>,a<\/span>,b<\/span>):\r\n \u00a0  bn<\/span>='URL\u4f20\u53c2'<\/span>\r\n \u00a0  if<\/span> a<\/span> or<\/span> b<\/span>:\r\n \u00a0 \u00a0 \u00a0  Author<\/span>.objects<\/span>.create<\/span>(name<\/span>=a<\/span>,age<\/span>=b<\/span>)\r\n \u00a0  aa<\/span>=Author<\/span>.objects<\/span>.all<\/span>()\r\n \u00a0  return<\/span> render<\/span>(request<\/span>,'book_name.html'<\/span>,{'book_name'<\/span>:bn<\/span>,'a'<\/span>:aa<\/span>,'name'<\/span>:a<\/span>,'age'<\/span>:b<\/span>})<\/pre>\n
<!DOCTYPE html><\/span>\r\n<<\/span>html<\/span> lang<\/span>=\"en\"<\/span>><\/span>\r\n<<\/span>head<\/span>><\/span>\r\n \u00a0  <<\/span>meta<\/span> charset<\/span>=\"UTF-8\"<\/span>><\/span>\r\n \u00a0  <<\/span>title<\/span>><\/span>\u8fd9\u662f{{ book_name }}\u9875\u9762<\/<\/span>title<\/span>><\/span>\r\n<\/<\/span>head<\/span>><\/span>\r\n<<\/span>body<\/span>><\/span>\r\n<<\/span>center<\/span>><\/span>\r\n \u00a0  <<\/span>h1<\/span>><\/span>\u8fd9\u662f{{ book_name }}\u9875\u9762<\/<\/span>h1<\/span>><\/span>\r\n \u00a0  {% if name or age %}\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <<\/span>h1<\/span>><\/span>\u5df2\u5c06\u8bb0\u5f55\u540d\u5b57:{{ name }},\u5e74\u9f84:{{ age }}\u5165\u5e93<\/<\/span>h1<\/span>><\/span>\r\n \u00a0  {% endif %}\r\n \u00a0  <<\/span>table<\/span> border<\/span>=\"1\"<\/span>><\/span>\r\n \u00a0  <<\/span>tr<\/span>><\/span>\r\n \u00a0 \u00a0 \u00a0  <<\/span>th<\/span>><\/span>\u59d3\u540d<\/<\/span>th<\/span>><\/span>\r\n \u00a0 \u00a0 \u00a0  <<\/span>th<\/span>><\/span>\u5e74\u9f84<\/<\/span>th<\/span>><\/span>\r\n \u00a0  <\/<\/span>tr<\/span>><\/span>\r\n \u00a0  {% for i in a %}\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <<\/span>tr<\/span>><\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <<\/span>td<\/span>><\/span>{{ i.name }}<\/<\/span>td<\/span>><\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <<\/span>td<\/span>><\/span>{{ i.age }}<\/<\/span>td<\/span>><\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <\/<\/span>tr<\/span>><\/span>\r\n \u00a0  {% endfor %}\r\n \u00a0  <\/<\/span>table<\/span>><\/span>\r\n<\/<\/span>center<\/span>><\/span>\r\n<\/<\/span>body<\/span>><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/pre>\n
\u9996\u5148\u662f\u901a\u8fc7request\u7684\u53c2\u6570\u4f20\u53c2,\u4f20\u5165name=”zhangsan”&age=40,\u53d1\u73b0\u5165\u5e93\u6210\u529f!<\/h4>\n
<\/span><\/span><\/p>\n
\u63a5\u7740\u662fURL\u8def\u7531\u7684\u53c2\u6570\u4f20\u53c2,\u5165\u5e93\u6210\u529f<\/h4>\n
<\/span><\/span><\/p>\n
python manage.py shell \u67e5\u770b\u8bb0\u5f55,\u5df2\u5165\u5e93\u6210\u529f<\/h5>\n
>>><\/span> Author<\/span>.objects<\/span>.all<\/span>()\r\n<<\/span>QuerySet<\/span> [<<\/span>Author<\/span>: yangfan<\/span>><\/span>, <<\/span>Author<\/span>: Fusheng<\/span>><\/span>, <<\/span>Author<\/span>: FF<\/span>><\/span>, <<\/span>Author<\/span>: FF<\/span>><\/span>, <<\/span>Author<\/span>: \"zhangsan\"<\/span>><\/span>, <<\/span>Author<\/span>: zhangsan<\/span>><\/span>, <<\/span>Author<\/span>: zhangsan<\/span>><\/span>, <<\/span>Author<\/span>: fusheng<\/span>><\/span>]><\/span><\/pre>\n
<\/h1>\n","protected":false},"excerpt":{"rendered":"
ORM (\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04-Object Relational Mapping) \u53ef\u4ee5\u9762\u5411\u5bf9\u8c61\u7f16\u7a0b\u8bed\u8a00\u91cc\u4e0d\u540c\u7c7b\u578b\u7cfb\u7edf\u7684\u6570\u636e\u4e4b\u95f4\u7684\u8f6c\u6362. \u6a21\u578bmodel\u4e0e\u6570\u636e\u5e93 model\u901a\u5e38\u4f4d\u4e8eapp\/models.py 1.\u65b0\u5efa\u4e00\u4e2aBook,Author\u7684\u6a21 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[54],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/posts\/1288"}],"collection":[{"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1288"}],"version-history":[{"count":3,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/posts\/1288\/revisions"}],"predecessor-version":[{"id":1425,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=\/wp\/v2\/posts\/1288\/revisions\/1425"}],"wp:attachment":[{"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1288"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yueguangzu.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}