파이썬이랑 DB연동하기 23.04.21

import pymysql

#변수선언#
con,cur=None,None
data1,data2,data3="","",""
sql=''

con = pymysql.connect(
                    host="127.0.0.1",
                    user="root",
                    port=3306,
                    password="1234",
                    db="shopdb",
                    charset='utf8')
cur  = con.cursor()

while True : 
    data1 = input("memberID => ")
    if data1 == '':
        break
    data2 = input("memberName => ")
    data3 = input("memberAddress => ")

    sql = "INSERT INTO memberTbl VALUES ('"+data1+"','"+data2+"','"+data3+"')"
    cur.execute(sql)

con.commit()

cur.execute("SELECT * FROM memberTbl")

while(True) :
    row = cur.fetchone()
    if row == None :
        break
    data1 = row[0]
    data2 = row[1]
    data3 = row[2]


    print("%5s %15s %20s" % (data1,data2,data3))
con.close()