人工智能-项目实践-信息管理系统-django实现学生信息管理系统

import pymysql from django.shortcuts import render, redirect, HttpResponse from utils import sqlhelper import json from django.core.paginator import Paginator, PageNotAnInteger, EmptyPage # Create your views here. def login(request): ''' 用户登录 :param request: :return: ''' username = request.POST.get('username') pwd = request.POST.get('pwd') if request.method == 'POST': if username == 'thanlon' and pwd == '123456': obj = redirect('/user/class/') obj.set_signed_cookie('ticket', 'thanlon', salt='123456') return obj else: return render(request, 'login.html') def classes(request): """ 查询班级信息 :param request: :return: """ ticket = request.get_signed_cookie('ticket', salt='123456') if not ticket: return redirect('/login/') conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) cursor.execute("select id,title from class") class_list = cursor.fetchall() # print(class_list) # [{'id': 1, 'title': '软件工程'}, {'id': 3, 'title': '网络工程'}, {'id': 4, 'title': '计算机科学与技术'}] cursor.close() conn.close() return render(request, 'class.html', {'class_list': class_list}) def add_class(request): """ 添加班级信息 :param request: :return: """ # 如果是get请求就返回add_class.html模板就可以 if request.method == 'GET': return render(request, 'add_class.html') # 如果是post请求则执行下面的代码 else: # 获取班级的标题 class_title = request.POST.get('class_title') print(class_title) # 创建数据库连接对象 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 将班级的名称传到sql语句中 cursor.execute('insert into class(title) values(%s)', class_title) # cursor.execute("insert into class(title) values(%s)", [class_title, ]) # 提交(查询不需要，其它如添加、修改、更新数据是需要执行commit方法才能将数据插入成功) conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close() # 添加之后就会重定向到/classes/路由，会显示添加后的班级 return redirect('/user/class/') def edit_class(request): """ 编辑班级信息 :param request: :return: """ # 如果是get请求，这里额外也需要查询下数据库，把原来的信息也展示出来 if request.method == 'GET': # 获取客户端传过来的班级id nid = request.GET.get('nid') # 创建数据库连接 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 执行游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 执行sql语句 cursor.execute('select id,title from class where id=%s', nid) # 获取查询到的所有数据 result = cursor.fetchone() # print(result) # {'id': 1, 'title': '软件工程'} # 创建游标 cursor.close() # 关闭连接 conn.close() # 返回模板和数据 return render(request, 'edit_class.html', {'result': result}) # post请求用来修改班级信息 else: # nid = request.POST.get('nid') # 放到请求体 nid = request.GET.get('nid') # 放到请求头 title = request.POST.get('title') # 创建数据库连接 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 执行sql语句 cursor.execute('update class set title=%s where id = %s', [title, nid]) # 提交事务 conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close() return redirect('/user/class/') def del_class(request): # 获取客户端传过来的nid，我们要个根据nid来删除数据 nid = request.GET.get('nid') # 创建连接对象 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 执行sql语句 cursor.execute('delete from class where id=%s', nid) # 提交事务 conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close() return redirect('/user/class/') def student(request): ''' 学生信息列表 :param request:封装了请求相关的所有信息 :return:返回模板和数据 ''' # 创建连接对象 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 查询学生信息列表 cursor.execute( 'select student.id,student.name,class_id,class.title from student left join class on student.class_id=class.id') # 获取查询到的所有数据 student_list = cursor.fetchall() paginator = Paginator(student_list, 1) current_page = request.GET.get('page') try: posts = paginator.page(current_page) except PageNotAnInteger as e: posts = paginator.page(1) except EmptyPage as e: posts = paginator.page(1) # 查询班级信息 cursor.execute('select id,title from class') # 获取查询到的所有班级列表 class_list = cursor.fetchall() # 关闭游标 cursor.close() # 关闭连接 conn.close() # 返回模板和数据 return render(request, 'student.html', {'student_list': student_list, 'class_list': class_list, 'posts': posts}) def add_student(request): """ 添加学生信息 :param request: :return: """ # 如果是get请求 if request.method == 'GET': # 创建连接对象 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 执行查询的sql语句 cursor.execute("select id,title from class") # 获取查询到的所有数据 classe_list = cursor.fetchall() # 关闭游标 cursor.close() # 关闭连接 conn.close() # 返回模板和数据 return render(request, 'add_student.html', {'class_list': classe_list}) # 如果是post请求 else: # 获取学生的名字 name = request.POST.get('name') # 获取学生的班级id class_id = request.POST.get('class_id') # 创建连接 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) # 将学生的名字和班级的id信息放到sql中 cursor.execute("insert into student(name,class_id) values (%s,%s)", [name, class_id, ]) # 执行事务 conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close() # 返回模板 return redirect('/user/student/') def edit_student(request): """ 编辑学生信息 :param request: :return: """ # get请求时 if request.method == 'GET': # 获取传过来的学生id nid = request.GET.get('nid') # 创建连接对象 conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='test') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.Dict