def student_register():
if request.method == "GET":
return render_template('StudentRegister.html')
elif request.method == "POST":
username = request.form.get("username")
password = request.form.get("password")
phone = request.form.get("phone")
# hash_pwd = generate_password_hash(password)
code = request.form.get("code")
cache_code = cache.get(username)
if code != cache_code:
return "验证失败"
student = Student()
student.s_name = username
student.s_password = password
student.s_phone = phone
db.session.add(student)
db.session.commit()
return 'Register Success'
def student_register():
if request.method == 'GET':
return render_template('StudentRegister.html')
elif request.method == "POST":
username = request.form.get('username')
password = request.form.get('password')
phone = request.form.get('phone')
# hash_psd = generate_password_hash(password)
# hash_psd = password
code = request.form.get('code')
cache_code = cache.get(username)
print("验证码", code,cache_code)
if code != cache_code:
return '验证失败'
student = Student()
student.s_name = username
student.s_password = password # model 里面已经做了处理了
student.s_phone = phone
db.session.add(student)
db.session.commit()
return '注册成功'
def add_student():
student = Student()
student.name = '测试'
student.age = random.randrange(100)
db.session.add(student)
db.session.commit()
return '学生创建成功'
def addStudent():
s = Student()
s.name = 'zs'
s.age = 18
db.session.add(s)
db.session.commit()
return '添加成功'
def add_students():
# s1 = Student()
# s1.s_name = "好好听课"
#
# s2 = Student()
# s2.s_name = "好好学习"
#
# s3 = Student()
# s3.s_name = "好好休息"
#
# db.session.add(s1)
# db.session.add(s2)
# db.session.add(s3)
#
# db.session.commit()
students = []
for i in range(10):
student = Student()
student.s_name = "爱学习的小明%d" % random.randrange(100)
students.append(student)
db.session.add_all(students)
db.session.commit()
return 'Add Success'
def add_student():
student = Student()
student.s_name = '洪泽飞%d' % random.randrange(100)
model.session.add(student)
model.session.commit()
return 'Student Create Success'
def create_stu():
stu = Student()
stu.s_name = 'yy'
stu.s_age = '21'
db.session.add(stu)
db.session.commit()
return '添加学生成功'
def addstudent():
s = Student()
s.name = 'zs'
db.session.add(s)
db.session.commit()
return '添加成功'
def add_student(request):
student = Student()
student.s_name = "小花%d" % random.randrange(100)
student.save()
data = {
"student": student,
}
return render(request, "student.html", context=data)
def create_stu():
stu = Student()
stu.s_name = '张三'
stu.s_age = '17'
db.session.add(stu)
db.session.commit()
return '创建学生成功'
def create_stu():
stu = Student()
stu.s_name = '李四'
stu.s_age = '19'
# 创建数据
db.session.add(stu)
db.session.commit()
return '创建学生成功'
def add_student():
student = Student()
student.s_name = "小明%d" % random.randrange(100)
# 添加数据操作
db.session.add(student)
db.session.commit()
return "Student Create Success!"
def add_students():
students = []
for i in range(20):
student = Student()
student.s_name = 'jm%d' % random.randrange(1000)
students.append(student)
model.session.add_all(students)
model.session.commit()
return 'Students Add Success'
def register():
"""
用户输入信息页面
"""
# 实例化按钮
if request.method == 'GET':
return render_template('register.html')
if request.method == 'POST':
'''
加一个返回首页的按钮
'''
if 'up' in request.form:
return redirect(url_for('student.home'))
# 获取学生信息
studentName = request.form.get('studentName')
studentNum = request.form.get('studentNum')
session['studentName'] = studentName
session['studentNum'] = studentNum
# 定义个变量来控制过滤用户填写的信息
# 判断用户是否信息都填写了.(all()函数可以判断用户填写的字段是否有空)
if not all([studentName, studentNum]):
msg = '* 请填写完整信息'
return render_template('register.html', msg=msg)
# 判断身份证号长度是否等于18位
if len(studentNum) != 18:
msg = '* 请输入18位身份证号码'
return render_template('register.html', msg=msg)
'''
查询数据库中身份证号是否已经存在
1.如果存在，则返回一个确认更改弹窗：
(在js里完成定向)
您的信息已经存在，点击'yes'：定向到上传图片；
点击'no'：定向到当前网页
'''
student_base = Student.query.filter_by(studentNum=studentNum).first()
if student_base:
base = student_base
return render_template('register.html',
base=base,
studentNum=studentNum,
studentName=studentName)
'''
2.如果不存在，添加数据。
'''
# 将学生信息保存在session中
# 核对输入的用户是否已经被注册了
# stu = Student.query.filter(Student.studentNum == studentNum).first()
# 上面的验证全部通过后就开始创建新用户
# 实例化Student类
student = Student(studentName=studentName, studentNum=studentNum)
# 调用save函数存注册的用户
student.stu_save()
# 跳转到传照片页面
name = studentName
return redirect(url_for('student.upload_pic', name=name))
def add_student():
student = Student()
flag = random.randrange(100)
sex = random.randint(0, 1)
student.name = '小明%s号' % flag
student.sex = sex
db.session.add(student)
db.session.commit()
return 'Add Success'
def add_stu(): num = random.randrange(100) stu = Student() stu.s_name = '小花%d号'% num db.session.add(stu) db.session.commit() return 'add success'
def addStudentList():
student_list = []
for i in range(5):
s = Student()
s.name = '小明%d' % i
s.age = i
student_list.append(s)
db.session.add_all(student_list)
db.session.commit()
return '添加成功'
def add_student():
student = Student()
student.s_name = '爱学习的飞飞%d' % random.randrange(200)
# grade = Grade.query.order_by('-id').first()
grade = Grade.query.order_by('-id').first()
student.s_grade_id = grade.id
db.session.add(student)
db.session.commit()
return 'Student add Success'
def add_students():
students = []
for i in range(10):
student = Student()
student.s_name = 'aixue%d' % random.randrange(100)
students.append(student)
db.session.add_all(students)
db.session.commit()
return 'Add success'
def add_student():
student = Student()
student.s_name = "小花"
db.session.add(student)
db.session.commit()
return 'Add Success'
def create_stus():
stu_list = []
for i in range(10):
stu = Student()
stu.s_name = '南弦%s' % random.randrange(1000)
stu.s_age = '%s' % random.randrange(20)
stu_list.append(stu)
db.session.add_all(stu_list)
db.session.commit()
return '創建小姐姐成功'
def create_stu():
if request.method == 'GET':
return render_template('create_student.html')
if request.method == 'POST':
username = request.form.get('username')
stu = Student()
stu.s_name = username
db.session.add(stu)
db.session.commit()
return '创建%s学生成功' % username
def add_student():
if request.method == 'GET':
grades = Grade.query.all()
return render_template('addstu.html', grades=grades)
if request.method == 'POST':
s_name = request.form.get('s_name')
g_id = request.form.get('g_id')
stu = Student(s_name)
stu.grades = g_id
db.session.add(stu)
db.session.commit()
return redirect(url_for('main.show_student'))
def addstu():
if request.method == 'GET':
grades = Grade.query.all()
return render_template('addstu.html', grades=grades)
if request.method == 'POST':
student = Student()
student_name = request.form.get('s_name')
student_sex = request.form.get('s_sex')
if request.form.get('s_birth'):
student_s_birth = request.form.get('s_birth')
student.s_birth = student_s_birth
student_grade_name = request.form.get('grade_name')
if request.files.get('s_img'):
student_s_img = request.files.get('s_img').filename
student.s_img = student_s_img
f = request.files['s_img']
basepath = os.path.dirname(os.path.dirname(__file__)) # 当前文件所在路径
upload_path = os.path.join(
basepath, 'static\icons',
secure_filename(f.filename)) # 注意：没有的文件夹一定要先创建，不然会提示没有该路径
f.save(upload_path)
student.s_name = student_name
student.s_sex = int(student_sex)
student.s_grade_name = student_grade_name
grade = Grade.query.filter_by(g_name=student_grade_name).first()
student.grade_id = grade.g_id
db.session.add(student)
db.session.commit()
return redirect(url_for('user.student'))
def create_stu():
if request.method == 'GET':
return render_template('create_stu.html')
if request.method == 'POST':
stu_name = request.form.get('stu_name')
stu_age = request.form.get('stu_age')
stu = Student()
stu.s_name = stu_name
stu.s_age = stu_age
db.session.add(stu)
db.session.commit()
return '创建学生成功!'
def create_stu_by_grade():
if request.method == 'GET':
g_id = request.args.get('g_id')
return render_template('create_student.html', g_id=g_id)
if request.method == 'POST':
g_id = request.form.get('g_id')
username = request.form.get('username')
stu = Student()
stu.s_name = username
stu.grades = g_id
db.session.add(stu)
db.session.commit()
return redirect(url_for('user.grade_all'))
def add_students():
students = []
for i in range(10):
student = Student()
student.s_name = "小王%d" % random.randrange(100)
students.append(student)
# 添加一组学生
db.session.add_all(students)
db.session.commit()
return "一组学生创建成功！"
def register():
if request.method == "GET":
return render_template("student_register.html")
elif request.method == "POST":
username = request.form.get("username")
password = request.form.get("password")
student = Student()
student.s_name = username
student.s_password = password
db.session.add(student)
db.session.commit()
return redirect(url_for("blue.login"))
def addstudent(request):
student = Student()
student.sno = '1806' + str(randint(1, 10000))
student.sname = '栋梁' + str(randint(1, 1000))
student.ssex = '男' if randint(1, 2) % 2 else '女'
student.sclass = '1806'
student.save()
return HttpResponse("创建一个学生成功%d" % student.id)
def auto_add_student():
firstname_list = [
'赵', '钱', '孙', '李', '周', '武', '郑', '王', '杨', '唐', '刘', '方'
]
lastname_list = [
'倩倩', '微微', '萌萌', '珠珠', '点点', '姗姗', '娜娜', '玉玉', '婉婉', '琪琪', '依依', '思思',
'迪迪', '霏霏', '珂珂', '乐乐', '米米'
]
student_list = []
for i in range(100):
name = choice(firstname_list) + choice(lastname_list)
stu = Student(name)
stu.grades = randint(1, 6)
student_list.append(stu)
db.session.add_all(student_list)
db.session.commit()
return '自动添加学生成功'
