django管理系统代码优化-分组(二)
程序员文章站
2022-06-16 23:42:46
django管理系统代码优化 分组(二) 一优化的内容 优化前代码:https://www.cnblogs.com/pythonywy/p/11345626.html 路由进行主次分组( ) cookies有效时间设置为1小时,1小时后失效 界面美化 二.创建app进行分组 1.app创建: 使用p ......
django管理系统代码优化-分组(二)
后续进行代码更新,优化
一优化的内容
优化前代码:https://www.cnblogs.com/pythonywy/p/11345626.html
- 路由进行主次分组(
主要) - cookies有效时间设置为1小时,1小时后失效
- 界面美化
二.创建app进行分组
1.app创建:
- 使用pycharm创建django的时候， 加上app的名字,多个app复制改名即可
- 命令行创建:python manage.py startapp app的名字
2.创建后:
3.app介绍
二.mysql表单创建
zouye库:存信息相关的
#班级表
create table classes(
cid int primary key auto_increment,
name varchar(32) not null default ''
)engine=innodb charset=utf8;
insert into classes (name) values ('三年a班'), ('三年b班'),('三年c班');
#学生表
create table students (
sid int primary key auto_increment,
name varchar(32) not null default '',
class_id int not null default 1,
foreign key (class_id) references classes(cid)
)engine=innodb charset=utf8;
insert into students (name, class_id) values ('张三', 1),('李四', 2),('王五', 1);
#老师表
create table teacher (
tid int primary key auto_increment,
name varchar(32) not null default ''
)engine=innodb charset=utf8;
insert into teacher (name) values ('老师1'), ('老师2'),('老师3');
#关系表
create table teacher2class (
id int primary key auto_increment,
tid int not null default 1,
cid int not null default 1
)engine=innodb charset=utf8;
insert into teacher2class (tid, cid) values (1,1), (1,2),(2,1),(2,2);
userinfo库:存账号密码
create table info(id int,name char(30),password char(30)) charset utf8;
三.settings文件的设置
setting.py
"""
django settings for djang分组 project.
generated by 'django-admin startproject' using django 1.11.22.
for more information on this file, see
https://docs.djangoproject.com/en/1.11/topics/settings/
for the full list of settings and their values, see
https://docs.djangoproject.com/en/1.11/ref/settings/
"""
import os
# build paths inside the project like this: os.path.join(base_dir, ...)
base_dir = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
# quick-start development settings - unsuitable for production
# see https://docs.djangoproject.com/en/1.11/howto/deployment/checklist/
# security warning: keep the secret key used in production secret!
secret_key = '_k@kzje+27*@f2!lgi60!s264fm&a^!ev(g!!+)_eycn4pqv$5'
# security warning: don't run with debug turned on in production!
debug = true
allowed_hosts = []
# application definition
installed_apps = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'classes.apps.classesconfig',
]
middleware = [
'django.middleware.security.securitymiddleware',
'django.contrib.sessions.middleware.sessionmiddleware',
'django.middleware.common.commonmiddleware',
# 'django.middleware.csrf.csrfviewmiddleware',
'django.contrib.auth.middleware.authenticationmiddleware',
'django.contrib.messages.middleware.messagemiddleware',
'django.middleware.clickjacking.xframeoptionsmiddleware',
]
root_urlconf = 'djang分组.urls'
templates = [
{
'backend': 'django.template.backends.django.djangotemplates',
'dirs': [os.path.join(base_dir, 'templates')],
'app_dirs': true,
'options': {
'context_processors': [
'django.template.context_processors.debug',
'django.template.context_processors.request',
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages',
],
},
},
]
wsgi_application = 'djang分组.wsgi.application'
# database
# https://docs.djangoproject.com/en/1.11/ref/settings/#databases
databases = {
'default': {
'engine': 'django.db.backends.sqlite3',
'name': os.path.join(base_dir, 'db.sqlite3'),
}
}
# password validation
# https://docs.djangoproject.com/en/1.11/ref/settings/#auth-password-validators
auth_password_validators = [
{
'name': 'django.contrib.auth.password_validation.userattributesimilarityvalidator',
},
{
'name': 'django.contrib.auth.password_validation.minimumlengthvalidator',
},
{
'name': 'django.contrib.auth.password_validation.commonpasswordvalidator',
},
{
'name': 'django.contrib.auth.password_validation.numericpasswordvalidator',
},
]
# internationalization
# https://docs.djangoproject.com/en/1.11/topics/i18n/
language_code = 'en-us'
time_zone = 'utc'
use_i18n = true
use_l10n = true
use_tz = true
# static files (css, javascript, images)
# https://docs.djangoproject.com/en/1.11/howto/static-files/
static_url = '/static/'
staticfiles_dirs = (os.path.join(base_dir, 'static'),)
四.路由
主路由django分组>urls.py
import pymysql
from django.conf.urls import url,include
from django.shortcuts import render, redirect
def login(request):
if request.method == 'get':
return render(request, 'login.html')
cursor, conn = mysql_to_db('userinfo')
user_name = request.post.get('username')
user_pwd = request.post.get('pwd')
sql = 'select * from info where name=%s and password=%s'
cursor.execute(sql, (user_name, user_pwd))
a = cursor.fetchall()
if a:
obj = redirect('/classes/')
obj.set_cookie('login', 'success',max_age=1800)
return obj
else:
return render(request, 'login.html', {'msg': '登入失败'})
def mysql_to_db(db):
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
password='16745',
db=db
)
cursor = conn.cursor(pymysql.cursors.dictcursor)
return cursor, conn
def register(request):
if request.method == 'get':
return render(request, 'register.html')
cursor, conn = mysql_to_db('userinfo')
user_name = request.post.get('username')
user_pwd = request.post.get('pwd')
print(user_name, user_pwd)
sql = 'select name from info where name=%s'
x = cursor.execute(sql, (user_name))
print('231')
if not x:
sql = 'insert into info(name,password) values(%s,%s) '
cursor.execute(sql, (user_name, user_pwd))
a = cursor.fetchall()
return render(request, 'register.html', {'msg': '注册成功'})
else:
return render(request, 'register.html', {'msg': '登入失败'})
def run(request):
return render(request, 'run.html')
urlpatterns = [
# url(r'^admin/', admin.site.urls),
url(r'^login/', login),
url(r'^register/', register),
url(r'^teacher/', include('teacher.urls')),
url(r'^student/', include('student.urls')),
url(r'^classes/', include('classes.urls')),
url(r'', run),
]
分路由student>urls.py
from django.conf.urls import url
from django.contrib import admin
from student import views
urlpatterns = [
url(r'',views.student),
]
分路由teacher>urls.py
from django.conf.urls import url
from django.contrib import admin
from teacher import views
urlpatterns = [
url(r'',views.teacher),
]
分路由classes>urls.py
from django.conf.urls import url
from django.contrib import admin
from classes import views
urlpatterns = [
url(r'^add/', views.add),
url(r'^up/', views.up),
url(r'^deleter/', views.show_class),
url(r'^ajax_add/', views.ajax_add),
url(r'^ajax_deleter/', views.ajax_deleter),
url(r'^ajax_up/', views.ajax_up),
url(r'^', views.show_class),
]
五.html相关文件
1.母版
fuck.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>title</title>
<style>
a:hover {
cursor: url(https://www.cnblogs.com/images/cnblogs_com/pythonywy/1516412/o_hand.png), auto;
}
a:active {
cursor: url(https://www.cnblogs.com/images/cnblogs_com/pythonywy/1516412/o_appstarting.png), auto;
}
a:focus {
cursor: url(https://www.cnblogs.com/images/cnblogs_com/pythonywy/1516412/o_wait.png), auto;
}
p, code {
cursor: url(https://www.cnblogs.com/images/cnblogs_com/pythonywy/1516412/o_ibeam.png), auto;
}
* {
cursor: url(https://www.cnblogs.com/images/cnblogs_com/pythonywy/1516412/o_arrow.png), auto;
}
* {
margin: 0;
padding: 0;
}
.top {
position: absolute;
width: 100%;
height: 100px;
background: coral;
background-size: 100% 100%;
}
.nav {
position: absolute;
left: 0;
top: 100px;
width: 200px;
bottom: 0;
background: chartreuse;
text-align: center;
overflow: auto;
line-height: 30px;
}
a.class-action, a.student-action, .teacher-action {
color: white;
background: #80ff5d;
padding: 10px;
margin: 2px;
display: block;
}
.data {
position: absolute;
left: 200px;
top: 100px;
bottom: 0;
right: 0;
background: url('https://images.cnblogs.com/cnblogs_com/pythonywy/1455150/o_111.png');
background-size: 100% 100%;
overflow: scroll;
}
.top-left {
float: left;
width: 200px;
background: aqua;
height: 100px;
text-align: center;
line-height: 100px;
border-right: 2px solid white;
}
.top-right {
float: right;
text-align: center;
line-height: 100px;
margin-right: 50px;
}
</style>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"
integrity="sha384-bvyiisifek1dgmjrakycuhahrg32omucww7on3rydg4va+pmstsz/k68vbdejh4u" crossorigin="anonymous">
<style>
{% block css%}
{% endblock %}
th, td {
padding: 10px;
}
</style>
</head>
<body>
<div class="top">
<div class="top-left">管理系统</div>
<div class="top-right">
<a href="\login\">登入</a>
<a href="\register\">注册</a>
</div>
</div>
<div class="nav">
<ol>
<li><a class="class-action" href="\classes\">班级系统</a></li>
<li><a class="student-action" href="\student\">学生系统</a></li>
<li><a class="teacher-action" href="\teacher\">老师系统</a></li>
</ol>
</div>
<div class="data">
{% block data %}
{% endblock %}
</div>
</body>
{% block js %}
{% endblock %}
</html>
2.登入
login.html
{% extends 'fuck.html' %}
{% block data %}
<form action="/login/" method="post" style="position: absolute;top: 20%;left: 40%">
账号: <input type="text" name="username"><br>
密码: <input type="password" name="pwd"><br>
<input type="submit" value="提交">
</form>
<a href="http://127.0.0.1:8000/register/">去注册</a>
<div style="color: red;font-size: 30px ;text-align: center">{{ msg }}</div>
{% endblock %}
3.注册
register.html
{% extends 'fuck.html' %}
{% block data %}
<form action="/register/" method="post">
注册账号: <input type="text" name="username"><br>
注册密码: <input type="password" name="pwd"><br>
<input type="submit" value="提交">
</form>
<a href="http://127.0.0.1:8000/login/">去登入</a>
<div>{{msg}}</div>
{% endblock %}
4.学生相关
show_student.html
{% extends 'fuck.html' %}
{% block data %}
<form action="/login/" method="post" style="position: absolute;top: 20%;left: 40%">
注册账号: <input type="text" name="username"><br>
注册密码: <input type="password" name="pwd"><br>
<input type="submit" value="提交">
</form>
<a href="http://127.0.0.1:8000/login/">去登入</a>
<div style="color: red;font-size: 30px ;text-align: center">{{msg}}</div>
{% endblock %}
5.老师相关
show_teacher.html
{% extends 'fuck.html' %}
{% block data %}
<table border="2px" class="table table-bordered">
<thead>
<tr>
<th>id</th>
<th>老师名称</th>
<th>班级</th>
</tr>
</thead>
<tbody>
{% for item in info %}
<tr>
<td>{{ item.tid }}</td>
<td>{{ item.name }}</td>
<td>{{ item.cname }}</td>
</tr>
{% endfor %}
</tbody>
</table>
<div>{{ msg }}</div>
<form class="action" method="post">
<input type="text" name="action" value="add" style="display: none">
已有老师教添加班级<select name="tid" id="">
{% for foo in teacher_info %}
<option value="{{ foo.tid }}">{{ foo.name }}</option>
{% endfor %}
</select>
<select name="cid" id="">
{% for class in class_info %}
<option value="{{ class.cid }}">{{ class.name }}</option>
{% endfor %}
</select>
<input type="submit">
</form>
<form class="action" method="post">
<input type="text" name="action" value="delete" style="display: none">
已有老师教删除班级<select name="tid" id="">
{% for foo in teacher_info %}
<option value="{{ foo.tid }}">{{ foo.name }}</option>
{% endfor %}
</select>
</select>
<select name="cid" id="">
{% for class in class_info %}
<option value="{{ class.cid }}">{{ class.name }}</option>
{% endfor %}
</select>
<input type="submit">
</form>
<span style="color: red"> {{ delete_msg }} </span>
{% endblock %}
{% block js %}
<script
src="http://code.jquery.com/jquery-1.12.4.min.js"
integrity="sha256-zosebrlbnqzlpnkikedrpv7loy9c27hhq+xp8a4mxaq="
crossorigin="anonymous"></script>
<script>
$('.add-button').click(function () {
$('#add-back,#add-window').css('display', 'block');
});
$('.add-window-button').click(function () {
$('#add-back,#add-window').css('display', 'none');
});
$('.add-submit').click(function () {
var name = $('.add-text').val();
$.ajax({
type: "post",
url: "/ajax_add/",
data: {'classname': name},
success: function (msg) {
if (msg == 'ok') {
alert('添加成功');
window.location.href = '/class/';
} else {
alert('输入内容不能为空');
{#window.location.replace(location.href);#}
}
}
});
});
$('.up-button').click(function () {
$('#up-back,#up-window').css('display', 'block');
window.upid = $(this).attr('cid');
$('.up-text').val($(this).attr('classname'));
console.log(upid);
});
$('.up-window-button').click(function () {
$('#up-back,#up-window').css('display', 'none');
});
$('.up-submit').click(function () {
var name = $('.up-text').val();
console.log(name);
console.log(upid);
$.ajax({
type: "post",
url: "/ajax_up/",
data: {'id': upid, 'name': name},
success: function (msg) {
if (msg == 'ok') {
alert('更新成功');
window.location.href = '/class/';
} else {
alert('输入内容不能为空');
}
}
});
});
$('.deleter-button').click(function () {
var chiose = confirm('是否删除');
var deleter_id = $(this).attr('cid');
if (chiose) {
$.ajax({
type: "post",
url: "/ajax_deleter/",
data: {'id': deleter_id},
success: function (msg) {
if (msg == 'ok') {
alert('删除成功');
window.location.href = '/class/';
} else {
alert('内容有关联无法删除');
}
}
});
}
});
$('.deleter-a').click(function () {
var chiose = confirm('是否删除');
return chiose
})
</script>
{% endblock %}
6.班级相关
show_class.html
{% extends 'fuck.html' %}
{% block css %}
table{
position: absolute;
top: 0;
left: 0;
color: #000000;
width: 100%;
}
#up-back, #add-back {
position: fixed;
top: 0;
left: 0;
right: 0;
bottom: 0;
background: rgba(0, 0, 0, 0.5);
display: none;
}
#up-window, #add-window {
position: fixed;
top: 20%;
left: 37%;
width: 400px;
height: 200px;
background-color: beige;
text-align: center;
display: none;
}
{% endblock %}}
{% block data %}
<table border="2px" class="table-hover">
<thead>
<tr>
<th>id</th>
<th>班级名称</th>
<th colspan="3">功能</th>
<th colspan="3">ajax功能</th>
</tr>
</thead>
<tbody>
{% for item in dict_list %}
<tr>
<td>{{ item.cid }}</td>
<td>{{ item.name }}</td>
<td><a class='deleter-a glyphicon glyphicon-trash' href="/classes/?id={{ item.cid }}"></a></td>
<td><a href="/classes/up/?id={{ item.cid }}&name={{ item.name }}">更新</a></td>
<td><a href="/classes/add/">添加</a></td>
<td>
<button class='deleter-button glyphicon glyphicon-trash'
cid={{ item.cid }} classname={{ item.name }}></button>
</td>
<td>
<button class='up-button' cid={{ item.cid }} classname={{ item.name }}>更新</button>
</td>
<td>
<button class='add-button' cid={{ item.cid }} classname={{ item.name }}>添加</button>
</td>
</tr>
{% endfor %}
</tbody>
</table>
<div>{{ msg }}</div>
<div id="up-back"></div>
<div id="up-window">
<input type="text" name="id" style="visibility: hidden"><br>
修改名称:<input type="text" class='up-text' name="'classname">
<input class='up-submit' type="button" value="提交">
<button class="up-window-button">取消</button>
</div>
<div id="add-back"></div>
<div id="add-window">
<input type="text" name="id" style="visibility: hidden"><br>
添加名称:<input type="text" class='add-text' name="'classname">
{# <button class="add-submit">提交</button>#}
<input class='add-submit' type="button" value="提交">
<button class="add-window-button">取消</button>
</div>
{% endblock %}
{% block js %}
<script
src="http://code.jquery.com/jquery-1.12.4.min.js"
integrity="sha256-zosebrlbnqzlpnkikedrpv7loy9c27hhq+xp8a4mxaq="
crossorigin="anonymous"></script>
<script>
$('.add-button').click(function () {
$('#add-back,#add-window').css('display', 'block');
});
$('.add-window-button').click(function () {
$('#add-back,#add-window').css('display', 'none');
});
$('.add-submit').click(function () {
var name = $('.add-text').val();
$.ajax({
type: "post",
url: "/classes/ajax_add/",
data: {'classname': name},
success: function (msg) {
if (msg == 'ok') {
alert('添加成功');
window.location.href = '/classes/';
} else {
alert('输入内容不能为空');
{#window.location.replace(location.href);#}
}
}
});
});
$('.up-button').click(function () {
$('#up-back,#up-window').css('display', 'block');
window.upid = $(this).attr('cid');
$('.up-text').val($(this).attr('classname'));
console.log(upid);
});
$('.up-window-button').click(function () {
$('#up-back,#up-window').css('display', 'none');
});
$('.up-submit').click(function () {
var name = $('.up-text').val();
console.log(name);
console.log(upid);
$.ajax({
type: "post",
url: "/classes/ajax_up/",
data: {'id': upid, 'name': name},
success: function (msg) {
if (msg == 'ok') {
alert('更新成功');
window.location.href = '/classes/';
} else {
alert('输入内容不能为空');
}
}
});
});
$('.deleter-button').click(function () {
var chiose = confirm('是否删除');
var deleter_id = $(this).attr('cid');
if (chiose) {
$.ajax({
type: "post",
url: "/classes/ajax_deleter/",
data: {'id': deleter_id},
success: function (msg) {
if (msg == 'ok') {
alert('删除成功');
window.location.href = '/classes/';
} else {
alert('内容有关联无法删除');
}
}
});
}
});
$('.deleter-a').click(function () {
var chiose = confirm('是否删除');
return chiose
})
</script>
{% endblock %}
add.html
{% extends 'fuck.html' %}
{% block data %}
<form action="" method="post">
添加班级名称:<input type="text" name="classname">
<input type="submit" value="提交">
<div>{{ msg }}</div>
</form>
{% endblock %}
up.html
{% extends 'fuck.html' %}
{% block data %}
<form action="" method="post">
跟换班级名称:<input type="text" name="classname" placeholder="{{test}}">
<input type="submit" value="提交">
<div>{{msg}}</div>
</form>
{% endblock %}
7.首页
run.html
{% extends 'fuck.html' %}
{% block data %}
<div style="color: red;font-size: 40px;text-align: center;">欢迎来到管理系统</div>
{% endblock %}
六.视图
学生端
student>view.py
import pymysql
from django.shortcuts import render, redirect
# create your views here.
def login_deco(func):
def wrapper(request):
print(request.cookies)
if request.cookies:
res = func(request)
return res
else:
return render(request, 'login.html', {'msg': '登入失效请重新登入'})
return wrapper
def mysql_to_db(db):
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
password='16745',
db=db
)
cursor = conn.cursor(pymysql.cursors.dictcursor)
return cursor, conn
@login_deco
def student(request):
cursor, conn = mysql_to_db('zuoye')
if request.method == 'get':
sql_1 = 'select sid,students.name as sname,cid,classes.name as cname from students,classes where class_id=cid'
sql_2 = 'select * from classes'
cursor.execute(sql_1)
student_info = cursor.fetchall()
cursor.execute(sql_2)
class_info = cursor.fetchall()
return render(request, 'show_student.html', {'student': student_info, 'class': class_info})
else:
if request.post.get('action') == 'add':
sql_1 = 'select sid,students.name as sname,cid,classes.name as cname from students,classes where class_id=cid'
sql_2 = 'select * from classes'
cursor.execute(sql_1)
student_info = cursor.fetchall()
cursor.execute(sql_2)
class_info = cursor.fetchall()
print(request.post)
name = request.post.get('name')
id = request.post.get('id')
print(name, id)
if name:
sql = 'insert into students(name,class_id) values(%s,%s)'
cursor.execute(sql, (name, id))
conn.commit()
return redirect('/student/')
else:
return render(request, 'show_student.html',
{'student': student_info, 'class': class_info, 'addmsg': '名字不能为空'})
elif request.post.get('action') == 'up':
print(request.post)
sql_1 = 'select sid,students.name as sname,cid,classes.name as cname from students,classes where class_id=cid'
sql_2 = 'select * from classes'
cursor.execute(sql_1)
student_info = cursor.fetchall()
cursor.execute(sql_2)
class_info = cursor.fetchall()
print(request.post)
name = request.post.get('sname')
sid = request.post.get('sid')
cid = request.post.get('cid')
print(name, sid, cid)
if name:
sql = 'update students set name=%s,class_id=%s where sid=%s'
cursor.execute(sql, (name, cid, sid))
conn.commit()
return redirect('/student/')
else:
return render(request, 'show_student.html',
{'student': student_info, 'class': class_info, 'upmsg': '名字不能为空'})
老师端
teacher>view.py
import pymysql
from django.shortcuts import render, redirect
# create your views here.
def login_deco(func):
def wrapper(request):
print(request.cookies)
if request.cookies:
res = func(request)
return res
else:
return render(request, 'login.html', {'msg': '登入失效请重新登入'})
return wrapper
def mysql_to_db(db):
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
password='16745',
db=db
)
cursor = conn.cursor(pymysql.cursors.dictcursor)
return cursor, conn
@login_deco
def teacher(request):
cursor, conn = mysql_to_db('zuoye')
if request.method == 'get':
sql = 'select teacher.tid,teacher.name,group_concat(classes.name) as cname from teacher left join teacher2class on teacher.tid=teacher2class.tid left join classes on classes.cid=teacher2class.cid group by teacher.tid'
cursor.execute(sql)
info = cursor.fetchall()
sq1_teacher = 'select * from teacher'
cursor.execute(sq1_teacher)
teacher_info = cursor.fetchall()
sq1_teacher = 'select * from classes'
cursor.execute(sq1_teacher)
class_info = cursor.fetchall()
print(info)
print(teacher_info)
print(class_info)
obj = render(request, 'show_teacher.html',
{'info': info, 'class_info': class_info, 'teacher_info': teacher_info})
return obj
else:
if request.post.get('action') == 'add':
tid = request.post.get('tid')
cid = request.post.get('cid')
sql = 'insert into teacher2class(cid,tid) values(%s,%s)'
cursor.execute(sql, (cid, tid))
conn.commit()
obj = redirect('/teacher/')
return obj
if request.post.get('action') == 'delete':
tid = request.post.get('tid')
cid = request.post.get('cid')
sql = 'delete from teacher2class where cid=%s and tid=%s'
a = cursor.execute(sql, (cid, tid))
conn.commit()
if a:
obj = redirect('/teacher/')
return obj
else:
sql = 'select teacher.tid,teacher.name,group_concat(classes.name) as cname from teacher left join teacher2class on teacher.tid=teacher2class.tid left join classes on classes.cid=teacher2class.cid group by teacher.tid'
cursor.execute(sql)
info = cursor.fetchall()
sq1_teacher = 'select * from teacher'
cursor.execute(sq1_teacher)
teacher_info = cursor.fetchall()
sq1_teacher = 'select * from classes'
cursor.execute(sq1_teacher)
class_info = cursor.fetchall()
obj = render(request, 'show_teacher.html',
{'info': info, 'class_info': class_info, 'teacher_info': teacher_info,
'delete_msg': '该老师没有教这个班级'})
return obj
班级端
import pymysql
from django.shortcuts import httpresponse, render, redirect
# create your views here.
def login_deco(func):
def wrapper(request):
print(request.cookies)
if request.cookies:
res = func(request)
return res
else:
return render(request, 'login.html', {'msg': '登入失效请重新登入'})
return wrapper
def mysql_to_db(db):
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
password='16745',
db=db
)
cursor = conn.cursor(pymysql.cursors.dictcursor)
return cursor, conn
@login_deco
def show_class(request):
if request.method == 'get':
cursor, conn = mysql_to_db('zuoye')
if not request.get:
sql = 'select * from classes'
cursor.execute(sql)
info = cursor.fetchall()
print(info)
return render(request, 'show_class.html', {'dict_list': info})
else:
deleter_id = request.get.get('id')
sql = 'delete from classes where cid=%s '
try:
a = cursor.execute(sql, (deleter_id,))
conn.commit()
obj = redirect('/classes/')
return obj
except:
sql = 'select * from classes'
cursor.execute(sql)
info = cursor.fetchall()
obj = render(request, 'show_class.html', {'dict_list': info, 'msg': '内容有关联无法删除 '})
return obj
def add(request):
if request.method == 'get':
return render(request, 'add.html')
else:
if not request.post.get('classname'):
return render(request, 'add.html', {'msg': '输入内容不能为空'})
else:
classname = request.post.get('classname')
print(classname)
cursor, conn = mysql_to_db('zuoye')
sql = 'insert into classes(name) values(%s)'
cursor.execute(sql, (classname,))
conn.commit()
return redirect('/classes/')
def up(request):
id = request.get.get('id')
name = request.get.get('name')
print(id)
print(name)
if request.method == 'get':
return render(request, 'add.html', {'name': name})
else:
if not request.post.get('classname'):
return render(request, 'add.html', {'msg': '输入内容不能为空'})
else:
classname = request.post.get('classname')
print(classname)
cursor, conn = mysql_to_db('zuoye')
sql = 'update classes set name=%s where cid = %s'
cursor.execute(sql, (classname, id))
conn.commit()
return redirect('/classes/')
def ajax_add(request):
class_name = request.post.get('classname')
if class_name:
cursor, conn = mysql_to_db('zuoye')
sql = 'insert into classes(name) values(%s)'
cursor.execute(sql, (class_name,))
conn.commit()
return httpresponse('ok')
else:
return httpresponse('不能为空')
def ajax_up(request):
print(request.post)
class_name = request.post.get('name')
id = request.post.get('id')
# print(class_name,id)
if class_name:
cursor, conn = mysql_to_db('zuoye')
sql = 'update classes set name=%s where cid = %s'
cursor.execute(sql, (class_name, id))
conn.commit()
return httpresponse('ok')
else:
return httpresponse('不能为空')
def ajax_deleter(request):
id = request.post.get('id')
try:
cursor, conn = mysql_to_db('zuoye')
sql = 'delete from classes where cid=%s '
cursor.execute(sql, (id,))
conn.commit()
return httpresponse('ok')
except:
return httpresponse('11')