終端中cd到當(dāng)前文件路徑下，輸入python3 manage.py startapp app01
項(xiàng)目目錄結(jié)構(gòu)
手動(dòng)再數(shù)據(jù)庫(kù)中添加一條班級(jí)數(shù)據(jù)
Navicat Premium 手動(dòng)添加一條班級(jí)數(shù)據(jù)
班級(jí)列表
編寫(xiě)urls.py文件，
urlpatterns = [
# 班級(jí)
path('class/',views.classes),
]
在app01文件夾下views.py 添加對(duì)應(yīng)的班級(jí)列表函數(shù)
# 班級(jí)列表
import SQLHelper
def classes(request):
obj = SQLHelper()
class_list = obj.get_list("select id,name from class")
obj.close()
return render(request, 'classes.html', {"class_list": class_list})
創(chuàng)建班級(jí)列表頁(yè)面classes.html
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<title>班級(jí)列表</title>
</head>
<body style="margin: 30px">
<div>
<h3>班級(jí)列表</h3>
<a href="/addclass" >添加班級(jí)</a>
<table class="table">
<thead>
<tr>
<td>ID</td>
<td>班級(jí)名稱</td>
<td>操作</td>
</tr>
</thead>
<tbody>
<!-- class_list 就是views.py中的 classes 函數(shù)中的class_list -->
<!-- 模板語(yǔ)言for循環(huán) -->
{% for class in class_list %}
<tr>
<td>{{ class.id }}</td>
<td>{{ class.name }}</td>
<td>
<a href="\edit_class\?id={{ class.id }}" class="btn btn-info">編輯</a>
<a href="\delete_class\?id={{ class.id }}" class="btn btn-danger">刪除</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</body>
</html>
班級(jí)列表(丑)
添加班級(jí)
編寫(xiě)urls.py文件，
urlpatterns = [
path('class/',views.classes), # 班級(jí)列表
path('addclass/',views.add_class), #添加班級(jí)
]
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<title>add_class</title>
</head>
<body>
<h1>添加班級(jí)</h1>
<!-- Form表單post方式提交數(shù)據(jù)到 addclass -->
<form action="/addclass/" method="post">
<p>班級(jí)名稱：<input type="text" name="name"></p>
<!-- msg 錯(cuò)誤提示信息-->
<p>{{ msg }}</p>
<input type="submit" value="提交">
</form>
</body>
</html>
views.py 內(nèi)編寫(xiě)添加班級(jí)函數(shù)
# 添加班級(jí)
def add_class(request):
if request.method == 'GET':
#返回渲染添加班級(jí)頁(yè)面
return render(request, 'addclass.html')
else:
# 接收點(diǎn)擊提交按鈕的數(shù)據(jù)
v = request.POST.get('name')
if len(v) > 0:
obj = SQLHelper()
obj.modify("insert into class(name) values(%s)", [v, ])
obj.close()
return redirect('/class/')
else:
return render(request, 'addclass.html', {"msg": "班級(jí)名稱不能為空"})
添加班級(jí)
編輯班級(jí)
views.py中編寫(xiě)編輯班級(jí)函數(shù)。
urlpatterns = [
path('class/',views.classes),#班級(jí)列表
path('addclass/',views.add_class),#添加班級(jí)
path('edit_class/', views.edit_class),#編輯班級(jí)
]
edit_class.html 編輯班級(jí)頁(yè)面
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="UTF-8">
<title>編輯班級(jí)</title>
</head>
<body>
<h1>編輯班級(jí)</h1>
<div>
<p>原名：{{ result.name }}</p>
</div>
<!-- editClass函數(shù)需要用get方式接收參數(shù) -->
<form action="/edit_class/?id={{ result.id }}" method="post">
<!-- editClass函數(shù)需要用post方式接收參數(shù) -->
<!-- <input style="display: none" name="id" value="{{ result.id }}">#} -->
<p>改為：<input type="text" name="name"></p>
<input type="submit" value="提交">
</form>
</body>
</html>
views.py 中添加編輯班級(jí)的函數(shù)
# 編輯班級(jí)
def edit_class(request):
if request.method == "GET":
# 從classes.html中的編輯a標(biāo)簽獲取到的數(shù)據(jù)
id = request.GET.get("id")
obj = SQLHelper()
result = obj.get_one("select id,name from class where id = %s", id)
obj.close()
return render(request, 'edit_class.html', {"result": result})
else:
id = request.GET.get("id")
# id = request.POST.get("id")
name = request.POST.get("name")
obj = SQLHelper()
obj.modify("update class set name = %s where id = %s", [name, id, ])
obj.close()
return redirect("/class/")
編輯班級(jí)
查看到編輯和刪除對(duì)應(yīng)的id的值。
鼠標(biāo)右鍵 - 檢查 ==> 班級(jí)列表
刪除班級(jí)
刪除班級(jí)不需要專門的刪除頁(yè)面。暫時(shí)就點(diǎn)擊刪除按鈕，直接刪除掉。
urls.py中編寫(xiě)刪除班級(jí)函數(shù)。
urlpatterns = [
path('class/',views.classes),#班級(jí)列表
path('addclass/',views.add_class),#添加班級(jí)
path('edit_class/', views.edit_class),#編輯班級(jí)
path('delete_class/',views.delete_class),#刪除班級(jí)
]
views.py編輯刪除函數(shù)
# 刪除班級(jí)
def delete_class(request):
id = request.GET.get('id')
obj = SQLHelper()
obj.modify("delete from class where id=%s", id)
obj.close()
return redirect('/class/')
學(xué)生和老師的HTML代碼和班級(jí)的類似。直接貼其余全部代碼。
urls.py
urlpatterns = [
path('class/',views.classes),#班級(jí)列表
path('addclass/',views.add_class),#添加班級(jí)
path('edit_class/', views.edit_class),#編輯班級(jí)
path('delete_class/',views.delete_class),#刪除班級(jí)
# 學(xué)生
path('students/',views.students),
path('addStudent/',views.addStudent),
path('editStudent/',views.edit_student),
path('delete_student/',views.deleteStudent),
# 老師
path('tearchers/',views.tearchers),
path('addtearcher/',views.addtearchers),
path('editTearcher/',views.editTearcher),
path('deleteTearcher/',views.deleteTearcher),
]
views.py
# 學(xué)生列表
def students(request):
obj = SQLHelper()
student_list = obj.get_list("select student.id,student.sname,class.name,student.cid from student left join class on student.cid = class.id",
[])
class_list = obj.get_list('select id,name from class', [])
obj.close()
return render(request, "students.html", {"student_list": student_list, 'class_list': class_list})
# 添加學(xué)生
def addStudent(request):
if request.method == "GET":
obj = SQLHelper()
classes = obj.get_list("select id,name from class")
obj.close()
return render(request, "addStudent.html", {'classes': classes})
else:
class_id = request.POST.get("class_id")
sname = request.POST.get("sname")
obj = SQLHelper()
obj.modify("insert into student( sname, cid) value (%s,%s)", [sname, class_id])
obj.close()
return redirect("/students/")
# 刪除學(xué)生
def deleteStudent(request):
id = request.GET.get("id")
obj = SQLHelper()
obj.modify("delete from student where id = %s", id)
obj.close()
return redirect("/students/")
# 編輯學(xué)生
def edit_student(request):
if request.method == "GET":
id = request.GET.get("id")
obj = SQLHelper()
class_list = obj.get_list("select id,name from class", [])
student = obj.get_one(
"select student.id,student.sname,student.cid,class.name from student left join class on student.cid = class.id where student.id = %s",
id)
obj.close()
return render(request, "edit_student.html", {"student": student, "class_list": class_list})
else:
id = request.POST.get("id")
sname = request.POST.get("sname")
cid = request.POST.get("class_id")
obj = SQLHelper()
obj.modify("update student set sname = %s,cid = %s where id = %s", [sname, cid, id, ])
obj.close()
return redirect("/students/")
###老師列表
def tearchers(request):
obj = SQLHelper()
tearcher_list = obj.get_list('''
SELECT tearcher.tid,tearcher.tname,tearch2class.cid,class.name from tearcher
LEFT JOIN tearch2class on tearcher.tid = tearch2class.tid
LEFT JOIN class ON class.id = tearch2class.cid;
''', [])
result = {}
for tearcher in tearcher_list:
tid = tearcher['tid']
if tid in result:
result[tid]['classes'].append({'cid':tearcher['cid'],'name':tearcher['name']})
else:
result[tid] = {
'tid':tearcher['tid'],
'tname':tearcher['tname'],
'classes':[{'cid':tearcher['cid'],'name':tearcher['name']}],
}
class_list = obj.get_list('select * from class')
obj.close()
return render(request, 'tearchers.html', {'result': result.values(),"class_list":class_list})
# 添加老師
def addtearchers(request):
if request.method == 'GET':
obj = SQLHelper()
class_list = obj.get_list('select * from class')
obj.close()
return render(request,'addTearcher.html',{"class_list":class_list})
else:
tname = request.POST.get('tname')
clds = request.POST.getlist('class_ids')
obj = SQLHelper()
#老師表中添加數(shù)據(jù) #獲取老師id
tearcher_id = obj.create('insert into tearcher(tname) values (%s)', [tname])
#老師班級(jí)表中插入數(shù)據(jù)
sql_args = []
for cid in clds:
temp = (tearcher_id,cid)
sql_args.append(temp)
obj.multiple_modify('insert into tearch2class(tid, cid) values (%s,%s)', sql_args)
obj.close()
return redirect('/tearchers/')
# 編輯老師
def editTearcher(request):
if request.method == 'GET':
tid = request.GET.get('tid')
obj = SQLHelper()
tearcher_info = obj.get_one('select tid,tname from tearcher where tid = %s',[tid])
tearcher_class_list = obj.get_list('select cid from tearch2class where tearch2class.tid = %s',[tid,])
class_list = obj.get_list('select id,name from class')
obj.close()
temp = []
for i in tearcher_class_list:
temp.append(i['cid'])
return render(request,'edit_tearcher.html',{
'info':tearcher_info,
'tearcher_class_list':temp,
'class_list':class_list
})
else:
tid = request.GET.get('tid')
class_ids = request.POST.getlist('class_ids')
tname = request.POST.get('tname')
#更新老師表
obj = SQLHelper()
obj.modify('update tearcher set tname=%s where tid = %s',[tname,tid])
#更細(xì)老師班級(jí)關(guān)系表
# 方案一：先刪除老師和班級(jí)的對(duì)應(yīng)關(guān)系刪除，之后再做添加
obj.modify('delete from tearch2class where tid = %s',[tid])
sql_args = []
for cid in class_ids:
temp = (tid, cid)
sql_args.append(temp)
obj.multiple_modify('insert into tearch2class(tid, cid) values (%s,%s)', sql_args)
obj.close()
# 方案二：把新的班級(jí)數(shù)據(jù)和老的數(shù)據(jù)做對(duì)比進(jìn)行刪除和增加
return redirect('/tearchers/')
# 刪除老師
def deleteTearcher(request):
tid = request.GET.get('tid')
obj = SQLHelper()
obj.modify('delete from tearcher where tid = %s', tid)
obj.modify('delete from tearch2class where tid = %s', tid)
obj.close()
return redirect('/tearchers/')
