Django 2

urlpatterns = [ path('student/register/', views.student_register), path('student/search/', views.student_search), path('student/modify/', views.student_modify), path('student/delete/', views.student_delete) ]

def registerStudent(request): # 데이터 베이스 등을 이용한 프로그램 실행 결과 return HttpResponse() # Template으로...

# SQL -> class를 이용한 맵핑 class Student(models.Model): s_name = models.CharField(max_length = 30) s_major = models.CharField(max_length = 30) # students_student 테이블 생성 # 애플리케이션 이름 + _ + 클래스명(소문자)

INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', ]

TEMPLATES = [ [ 'BACKEND' : 'django.template.backends.django.DjangoTemplates', 'DIRS' : [], 'APP_DIRS' : True, 'OPTIONS' : [ 'context_processorst' : [ 'django.template.context_processors.debug', 'django.eemplate.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', ], ], ], ]

# 애플리케이션의 설정 클래스를 이용한 등록 from django.apps import AppConfig class StudentsConfig(AppConfig): name = 'students'

DEBUG = True # 개발모드 DEBUG = False # 운영모드

# 개발모드 : 입력하지 않아도 자동으로 localhost로 정의 # 운영모드 : 서버 IP주소 입력

C:\Django\pjt\tempPjt>python manage.py migrate C:\Django\pjt\tempPjt>python manage.py makemigrations C:\Django\pjt\tempPjt>python manage.py migrate

C:\Django\pjt\tempPjt>python manage.py createsuperuser C:\Django\pjt\tempPjt>python manage.py runserver C:\Django\pjt\tempPjt>python manage.py migrate

Microsoft Windows [Version 10.0.19042.1348] (c) Microsoft Corporation. All rights reserved. C:\Users\jhe00>cd C:\Django\pjt C:\Django\pjt>django-admin startingproject tempProject No Django settings specified. Unknown command: 'startingproject'. Did you mean startproject? Type 'django-admin help' for usage. C:\Django\pjt>django-admin startproject tempProject C:\Django\pjt>cd tempProject C:\Django\pjt\tempProject>dir C 드라이브의 볼륨에는 이름이 없습니다. 볼륨 일련 번호: 9AEB-3250 C:\Django\pjt\tempProject 디렉터리 2021-11-20 오후 04:03 <DIR> . 2021-11-20 오후 04:03 <DIR> .. 2021-11-20 오후 04:03 689 manage.py 2021-11-20 오후 04:03 <DIR> tempProject 1개 파일 689 바이트 3개 디렉터리 337,288,167,424 바이트 남음 C:\Django\pjt\tempProject>python manage.py startapp students C:\Django\pjt\tempProject>cd../ C:\Django\pjt>dir C 드라이브의 볼륨에는 이름이 없습니다. 볼륨 일련 번호: 9AEB-3250 C:\Django\pjt 디렉터리 2021-11-20 오후 04:03 <DIR> . 2021-11-20 오후 04:03 <DIR> .. 2021-11-20 오전 12:12 <DIR> tempPjt 2021-11-20 오후 04:04 <DIR> tempProject 0개 파일 0 바이트 4개 디렉터리 337,291,419,648 바이트 남음 C:\Django\pjt>move tempPjt tempProject_ 1개의 디렉터리를 이동했습니다. C:\Django\pjt>cd tempProject C:\Django\pjt\tempProject>dir C 드라이브의 볼륨에는 이름이 없습니다. 볼륨 일련 번호: 9AEB-3250 C:\Django\pjt\tempProject 디렉터리 2021-11-20 오후 04:04 <DIR> . 2021-11-20 오후 04:04 <DIR> .. 2021-11-20 오후 04:03 689 manage.py 2021-11-20 오후 04:10 <DIR> students 2021-11-20 오후 04:09 <DIR> tempProject 1개 파일 689 바이트 4개 디렉터리 337,377,005,568 바이트 남음

