def stu_details(request): if request.method == 'POST': if request.POST.get('usn') != None and request.POST.get( 'name') != None and request.POST.get( 'sem') != None and request.POST.get('dept') != None: print("Hie") form = Student() form.USN = request.POST['usn'] form.name = request.POST['name'] form.sem = request.POST['sem'] form.Dept = request.POST['dept'] form.save() return redirect('accounts:signup') else: form = Student return render(request, 'accounts/student_details.html')
def insertStudents(request): print("This is the insert Excel page") connection = sqlite3.connect('students.db') cursor = connection.cursor() if request.method == "POST": data = request.POST.copy() student=Student() student.room_no = data.get('room_no') student.block = data.get('block') student.name = data.get('name') student.mob_no = data.get('mob_no') student.id_no = data.get('id_no') print(student.room_no) student.save() #sql_insert_single = "INSERT INTO students(ROOMNO, BLOCK, STUDENT, MOBILE, ID) VALUES('{0}', '{1}', '{2}', '{3}', '{4}')".format(room_no, block, student, mobile, id) #cursor.execute(sql_insert_single) connection.commit() connection.close() return render(request, 'insertStudentExcel.html')
def add(request): if request.method == "POST": form = request.POST student = Student() student.name = form['name'] student.registration_number = form['registration_number'] student.address = form['address'] student.age = form['age'] #1 student.school = School.objects.get(pk=form['school']) student.save() return redirect('students:student_detail',student.pk) schools = School.objects.all() context = {'schools': schools} return render(request, 'students/addStudent.html',context)
def student_add(request): if request.method == 'POST': form = StudentForm(request.POST) if form.is_valid(): student = Student() student.name = form.cleaned_data['student_name'] student.surname = form.cleaned_data['student_surname'], student.email = form.cleaned_data['student_email'], student.phone = form.cleaned_data['student_phone'], student.package = form.cleaned_data['student_package'] student.save() return redirect('Student_list') else: form = StudentForm(initial={ 'student_name': '', 'student_surname': '', 'student_email': '', 'student_phone': '', 'student_package': '', }) return render(request,'students/edit.html', {'form': form})
def addStudent(request): if request.method == 'GET': return HttpResponse(render(request, 'add_student.html')) elif request.method == 'POST': name = request.POST.get('name') surname = request.POST.get('surname') avg_mark = request.POST.get('avg_mark') group_id = request.POST.get('group_id') if int(avg_mark) > 9: group_id = 2 student = Student() student.name = name student.surname = surname student.avg_mark = avg_mark student.group_id = group_id student.save() return redirect('/groups/all')
# _*_ coding: utf-8 _*_ __author__ = 'Yang Haibo' __date__ = '2020/4/29 11:48' # 独立使用django的model import os import sys # 当前文件所在目录 pwd = os.path.dirname(os.path.realpath(__file__)) # 获取工程根目录下的backend目录 pwd = os.path.join(os.path.dirname(os.path.dirname(pwd)), 'backend') sys.path.append(pwd) os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'dyezweb.settings') import django django.setup() from students.models import Student from tools.db.data.students_data import raw_data for student_detail in raw_data: student = Student() student.name = student_detail["name"] student.gender = student_detail["gender"]