python+django+sae系列教程13-----mysql记录的添\删\改 建立了数据库后，我们就来做一个简单的表（ person_classroom ）的添加、删除、修改的操作。 首先我们建立一个添加的页面的模板 classroom_add.html（添加的表单） 并把它放在 bidding\templates\person
python+django+sae系列教程13-----mysql记录的添\删\改
建立了数据库后，我们就来做一个简单的表（person_classroom）的添加、删除、修改的操作。
首先我们建立一个添加的页面的模板classroom_add.html（添加的表单）并把它放在bidding\templates\person中：
classroom_add.html：
数据库操作简单表的添加这里是classroom的添加页面 {% if error %} 请输入班级名称和导师姓名
{% endif %}
项目 内容
班级名称：
导师姓名：
classroom_add_results.html：
查询用户结果页


班级：{{name}}添加成功 ！
点击返回
上面的 这个文件时添加后的结果页。
然后建立对应的view，我们修改person/views.py 文件
views.py：
# -*- coding: utf-8 -*-from django.shortcuts import render_to_responsefrom django.db import connection,transactionfrom person.models import *def classroonadd(request): if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: name = request.get['name'] tutor = request.get['tutor'] cursor=connection.cursor() sql='insert into person_classroom (name,tutor) values (\''+name+'\',\''+tutor+'\')' cursor.execute(sql) transaction.commit_unless_managed() cursor.close() return render_to_response('person/classroom_add_results.html', {'name': name}) else: return render_to_response('person/classroom_add.html', {'error': true})
在修改一下urls.py文件:
from django.conf.urls import patterns, include, url# uncomment the next two lines to enable the admin:# from django.contrib import admin# admin.autodiscover()urlpatterns = patterns('', # examples: # url(r'^$', 'bidding.views.home', name='home'), # url(r'^bidding/', include('bidding.foo.urls')), # uncomment the admin/doc line below to enable admin documentation: # url(r'^admin/doc/', include('django.contrib.admindocs.urls')), # uncomment the next line to enable the admin: # url(r'^admin/', include(admin.site.urls)), url(r'^hello/$', 'bidding.views.hello'), url(r'^time/$', 'bidding.views.current_datetime'), url(r'^time/plus/(\d{1,2})/$', 'bidding.views.hours_ahead'), url(r'^hello_base/$', 'bidding.views.hello_base'), url(r'^request_test/$', 'bidding.views.request_test'), url(r'^userssearch/$', 'bidding.users.views.search_form'), url(r'^search/$', 'bidding.users.views.search'), url(r'^classroom/add/$', 'person.views.classroonadd'),)
这时我们的添加就做好了，访问一下classroom/add这个 页面，就可以看到结果了。
不过上面我们所说的办法是执行一个原始的sql语句，这个方式其实并不是django推荐的，我们可以直接使用models操作数据库的方法，改造一下classroomadd这个视图：
def classroonadd(request): if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: name = request.get['name'] tutor = request.get['tutor'] c = classroom(name=name,tutor=tutor) c.save() return render_to_response('person/classroom_add_results.html', {'name': name}) else: return render_to_response('person/classroom_add.html', {'error': true})
这样的方法即简单，有不用我们很多sql的语法，并且最重要的是如果更换数据库类型（sqlserver->oracle），也不会因为受sql语法不一致的影响。
在接下来，我们来做一个列表页，把数据库中的classroom表的记录以一个表格的形式显示出来。还是从模板先入手，建立一个classroom_list.html，放入bidding\templates\person文件夹下：
classroom_list.html：
数据库操作简单表的添加这里是classroom的管理页面