C:\Django\pjt\tempProject>python manage.py migrate Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions Running migrations: Applying contenttypes.0001_initial... OK Applying auth.0001_initial... OK Applying admin.0001_initial... OK Applying admin.0002_logentry_remove_auto_add... OK Applying admin.0003_logentry_add_action_flag_choices... OK Applying contenttypes.0002_remove_content_type_name... OK Applying auth.0002_alter_permission_name_max_length... OK Applying auth.0003_alter_user_email_max_length... OK Applying auth.0004_alter_user_username_opts... OK Applying auth.0005_alter_user_last_login_null... OK Applying auth.0006_require_contenttypes_0002... OK Applying auth.0007_alter_validators_add_error_messages... OK Applying auth.0008_alter_user_username_max_length... OK Applying auth.0009_alter_user_last_name_max_length... OK Applying auth.0010_alter_group_name_max_length... OK Applying auth.0011_update_proxy_permissions... OK Applying auth.0012_alter_user_first_name_max_length... OK Applying sessions.0001_initial... OK C:\Django\pjt\tempProject>python manage.py createsuperuser Username (leave blank to use 'jhe00'): jhe Email address: jhe226@korea.ac.kr Password: Password (again): Superuser created successfully.

Microsoft Windows [Version 10.0.19042.1348] (c) Microsoft Corporation. All rights reserved. C:\Users\jhe00>cd C:\Django\pjt\tempProject C:\Django\pjt\tempProject>dir C 드라이브의 볼륨에는 이름이 없습니다. 볼륨 일련 번호: 9AEB-3250 C:\Django\pjt\tempProject 디렉터리 2021-11-20 오후 04:14 <DIR> . 2021-11-20 오후 04:14 <DIR> .. 2021-11-20 오후 04:14 131,072 db.sqlite3 2021-11-20 오후 04:03 689 manage.py 2021-11-20 오후 04:11 <DIR> students 2021-11-20 오후 04:09 <DIR> tempProject 2개 파일 131,761 바이트 4개 디렉터리 337,371,860,992 바이트 남음 C:\Django\pjt\tempProject>python manage.py runserver 0.0.0.0:8000 Watching for file changes with StatReloader Performing system checks...

# models.py from django.db import models # Create your models here. class Student(models.Model): s_name = models.CharField(max_length=100) s_major = models.CharField(max_length=100) s_age = models.IntegerField(default=0) s_grade = models.IntegerField(default=0) s_gender = models.CharField(max_length=30) def __str__(self): return self.s_name

# admin.py from django.contrib import admin from students.models import Student # Register your models here. admin.site.register(Student)

C:\Django\pjt\tempProject>python manage.py makemigrations students Migrations for 'students': students\migrations\0001_initial.py - Create model Student C:\Django\pjt\tempProject>python manage.py migrate Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions, students Running migrations: Applying students.0001_initial... OK

