Python - Django를 사용하여 DB 불러오기 예제

---

오늘은 Python을 활용하여 SQL DB를 표 형식으로 불러오는 예제를 리뷰합니다. JAVA랑 비슷하지만 많이 다릅니다. 

Django 설치 및 연동은 아래의 글을 참조해주세요.

Django 프로젝트 생성 및 세팅 : http://note.espriter.net/1275

---

dj_ex7_crud

** settings.py **

아래에서 my_sangpum 추가

INSTALLED_APPS = [

    'django.contrib.admin',

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'my_sangpum',

** urls.py **

urlpatterns에서 경로 추가

"""dj_ex7_crud URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:

https://docs.djangoproject.com/en/2.0/topics/http/urls/

Examples:

Function views

    1. Add an import:  from my_app import views

    2. Add a URL to urlpatterns:  path('', views.home, name='home')

Class-based views

    1. Add an import:  from other_app.views import Home

    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')

Including another URLconf

    1. Import the include() function: from django.urls import include, path

    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))

"""

from django.contrib import admin

from django.urls import path

from my_sangpum import views

import my_sangpum

from django.urls.conf import include

urlpatterns = [

    path('admin/', admin.site.urls),

    

    path('', views.Main),

    path('sangpum/', include('my_sangpum.urls')),

    

    ]

my_sangpum

** 0001_initial **

# Generated by Django 2.0.5 on 2018-05-14 06:07

from django.db import migrations, models

class Migration(migrations.Migration):

    initial = True

    dependencies = [

    ]

    operations = [

        migrations.CreateModel(

            name='SangTab',

            fields=[

                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

                ('code', models.CharField(max_length=20)),

                ('sang', models.CharField(max_length=30)),

                ('su', models.IntegerField()),

                ('dan', models.IntegerField()),

            ],

        ),

    ]

** admin.py **

from django.contrib import admin

from my_sangpum.models import SangTab

# Register your models here.

class SangTabAdmin(admin.ModelAdmin):

    list_display = ('id','sang','su','dan')

    

admin.site.register(SangTab, SangTabAdmin)

**models.py **

from django.db import models

# Create your models here.

class SangTab(models.Model):

    code = models.CharField(max_length=20)

    sang = models.CharField(max_length=30)

    su = models.IntegerField()

    dan = models.IntegerField()

** urls.py **

from django.urls import path

from my_sangpum import views

urlpatterns = [

    path('list', views.ListFunc),

    path('insert', views.InsertFunc),

    path('insertok', views.InsertFuncOk),

    path('update', views.UpdateFunc),

    path('updateok', views.UpdateFuncOk),

    path('delete', views.DeleteFunc),

    

]

** views.py **

from django.shortcuts import render

from my_sangpum.models import SangTab

from _mysql import connection

from django.http.response import HttpResponseRedirect

# Create your views here.

def Main(request):

    return render(request, 'main.html')

def ListFunc(request):

    datas = SangTab.objects.all()

    return render(request, 'list.html', {'sangpums':datas})

    ''' (데이터 받을 때 튜플로 받아야 됨)

    sql = "select * from my_sangpum_sangtab"

    cursor = connection.cursor()

    cursor.execute(sql)

    datas = cursor.fetchall()

    return render(request, 'list.htlm', {'sangpums':datas})

    '''

def InsertFunc(request):

    return render(request, 'insert.html')

def InsertFuncOk(request):

    if request.method == 'POST':

        SangTab(

            code = request.POST.get('code'),

            sang = request.POST.get('sang'),

            su = request.POST.get('su'),

            dan = request.POST.get('dan'),

        ).save()

    return HttpResponseRedirect('/sangpum/list') #추가 후 목록보기

def UpdateFunc(request):

    #print(request.GET.get('id'))

    data = SangTab.objects.get(id=request.GET.get('id'))

    #print(data)

    return render(request, 'update.html', {'sang_one': data})

def UpdateFuncOk(request):

    if request.method == 'POST':

        upRec = SangTab.objects.get(id=request.POST.get('id'))

        upRec.code = request.POST.get('code')

        upRec.sang = request.POST.get('sang')

        upRec.su = request.POST.get('su')

        upRec.dan = request.POST.get('dan')

        upRec.save()

    return HttpResponseRedirect('/sangpum/list') #추가 후 목록보기

def DeleteFunc(request):

    delRec = SangTab.objects.get(id=request.GET.get('id'))

    delRec.delete()

    return HttpResponseRedirect('/sangpum/list') #추가 후 목록보기

templates

** insert.html **

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

<script type="text/javascript">

function chkData() {

    //alert("aa");

    if(frm.code.value == "" ||

        frm.sang.value == "" ||

        frm.su.value == "" ||

        frm.dan.value == ""){

        alert("입력자료를 모두 채우시오");

        return;

    }

    frm.submit();

}

</script>

</head>

<body>

<h2>자료 입력</h2>

<form name="frm" action="/sangpum/insertok" method="post">{% csrf_token%}

<table border="1">

    <tr><td>코드 : </td><td><input type="text" name="code"></td></tr>

    <tr><td>품명 : </td><td><input type="text" name="sang"></td></tr>

    <tr><td>수량 : </td><td><input type="text" name="su"></td></tr>

    <tr><td>단가 : </td><td><input type="text" name="dan"></td></tr>

    <tr>

     <td colspan="2" style="text-align:center;">

     <input type="button" value="저장" onclick="chkData()">

     </td>

    </tr>

</table>

</form>

</body>

</html>

** list.html **

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

</head>

<body>

<h2>* 상품 목록 *</h2>

<a href="/sangpum/insert?id={{s.id}}">상품 추가</a>

<table border="1">

<tr>

    <th>id</th><th>코드</th><th>상품</th><th>수량</th><th>단가</th>

    <th>변경</th>

</tr>

{% if sangpums %}

{% for s in sangpums %}

<tr>

    <td>{{s.id}}</td>

    <td>{{s.code}}</td>

    <td>{{s.sang}}</td>

    <td>{{s.su}}</td>

    <td>{{s.dan}}</td>

    <td>

        <a href="/sangpum/update?id={{s.id}}">수정</a> /

        <a href="/sangpum/delete?id={{s.id}}">삭제</a>

    </td>

</tr>

{% endfor %}

{% else %}

    <tr><td colspan="5"> 자료가 없음 </td></tr>

{% endif %}

</table>

</body>

</html>

** main.html **

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

</head>

<body>

Main<p/>

<a href="sangpum/list">상품목록</a>

</body>

</html>

** update.html **

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

<script type="text/javascript">

function chkData() {

    //alert("aa");

    if(frm.code.value == "" ||

        frm.sang.value == "" ||

        frm.su.value == "" ||

        frm.dan.value == ""){

        alert("입력자료를 모두 채우시오");

        return;

    }

    frm.submit();

}

</script>

</head>

<body>

<h2>* 자료 수정 * </h2>

<form name="frm" action="/sangpum/updateok" method="post">{% csrf_token %}

<input type="hidden" name="id" value="{{sang_one.id}}">

<table border="1">

    <tr>

        <td>코드 : </td>

        <td><input type="text" name="code" value="{{sang_one.code}}"></td>

    </tr>

    <tr>

        <td>품명 : </td>

        <td><input type="text" name="sang" value="{{sang_one.sang}}"></td>

    </tr>

    <tr>

        <td>수량 : </td>

        <td><input type="text" name="su" value="{{sang_one.su}}"></td>

    </tr>        

    <tr>

        <td>단가 : </td>

        <td><input type="text" name="dan" value="{{sang_one.dan}}"></td>

    </tr>

    <tr>

        <td colspan="2">

            <input type="button" value="수정하기" onclick="chkData()">

            <input type="button" value="수정취소" onclick="history.back()">

    </tr>    

</table>

</form>

</body>

</html>

---

결과 이미지 및 파일

dj_ex7_crud.zip

---

본 포스팅은 KIC 캠퍼스에서 박영권 강사의 지도하에 공부하며 작성한 리포트입니다.

혹시 잘못된 내용이 있거나 문제 소지시 댓글 남겨주시면 조치하겠습니다.

---