序号 班级名称 导师姓名
{% for myclass in classroonlist%} {{ myclass.id }} {{ myclass.name }} {{ myclass.tutor }}
{% endfor %}
添加视图：
# -*- coding: utf-8 -*-from django.shortcuts import render_to_responsefrom django.db import connection,transactionfrom person.models import *def classroonadd(request): if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: name = request.get['name'] tutor = request.get['tutor'] cursor=connection.cursor() sql='insert into person_classroom (name,tutor) values (\''+name+'\',\''+tutor+'\')' cursor.execute(sql) transaction.commit_unless_managed() cursor.close() return render_to_response('person/classroom_add_results.html', {'name': name}) else: return render_to_response('person/classroom_add.html', {'error': true})def classroonadd(request): if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: name = request.get['name'] tutor = request.get['tutor'] c = classroom(name=name,tutor=tutor) c.save() return render_to_response('person/classroom_add_results.html', {'name': name}) else: return render_to_response('person/classroom_add.html', {'error': true})def classroonlist(request): cursor=connection.cursor() sql='select id,name,tutor from person_classroom' classroonlist=classroom.objects.raw(sql) return render_to_response('person/classroom_list.html', {'classroonlist': classroonlist})
配置urls.py:
from django.conf.urls import patterns, include, url# uncomment the next two lines to enable the admin:# from django.contrib import admin# admin.autodiscover()urlpatterns = patterns('', # examples: # url(r'^$', 'bidding.views.home', name='home'), # url(r'^bidding/', include('bidding.foo.urls')), # uncomment the admin/doc line below to enable admin documentation: # url(r'^admin/doc/', include('django.contrib.admindocs.urls')), # uncomment the next line to enable the admin: # url(r'^admin/', include(admin.site.urls)), url(r'^hello/$', 'bidding.views.hello'), url(r'^time/$', 'bidding.views.current_datetime'), url(r'^time/plus/(\d{1,2})/$', 'bidding.views.hours_ahead'), url(r'^hello_base/$', 'bidding.views.hello_base'), url(r'^request_test/$', 'bidding.views.request_test'), url(r'^userssearch/$', 'bidding.users.views.search_form'), url(r'^search/$', 'bidding.users.views.search'), url(r'^classroom/add/$', 'person.views.classroonadd'), url(r'^classroom/list/$', 'person.views.classroonlist'),)
如同上述讨论的一样，我们现在的视图执行的是一个原始的sql，现在我们需要用models来修改一下：
def classroonlist(request): cursor=connection.cursor() classroonlist=classroom.objects.all() #classroonlist=classroom.objects.filter(name__icontains='大') return render_to_response('person/classroom_list.html', {'classroonlist': classroonlist})
如果需要执行where或者order by等操作可以这样：
 classroonlist=classroom.objects.filter(name__icontains='大').order_by(‘name’)
这里还有很多关于选择的内容以后我们逐渐会介绍到。
做完了列表页，我们在来做一个修改的页面，思路是这样的：在列表页中的每一行的后面添加一列“修改”按钮，点击按钮后跳转到修改页面，首先以此条记录的主键专递到修改页面，在修改页面中要先读取出数据库中的信息，然后点击确定按钮以后执行修改操作。
我们首先来修改这个管理页面的模板：
classroom_list.html：
数据库操作简单表的添加这里是classroom的管理页面


序号 班级名称 导师姓名 操作
{% for myclass in classroonlist%} {{ myclass.id }} {{ myclass.name }} {{ myclass.tutor }}
{% endfor %}
建立一个classroom_modify.html模板，把它放在bidding\templates\person文件夹下
classroom_modify.html：
数据库操作简单表的修改这里是classroom--{{name}}的修改页面 {% if error %} 请输入班级名称和导师姓名
{% endif %}
项目 内容
班级名称：
导师姓名：
classroom_modify_results.html：
查询用户结果页


