#add.py#
from django.shortcuts import render_to_response
from django.db import connection, transaction
def adds (request):
http_name=request.GET['fname']
cursor=connection.cursor()
sql="INSERT INTO Tab_type(F_Name)VALUES('"
sql+=http_name
sql+="')"
cursor.execute(sql)
cursor.execute('commit')
cursor.execute('SELECT F_Name FROM tab_type ORDER BY F_Id DESC limit 1')
cursor.close()
return render_to_response('testmysql\\addok.html',{'s':http_name,'d':sql})
#表单 form#
<body>
<p><ul><li>{{type_list}} </li>
</p>
<p>
<form action="../add" method="get">
type name: <input type="text" name="fname" id="fname" />
<input type="submit" value="Submit" />
</form></p>
</body>