flask์‚ฌ์šฉ๋ฒ• 2

[PYTHON] Flask(02) DB์—์„œ ๋ฐ์ดํ„ฐ ๋ฐ›์•„์™€ html์— ์ถœ๋ ฅํ•˜๊ธฐ

mysql(heidiDB)์—์„œ ๋ฐ›์€ ๊ฐ’๋“ค์„ html์— ์ถœ๋ ฅํ•˜๊ธฐ์ด 4๊ฐœ์˜ ํŒŒ์ผ๋กœ ๊ธฐํš.py ํŒŒ์ผ๋“คmyheidi01.py# ๋ถˆ๋Ÿฌ์˜ค๊ธฐ import pymysql import pandas as pd import numpy as np def getList(s_name): gil_db = pymysql.connect( user='root', passwd='python', host='127.0.0.1', db='python', charset='utf8' ) cursor = gil_db.cursor() #* ์“ฐ๋Š”๊ฑธ ์ง€์–‘ํ•˜์ž. ํŒŒ์ด์ฌ ;์ด ์žˆ๊ฑฐ๋‚˜ ์—†๊ฑฐ๋‚˜ ์ƒ๊ด€์ด ์—†๋‹ค. sql = f""" SELECT s_code, s_name, s_price, in_date FROM stock WHERE s_name = '{s_name}..

Languages/python 2021.03.23

[PYTHON] Flask(01) ์„ค์น˜๋ถ€ํ„ฐ ๊ธฐ๋ณธ์—ฐ๋™

์„ค์น˜ํ•˜๊ธฐ $conda install flask$pip install flask๋‘˜ ์ค‘ ํ•˜๋‚˜๋กœ flask๋ฅผ ์„ค์น˜.์•„๋‚˜์ฝ˜๋‹ค๋ฅผ ์„ค์น˜ ํ•˜์˜€๋‹ค๋ฉด ์œ„์—์žˆ๋Š” ์ฝ˜๋‹ค ๋ช…๋ น์–ด๋ฅผ ์šฐ์„ ์ ์œผ๋กœ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์„ ์ถ”์ฒœ. ํ›„์— ์ฝ”๋“œ ์ถฉ๋Œ ์šฐ๋ ค๊ฐ€ ์žˆ๊ธฐ ๋•Œ๋ฌธ1. ๊ธฐ๋ณธ์ ์ธ ์„œ๋ฒ„ ์—ด๊ธฐfrom flask import Flask app = Flask(__name__) @app.route('/') def hello(): return 'Hello world' if __name__ == '__main__': app.run(host="127.0.0.1", port='80')์‹คํ–‰ ํ›„ ๋ณธ์ธ์ด ์‚ฌ์šฉํ•˜๋Š” ์ธํ„ฐ๋„ท(chrome / IE) ๋“ฑ์„ ์‹คํ–‰ ์‹œํ‚จ ํ›„localhost๋ฅผ ์ž…๋ ฅํ•œ๋‹ค.๊ฒฐ๊ณผ2. html ์—ฐ๋™ํ•˜๊ธฐ๋ฐ˜๋“œ์‹œ ํด๋” ๋ฐฐ์น˜๋ฅผ ๋”ฐ๋ผ์•ผ ํ•œ๋‹ค.ํ”„๋กœ์ ํŠธ๋ช… / ํด๋”1 /..

Languages/python 2021.03.23
728x90
๋ฐ˜์‘ํ˜•