C:\Django\pjt\tempProject>python manage.py shell Python 3.9.6 (tags/v3.9.6:db3ff76, Jun 28 2021, 15:26:21) [MSC v.1929 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>>

>>> from students.models import Student >>> qs = Student(s_name = 'HongGilDong', s_major = 'computer', s_age = 21, s_grade = 2, s_gender = 'M') >>> qs.save() >>> qs = Student(s_name = 'HongGilSoon', s_major = 'dance', s_age = 22, s_grade = 3, s_gender = 'W') >>> qs.save() >>> qs = Student(s_name = 'HongGilJa', s_major = 'song', s_age = 23, s_grade = 4, s_gender = 'W') >>> qs.save()

>>> Student.objects.all() <QuerySet [<Student: HongGilDong>, <Student: HongGilSoon>, <Student: HongGilJa>]> >>> qs = Student.objects.all() >>> print(qs) <QuerySet [<Student: HongGilDong>, <Student: HongGilSoon>, <Student: HongGilJa>]> >>> type(qs) <class 'django.db.models.query.QuerySet'> >>> qs = Student.objects.get(s_name = 'HongGilDong') >>> qs <Student: HongGilDong> >>> type(qs) <class 'students.models.Student'>

>>> qs = Student.objects.all() >>> qs <QuerySet [<Student: HongGilDong>, <Student: HongGilSoon>, <Student: HongGilJa>]> >>> qs[1] <Student: HongGilSoon> >>> qs[1].s_name 'HongGilSoon' >>> qs[1].s_age 22 >>> qs = Student.objects.get(s_name = 'HongGilDong') >>> qs.s_name 'HongGilDong' >>> qs.s_age 21 >>> qs.s_major 'computer' >>>

>>> qs = Student.objects.filter(s_age__lt=22) >>> qs <QuerySet [<Student: HongGilDong>]> >>> qs = Student.objects.filter(s_age__gt=22) >>> qs <QuerySet [<Student: Student object (3)>]> >>> qs = Student.objects.filter(s_age__lte=22) >>> qs <QuerySet [<Student: HongGilDong>, <Student: HongGilSoon>]> >>> qs = Student.objects.filter(s_age__gte=22) >>> qs <QuerySet [<Student: HongGilSoon>, <Student: HongGilJa>]> >>>

>>> qs = Student.objects.order_by('s_age') >>> qs <QuerySet [<Student: HongGilDong>, <Student: HongGilSoon>, <Student: HongGilJa>]> >>> qs = Student.objects.order_by('-s_age') >>> qs <QuerySet [<Student: HongGilJa>, <Student: HongGilSoon>, <Student: HongGilDong>]> >>>

>>> qs = Student.objects.get(s_name = 'HongGilDong') >>> qs <Student: Student object (1)> >>> qs.s_major = 'mathmatics' >>> qs.save() >>> qs.s_major 'mathmatics' >>>

>>> qs = Student.objects.filter(s_age__gte = 22) >>> qs <QuerySet [<Student: HongGilSoon>, <Student: HongGilJa>]> >>> qs.delete() (2, {'students.Student': 2}) >>>

Microsoft Windows [Version 10.0.19042.1348] (c) Microsoft Corporation. All rights reserved. C:\Users\jhe00>cd C:\Django\pjt C:\Django\pjt>django-admin startproject studentsProject C:\Django\pjt>dir C 드라이브의 볼륨에는 이름이 없습니다. 볼륨 일련 번호: 9AEB-3250 C:\Django\pjt 디렉터리 2021-11-21 오전 07:22 <DIR> . 2021-11-21 오전 07:22 <DIR> .. 2021-11-21 오전 07:22 <DIR> studentsProject 2021-11-20 오전 12:12 <DIR> tempProject_ 0개 파일 0 바이트 4개 디렉터리 342,851,301,376 바이트 남음 C:\Django\pjt>move studentsProject sProject 1개의 디렉터리를 이동했습니다.

C:\Django\pjt>cd sProject C:\Django\pjt\sProject>python manage.py startapp students

INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'students.apps.StudentsConfig', ] . . . # TIME_ZONE = 'UTC' TIME_ZONE = 'Asia/Seoul'

from django.db import models # Create your models here. class Student(models.Model): s_name = models.CharField(max_length=100) s_major = models.CharField(max_length=100) s_ages = models.IntegerField(default=0) s_grade = models.IntegerField(default=0) s_gender = models.CharField(max_length=30) def __str__(selfself): return self.s_name

from django.contrib import admin from students.models import Student # Register your models here. admin.site.register(Student)

C:\Django\pjt\sProject>python manage.py makemigrations students Migrations for 'students': students\migrations\0001_initial.py - Create model Student C:\Django\pjt\sProject>python manage.py migrate Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions, students Running migrations: Applying contenttypes.0001_initial... OK Applying auth.0001_initial... OK Applying admin.0001_initial... OK Applying admin.0002_logentry_remove_auto_add... OK Applying admin.0003_logentry_add_action_flag_choices... OK Applying contenttypes.0002_remove_content_type_name... OK Applying auth.0002_alter_permission_name_max_length... OK Applying auth.0003_alter_user_email_max_length... OK Applying auth.0004_alter_user_username_opts... OK Applying auth.0005_alter_user_last_login_null... OK Applying auth.0006_require_contenttypes_0002... OK Applying auth.0007_alter_validators_add_error_messages... OK Applying auth.0008_alter_user_username_max_length... OK Applying auth.0009_alter_user_last_name_max_length... OK Applying auth.0010_alter_group_name_max_length... OK Applying auth.0011_update_proxy_permissions... OK Applying auth.0012_alter_user_first_name_max_length... OK Applying sessions.0001_initial... OK Applying students.0001_initial... OK

