본문 바로가기

Python

 (19)
[DJANGO] Ajax 통신을 이용한 CRUD emp.html EMP ajax emp_list 사번 이름 성별 주소 데이터가 없습니다. 사번 이름 성별 주소 urls.py from django.contrib import admin from django.urls import path from HELLO_AJAX import views urlpatterns = [ path('admin/', admin.site.urls), path('', views.emp), path('emp', views.emp), path('ajax', views.ajax), path('emp_list', views.emp_list), path('emp_one', views.emp_one), path('emp_add', views.emp_add), path('emp_del', vie..
[DJANGO] MARIA DB 연결(4) - INSERT(ADD) dao_emp.py import pymysql class DaoEmp: def __init__(self): self.conn = pymysql.connect(host='127.0.0.1', user='root', password='python', db='python',port=3304, charset='utf8') self.curs = self.conn.cursor(pymysql.cursors.DictCursor) def selectList(self): sql = """ select E_ID, E_NAME, GEN, ADDR from emp ORDER BY CAST(E_ID AS INTEGER) """ self.curs.execute(sql) list = self.curs.fetchall() return..
[DJANGO] MARIA DB 연결(3) - DELETE dao_emp.py import pymysql class DaoEmp: def __init__(self): self.conn = pymysql.connect(host='127.0.0.1', user='root', password='python', db='python',port=3304, charset='utf8') self.curs = self.conn.cursor(pymysql.cursors.DictCursor) def selectList(self): sql = """ select E_ID, E_NAME, GEN, ADDR from emp ORDER BY CAST(E_ID AS INTEGER) """ self.curs.execute(sql) list = self.curs.fetchall() return..
[DJANGO] MARIA DB 연결(2) - UPDATE(MODIFY) dao_emp.py import pymysql class DaoEmp: def __init__(self): self.conn = pymysql.connect(host='127.0.0.1', user='root', password='python', db='python',port=3304, charset='utf8') self.curs = self.conn.cursor(pymysql.cursors.DictCursor) def selectList(self): sql = """ select E_ID, E_NAME, GEN, ADDR from emp ORDER BY CAST(E_ID AS INTEGER) """ self.curs.execute(sql) list = self.curs.fetchall() return..
[DJANGO] MARIA DB 연결(1) - SELECT dao_emp.py import pymysql class DaoEmp: def __init__(self): self.conn = pymysql.connect(host='127.0.0.1', user='root', password='python', db='python',port=3304, charset='utf8') self.curs = self.conn.cursor(pymysql.cursors.DictCursor) def selectList(self): sql = """ select E_ID, E_NAME, GEN, ADDR from emp ORDER BY CAST(E_ID AS INTEGER) """ self.curs.execute(sql) list = self.curs.fetchall() return..
[MariaDB] MariaDB, HeidiSQL 이용해 python과 연결하기 (1) MariaDB 다운로드 https://mariadb.org/download/?t=mariadb&p=mariadb&r=11.2.0&os=windows&cpu=x86_64&pkg=msi&m=blendbyte Download MariaDB Server - MariaDB.org REST API Release Schedule Reporting Bugs … Continue reading "Download MariaDB Server" mariadb.org 다운로드 클릭 Enable access from remote machines for 'root' user Use UTF8 as default server's character set 둘 다 체크!!! 사진은 없지만 포트 번호를 3304로 설정해 주었다.! *..
[QT] 오목 게임 omok03.ui MainWindow 0 0 1034 967 MainWindow 410 20 71 40 0,0 BACK 40 40 410 80 71 40 0,0 RESET 40 40 0 0 1034 21 omok03.py import sys from PyQt5 import uic from PyQt5.QtWidgets import QApplication, QMainWindow, QPushButton, QMessageBox from PyQt5.Qt import QIcon, QSize form_class = uic.loadUiType("omok03.ui")[0] class WindowClass(QMainWindow, form_class): def __init__(self): super().__init__() ..
[QT] 야구 게임 myqt08.py import sys from PyQt5 import uic from PyQt5.QtWidgets import QApplication, QMainWindow, QMessageBox from random import random from _functools import partial form_class = uic.loadUiType("myqt08.ui")[0] class WindowClass(QMainWindow, form_class): def __init__(self): super().__init__() self.setupUi(self) com1 = self.getCom(); self.pb.clicked.connect(partial(self.btnClick,com1)) def btnCli..

티스토리툴바