修改前 修改后
班级名称： {{old_name}} {{new_name}}
导师姓名： {{old_tutor}} {{new_tutor}}
修改成功！
点击返回
添加视图：
def classroonmodify(request,id1): cursor=connection.cursor() sql='select id,name,tutor from person_classroom where id='+id1 classroonlist=classroom.objects.raw(sql) old_name = classroonlist[0].name old_tutor = classroonlist[0].tutor if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: new_name = request.get['name'] new_tutor = request.get['tutor'] cursor=connection.cursor() sql='update person_classroom set name=\''+new_name+'\',tutor=\''+new_tutor+'\' where id=\''+id1+'\'' cursor.execute(sql) transaction.commit_unless_managed() cursor.close() return render_to_response('person/classroom_modify_results.html', {'old_name': old_name,'old_tutor':old_tutor,'new_name':new_name,'new_tutor':new_tutor}) else: return render_to_response('person/classroom_modify.html', {'error': true,'id':id1,'name':old_name,'tutor':old_tutor})
编辑urls.py，这里面需要注意的是正则的写法，这个之前的章节已经说过了，这里我们可以再复习一遍：
from django.conf.urls import patterns, include, url# uncomment the next two lines to enable the admin:# from django.contrib import admin# admin.autodiscover()urlpatterns = patterns('', # examples: # url(r'^$', 'bidding.views.home', name='home'), # url(r'^bidding/', include('bidding.foo.urls')), # uncomment the admin/doc line below to enable admin documentation: # url(r'^admin/doc/', include('django.contrib.admindocs.urls')), # uncomment the next line to enable the admin: # url(r'^admin/', include(admin.site.urls)), url(r'^hello/$', 'bidding.views.hello'), url(r'^time/$', 'bidding.views.current_datetime'), url(r'^time/plus/(\d{1,2})/$', 'bidding.views.hours_ahead'), url(r'^hello_base/$', 'bidding.views.hello_base'), url(r'^request_test/$', 'bidding.views.request_test'), url(r'^userssearch/$', 'bidding.users.views.search_form'), url(r'^search/$', 'bidding.users.views.search'), url(r'^classroom/add/$', 'person.views.classroonadd'), url(r'^classroom/list/$', 'person.views.classroonlist'), url(r'^classroom/modify/(\d+)/$', 'person.views.classroonmodify'),)
如同添加时候的问题，我们这里面使用的仍然是最原始的sql语句，我们同样可以给他修改成为model的方式：
def classroonmodify(request,id1): cursor=connection.cursor() classroon=classroom.objects.get(id=id1) old_name = classroon.name old_tutor = classroon.tutor cursor.close() if 'name' in request.get and request.get['name'] and 'tutor' in request.get and request.get['tutor']: new_name = request.get['name'] new_tutor = request.get['tutor'] classroon.name=new_name classroon.tutor=new_tutor classroon.save() return render_to_response('person/classroom_modify_results.html', {'old_name': old_name,'old_tutor':old_tutor,'new_name':new_name,'new_tutor':new_tutor}) else: return render_to_response('person/classroom_modify.html', {'error': true,'id':id1,'name':old_name,'tutor':old_tutor})
这样看起来是不是简便多了？我们打开 页面看看效果吧 ：
接下来我们来做删除的功能，首先修改列表页的模板，加入一列删除按钮：
数据库操作简单表的添加这里是classroom的管理页面


序号 班级名称 导师姓名 操作
{% for myclass in classroonlist%} {{ myclass.id }} {{ myclass.name }} {{ myclass.tutor }}
{% endfor %}
classroom_delete_results.html:
查询用户结果页


班级：{{name}}删除成功 ！
点击返回
修改视图：
def classroondelete(request,id1): cursor=connection.cursor() classroon=classroom.objects.get(id=id1) old_name = classroon.name classroon.delete() classroonlist=classroom.objects.all() cursor.close()return render_to_response('person/classroom_delete_results.html',{'name':old_name})
配置urls.py:
from django.conf.urls import patterns, include, url# uncomment the next two lines to enable the admin:# from django.contrib import admin# admin.autodiscover()urlpatterns = patterns('', # examples: # url(r'^$', 'bidding.views.home', name='home'), # url(r'^bidding/', include('bidding.foo.urls')), # uncomment the admin/doc line below to enable admin documentation: # url(r'^admin/doc/', include('django.contrib.admindocs.urls')), # uncomment the next line to enable the admin: # url(r'^admin/', include(admin.site.urls)), url(r'^hello/$', 'bidding.views.hello'), url(r'^time/$', 'bidding.views.current_datetime'), url(r'^time/plus/(\d{1,2})/$', 'bidding.views.hours_ahead'), url(r'^hello_base/$', 'bidding.views.hello_base'), url(r'^request_test/$', 'bidding.views.request_test'), url(r'^userssearch/$', 'bidding.users.views.search_form'), url(r'^search/$', 'bidding.users.views.search'), url(r'^classroom/add/$', 'person.views.classroonadd'), url(r'^classroom/list/$', 'person.views.classroonlist'), url(r'^classroom/modify/(\d+)/$', 'person.views.classroonmodify'), url(r'^classroom/delete/(\d+)/$', 'person.views.classroondelete'),)
到此，我们就做好了一个简单的表的添加、删除、修改的操作。