C:\Django\pjt\sProject>python manage.py createsuperuser Username (leave blank to use 'jhe00'): jhe226 Email address: jhe226@korea.ac.kr Password: Password (again): Superuser created successfully. C:\Django\pjt\sProject>python manage.py runserver 0.0.0.0:8000 Watching for file changes with StatReloader Performing system checks... System check identified no issues (0 silenced). November 21, 2021 - 07:32:40 Django version 3.2.9, using settings 'studentsProject.settings' Starting development server at http://0.0.0.0:8000/ Quit the server with CTRL-BREAK.

from django.contrib import admin from django.urls import path, include urlpatterns = [ path('admin/', admin.site.urls), path('students/', include('students.urls')), ]

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name = 'reg'), ]

from django.shortcuts import render # Create your views here. def regStudent(request): return render(request, 'students/registerStudent.html')

registerStudent.html <!DOCTYPE html> <html lang="ko"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Title</title> </head> <body> <p>Register Student</p> <form action="{% url 'students:regCon' %}" method="post"> {% csrf_token %} name : <input type="text" name="name"></br> major : <input type="text" name="major"></br> age : <input type="text" name="age"></br> grade : <input type="text" name="grade"></br> gender : <input type="text" name="gender"></br> <input type="submit" value="Register"> </form> </body> </html>

from django.http import HttpResponseRedirect from django.urls import reverse from django.shortcuts import render from students.models import Student # Create your views here. def regStudent(request): return render(request, 'students/registerStudent.html') def regConStudent(request): name = request.POST['name'] major = request.POST['major'] age = request.POST['age'] grade = request.POST['grade'] gender = request.POST['gender'] qs = Student(s_name=name, s_major=major, s_age=age, s_grade=grade, s_gender=gender) qs.save() return HttpResponseRedirect(reverse('students:stuAll'))

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name = 'reg'), path('regCon/', views.regConStudent, name = 'regCon'), path('all/', views.reaStudentAll, name = 'stuAll'), ]

from django.http import HttpResponseRedirect from django.urls import reverse from django.shortcuts import render from students.models import Student # Create your views here. def regStudent(request): return render(request, 'students/registerStudent.html') def regConStudent(request): name = request.POST['name'] major = request.POST['major'] age = request.POST['age'] grade = request.POST['grade'] gender = request.POST['gender'] qs = Student(s_name=name, s_major=major, s_age=age, s_grade=grade, s_gender=gender) qs.save() return HttpResponseRedirect(reverse('students:stuAll')) def reaStudentAll(request): qs = Student.objects.all() context = {'student_list': qs} return render(request, 'students/readStudents.html', context)

<!DOCTYPE html> <html> <head> <meta http-equiv="content-Type" content="text/html"; charset=UTF-8> <title>Title</title> </head> <body> <p>Read Students</p> {% if student_list %} <ol> {% for s in student_list %} <li> <a href="{% url 'students:stuDet' s.s_name %}">{{s.s_name}}</a> <a href="{% url 'students:stuMod' s.s_name %}">수정</a> <a href="{% url 'students:stuDel' s.s_name %}">삭제</a> </li> {% endfor %} </ol> {% else %} <p>Student: 0</p> {% endif %} </br> <a href="{% url 'students:reg ' %} ">신규학생등록</a> </body> </html>

<!DOCTYPE html> <html> <head> <meta http-equiv="content-Type" content="text/html"; charset=UTF-8> <title>Title</title> </head> <body> <p>Read Students</p> {% if student_list %} <ol> {% for s in student_list %} <li> <a href="{% url 'students:stuDet' s.s_name %}">{{s.s_name}}</a> <a href="#none">수정</a> <a href="#none">삭제</a> </li> {% endfor %} </ol> {% else %} <p>Student: 0</p> {% endif %} </br> <a href="{% url 'students:reg' %}">신규학생등록</a> </body> </html>

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name='reg'), path('regCon/', views.regConStudent, name='regCon'), path('all/', views.reaStudentAll, name='stuAll'), path('<str:name>/det/', views.detStudent, name='stuDet'), ]

def detStudent(request, name): qs = Student.objects.get(s_name = name) context = {'student_info': qs} return render(request, 'students/detailStudent.html', context)

