기록

myfast01.py from fastapi import FastAPI,Form,Request from fastapi.templating import Jinja2Templates from fastapi.staticfiles import StaticFiles from fastapi.responses import HTMLResponse import pymssql import uvicorn from day10.daoemp import DaoEmp app = FastAPI() app.mount("/static", StaticFiles(directory="static"), name="static") templates = Jinja2Templates(directory="templates") de = DaoEmp()..

FastAPI 설치 cmd창에서 설치 pip3 install fastapi # FastAPI 사용을 위한 설치 pip3 install uvicorn # 파이썬 서버실행기인 uvicorn 설치 환경변수 설정 설치후 from fastapi import FastAPI import uvicorn app = FastAPI() @app.get("/") async def root(): return "Hello World" if __name__ == "__main__": uvicorn.run(app, host="localhost", port=8000) 아파치 톰캣 서버 종료 후 post.html 생성 후

먼저 pymssql 을 import후 진행해야한다. SELECT 문 import pymssql conn = pymssql.connect(host="내 ip주소",database="python",user="sa",password="python") cursor = conn.cursor() # SQL문 실행 cursor.execute('SELECT * FROM emp') list = cursor.fetchall() print(cursor.rowcount) print(list) cursor.close() conn.close() INSERT 문 import pymssql conn = pymssql.connect(host="내 IP주소",database="python",user="sa",password="pytho..

MainWindow 0 0 748 602 MainWindow 70 30 71 31 스크라이크 140 30 111 31 80 80 171 31 맞추기 80 130 171 191 0 0 748 21 코드 import sys from PyQt5.QtWidgets import * from PyQt5 import uic import random form_class = uic.loadUiType("main0b.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.com =1 self.pb.clicked.connect(self.myclick) self.comran..

import sys from PyQt5.QtWidgets import * from PyQt5 import uic form_class = uic.loadUiType("main09.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.pb.clicked.connect(self.myclick) def myclick(self): a = self.leA.text() b = self.leB.text() aa = int(a) bb = int(b) self.leC.setText(str(aa*bb)) if __name__ == "__main__" : #QApplica..

import sys from PyQt5.QtWidgets import * from PyQt5 import uic form_class = uic.loadUiType("main0a.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.pb.clicked.connect(self.myclick) def myclick(self): a = self.leA.text() b = self.leB.text() c = self.leC.text() num1 = int(a) num2 = int(b) num3 = int(c) sum=0 for i in range(num1,nu..

MainWindow 0 0 748 602 MainWindow 70 80 75 23 1 160 80 75 23 2 250 80 75 23 3 70 110 75 23 4 160 110 75 23 5 250 110 75 23 6 70 140 75 23 7 160 140 75 23 8 250 140 75 23 9 70 170 75 23 0 160 170 161 21 CALL 80 30 241 31 Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter 0 0 748 21 코드 import sys from PyQt5.QtWidgets import * from PyQt5 import uic form_class = uic.loadUiType("main08.ui")[0] class W..

import sys from PyQt5.QtWidgets import * from PyQt5 import uic form_class = uic.loadUiType("main07.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.pb.clicked.connect(self.myclick) def drawstar(self,cnt): ret="" for i in range(cnt): ret+="*" ret+="\n" return ret def myclick(self): f = self.le_first.text() l = self.le_last.text()..

MainWindow 0 0 748 602 MainWindow 60 10 121 61 나 70 200 181 23 게임하기 60 50 121 61 컴 60 120 121 61 결과 170 30 113 20 170 70 113 20 170 130 113 20 0 0 748 21 코드 import sys from PyQt5.QtWidgets import * from PyQt5 import uic import random form_class = uic.loadUiType("main06.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.pb.clicked...

MainWindow 0 0 748 602 MainWindow 40 40 41 31 __ 50 130 161 51 click 90 40 41 31 __ 130 40 41 31 __ 220 40 41 31 __ 260 40 41 31 __ 170 40 31 31 __ 0 0 748 21 코드 import sys from PyQt5.QtWidgets import * from PyQt5 import uic import random form_class = uic.loadUiType("main05.ui")[0] class WindowClass(QMainWindow, form_class) : def __init__(self) : super().__init__() self.setupUi(self) self.pb.cli..