<!DOCTYPE html> <html> <head> <meta http-equiv="content-Type" content="text/html"; charset=UTF-8> <title>Title</title> </head> <body> <p>Detail Students</p> {% if student_info %} name: {{student_info.s_name}}</br> major: {{student_info.s_major}}</br> age: {{student_info.s_age}}</br> grade: {{student_info.s_grade}}</br> gender: {{student_info.s_gender}}</br> {% else %} <p>student: 0</p> {% endif%} </br> <a href="{% url 'students:stuMod' student_info.s_name %}">수정</a> <a href="#none">삭제</a> <a href="{% url 'students:stuAll' %}">학생리스트</a> <a href="{% url 'students:reg' %}">신규학생등록</a> </body> </html>

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name='reg'), path('regCon/', views.regConStudent, name='regCon'), path('all/', views.reaStudentAll, name='stuAll'), path('<str:name>/det/', views.detStudent, name='stuDet'), path('<str:name>/mod/', views.reaStudentOne, name='stuMod'), ]

def reaStudentOne(request, name): qs = Student.objects.get(s_name = name) context = {'student_info': qs} return render(request, 'students/modifyStudent.html', context)

<!DOCTYPE html> <html> <head> <meta http-equiv="content-Type" content="text/html"; charset=UTF-8> <title>Title</title> </head> <body> <p>Modify Student</p> {% if student_info %} <form action="{% url 'students:modCon' %}" method="post"> {% csrf_token %} name : {{student_info.s_name}}</br> <input type="hidden" name="name" value={{student_info.s_name}}></br> major : <input type="text" name="major" value={{student_info.s_major}}></br> age : <input type="text" name="age" value={{student_info.s_age}}></br> grade : <input type="text" name="grade" value={{student_info.s_grade}}></br> gender : <input type="text" name="gender" value={{student_info.s_gender}}></br> <input type="submit" name="Modify"></br> </form> {% else %} <p>student: 0</p> {% endif %} </body> </html>

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name='reg'), path('regCon/', views.regConStudent, name='regCon'), path('all/', views.reaStudentAll, name='stuAll'), path('<str:name>/det/', views.detStudent, name='stuDet'), path('<str:name>/mod/', views.reaStudentOne, name='stuMod'), path('modCon/', views.modConStudent, name='modCon'), ]

def modConStudent(request): name = request.POST['name'] major = request.POST['major'] age = request.POST['age'] grade = request.POST['grade'] gender = request.POST['gender'] s_qs = Student.objects.get(s_name=name) s_qs.s_name = name s_qs.s_major = major s_qs.s_age = age s_qs.s_grade = grade s_qs.s_gender = gender s_qs.save() return HttpResponseRedirect(reverse('students:stuAll'))

<!DOCTYPE html> <html> <head> <meta http-equiv="content-Type" content="text/html"; charset=UTF-8> <title>Title</title> </head> <body> <p>Detail Students</p> {% if student_info %} name: {{student_info.s_name}}</br> major: {{student_info.s_major}}</br> age: {{student_info.s_age}}</br> grade: {{student_info.s_grade}}</br> gender: {{student_info.s_gender}}</br> {% else %} <p>student: 0</p> {% endif%} </br> <a href="{% url 'students:stuMod' student_info.s_name %}">수정</a> <a href="{% url 'students:stuDel' student_info.s_name %}">삭제</a> <a href="{% url 'students:stuAll' %}">학생리스트</a> <a href="{% url 'students:reg' %}">신규학생등록</a> </body> </html>

from django.urls import path from . import views app_name = 'students' urlpatterns = [ path('reg/', views.regStudent, name='reg'), path('regCon/', views.regConStudent, name='regCon'), path('all/', views.reaStudentAll, name='stuAll'), path('<str:name>/det/', views.detStudent, name='stuDet'), path('<str:name>/mod/', views.reaStudentOne, name='stuMod'), path('modCon/', views.modConStudent, name='modCon'), path('<str:name>/del', views.delConStudent, name='stuDel'), ]

def delConStudent(request, name): qs = Student.objects.get(s_name = name) qs.delete() return HttpResponseRedirect(reverse('students:stuAll'))